See below-----
----- Original Message ----- From: "Ethan Rosenberg" <ethros@xxxxxxxxxxxxx>
Newsgroups: php.db
To: "Matijn Woudt" <tijnema@xxxxxxxxx>
Cc: "php-db-lists.php.net"
<php-db@xxxxxxxxxxxxx>; <jim.giner@xxxxxxxxxxxxxxxxxx>
Sent: Friday, March 30, 2012 1:00 PM
Subject: Re: 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 <ethros@xxxxxxxxxxxxx> 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 <br />";
> Â Â $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 "<tr>\n";
>
> echo "<td> $Indx </td>\n";
> echo "<td> $Site </td>\n";
> echo "<td> $MedRec </td>\n";
> echo "<td> $Notes </td>\n";
> echo "<td> $Weight </td>\n";
> echo "<td> $BMI </td>\n";
> echo "<td> $Date </td>\n";
>
> echo "</tr>\n";
> echo "</table>";
>
> The date value is not inserted properly into the table:
>
> mysql> select * from Visit3;
> | 2416 | AA Â | Â 10001 | uih s45t | Â Â 125 | 19.0 | 0000-00-00 |
> | 2417 | AA Â | Â 10000 | bnkjlolk | Â Â 174 | 28.1 | 0000-00-00 |
>
> Advice and help, please.
>
> Thanks.
>
> Ethan Rosenberg
>
I think MySQL wants the date in YYYY-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
