How can I do to import a csv file with PHP and grab the data from a specific column and write that data to the database?
Can you do this analysis and save only specific data (type a column, or row)?
In a PHP system I'm developing, I need to update a column of the price table. The price field is in float format and the administrator informs the percentage of increase.
Example: Reports that it will have a 10% increase.
$valor_anti...
I'm testing the targeting of images with the URL. But during the tests, the URL was returned with changes as seen below:
URL entered in the database:
http://www.meusite.com.br/pastaimagem/logos/imageLogo.jpg
URL returned by the bank:
h...
Can anyone tell me what kind of date is this format?
2013-09-17T05:59:00+01:00
I have in the database a field of type timestamp or date. How to convert the value of it to this format using PHP?
I get via Ajax a $_POST request with 5 indexes and the last 3 are Arrays.
It looks something like this:
Array
(
[c] =>
[s] =>
[dt] =>
[nl] => Array
(
[0] => valor1
[...
DBMS: MySql
Problem: List all the possibilities of combinations between the numbers "1,2,3,4", so that they do not repeat between them.
Example:
1
2
3
4
12
13
14
21
23
24
31
32
34
41
42
43...
I'm doing a query in the database, follow my table below
id | protocolo | status | alteracao | datahora
1 2 1 teste 2014-11-10 15:23:44
2 2 3 teste 2014-11-10 14:23:44
3 2 4...
I have a problem submitting Query.
I have the alvaraValidade field that only receives Date fields.
When I do not put anything in this field, the date field is saved as 0000-00-00 .
$sql = "Select * From tb_trabalhador wh...
I'm trying to select the categories of the database and count in the same query the number of products registered in that category. So far so good, the problem is that I can not return the category when there is no product registered, for exampl...
Well, what I want is the following:
I have 1 table designated by items, in this table I have 4 columns:
name
iditem (Unique ID)
numerobot
What I want to do is: I want to make a mysql_num_rows of all results, but for each different...