Re: search of data base - again

See below-----
----- Original Message ----- From: "Ethan Rosenberg" <[email protected]>
Newsgroups: php.db
To: "Matijn Woudt" <[email protected]>
Cc: "php-db-lists.php.net" 
<[email protected]>; <[email protected]>
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 <[email protected]> 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