Re: 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 <[email protected]>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)
>    {
> ?>
>    <br /><br /><center><b><p style="color: red; font-size:14pt;" >No
> Records Retrieved #1</center></b></style></p>
> <?php
>    exit();
>    }
>
> DISPLAY THE INPUT3 DATA:
>
> >>> THIS SEEMS TO BE THE ROUTINE THAT IS FAILING <<<
>
>    <center><b>Search Results</b></center><br />
>
>    <center><table border="4" cellpadding="5" cellspacing="55"  rules="all"
>  frame="box">
>    <tr class=\"heading\">
>    <th>Site</th>
>    <th>Medical Record</th>
>    <th>First Name</th>
>    <th>Last Name</th>
>    <th>Phone</td>
>    <th>Height</td>
>    <th>Sex</td>
>    <th>History</td>
>    </tr>
>
> <?php
>
>       while ($row1 = mysqli_fetch_array($result1, MYSQLI_BOTH))
>       {
>            print_r($_POST);
>               global $MDRcheck;
>               $n1++;
>               echo "<br />n1 <br />";echo $n1;
>            {
>               if (($n1 > 2) && ($MDRcheck == $row1[1]))
>               {
>                    echo ">2==  ";
>                    echo $MDRcheck;
>                    echo "<td> $row1[0] </td>\n";
>                    echo "<td> $row1[1] </td>\n";
>                    echo "<td> $row1[2] </td>\n";
>                    echo "<td> $row1[3] </td>\n";
>                    echo "<td> $row1[4] </td>\n";
>                    echo "<td> $row1[5] </td>\n";
>                    echo "<td> $row1[6] </td>\n";
>                    echo "<td> $row1[7] </td>\n";
>                    echo "</tr>\n";
>               }
>               elseif (($n1 > 2) && ($MDRcheck != $row1[1]))
>               {
>                    echo ">2!=  ";
>
>                    echo $MDRcheck;
>
>
>                    continue;
>               }
>               elseif ($n1 == 2)
>               {
>
>                    define( "MDR" ,  $row1[1]);
>                    echo "<br />row1 <br>";echo $row1[1];
>                    echo "<tr>\n";
>
>                    $_GLOBALS['mdr']= $row1[1];
>                    $_POST['MedRec'] = $row1[1];
>                    $MDRold = $_GLOBALS['mdr'];
>                    echo "<td> $row1[0] </td>\n";
>                    echo "<td> $row1[1] </td>\n";
>                    echo "<td> $row1[2] </td>\n";
>                    echo "<td> $row1[3] </td>\n";
>                    echo "<td> $row1[4] </td>\n";
>                    echo "<td> $row1[5] </td>\n";
>                    echo "<td> $row1[6] </td>\n";
>                    echo "<td> $row1[7] </td>\n";
>                    echo "</tr>\n";
>               }
>
>            }
>       }
>
> ?>
>
> SELECT AND DISPLAY DATA FROM VISIT3 DATABASE
>
> <?php
>    $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 "<tr>\n";
>       echo "<td> $row2[0] </td>\n";
>       echo "<td> $row2[1] </td>\n";
>       echo "<td> $row2[2] </td>\n";
>       echo "<td> $row2[3] </td>\n";
>       echo "<td> $row2[4] </td>\n";
>       echo "<td> $row2[5] </td>\n";
>       echo "<td> $row2[6] </td>\n";
>       echo "</tr>\n";
>
>    }
>
> echo "</table>";
>
> ENTER MORE DATA:
>
>    function More_Data()
>    {
>       $decision = 5;
> ?>
>
>    Do you Wish to Enter More Data?
>    <form method="post" action="">
>    <center><input type="radio" name="decision" value="1" />Yes <input
> type="radio" name="decision" value="0" />No</center><br />
>    <center><input type="submit" value="Enter more Data" /></center>
>    <input type="hidden" name="next_step" value="step10" />
>     </form>
>
> <?php
>    } //>>>>>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 "<form method=\"post\" action=\"\">";
>            echo "<input type=\"hidden\" name=\"next_step\" value=\"step4\"
> />";
>            echo "<enter><br />";
>            echo "Medical Record: &nbsp<input type=\"text\" name=\"MedRec\"
> value=\" $_GLOBALS[mdr]\" />";
>            echo "&nbsp&nbsp Weight: <input type=\"decimal\"
> name=\"Weight\" /></input><br /><br /><br /><br /> &nbsp&nbsp&nbsp&nbsp ";
>            echo "Notes: <br /> ";
>            echo "<textarea style=\"overflow: scroll\"; cols=\"60\"
> rows=\"10\" wrap=\"hard\" name=\"Notes\" ></textarea> </input><p />";
>            echo "<input type=\"submit\" value = \"Submit\"/><br /><br />";
>            echo " <input type=hidden name=\"datain\" value='already'>";
>
>            echo "<input type = \"reset\" /></center>";
>       echo "</form>";
>
>
>       }
>
>    } /*  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['Weight'];
>            $Notes  = $_POST['Notes'];
>
>            $sql5 = "select MedRec, Weight from Visit3 where (MedRec =
> $MDRold)";
>            $result5 = mysqli_query($cxn, $sql5);
>            $row5 = mysqli_fetch_array($result5, MYSQLI_BOTH);
>            $BMI = ($Weight*703)/($Height*$**Height);
>            $BMI = round($BMI,1);
>
>            $fptr1 = fopen("/home/ethan/PHP/**HRecnumSite", "r+");
>            fscanf($fptr1,"%d %s",$Num, $Site);
>            $sql2 =  "INSERT INTO Visit3(Indx, Site, MedRec, Notes, Weight,
> BMI, Date) VALUES(null, '$Site', '$MDRold', '$Notes',
>               $Weight, $BMI, '$Date')";
>
>            $result6 = mysqli_query($cxn, $sql2);
>            $MDRcheck = $MDRold;
>            $row2 = mysqli_fetch_array($result6, MYSQLI_BOTH);
>
> ?>
>
> ?>
>
>    <center>
>    <table border="4" cellpadding="5" cellspacing="55" rules="all"
> frame="box">
>       <tr class=\"heading\">
>       <th>Index</th>
>       <th>Site</th>
>       <th>Medical Record</th>
>       <th>Notes</th>
>       <th>Weight</th>
>       <th>BMI</td>
>       <th>Date</td>
>       </tr>
>
>
> <?php
>
>       $sql3 = "select max(Indx) from Visit3";
>       $result7 = mysqli_query($cxn, $sql3);
>       $row7 = mysqli_fetch_array($result7, MYSQLI_BOTH);
>       $Indx = $row7[0];
>
>       echo "<tr>\n";
>       echo "<td> $Indx </td>\n";
>       echo "<td> $Site </td>\n";
>       echo "<td> $_GLOBALS[mdr] </td>\n";
>       echo "<td> $Notes </td>\n";
>       echo "<td> $Weight </td>\n";
>       echo "<td> $BMI </td>\n";
>       echo "<td> $Date2 </td>\n";
>       echo "</tr>\n";
>
>
>       while($row8 = mysqli_fetch_array($result2, MYSQLI_BOTH))
>       {
>            global $finished;
>            echo "<tr>\n";
>            echo "<td> $row8[0] </td>\n";
>            echo "<td> $_GLOBALS[mdr] </td>\n";
>            echo "<td> $row8[2] </td>\n";
>            echo "<td> $row8[3] </td>\n";
>            echo "<td> $row8[4] </td>\n";
>            echo "<td> $row8[5] </td>\n";
>            echo "<td> $row8[6] </td>\n";
>            echo "</tr>\n";
>            echo "<br />row8<br />"; print_r($row8[1]);
>
>       }
>            echo "</table>";
>            $flag = 1;
>
>       }
>    } /* end step4 */
> } /* End Switch */
>
> WELCOME SCREEN:
>
>    function show_welcome()
>    {
>
>       $first_name = isset($_REQUEST["Fname"])  ? $_REQUEST["Fname"] : "";
>       $last_name  = isset($_REQUEST["Lname"])  ? $_REQUEST["Lname"] : "";
>       $medrec     = isset($_REQUEST["MedRec"]) ? $_REQUEST["MedRec"] : "";
>       $phone      = isset($_REQUEST["Phone"])  ? $_REQUEST["Phone"] : "";
>       $height     = isset($_REQUEST["Height"]) ? $_REQUEST["Height"] : "";
>
>       echo "<form  method=\"post\">";
>       echo " <center>Site: <input type=\"text\" name=\"Site\" value=\"AA\"
> /></input>";
>       echo " Record Number: <input type=\"text\" name=\"MedRec\"
>  value='", $medrec, "' /></input>";
>       echo " First Name: <input type=\"text\" name=\"Fname\" value='",
> $first_name, "' />";
>       echo " Last Name: <input type=\"text\" name=\"Lname\" value='",
> $last_name, "' /></input><br /><br />";
>       printf("Two Capital Letters\t\t\t   Five Numbers\t\t\t\t  Text - No
> Numbers\t\t\t Text - No Numbers\n\n\n");
>       echo " Phone: <input type=\"text\" name=\"Phone\" value='", $phone,
> "' /></input>";
>       echo " Height: <input type=\"decimal\" name=\"Height\" value='",
> $height, "' /></input><br /><br />";
>       printf("XXX-XXX-XXXX\t\t\t    Inches\n\n");
>       echo " Male<input type=\"radio\" name=\"Sex\" value = \"Male\"
> checked>";
>       echo " Female<input type=\"radio\" name=\"Sex\" value = \"Female\"
> ><br /><br /><br />";
>       echo " <input type=\"submit\"  /><br /><br />";
>       echo " <input type=\"reset\" value = \"Clear Form\"  /></center>";
>       echo " <input type=hidden name='welcome_already_seen'
>          value='already_seen'>";
>
>    }
> ?>
>
> I hope this helps.
>
> Ethan
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
> Ethan Rosenberg, PhD
> Pres/CEO
> Hygeia Biomedical Research, Inc
> 2 Cameo Ridge Road
> Monsey, NY 10952
> T: 845 352-3908
> F: 845 352-7566
> <mailto:erosenberg@**hygeiabiomedical.com<[email protected]>
> >erosenber**[email protected] <[email protected]>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 
Duken Marga