Re: [PHP-DB] search of data base - again

[Gavin]

|DATE|  => MySQL 
permits some keywords to be used as unquoted identifiers because many 
people previously used them. Examples are those in the following list:


 *

   |ACTION|

 *

   |BIT| 

 *

   |DATE| 

 *

   |ENUM| 

 *

   |NO|

 *

   |TEXT| 

 *

   |TIME| 

 *

   |TIMESTAMP| 

Best Regards,

Gavin

On 30/03/2012 19:48, Lars Nielsen wrote:

fre, 30 03 2012 kl. 20:00 +0200, skrev Matijn Woudt:

On Fri, Mar 30, 2012 at 7:49 PM, Jim Giner  wrote:

""Jim Giner""  wrote in message
news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2...

===
Martijn&  Jim -

Is it just the date that is the problem?

Yes.

Tru dat.  But mySql doesn't want the dashes embedded.  The format string
should be "Ymd" instead.

That's what I am doing.  No luck.

Ethan

*
You're using a format with just Ymd in it (no dashes)?  Can you post
*just* the query as it is looks in your php code?




While waiting - I looked at your code again.  What is the (greater than)
symbol doing in front of your $Date var?

Date) VALUES(null, '$Site', '$MedRec', '$Notes', $Weight, $BMI,>
'$Date'";

Also - is it valid to use the word 'Date' as a field name?  Just wondering.

It is valid, though It may require quotes (backtick ?)


Hi,

Have you tried to write out the generated sql with var_dump() and then
feed it to an SQL interface? By using Mysql Query Browser you can easily
check it the sql-string is correct.

Regards
Lars Nielsen
LFWeb




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] search of data base - again

[Lars Nielsen]

fre, 30 03 2012 kl. 20:00 +0200, skrev Matijn Woudt:
> On Fri, Mar 30, 2012 at 7:49 PM, Jim Giner  
> wrote:
> >
> > ""Jim Giner""  wrote in message
> > news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2...
> >> ===
> >> Martijn & Jim -
> >>
> >> Is it just the date that is the problem?
> >>
> >> Yes.
> >>
> >> Tru dat.  But mySql doesn't want the dashes embedded.  The format string
> >> should be "Ymd" instead.
> >>
> >> That's what I am doing.  No luck.
> >>
> >> Ethan
> >>
> >> *
> >> You're using a format with just Ymd in it (no dashes)?  Can you post
> >> *just* the query as it is looks in your php code?
> >>
> >>
> >>
> > While waiting - I looked at your code again.  What is the (greater than)
> > symbol doing in front of your $Date var?
> >> > Date) VALUES(null, '$Site', '$MedRec', '$Notes', $Weight, $BMI, >
> >> > '$Date'";
> >
> > Also - is it valid to use the word 'Date' as a field name?  Just wondering.
> 
> It is valid, though It may require quotes (backtick ?)
> 
Hi,

Have you tried to write out the generated sql with var_dump() and then
feed it to an SQL interface? By using Mysql Query Browser you can easily
check it the sql-string is correct.

Regards
Lars Nielsen 
LFWeb


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] search of data base - again

[Matijn Woudt]

On Fri, Mar 30, 2012 at 7:49 PM, Jim Giner  wrote:
>
> ""Jim Giner""  wrote in message
> news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2...
>> ===
>> Martijn & Jim -
>>
>> Is it just the date that is the problem?
>>
>> Yes.
>>
>> Tru dat.  But mySql doesn't want the dashes embedded.  The format string
>> should be "Ymd" instead.
>>
>> That's what I am doing.  No luck.
>>
>> Ethan
>>
>> *
>> You're using a format with just Ymd in it (no dashes)?  Can you post
>> *just* the query as it is looks in your php code?
>>
>>
>>
> While waiting - I looked at your code again.  What is the (greater than)
> symbol doing in front of your $Date var?
>> > Date) VALUES(null, '$Site', '$MedRec', '$Notes', $Weight, $BMI, >
>> > '$Date'";
>
> Also - is it valid to use the word 'Date' as a field name?  Just wondering.

It is valid, though It may require quotes (backtick ?)

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] search of data base - again

[Jim Giner]

""Jim Giner""  wrote in message 
news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2...
> ===
> Martijn & Jim -
>
> Is it just the date that is the problem?
>
> Yes.
>
> Tru dat.  But mySql doesn't want the dashes embedded.  The format string
> should be "Ymd" instead.
>
> That's what I am doing.  No luck.
>
> Ethan
>
> *
> You're using a format with just Ymd in it (no dashes)?  Can you post 
> *just* the query as it is looks in your php code?
>
>
>
While waiting - I looked at your code again.  What is the (greater than) 
symbol doing in front of your $Date var?
> > Date) VALUES(null, '$Site', '$MedRec', '$Notes', $Weight, $BMI, > 
> > '$Date'";

Also - is it valid to use the word 'Date' as a field name?  Just wondering.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] search of data base - again

[Jim Giner]

===
Martijn & Jim -

Is it just the date that is the problem?

Yes.

Tru dat.  But mySql doesn't want the dashes embedded.  The format string
should be "Ymd" instead.

That's what I am doing.  No luck.

Ethan

*
You're using a format with just Ymd in it (no dashes)?  Can you post *just* 
the query as it is looks in your php code?





--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] search of data base - again

[Ethan Rosenberg]

See below-
- Original Message - From: "Ethan Rosenberg" 
Newsgroups: php.db
To: "Matijn Woudt" 
Cc: "php-db-lists.php.net" 
; 

Sent: Friday, March 30, 2012 1:00 PM
Subject: Re: [PHP-DB] search of data base - again


At 07:15 PM 3/29/2012, Matijn Woudt wrote:

On Fri, Mar 30, 2012 at 1:10 AM, Ethan Rosenberg  wrote:
> Sending again, since no response on 1st try.
>
> Ethan
> ==
> Dear List
>
> I am trying to insert data into a table, with no success.
>
> I have two tables:
>
> mysql> describe Visit3;
> ++--+--+-+-++
> | Field  | Type         | Null | Key | 
Default | Extra        >  |

> ++--+--+-+-++
> | Indx   | int(4)       | NO   | PRI | NULL    | auto_increment |
> | Site   | varchar(6)   | YES  |     |
NULL Â  Â | Â  Â  Â  Â  Â  Â  Â  Â |
> | MedRec | int(6) Â  Â  Â  | YES Â | Â  Â  |
NULL Â  Â | Â  Â  Â  Â  Â  Â  Â  Â |
> | Notes  | text         | YES  |
    | NULL    |                |
> | Weight | int(4) Â  Â  Â  | YES Â | Â  Â  |
NULL Â  Â | Â  Â  Â  Â  Â  Â  Â  Â |
> | BMI Â  Â | decimal(3,1) | YES Â | Â  Â  |
NULL Â  Â | Â  Â  Â  Â  Â  Â  Â  Â |
> | Date   | date         | YES  |
    | NULL    |                |
> ++--+--+-+-++
>
> ++-+--+-+-+---+
> | Field  | Type        | Null | Key | Default | Extra |
> ++-+--+-+-+---+
> | Site   | varchar(6)  | NO   | PRI |         |       |
> | MedRec | int(6) Â  Â  Â | NO Â  | PRI | NULL Â  Â | Â  Â  Â  |
> | Fname  | varchar(15) | YES  |     | NULL    |       |
> | Lname  | varchar(30) | YES  |     | NULL    |       |
> | Phone  | varchar(30) | YES  |     | NULL    |       |
> | Height | int(4) Â  Â  Â | YES Â | Â  Â  | NULL Â  Â | Â  Â  Â  |
> | Sex    | char(7)     | YES  |     | NULL    |       |
> | Hx     | text        | YES  |     | NULL    |       |
> ++-+--+-+-+---+
>
> I calculate some values:
>
> Â  Â default_timezone_set('America/New_York');
>     $Date  = date('M d Y');
> Â  Â  $sql1 = "select MedRec, Height from Intake3 where (MedRec =
> '$_POST[MedRec]')";
> Â  Â  $result = mysqli_query($cxn, $sql1);
> Â  Â $row = mysqli_fetch_array($result);
> Â  Â $MedRec = $row[0];
> Â  Â $Height = $row[1];
> Â  Â $Weight = $_POST['Weight'];
>    $Notes  = $_POST['Notes'];
> Â  Â $sql4 = "select MedRec, Weight from Visit3 where (MedRec =
> $_POST[MedRec])";
> Â  Â $result4 = mysqli_query($cxn, $sql4);
> Â  Â $row4 = mysqli_fetch_array($result4);
> Â  Â $MedRec = $_POST['MedRec'];
> Â  Â $BMI = ($Weight*703)/($Height*$Height);
> Â  Â $BMI = round($BMI,1);
> Â  Â $fptr1 = fopen("/home/ethan/PHP/HRecnumSite", "r+");
> Â  Â fscanf($fptr1,"%d %s",$Num, $Site);
> Â  Â echo "$Site, $MedRec, $Notes, $Weight $BMI, $Date ";
> Â  Â $sql2 = Â "INSERT INTO Visit3(Indx, 
Site, MedRec, Notes, Weight, > BMI,

> Date) VALUES(null, '$Site', '$MedRec', '$Notes', $Weight, $BMI, > '$Date'";
> Â  Â $result2 = mysqli_query($cxn, $sql2);
>
> They display properly.
>
> $sql3 = "select max(Indx) from Visit3";
> $result3 = mysqli_query($cxn, $sql3);
> var_dump($result3);
> echo "result3 Â  ";
> print_r($result3);
> $row = mysqli_fetch_array($result3);
> $Indx = $row[0];
>
> echo "\n";
>
> echo " $Indx \n";
> echo " $Site \n";
> echo " $MedRec \n";
> echo " $Notes \n";
> echo " $Weight \n";
> echo " $BMI \n";
> echo " $Date \n";
>
> echo "\n";
> echo "";
>
> The date value is not inserted properly into the table:
>
> mysql> select * from Visit3;
> | 2416 | AA Â  | Â 10001 | uih s45t | Â  Â 125 | 19.0 | -00-00 |
> | 2417 | AA Â  | Â 1 | bnkjlolk | Â  Â 174 | 28.1 | -00-00 |
>
> Advice and help, please.
>
> Thanks.
>
> Ethan Rosenberg
>

I think MySQL wants the date in -M-D format, did you try changing
$Date  = date('M d Y');
to
$Date  = date('Y-m-d');

- Matijn

==
Martijn & Jim -

Thanks.

I made the suggested changes.  The date still is not in the database.

Advice and help, please.

Ethan

===
Martijn & Jim -

Is it just the date that is the problem?

Yes.

Tru dat.  But mySql doesn't want the dashes embedded.  The format string
should be "Ymd" instead.

That's what I am doing.  No luck.

Ethan 




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] search of data base - again

[Jim Giner]

>
>I think MySQL wants the date in -M-D format, did you try changing
>$Date  = date('M d Y');
>to
>$Date  = date('Y-m-d');
>
>- Matijn

Tru dat.  But mySql doesn't want the dashes embedded.  The format string 
should be "Ymd" instead.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] search of data base - again

[Ethan Rosenberg]

At 07:15 PM 3/29/2012, Matijn Woudt wrote:

On Fri, Mar 30, 2012 at 1:10 AM, Ethan Rosenberg  wrote:
> Sending again, since no response on 1st try.
>
> Ethan
> ==
> Dear List
>
> I am trying to insert data into a table, with no success.
>
> I have two tables:
>
> mysql> describe Visit3;
> ++--+--+-+-++
> | Field  | Type         | Null | Key | Default | Extra          |
> ++--+--+-+-++
> | Indx   | int(4)       | NO   | PRI | NULL    | auto_increment |
> | Site   | varchar(6)   | YES  |     | 
NULL Â  Â | Â  Â  Â  Â  Â  Â  Â  Â |
> | MedRec | int(6) Â  Â  Â  | YES Â | Â  Â  | 
NULL Â  Â | Â  Â  Â  Â  Â  Â  Â  Â |
> | Notes  | text         | YES  | 
    | NULL    |                |
> | Weight | int(4) Â  Â  Â  | YES Â | Â  Â  | 
NULL Â  Â | Â  Â  Â  Â  Â  Â  Â  Â |
> | BMI Â  Â | decimal(3,1) | YES Â | Â  Â  | 
NULL Â  Â | Â  Â  Â  Â  Â  Â  Â  Â |
> | Date   | date         | YES  | 
    | NULL    |                |

> ++--+--+-+-++
>
> ++-+--+-+-+---+
> | Field  | Type        | Null | Key | Default | Extra |
> ++-+--+-+-+---+
> | Site   | varchar(6)  | NO   | PRI |         |       |
> | MedRec | int(6) Â  Â  Â | NO Â  | PRI | NULL Â  Â | Â  Â  Â  |
> | Fname  | varchar(15) | YES  |     | NULL    |       |
> | Lname  | varchar(30) | YES  |     | NULL    |       |
> | Phone  | varchar(30) | YES  |     | NULL    |       |
> | Height | int(4) Â  Â  Â | YES Â | Â  Â  | NULL Â  Â | Â  Â  Â  |
> | Sex    | char(7)     | YES  |     | NULL    |       |
> | Hx     | text        | YES  |     | NULL    |       |
> ++-+--+-+-+---+
>
> I calculate some values:
>
> Â  Â default_timezone_set('America/New_York');
>     $Date  = date('M d Y');
> Â  Â  $sql1 = "select MedRec, Height from Intake3 where (MedRec =
> '$_POST[MedRec]')";
> Â  Â  $result = mysqli_query($cxn, $sql1);
> Â  Â $row = mysqli_fetch_array($result);
> Â  Â $MedRec = $row[0];
> Â  Â $Height = $row[1];
> Â  Â $Weight = $_POST['Weight'];
>    $Notes  = $_POST['Notes'];
> Â  Â $sql4 = "select MedRec, Weight from Visit3 where (MedRec =
> $_POST[MedRec])";
> Â  Â $result4 = mysqli_query($cxn, $sql4);
> Â  Â $row4 = mysqli_fetch_array($result4);
> Â  Â $MedRec = $_POST['MedRec'];
> Â  Â $BMI = ($Weight*703)/($Height*$Height);
> Â  Â $BMI = round($BMI,1);
> Â  Â $fptr1 = fopen("/home/ethan/PHP/HRecnumSite", "r+");
> Â  Â fscanf($fptr1,"%d %s",$Num, $Site);
> Â  Â echo "$Site, $MedRec, $Notes, $Weight $BMI, $Date ";
> Â  Â $sql2 = Â "INSERT INTO Visit3(Indx, Site, MedRec, Notes, Weight, BMI,
> Date) VALUES(null, '$Site', '$MedRec', '$Notes', $Weight, $BMI, '$Date'";
> Â  Â $result2 = mysqli_query($cxn, $sql2);
>
> They display properly.
>
> $sql3 = "select max(Indx) from Visit3";
> $result3 = mysqli_query($cxn, $sql3);
> var_dump($result3);
> echo "result3 Â  ";
> print_r($result3);
> $row = mysqli_fetch_array($result3);
> $Indx = $row[0];
>
> echo "\n";
>
> echo " $Indx \n";
> echo " $Site \n";
> echo " $MedRec \n";
> echo " $Notes \n";
> echo " $Weight \n";
> echo " $BMI \n";
> echo " $Date \n";
>
> echo "\n";
> echo "";
>
> The date value is not inserted properly into the table:
>
> mysql> select * from Visit3;
> | 2416 | AA Â  | Â 10001 | uih s45t | Â  Â 125 | 19.0 | -00-00 |
> | 2417 | AA Â  | Â 1 | bnkjlolk | Â  Â 174 | 28.1 | -00-00 |
>
> Advice and help, please.
>
> Thanks.
>
> Ethan Rosenberg
>

I think MySQL wants the date in -M-D format, did you try changing
$Date  = date('M d Y');
to
$Date  = date('Y-m-d');

- Matijn

==
Martijn & Jim -

Thanks.

I made the suggested changes.  The date still is not in the database.

Advice and help, please.

Ethan 




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] search of data base - again

[Jim Giner]

I agree with Martin's assessment.  Took me awhile to always remember to have 
the date in the correct format. 



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php