Re: [PHP] PHP & Database Problems -- Code Snippets
On Thu, May 3, 2012 at 4:20 PM, Ethan Rosenberg wrote:
> At 06:47 PM 5/2/2012, Matijn Woudt wrote:
>>
>> On Wed, May 2, 2012 at 11:43 PM, Ethan Rosenberg
>> wrote: > Dear list - > > Sorry for the attachment. Â Here are code snippets
>> --- Ethan, I don't want to sound rude, but it appears to me you don't have
>> any understanding of what you're doing. It might help if you understand what
>> the code is doing... Let me explain. > > GET THE DATA FROM INTAKE3: > > Â Â
>> function handle_data() > Â Â { > Â Â Â global $cxn; > Â Â Â $query =
>> "select * from Intake3 where  1"; > > > >   Â
>> if(isset($_Request['Sex'])&& trim($_POST['Sex']) != '' ) $_Request does not
>> exists, you're looking for $_REQUEST. And why are you mixing $_REQUEST and
>> $_POST here? > Â Â Â { > Â Â Â Â Â Â if ($_REQUEST['Sex'] === "0") >
>> Â Â Â Â Â Â { > Â Â Â Â Â Â Â $sex = 'Male'; > Â Â Â Â Â Â
>> } > Â Â Â Â Â Â else > Â Â Â Â Â Â { > Â Â Â Â Â Â Â $sex =
>> 'Female'; > Â Â Â Â Â Â } > Â Â Â } > > Â Â } What is the point of
>> the handle_data function above? It doesn't do anything. > Â Â
>> $allowed_fields = array > Â Â Â ( Â 'Site' =>$_POST['Site'], 'MedRec' =>
>> $_POST['MedRec'], 'Fname' => > $_POST['Fname'], 'Lname' => $_POST['Lname'] ,
>> > Â Â Â Â Â Â 'Phone' => $_POST['Phone'] , 'Sex' => $_POST['Sex'] Â ,
>> 'Height' > => $_POST['Height'] Â ); > > Â Â if(empty($allowed_fields)) > Â
>> Â { > Â Â Â Â Â echo "ouch"; > Â Â } > > Â Â $query = "select * from
>> Intake3  where  1 "; > >   foreach ( $allowed_fields as $key => $val )
>> > Â Â { > Â Â Â if ( (($val != '')) ) > > Â Â { > Â Â Â $query .= "
>> AND ($key  = '$val') "; >   } >    $result1 = mysqli_query($cxn,
>> $query); > Â Â } First, this will allow SQL injections, because you insert
>> the values directly from the browser. Second, you should move the last line
>> ($result1=...), outside of the foreach loop, now you're executing the query
>> multiple times. Third, you should check if $result1 === FALSE, in case the
>> query fails > > Â Â $num = mysqli_num_rows($result1); > Â Â if(($num =
>> mysqli_num_rows($result1)) == 0) Doing the same thing twice? > Â Â { > ?> >
>> Â Â No
>> Records > Retrieved #1 > Â Â exit(); > Â
>> Â } > > DISPLAY THE INPUT3 DATA: > THIS SEEMS TO BE THE ROUTINE THAT
>> IS FAILING <<< > > Â Â Search Results > > Â
>> Â > > Â frame="box"> > Â Â > Â Â Site > Â Â
>> Medical Record > Â Â First Name > Â Â Last Name
>> > Â Â Phone > Â Â Height > Â Â Sex > Â Â
>> History > Â Â > > > Â Â Â while ($row1 =
>> mysqli_fetch_array($result1, MYSQLI_BOTH)) > Â Â Â { > Â Â Â Â Â Â
>> print_r($_POST); Doesn't really make sense to print $_POST here.. > Â Â Â
>> Â Â Â Â global $MDRcheck; > Â Â Â Â Â Â Â $n1++; > Â Â Â Â Â
>> Â Â echo "n1 ";echo $n1; > Â Â Â Â Â Â { > Â Â Â Â Â
>> Â Â if (($n1 > 2) && ($MDRcheck == $row1[1])) > Â Â Â Â Â Â Â { >
>> Â Â Â Â Â Â Â Â Â Â echo ">2== Â "; > Â Â Â Â Â Â Â Â Â Â
>> echo $MDRcheck; > Â Â Â Â Â Â Â Â Â Â echo " $row1[0] \n";
>> > Â Â Â Â Â Â Â Â Â Â echo " $row1[1] \n"; > Â Â Â Â Â
>> Â Â Â Â Â echo " $row1[2] \n"; > Â Â Â Â Â Â Â Â Â Â
>> echo " $row1[3] \n"; > Â Â Â Â Â Â Â Â Â Â echo "
>> $row1[4] \n"; > Â Â Â Â Â Â Â Â Â Â echo " $row1[5]
>> \n"; > Â Â Â Â Â Â Â Â Â Â echo " $row1[6] \n"; > Â
>> Â Â Â Â Â Â Â Â Â echo " $row1[7] \n"; > Â Â Â Â Â Â
>> Â Â Â Â echo "\n"; > Â Â Â Â Â Â Â } > Â Â Â Â Â Â Â
>> elseif (($n1 > 2) && ($MDRcheck != $row1[1])) > Â Â Â Â Â Â Â { > Â
>> Â Â Â Â Â Â Â Â Â echo ">2!= Â "; > > Â Â Â Â Â Â Â Â Â Â
>> echo $MDRcheck; > > > Â Â Â Â Â Â Â Â Â Â continue; continue
>> doesn't do anything here. > Â Â Â Â Â Â Â } > Â Â Â Â Â Â Â
>> elseif ($n1 == 2) > Â Â Â Â Â Â Â { > > Â Â Â Â Â Â Â Â Â Â
>> define( "MDR" , Â $row1[1]); > Â Â Â Â Â Â Â Â Â Â echo "row1
>> ";echo $row1[1]; > Â Â Â Â Â Â Â Â Â Â echo "\n"; > > Â Â
>> Â Â Â Â Â Â Â Â $_GLOBALS['mdr']= $row1[1]; > Â Â Â Â Â Â Â Â
>> Â Â $_POST['MedRec'] = $row1[1]; You're not supposed to set variables in
>> $_POST... > Â Â Â Â Â Â Â Â Â Â $MDRold = $_GLOBALS['mdr']; It
>> appears you want the old value of mdr, if so, then you should do this before
>> you set it again 2 lines above.. > Â Â Â Â Â Â Â Â Â Â echo "
>> $row1[0] \n"; > Â Â Â Â Â Â Â Â Â Â echo " $row1[1]
>> \n"; > Â Â Â Â Â Â Â Â Â Â echo " $row1[2] \n"; > Â
>> Â Â Â Â Â Â Â Â Â echo " $row1[3] \n"; > Â Â Â Â Â Â
>> Â Â Â Â echo " $row1[4] \n"; > Â Â Â Â Â Â Â Â Â Â
>> echo " $row1[5] \n"; > Â Â Â Â Â Â Â Â Â Â echo "
>> $row1[6] \n"; > Â Â Â Â Â Â Â Â Â Â echo " $row1[7]
>> \n"; > Â Â Â Â Â Â Â Â Â Â echo
Re: [PHP] PHP & Database Problems -- Code Snippets - Any more Ideas?
Am 04.05.2012 16:09, schrieb Ethan Rosenberg:
function handle_data()
{
global $cxn;
What does this function? It neither takes any parameters nor returns any
value. And it does not write back anything to its global $cxn. So it is
quite useless and can be deleted.
$query = "select * from Intake3 where 1";
if(isset($_Request['Sex'])&& trim($_POST['Sex']) != '' )
there is no variable $_Request, it is $_REQUEST.
Why do you test on $_REQUEST and compare it with trimmed $_POST?
{
if ($_REQUEST['Sex'] === "0")
{
$sex = 'Male';
}
else
{
$sex = 'Female';
}
Why do you set a variable that is never used?
$allowed_fields = array
( 'Site' =>$_POST['Site'], 'MedRec' => $_POST['MedRec'], 'Fname' =>
$_POST['Fname'], 'Lname' => $_POST['Lname'] ,
'Phone' => $_POST['Phone'] , 'Sex' => $_POST['Sex'] , 'Height' =>
$_POST['Height'] );
if(empty($allowed_fields))
{
echo "ouch";
}
$query = "select * from Intake3 where 1 ";
foreach ( $allowed_fields as $key => $val )
{
if ( (($val != '')) )
{
$query .= " AND ($key = '$val') ";
Why the hell do you put unverified data into an sql query?
DISPLAY THE INPUT3 DATA:
>>> THIS SEEMS TO BE THE ROUTINE THAT IS FAILING <<<
What fails?
I do not have access to your database, so I can not run your code to see
what fails.
n1 ";echo $n1;
{
if (($n1 > 2) && ($MDRcheck == $row1[1]))
What is $MDRcheck and what does this comparision mean?
SELECT AND DISPLAY DATA FROM VISIT3 DATABASE
Quotes around mdr missing
$result2 = mysqli_query($cxn, $query2);
$num = mysqli_num_rows($result2);
global $finished;
$finished = 0;
while($row2 = mysqli_fetch_array($result2, MYSQLI_BOTH))
{
global $finished;
No need to global that twice.
And why ndo you use global and $_GLOBALS? STick to one or better skip it
anyways. Globals are not to be used!
switch ( @$_POST[next_step] )
Remove all @ from your code or you won't see any errors on this.
Do proper checking and do NOT suppress errors or warnings.
echo "";
echo "";
echo "";
echo "Medical Record: ";
Quotes.
$Weight = $_POST['Weight'];
$Notes = $_POST['Notes'];
$sql2 = "INSERT INTO Visit3(Indx, Site, MedRec, Notes, Weight, BMI,
Date) VALUES(null, '$Site', '$MDRold', '$Notes',
Do NOT NEVER put data that is user input unchecked into a query.
?>
?>
Double closing tag?
echo " $_GLOBALS[mdr] \n";
Quotes.
$flag = 1;
What's this?
You really really should seperate your code from HTML.
Please truncate your apache and php error log.
Add
error_reporting(E_ALL);
ini_set('display_errors', 'On');
at the top of every php file right after Remove all @ from your lines and execute your script another time and
see what errors are appear into your browser and your logfiles. Post
them and the codelines for these errors on the list.
--
Marco Behnke
Dipl. Informatiker (FH), SAE Audio Engineer
Zend Certified Engineer PHP 5.3
Tel.: 0174 / 9722336
e-Mail: ma...@behnke.biz
Softwaretechnik Behnke
Heinrich-Heine-Str. 7D
21218 Seevetal
http://www.behnke.biz
smime.p7s
Description: S/MIME Kryptografische Unterschrift
[PHP] RE: [PHP-DB] [PHP] PHP & Database Problems -- Code Snippets - Any more Ideas?
Ethan,
You have been given advise and break down on your code.
Have you taken the advise given?
Which part of the code isn't working? Not which chunk, but break it down and
show which part
BR,
Gav
-Original Message-
From: Ethan Rosenberg [mailto:eth...@earthlink.net]
Sent: 04 May 2012 15:10
To: php-db-lists.php.net; php-general@lists.php.net
Subject: [PHP-DB] [PHP] PHP & Database Problems -- Code Snippets - Any more
Ideas?
I am sending this again to see if more ideas for solution of this problem
are available.
Ethan
===
Dear list -
Sorry for the attachment. Here are code snippets ---
GET THE DATA FROM INTAKE3:
function handle_data()
{
global $cxn;
$query = "select * from Intake3 where 1";
if(isset($_Request['Sex'])&& trim($_POST['Sex']) != '' )
{
if ($_REQUEST['Sex'] === "0")
{
$sex = 'Male';
}
else
{
$sex = 'Female';
}
}
}
$allowed_fields = array
( 'Site' =>$_POST['Site'], 'MedRec' => $_POST['MedRec'], 'Fname' =>
$_POST['Fname'], 'Lname' => $_POST['Lname'] ,
'Phone' => $_POST['Phone'] , 'Sex' => $_POST['Sex'] ,
'Height' => $_POST['Height'] );
if(empty($allowed_fields))
{
echo "ouch";
}
$query = "select * from Intake3 where 1 ";
foreach ( $allowed_fields as $key => $val )
{
if ( (($val != '')) )
{
$query .= " AND ($key = '$val') ";
}
$result1 = mysqli_query($cxn, $query);
}
$num = mysqli_num_rows($result1);
if(($num = mysqli_num_rows($result1)) == 0)
{
?>
No
Records Retrieved #1 >> THIS SEEMS TO BE THE ROUTINE THAT IS FAILING <<<
Search Results
Site
Medical Record
First Name
Last Name
Phone
Height
Sex
History
n1 ";echo $n1;
{
if (($n1 > 2) && ($MDRcheck == $row1[1]))
{
echo ">2== ";
echo $MDRcheck;
echo " $row1[0] \n";
echo " $row1[1] \n";
echo " $row1[2] \n";
echo " $row1[3] \n";
echo " $row1[4] \n";
echo " $row1[5] \n";
echo " $row1[6] \n";
echo " $row1[7] \n";
echo "\n";
}
elseif (($n1 > 2) && ($MDRcheck != $row1[1]))
{
echo ">2!= ";
echo $MDRcheck;
continue;
}
elseif ($n1 == 2)
{
define( "MDR" , $row1[1]);
echo "row1 ";echo $row1[1];
echo "\n";
$_GLOBALS['mdr']= $row1[1];
$_POST['MedRec'] = $row1[1];
$MDRold = $_GLOBALS['mdr'];
echo " $row1[0] \n";
echo " $row1[1] \n";
echo " $row1[2] \n";
echo " $row1[3] \n";
echo " $row1[4] \n";
echo " $row1[5] \n";
echo " $row1[6] \n";
echo " $row1[7] \n";
echo "\n";
}
}
}
?>
SELECT AND DISPLAY DATA FROM VISIT3 DATABASE
\n";
echo " $row2[0] \n";
echo " $row2[1] \n";
echo " $row2[2] \n";
echo " $row2[3] \n";
echo " $row2[4] \n";
echo " $row2[5] \n";
echo " $row2[6] \n";
echo "\n";
}
echo "";
ENTER MORE DATA:
function More_Data()
{
$decision = 5;
?>
Do you Wish to Enter More Data?
Yes
No
>>>>end function More_Data
switch ( @$_POST[next_step] )
{
case "step10":
{
if (!isset($_POST['decision']))
{
$_POST['decision'] = 5;
}
if ($_POST['decision'] == 0)
{
exit();
}
Re: [PHP] PHP & Database Problems -- Code Snippets - Any more Ideas?
Ethan, before you get frustrated or feel abandoned, let me *sincerely* try to help: Here is honestly what I am utterly convinced you need to do to get any where in the medium/long run: Break everything down into very small steps. Making web apps is just building a whole lot of layers/collections of very small simple things. Nothing is out of your grasp.. it only appears mysterious or complicated because you are not familiar with the terms/code structures and have not spent enough time with the little things to recognize them like english speakers do when reading written english. So what you do to get out of the woods (and it works every time), regardless of the problem, is just focus on one small thing at a time. START OVER. Throw out all the code, especially everything you borrowed from other sources. Write everything yourself, from scratch. Just print "hello" to a web page. Then add in the ability to do ONE more thing that you need... like reading from a db, or writing to a db... and then processing/manipulating things, as you need. Test everything every time you add even ONE little feature. Then as soon as something breaks, you know instantly where the issue lays.. and focus on solving why that one little thing is broken. If re-reading the docs about whatever code structures you used at that point (of your newly-added broken feature) does not clear it up for you, then post just that ONE little issue to this list.. asking why that one thing is behaving that way. Like this (using this tedious but effective method) , you will get your code into shape so it works, you will not alienate yourself from the help you need (by posting volumes of broken code with no evidence that you are actually trying to learn), and best of all - you will, step by step, come to master all this stuff! Everyone loves to help answer/clear up one little thing, but no one has time to digest a whole broken page/app and tell you where all the issues are. Even if they did have the time and inclination, they would lose it after the very first time they saw you take what they gave you and come back 3 weeks later with evidence that you never learned anything from the last episode. Believe me you will always have people climbing over each other to help you, if you can just break down your problems into such small portions that you will be able to realize you have the smarts to answer them yourself. ;-) There is a very lively, effective and popular coders community (and Q/A tool set) here: http://stackoverflow.com/ ..where you get almost instant help to any coding question.. because there are so many people who really care to give quality help, because they get recognized for their contributions. But if you try to use the tools at stackoverflow.com then you will find there, in that very professional atmosphere, that (to get anywhere) you HAVE to ask questions that are distilled down to something very specific and answerable in a specific/factual kind of way, as opposed to question that bring up more fuzzy-boundaried topics, like questions of preference or style, or questions that show an utter lack of homework/effort on the part of the asker which require more than a couple specific facts to answer. You can train here or on stackoverflow.com, but anywhere you go, you will find the same situation, that you have to use baby steps (as necessary) - for your own learning, and to get any decent help. -Govinda -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP & Database Problems -- Code Snippets - Any more Ideas?
Nor will posting to multiple lists.(Sorry to the rest of you - didn't realize it until now.) ""Jim Giner"" wrote in message news:c6.f8.38082.efae3...@pb1.pair.com... >I don't think posting the same voluminous code is going to generate any >better responses. > > The suggestion to start over and make your insert/retrieve queries fool > proof before starting to write some logic into your code was a very good > one. Why don't you work on that so that any requests for help can focus > on just that instead of the 100+ lines of code you are posting? Reading > some documentation on sql and some html/php relationships would be VERY > beneficial to your long-term success as a programmer as well. > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP & Database Problems -- Code Snippets - Any more Ideas?
I don't think posting the same voluminous code is going to generate any better responses. The suggestion to start over and make your insert/retrieve queries fool proof before starting to write some logic into your code was a very good one. Why don't you work on that so that any requests for help can focus on just that instead of the 100+ lines of code you are posting? Reading some documentation on sql and some html/php relationships would be VERY beneficial to your long-term success as a programmer as well. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP & Database Problems -- Code Snippets - Any more Ideas?
I am sending this again to see if more ideas for solution of this
problem are available.
Ethan
===
Dear list -
Sorry for the attachment. Here are code snippets ---
GET THE DATA FROM INTAKE3:
function handle_data()
{
global $cxn;
$query = "select * from Intake3 where 1";
if(isset($_Request['Sex'])&& trim($_POST['Sex']) != '' )
{
if ($_REQUEST['Sex'] === "0")
{
$sex = 'Male';
}
else
{
$sex = 'Female';
}
}
}
$allowed_fields = array
( 'Site' =>$_POST['Site'], 'MedRec' => $_POST['MedRec'],
'Fname' => $_POST['Fname'], 'Lname' => $_POST['Lname'] ,
'Phone' => $_POST['Phone'] , 'Sex' => $_POST['Sex'] ,
'Height' => $_POST['Height'] );
if(empty($allowed_fields))
{
echo "ouch";
}
$query = "select * from Intake3 where 1 ";
foreach ( $allowed_fields as $key => $val )
{
if ( (($val != '')) )
{
$query .= " AND ($key = '$val') ";
}
$result1 = mysqli_query($cxn, $query);
}
$num = mysqli_num_rows($result1);
if(($num = mysqli_num_rows($result1)) == 0)
{
?>
No Records Retrieved #1
>> THIS SEEMS TO BE THE ROUTINE THAT IS FAILING <<<
Search Results
cellspacing="55" rules="all" frame="box">
Site
Medical Record
First Name
Last Name
Phone
Height
Sex
History
n1 ";echo $n1;
{
if (($n1 > 2) && ($MDRcheck == $row1[1]))
{
echo ">2== ";
echo $MDRcheck;
echo " $row1[0] \n";
echo " $row1[1] \n";
echo " $row1[2] \n";
echo " $row1[3] \n";
echo " $row1[4] \n";
echo " $row1[5] \n";
echo " $row1[6] \n";
echo " $row1[7] \n";
echo "\n";
}
elseif (($n1 > 2) && ($MDRcheck != $row1[1]))
{
echo ">2!= ";
echo $MDRcheck;
continue;
}
elseif ($n1 == 2)
{
define( "MDR" , $row1[1]);
echo "row1 ";echo $row1[1];
echo "\n";
$_GLOBALS['mdr']= $row1[1];
$_POST['MedRec'] = $row1[1];
$MDRold = $_GLOBALS['mdr'];
echo " $row1[0] \n";
echo " $row1[1] \n";
echo " $row1[2] \n";
echo " $row1[3] \n";
echo " $row1[4] \n";
echo " $row1[5] \n";
echo " $row1[6] \n";
echo " $row1[7] \n";
echo "\n";
}
}
}
?>
SELECT AND DISPLAY DATA FROM VISIT3 DATABASE
$query2 = "select * from Visit3 where 1 AND (Site = 'AA') AND
(MedRec = $_GLOBALS[mdr])";
$result2 = mysqli_query($cxn, $query2);
$num = mysqli_num_rows($result2);
global $finished;
$finished = 0;
while($row2 = mysqli_fetch_array($result2, MYSQLI_BOTH))
{
global $finished;
echo "\n";
echo " $row2[0] \n";
echo " $row2[1] \n";
echo " $row2[2] \n";
echo " $row2[3] \n";
echo " $row2[4] \n";
echo " $row2[5] \n";
echo " $row2[6] \n";
echo "\n";
}
echo "";
ENTER MORE DATA:
function More_Data()
{
$decision = 5;
?>
Do you Wish to Enter More Data?
Yes
No
end function More_Data
switch ( @$_POST[next_step] )
{
case "step10":
{
if (!isset($_POST['decision']))
{
$_POST['decision'] = 5;
}
if ($_POST['decision'] == 0)
{
exit();
}
if ($_POST['decision'] == 1)
{
;
echo "";
echo "value=\"step4\" />";
echo "";
echo "Medical Record: name=\"MedRec\" value=\" $_GLOBALS[mdr]\" />";
echo " Weight: name=\"Weight\" /> ";
echo "Notes: ";
echo "rows=\"10\" wrap=\"hard\" name=\"Notes\" > ";
echo "";
echo " ";
echo "";
echo "";
}
} /* End Step10 */
case "step4":
{
if (!isset($_POST['datain']))
{
$_POST['datain'] = 5;
}
if( $_POST['datain'] == "already")
{
date_default_timezone_set('America/New_York');
$Date = date('Ymd');
$Date2 = date('d M Y');
$sql1 = "select MedRec, Height from Intake3 where
(MedRec = $MDRold)";
$result4 = mysqli_query($cxn, $sql1);
$row4 = m
Re: [PHP] PHP & Database Problems -- Code Snippets
At 06:47 PM 5/2/2012, Matijn Woudt wrote:
On Wed, May 2, 2012 at 11:43 PM, Ethan Rosenberg
wrote: > Dear list - > >
Sorry for the attachment. Â Here are code
snippets --- Ethan, I don't want to sound rude,
but it appears to me you don't have any
understanding of what you're doing. It might
help if you understand what the code is doing...
Let me explain. > > GET THE DATA FROM
INTAKE3: > > Â Â function handle_data() > Â Â
{ > Â Â Â global $cxn; > Â Â Â $query =
"select * from Intake3 where  1"; > > > >
   if(isset($_Request['Sex'])&&
trim($_POST['Sex']) != '' ) $_Request does not
exists, you're looking for $_REQUEST. And why
are you mixing $_REQUEST and $_POST here? >
   { >       if
($_REQUEST['Sex'] === "0") > Â Â Â Â Â Â
{ > Â Â Â Â Â Â Â $sex = 'Male'; >
      } >       else >
      { >        $sex =
'Female'; > Â Â Â Â Â Â } > Â Â Â } > >
  } What is the point of the handle_data
function above? It doesn't do anything. > Â Â
$allowed_fields = array > Â Â Â ( Â 'Site'
=>$_POST['Site'], 'MedRec' => $_POST['MedRec'],
'Fname' => > $_POST['Fname'], 'Lname' =>
$_POST['Lname'] , > Â Â Â Â Â Â 'Phone' =>
$_POST['Phone'] , 'Sex' => $_POST['Sex'] Â ,
'Height' > => $_POST['Height'] Â ); > > Â Â
if(empty($allowed_fields)) > Â Â { >
     echo "ouch"; >   } > >  Â
$query = "select * from Intake3  where  1
"; > > Â Â foreach ( $allowed_fields as $key =>
$val ) > Â Â { > Â Â Â if ( (($val != ''))
) > > Â Â { > Â Â Â $query .= " AND ($key Â
= '$val') "; > Â Â } > Â Â Â $result1 =
mysqli_query($cxn, $query); > Â Â } First, this
will allow SQL injections, because you insert
the values directly from the browser. Second,
you should move the last line ($result1=...),
outside of the foreach loop, now you're
executing the query multiple times. Third, you
should check if $result1 === FALSE, in case the
query fails > > Â Â $num =
mysqli_num_rows($result1); > Â Â if(($num =
mysqli_num_rows($result1)) == 0) Doing the same
thing twice? > Â Â { > ?> > Â Â />No Records > Retrieved
#1 > Â Â
exit(); > Â Â } > > DISPLAY THE INPUT3
DATA: > THIS SEEMS TO BE THE ROUTINE THAT
IS FAILING <<< > > Â Â Search
Results > > Â Â
cellspacing="55" Â rules="all" > Â
frame="box"> > Â Â >
  Site >   Medical
Record > Â Â First Name > Â Â
Last Name > Â Â Phone > Â Â
Height > Â Â Sex > Â Â
History > Â Â > > >
   while ($row1 =
mysqli_fetch_array($result1, MYSQLI_BOTH)) >
   { >       print_r($_POST);
Doesn't really make sense to print $_POST
here.. > Â Â Â Â Â Â Â global
$MDRcheck; > Â Â Â Â Â Â Â $n1++; >
       echo "n1 ";echo
$n1; > Â Â Â Â Â Â { >
       if (($n1 > 2) && ($MDRcheck
== $row1[1])) > Â Â Â Â Â Â Â { >
          echo ">2==  "; >
          echo $MDRcheck; >
          echo " $row1[0]
\n"; > Â Â Â Â Â Â Â Â Â Â echo
" $row1[1] \n"; >
          echo " $row1[2]
\n"; > Â Â Â Â Â Â Â Â Â Â echo
" $row1[3] \n"; >
          echo " $row1[4]
\n"; > Â Â Â Â Â Â Â Â Â Â echo
" $row1[5] \n"; >
          echo " $row1[6]
\n"; > Â Â Â Â Â Â Â Â Â Â echo
" $row1[7] \n"; >
          echo "\n"; >
       } >
       elseif (($n1 > 2) &&
($MDRcheck != $row1[1])) >
       { >
          echo ">2!=  "; > >
          echo
$MDRcheck; > > > Â Â Â Â Â Â Â Â Â Â
continue; continue doesn't do anything here. >
       } >
       elseif ($n1 == 2) >
       { > >
          define( "MDR" , Â
$row1[1]); > Â Â Â Â Â Â Â Â Â Â echo
"row1 ";echo $row1[1]; >
          echo "\n"; > >
          $_GLOBALS['mdr']=
$row1[1]; > Â Â Â Â Â Â Â Â Â Â
$_POST['MedRec'] = $row1[1]; You're not supposed
to set variables in $_POST... >
          $MDRold =
$_GLOBALS['mdr']; It appears you want the old
value of mdr, if so, then you should do this
before you set it again 2 lines above.. >
          echo " $row1[0]
\n"; > Â Â Â Â Â Â Â Â Â Â echo
" $row1[1] \n"; >
          echo " $row1[2]
\n"; > Â Â Â Â Â Â Â Â Â Â echo
" $row1[3] \n"; >
          echo " $row1[4]
\n"; > Â Â Â Â Â Â Â Â Â Â echo
" $row1[5] \n"; >
          echo " $row1[6]
\n"; > Â Â Â Â Â Â Â Â Â Â echo
" $row1[7] \n"; >
          echo "\n"; >
       } > >       } >
   } > > ?> You say this routine is
probably the one
Re: [PHP] PHP & Database Problems
On 5/2/2012 4:28 PM, Duken Marga wrote: But I don't see any attachments in this message. This was in the first email of this thread. I can easily extract data from the database. However, if I try to enter data, it goes into the incorrect record. Following are some screenshots. The program is attached. [pardon the comical names. This is a test, and any resemblance to true names is not intentional] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP & Database Problems -- Code Snippets
It is a good habbit to write the core code just for inserting/retrieving
data from database. It will reduce much of your code complexity. When you
see your code is working, you can continue to embed it with your visual
front-end or with your filter.
On Thu, May 3, 2012 at 4:43 AM, Ethan Rosenberg wrote:
> Dear list -
>
> Sorry for the attachment. Here are code snippets ---
>
> GET THE DATA FROM INTAKE3:
>
>function handle_data()
>{
> global $cxn;
> $query = "select * from Intake3 where 1";
>
>
>
> if(isset($_Request['Sex'])&& trim($_POST['Sex']) != '' )
> {
>if ($_REQUEST['Sex'] === "0")
>{
> $sex = 'Male';
>}
>else
>{
> $sex = 'Female';
>}
> }
>
>}
>
>$allowed_fields = array
> ( 'Site' =>$_POST['Site'], 'MedRec' => $_POST['MedRec'], 'Fname' =>
> $_POST['Fname'], 'Lname' => $_POST['Lname'] ,
> 'Phone' => $_POST['Phone'] , 'Sex' => $_POST['Sex'] ,
> 'Height' => $_POST['Height'] );
>
>if(empty($allowed_fields))
>{
> echo "ouch";
>}
>
>$query = "select * from Intake3 where 1 ";
>
>foreach ( $allowed_fields as $key => $val )
>{
> if ( (($val != '')) )
>
>{
> $query .= " AND ($key = '$val') ";
>}
> $result1 = mysqli_query($cxn, $query);
>}
>
>$num = mysqli_num_rows($result1);
>if(($num = mysqli_num_rows($result1)) == 0)
>{
> ?>
>No
> Records Retrieved #1
> exit();
>}
>
> DISPLAY THE INPUT3 DATA:
>
> >>> THIS SEEMS TO BE THE ROUTINE THAT IS FAILING <<<
>
>Search Results
>
> frame="box">
>
>Site
>Medical Record
>First Name
>Last Name
>Phone
>Height
>Sex
>History
>
>
>
> while ($row1 = mysqli_fetch_array($result1, MYSQLI_BOTH))
> {
>print_r($_POST);
> global $MDRcheck;
> $n1++;
> echo "n1 ";echo $n1;
>{
> if (($n1 > 2) && ($MDRcheck == $row1[1]))
> {
>echo ">2== ";
>echo $MDRcheck;
>echo " $row1[0] \n";
>echo " $row1[1] \n";
>echo " $row1[2] \n";
>echo " $row1[3] \n";
>echo " $row1[4] \n";
>echo " $row1[5] \n";
>echo " $row1[6] \n";
>echo " $row1[7] \n";
>echo "\n";
> }
> elseif (($n1 > 2) && ($MDRcheck != $row1[1]))
> {
>echo ">2!= ";
>
>echo $MDRcheck;
>
>
>continue;
> }
> elseif ($n1 == 2)
> {
>
>define( "MDR" , $row1[1]);
>echo "row1 ";echo $row1[1];
>echo "\n";
>
>$_GLOBALS['mdr']= $row1[1];
>$_POST['MedRec'] = $row1[1];
>$MDRold = $_GLOBALS['mdr'];
>echo " $row1[0] \n";
>echo " $row1[1] \n";
>echo " $row1[2] \n";
>echo " $row1[3] \n";
>echo " $row1[4] \n";
>echo " $row1[5] \n";
>echo " $row1[6] \n";
>echo " $row1[7] \n";
>echo "\n";
> }
>
>}
> }
>
> ?>
>
> SELECT AND DISPLAY DATA FROM VISIT3 DATABASE
>
> $query2 = "select * from Visit3 where 1 AND (Site = 'AA') AND (MedRec
> = $_GLOBALS[mdr])";
>$result2 = mysqli_query($cxn, $query2);
>$num = mysqli_num_rows($result2);
>
>
>global $finished;
>$finished = 0;
>
>
>while($row2 = mysqli_fetch_array($result2, MYSQLI_BOTH))
>{
> global $finished;
> echo "\n";
> echo " $row2[0] \n";
> echo " $row2[1] \n";
> echo " $row2[2] \n";
> echo " $row2[3] \n";
> echo " $row2[4] \n";
> echo " $row2[5] \n";
> echo " $row2[6] \n";
> echo "\n";
>
>}
>
> echo "";
>
> ENTER MORE DATA:
>
>function More_Data()
>{
> $decision = 5;
> ?>
>
>Do you Wish to Enter More Data?
>
>Yes type="radio" name="decision" value="0" />No
>
>
>
>
> } //>end function More_Data
>
>
>
>switch ( @$_POST[next_step] )
>{
>
> case "step10":
> {
>if (!isset($_POST['decision']))
>{
> $_POST['decision'] = 5;
>}
>
>if ($_POST['decision'] == 0)
>{
> exit();
>}
>if ($_POST['decision'] == 1)
>{
> ;
> echo "";
>echo " />";
>echo "";
>echo "Medical Record: value=\" $_GLOBALS[mdr]\" />";
>echo " Weight: name=\"Weight\" /> ";
>echo "Notes: ";
>
Re: [PHP] PHP & Database Problems
But I don't see any attachments in this message. On Thu, May 3, 2012 at 2:28 AM, Jim Lucas wrote: > I do believe attachments are allowed. Looking back, I see that there have > been messages sent to the list that had odt, php, and ini attachments > > > On 05/02/2012 12:12 PM, Gavin Chalkley wrote: > >> Ethan, >> >> Some coding you are using would be helpful (as far as i am aware >> attachments >> are not support on the mailing list's) >> >> Gav >> >> -Original Message- >> From: Ethan Rosenberg [mailto:eth...@earthlink.net] >> Sent: 02 May 2012 19:54 >> To: php-db-lists.php.net; php-general@lists.php.net >> Subject: [PHP-DB] PHP& Database Problems >> >> have a database >> >> mysql> describe Intake3; >> ++-+--**+-+-+---+ >> | 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| | >> ++-+--**+-+-+---+ >> 8 rows in set (0.00 sec) >> >> 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|| >> ++--+-**-+-+-+**+ >> >> and a program to enter and extract data. >> >> I can easily extract data from the database. However, if I try to enter >> data, it goes into the incorrect record. Following are some screenshots. >> The program is attached. [pardon the comical names. This is a test, and >> any resemblance to true names is not intentional] >> >> Let us say that I wish to deal with Medical Record 1: >> >> >> This it data from Intake3: >> Site Medical Record First Name Last Name Phone Height Sex History AA 1 >> David Dummy 845 365-1456 66 Male c/o obesity. Various treatments w/o >> success >> >> This is data from Visit3: >> Index Site Medical Record Notes Weight BMI Date >> 2322 AA 1 Second Visit. 170 27.4 2010-01-20 >> 2326 AA 1 Third visit. Small progress, but pt is very happy. 165 >> 26.6 2010-02-01 >> >> >> I then request to enter additional data: >> >> Site Medical Record First Name Last Name Phone Height Sex History >> AA 10003 Stupid Fool 325 563-4178 65 Male Has been convinced by his >> friends that he is obese. Normal BMI = 23. >> Index Site Medical Record Notes Weight BMI Date >> >> Notice that it is entered into record 10003 >> >> The data is "First Try" >> >> Index Site Medical Record Notes Weight BMI Date >> 2590 AA 10003 First Try 189 31.4 02 May 2012 >> >> Help and advice, please. >> >> Thanks. >> >> Ethan >> >> >> >> > > -- > Jim Lucas > > http://www.cmsws.com/ > http://www.cmsws.com/examples/ > http://www.bendsource.com/ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Duken Marga
Re: [PHP] PHP & Database Problems -- Code Snippets
On Wed, May 2, 2012 at 11:43 PM, Ethan Rosenberg wrote:
> Dear list -
>
> Sorry for the attachment. Here are code snippets ---
Ethan,
I don't want to sound rude, but it appears to me you don't have any
understanding of what you're doing. It might help if you understand
what the code is doing... Let me explain.
>
> GET THE DATA FROM INTAKE3:
>
> function handle_data()
> {
> global $cxn;
> $query = "select * from Intake3 where 1";
>
>
>
> if(isset($_Request['Sex'])&& trim($_POST['Sex']) != '' )
$_Request does not exists, you're looking for $_REQUEST. And why are
you mixing $_REQUEST and $_POST here?
> {
> if ($_REQUEST['Sex'] === "0")
> {
> $sex = 'Male';
> }
> else
> {
> $sex = 'Female';
> }
> }
>
> }
What is the point of the handle_data function above? It doesn't do anything.
> $allowed_fields = array
> ( 'Site' =>$_POST['Site'], 'MedRec' => $_POST['MedRec'], 'Fname' =>
> $_POST['Fname'], 'Lname' => $_POST['Lname'] ,
> 'Phone' => $_POST['Phone'] , 'Sex' => $_POST['Sex'] , 'Height'
> => $_POST['Height'] );
>
> if(empty($allowed_fields))
> {
> echo "ouch";
> }
>
> $query = "select * from Intake3 where 1 ";
>
> foreach ( $allowed_fields as $key => $val )
> {
> if ( (($val != '')) )
>
> {
> $query .= " AND ($key = '$val') ";
> }
> $result1 = mysqli_query($cxn, $query);
> }
First, this will allow SQL injections, because you insert the values
directly from the browser.
Second, you should move the last line ($result1=...), outside of the
foreach loop, now you're executing the query multiple times.
Third, you should check if $result1 === FALSE, in case the query fails
>
> $num = mysqli_num_rows($result1);
> if(($num = mysqli_num_rows($result1)) == 0)
Doing the same thing twice?
> {
> ?>
> No Records
> Retrieved #1
> exit();
> }
>
> DISPLAY THE INPUT3 DATA:
>
THIS SEEMS TO BE THE ROUTINE THAT IS FAILING <<<
>
> Search Results
>
> frame="box">
>
> Site
> Medical Record
> First Name
> Last Name
> Phone
> Height
> Sex
> History
>
>
>
> while ($row1 = mysqli_fetch_array($result1, MYSQLI_BOTH))
> {
> print_r($_POST);
Doesn't really make sense to print $_POST here..
> global $MDRcheck;
> $n1++;
> echo "n1 ";echo $n1;
> {
> if (($n1 > 2) && ($MDRcheck == $row1[1]))
> {
> echo ">2== ";
> echo $MDRcheck;
> echo " $row1[0] \n";
> echo " $row1[1] \n";
> echo " $row1[2] \n";
> echo " $row1[3] \n";
> echo " $row1[4] \n";
> echo " $row1[5] \n";
> echo " $row1[6] \n";
> echo " $row1[7] \n";
> echo "\n";
> }
> elseif (($n1 > 2) && ($MDRcheck != $row1[1]))
> {
> echo ">2!= ";
>
> echo $MDRcheck;
>
>
> continue;
continue doesn't do anything here.
> }
> elseif ($n1 == 2)
> {
>
> define( "MDR" , $row1[1]);
> echo "row1 ";echo $row1[1];
> echo "\n";
>
> $_GLOBALS['mdr']= $row1[1];
> $_POST['MedRec'] = $row1[1];
You're not supposed to set variables in $_POST...
> $MDRold = $_GLOBALS['mdr'];
It appears you want the old value of mdr, if so, then you should do
this before you set it again 2 lines above..
> echo " $row1[0] \n";
> echo " $row1[1] \n";
> echo " $row1[2] \n";
> echo " $row1[3] \n";
> echo " $row1[4] \n";
> echo " $row1[5] \n";
> echo " $row1[6] \n";
> echo " $row1[7] \n";
> echo "\n";
> }
>
> }
> }
>
> ?>
You say this routine is probably the one that is failing.. but what is
going wrong? And how the heck are we supposed to know what this
function should do?
>
> SELECT AND DISPLAY DATA FROM VISIT3 DATABASE
>
> $query2 = "select * from Visit3 where 1 AND (Site = 'AA') AND (MedRec =
> $_GLOBALS[mdr])";
You're using mdr as a constant here, this will generate a warning, but
sadly enough it works.
> $result2 = mysqli_query($cxn, $query2);
You should check if $result2 === FALSE, in case the query fails.
> $num = mysqli_num_rows($result2);
You're counting the rows here, but you don't do anything with the result?
>
<< Snip the rest of this crappy code >>
>
> I hope this helps.
>
> Ethan
>
>
I think I made my point. I guess if I continued on the rest of the
code t
[PHP] PHP & Database Problems -- Code Snippets
Dear list -
Sorry for the attachment. Here are code snippets ---
GET THE DATA FROM INTAKE3:
function handle_data()
{
global $cxn;
$query = "select * from Intake3 where 1";
if(isset($_Request['Sex'])&& trim($_POST['Sex']) != '' )
{
if ($_REQUEST['Sex'] === "0")
{
$sex = 'Male';
}
else
{
$sex = 'Female';
}
}
}
$allowed_fields = array
( 'Site' =>$_POST['Site'], 'MedRec' => $_POST['MedRec'],
'Fname' => $_POST['Fname'], 'Lname' => $_POST['Lname'] ,
'Phone' => $_POST['Phone'] , 'Sex' => $_POST['Sex'] ,
'Height' => $_POST['Height'] );
if(empty($allowed_fields))
{
echo "ouch";
}
$query = "select * from Intake3 where 1 ";
foreach ( $allowed_fields as $key => $val )
{
if ( (($val != '')) )
{
$query .= " AND ($key = '$val') ";
}
$result1 = mysqli_query($cxn, $query);
}
$num = mysqli_num_rows($result1);
if(($num = mysqli_num_rows($result1)) == 0)
{
?>
No Records Retrieved #1
>> THIS SEEMS TO BE THE ROUTINE THAT IS FAILING <<<
Search Results
cellspacing="55" rules="all" frame="box">
Site
Medical Record
First Name
Last Name
Phone
Height
Sex
History
n1 ";echo $n1;
{
if (($n1 > 2) && ($MDRcheck == $row1[1]))
{
echo ">2== ";
echo $MDRcheck;
echo " $row1[0] \n";
echo " $row1[1] \n";
echo " $row1[2] \n";
echo " $row1[3] \n";
echo " $row1[4] \n";
echo " $row1[5] \n";
echo " $row1[6] \n";
echo " $row1[7] \n";
echo "\n";
}
elseif (($n1 > 2) && ($MDRcheck != $row1[1]))
{
echo ">2!= ";
echo $MDRcheck;
continue;
}
elseif ($n1 == 2)
{
define( "MDR" , $row1[1]);
echo "row1 ";echo $row1[1];
echo "\n";
$_GLOBALS['mdr']= $row1[1];
$_POST['MedRec'] = $row1[1];
$MDRold = $_GLOBALS['mdr'];
echo " $row1[0] \n";
echo " $row1[1] \n";
echo " $row1[2] \n";
echo " $row1[3] \n";
echo " $row1[4] \n";
echo " $row1[5] \n";
echo " $row1[6] \n";
echo " $row1[7] \n";
echo "\n";
}
}
}
?>
SELECT AND DISPLAY DATA FROM VISIT3 DATABASE
$query2 = "select * from Visit3 where 1 AND (Site = 'AA') AND
(MedRec = $_GLOBALS[mdr])";
$result2 = mysqli_query($cxn, $query2);
$num = mysqli_num_rows($result2);
global $finished;
$finished = 0;
while($row2 = mysqli_fetch_array($result2, MYSQLI_BOTH))
{
global $finished;
echo "\n";
echo " $row2[0] \n";
echo " $row2[1] \n";
echo " $row2[2] \n";
echo " $row2[3] \n";
echo " $row2[4] \n";
echo " $row2[5] \n";
echo " $row2[6] \n";
echo "\n";
}
echo "";
ENTER MORE DATA:
function More_Data()
{
$decision = 5;
?>
Do you Wish to Enter More Data?
Yes
No
end function More_Data
switch ( @$_POST[next_step] )
{
case "step10":
{
if (!isset($_POST['decision']))
{
$_POST['decision'] = 5;
}
if ($_POST['decision'] == 0)
{
exit();
}
if ($_POST['decision'] == 1)
{
;
echo "";
echo "value=\"step4\" />";
echo "";
echo "Medical Record: name=\"MedRec\" value=\" $_GLOBALS[mdr]\" />";
echo " Weight: name=\"Weight\" /> ";
echo "Notes: ";
echo "rows=\"10\" wrap=\"hard\" name=\"Notes\" > ";
echo "";
echo " ";
echo "";
echo "";
}
} /* End Step10 */
case "step4":
{
if (!isset($_POST['datain']))
{
$_POST['datain'] = 5;
}
if( $_POST['datain'] == "already")
{
date_default_timezone_set('America/New_York');
$Date = date('Ymd');
$Date2 = date('d M Y');
$sql1 = "select MedRec, Height from Intake3 where
(MedRec = $MDRold)";
$result4 = mysqli_query($cxn, $sql1);
$row4 = mysqli_fetch_array($result4, MYSQLI_BOTH);
$Height = $row4[1];
$Weight = $_POST['Weigh
Re: [PHP] PHP & Database Problems
Dear Ethan,
It would be useful to see what code you are using.
The syntax is:
UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value
The data that you are required to enter is for Intake3. I am assuming that
the only change is the History and/or Phone that you need to update since
the Site, MedRec, Fname, Lname, Height and Sex should remain the same.
Therefore I imagine the code should be something like
mysql_query("UPDATE Intake3 SET History='Has been convinced by his
friends that he is obese. Normal BMI = 23', Phone='325 563-4178'
WHERE MedRec='1' LIMIT 1");
Having said that I notice that you have two primary keys in Intake3. Not
aware that a table can carry two.
Terry
On 2 May 2012 19:53, Ethan Rosenberg wrote:
> have a database
>
> mysql> describe Intake3;
> ++-+--**+-+-+---+
> | 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| |
> ++-+--**+-+-+---+
> 8 rows in set (0.00 sec)
>
> 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||
> ++--+-**-+-+-+**+
>
> and a program to enter and extract data.
>
> I can easily extract data from the database. However, if I try to enter
> data, it goes into the incorrect record. Following are some screenshots.
> The program is attached. [pardon the comical names. This is a test, and
> any resemblance to true names is not intentional]
>
> Let us say that I wish to deal with Medical Record 1:
>
>
> This it data from Intake3:
> Site Medical Record First Name Last Name Phone Height Sex History
> AA 1 David Dummy 845 365-1456 66 Male c/o obesity. Various treatments
> w/o success
>
> This is data from Visit3:
> Index Site Medical Record Notes Weight BMI Date
> 2322 AA 1 Second Visit. 170 27.4 2010-01-20
> 2326 AA 1 Third visit. Small progress, but pt is very happy. 165 26.6
> 2010-02-01
>
>
> I then request to enter additional data:
>
> Site Medical Record First Name Last Name Phone Height Sex History
> AA 10003 Stupid Fool 325 563-4178 65 Male Has been convinced by his
> friends that he is obese. Normal BMI = 23.
> Index Site Medical Record Notes Weight BMI Date
>
> Notice that it is entered into record 10003
>
> The data is "First Try"
>
> Index Site Medical Record Notes Weight BMI Date
> 2590 AA 10003 First Try 189 31.4 02 May 2012
>
> Help and advice, please.
>
> Thanks.
>
> Ethan
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
*Terry Ally*
Twitter.com/terryally
Facebook.com/terryally
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
To print or not to print this email is the environmentally-searching
question!
Which has the highest ecological cost? A sheet of paper or constantly
switching on your computer and connecting to the Internet to read your
email?
Re: [PHP] PHP & Database Problems
I do believe attachments are allowed. Looking back, I see that there have been messages sent to the list that had odt, php, and ini attachments On 05/02/2012 12:12 PM, Gavin Chalkley wrote: Ethan, Some coding you are using would be helpful (as far as i am aware attachments are not support on the mailing list's) Gav -Original Message- From: Ethan Rosenberg [mailto:eth...@earthlink.net] Sent: 02 May 2012 19:54 To: php-db-lists.php.net; php-general@lists.php.net Subject: [PHP-DB] PHP& Database Problems have a database mysql> describe Intake3; ++-+--+-+-+---+ | 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| | ++-+--+-+-+---+ 8 rows in set (0.00 sec) 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|| ++--+--+-+-++ and a program to enter and extract data. I can easily extract data from the database. However, if I try to enter data, it goes into the incorrect record. Following are some screenshots. The program is attached. [pardon the comical names. This is a test, and any resemblance to true names is not intentional] Let us say that I wish to deal with Medical Record 1: This it data from Intake3: Site Medical Record First Name Last Name Phone Height Sex History AA 1 David Dummy 845 365-1456 66 Male c/o obesity. Various treatments w/o success This is data from Visit3: Index Site Medical Record Notes Weight BMI Date 2322 AA 1 Second Visit. 170 27.4 2010-01-20 2326 AA 1 Third visit. Small progress, but pt is very happy. 165 26.6 2010-02-01 I then request to enter additional data: Site Medical Record First Name Last Name Phone Height Sex History AA 10003 Stupid Fool 325 563-4178 65 Male Has been convinced by his friends that he is obese. Normal BMI = 23. Index Site Medical Record Notes Weight BMI Date Notice that it is entered into record 10003 The data is "First Try" Index Site Medical Record Notes Weight BMI Date 2590 AA 10003 First Try 189 31.4 02 May 2012 Help and advice, please. Thanks. Ethan -- Jim Lucas http://www.cmsws.com/ http://www.cmsws.com/examples/ http://www.bendsource.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP & Database Problems
have a database mysql> describe Intake3; ++-+--+-+-+---+ | 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| | ++-+--+-+-+---+ 8 rows in set (0.00 sec) 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|| ++--+--+-+-++ and a program to enter and extract data. I can easily extract data from the database. However, if I try to enter data, it goes into the incorrect record. Following are some screenshots. The program is attached. [pardon the comical names. This is a test, and any resemblance to true names is not intentional] Let us say that I wish to deal with Medical Record 1: This it data from Intake3: Site Medical Record First Name Last Name Phone Height Sex History AA 1 David Dummy 845 365-1456 66 Male c/o obesity. Various treatments w/o success This is data from Visit3: Index Site Medical Record Notes Weight BMI Date 2322 AA 1 Second Visit. 170 27.4 2010-01-20 2326 AA 1 Third visit. Small progress, but pt is very happy. 165 26.6 2010-02-01 I then request to enter additional data: Site Medical Record First Name Last Name Phone Height Sex History AA 10003 Stupid Fool 325 563-4178 65 Male Has been convinced by his friends that he is obese. Normal BMI = 23. Index Site Medical Record Notes Weight BMI Date Notice that it is entered into record 10003 The data is "First Try" Index Site Medical Record Notes Weight BMI Date 2590 AA 10003 First Try 189 31.4 02 May 2012 Help and advice, please. Thanks. Ethan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
