Re: search of data base - again
Matijn Woudt <[email protected]>
| Newsgroups | gmane.comp.php.database |
|---|---|
| Message-ID | <CAC_gtuOK_3Ga54_pkemS=r3Y3LU-474Z19wboh6-YEEofOmQuA@mail.gmail.com> |
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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php