3 Replies - 544 Views - Last Post: 05 November 2011 - 07:01 AM Rate Topic: -----

#1 Syfer  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 190
  • Joined: 08-October 10

Updating issues

Posted 05 November 2011 - 03:32 AM

<?php
		$per_page = 15;
      
        $result = mysql_query("SELECT * FROM users_history where userid='".$_SESSION['userid']."'");
        $total_results = mysql_num_rows($result);
		if ($total_results > 0){
        $total_pages = ceil($total_results / $per_page);
		$pg = $_GET['page'];			  
        if (isset($_GET['page']) && is_numeric($_GET['page'])){
                $show_page = $_GET['page'];
				
                if ($show_page > 0 && $show_page <= $total_pages)
                {
                        $start = ($show_page -1) * $per_page;
                        $end = $start + $per_page; 
                }
                else
                {
                        $start = 0;
                        $end = $per_page; 
                }               
        }
        else
        {
                $start = 0;
                $end = $per_page; 
        }
        echo "<div><b>View Page:</b> ";
        for ($i = 1; $i <= $total_pages; $i++) {
                echo "<a href='owninfo.php?page=$i'>$i</a> ";
        }
		$pg = $_GET['page'];
        echo "</div><br>";
		echo "</h1></center>";
        echo "<center>Page: $pg</center>
		<div style='overflow:auto;'> 
		<br><table border='1' cellpadding='10' width='100%'>";
     echo "<tr> <th>Previous Dentist</th><th>Last Dental Visit</th><th>Name of Physician</th><th>Physican Specialty</th>
		 <th>Official Address</th><th>Official Number</th><th>In Good Health</th><th>Under Medical Treatment</th><th>Condition Treated</th>
		 <th>Had Operation</th><th>Specify Operation</th><th>Hospitalized</th><th>Why Hospitalized</th><th>Taking Prescription Medication</th>
		 <th>Specify Prescription</th><th>Do use Tobacoo?</th><th>Do use/drink Illegal Drugs/Alcohol?</th><th>Allergies</th>
		 <th>Bleeding Time</th><th>For Women</th><th>Blood Type</th><th>Blood Pressure</th><th>Health/Sick Background</th></tr>";
        for ($i = $start; $i < $end; $i++){
                if ($i == $total_results) { 
				break; 
				}
                echo "<tr>";
			    echo '<td>' . mysql_result($result, $i, 'prev_dent') . '</td>';
                echo '<td>' . mysql_result($result, $i, 'last_dent_visit') . '</td>';
                echo '<td>' . mysql_result($result, $i, 'name_physician') . '</td>';
                echo '<td>' . mysql_result($result, $i, 'physician_specialty') . '</td>';
				echo '<td>' . mysql_result($result, $i, 'off_add') . '</td>';
                echo '<td>' . mysql_result($result, $i, 'off_num') . '</td>';
                echo '<td>' . mysql_result($result, $i, 'good_health') . '</td>';
                echo '<td>' . mysql_result($result, $i, 'under_med_treatment') . '</td>';
				echo '<td>' . mysql_result($result, $i, 'condition_treated') . '</td>';
				echo '<td>' . mysql_result($result, $i, 'had_operation') . '</td>';
				echo '<td>' . mysql_result($result, $i, 'specify_operation') . '</td>';
				echo '<td>' . mysql_result($result, $i, 'hospitalized') . '</td>';
				echo '<td>' . mysql_result($result, $i, 'why_hospi') . '</td>';
				echo '<td>' . mysql_result($result, $i, 'prescrip_med') . '</td>';
				echo '<td>' . mysql_result($result, $i, 'specify_prescrip') . '</td>';
				echo '<td>' . mysql_result($result, $i, 'do_smoke') . '</td>';
				echo '<td>' . mysql_result($result, $i, 'do_badvices') . '</td>';
				echo '<td>' . mysql_result($result, $i, 'allergy') . '</td>';
				echo '<td>' . mysql_result($result, $i, 'bleed_time') . '</td>';
				echo '<td>' . mysql_result($result, $i, 'for_women') . '</td>';
				echo '<td>' . mysql_result($result, $i, 'blood_type') . '</td>';
				echo '<td>' . mysql_result($result, $i, 'blood_pressure') . '</td>';
				echo '<td>' . mysql_result($result, $i, 'sick_bg') . '</td>';
				echo '<td><a href="owninfo.php?action=edithealth&uid='.$_SESSION['userid'].'">edit health</a></td>';
                echo "</tr>";
    
		}
		}else{
		 echo '<br/>';
		 echo '<center><h1>No found records for Health History</h1></center>';
		}
        echo "</table>";
		if(isset($_REQUEST["action"]) && $_REQUEST["action"] == "edithealth" && $_REQUEST["uid"]){
				$uid=$_REQUEST["uid"];
				$query = mysql_query("SELECT * FROM users_history WHERE userid='$uid'") or die(mysql_error());
				echo "<div style=\"overflow:scroll;height:500px;position:absolute;top:0;right:180;z-index:1;background-color:FFFFFF;border:1px solid black;\">";
				echo "Edit<br/><br/>";
						$aaaat = mysql_result($query, 0, 'userid');
						$prevt = mysql_result($query, 0, 'prev_dent');
						$lastt = mysql_result($query, 0, 'last_dent_visit');
						$pnamet = mysql_result($query, 0, 'name_physician');
						$pspect= mysql_result($query, 0, 'physician_specialty');
						$ofaddt = mysql_result($query, 0, 'off_add');
						$ofnumt = mysql_result($query, 0, 'off_num');
						$healtht = mysql_result($query, 0, 'good_health');
						$udtt = mysql_result($query, 0, 'under_med_treatment');
						$ctreatt = mysql_result($query, 0, 'condition_treated');
						$hadoperat = mysql_result($query, 0, 'had_operation');
						$specoperat= mysql_result($query, 0, 'specify_operation');
						$hospitt = mysql_result($query, 0, 'hospitalized');
						$whospitt = mysql_result($query, 0, 'why_hospi');
						$presmedt = mysql_result($query, 0, 'prescrip_med');
						$sprest = mysql_result($query, 0, 'specify_prescrip');
						$smoket = mysql_result($query, 0, 'do_smoke');
						$vicest = mysql_result($query, 0, 'do_badvices');
						$geryt = mysql_result($query, 0, 'allergy');
						$btimet = mysql_result($query, 0, 'bleed_time');
						$woment = mysql_result($query, 0, 'for_women');
						$btypet = mysql_result($query, 0, 'blood_type');
						$bpresst = mysql_result($query, 0, 'blood_pressure');
						$sickt = mysql_result($query, 0, 'sick_bg');
					
				echo "<form method='request' action='owninfo.php'>";
				echo "<input type='hidden'  name='aaaa' value='$aaaat'><br/>";
			  echo  "<p>Previous Dentist:<input type='text' name='prev' value='$prevt' onkeypress='return alphaOnly(event)'></p>";
echo "<p>Last Dental Visit:<input onclick='scwShow(this,event);' name='last' value='$lastt' /></p><br/>";
echo "<p>Medical History</p>";
echo "<p>Name of Physician:<input type='text' name='pname' value='$pnamet' onkeypress='return alphaOnly(event)'></p>";
echo "<p>Specialty , If Applicable:<input type='text' name='pspec' value='$pspect' onkeypress='return alphaOnly(event)'></p>";
echo "<p>Official Address:<input type='text' name='ofadd' value='$ofaddt'></p>";
echo "<p>Official Number:<input type='text' name='ofnum' value='$ofnumt' onkeypress='return blockNonNumbers(this, event, false, false);'></p>";
echo "<p>1.Are you in good health?";
echo "<select name='health' value='$healtht'>";
echo "<option value='yes'>Yes</option>";
echo "<option value='no'>No</option>";
echo "</select></p>";
echo "<p>2.Are you under medical treatment now?";
echo "<select name='udt' value='$udtt'>";
echo "<option value='yes'>Yes</option>";
echo "<option value='no'>No</option>";
echo "</select></p>";
echo "<p>&nbsp &nbsp If so, What is the condition being treated?";
echo "&nbsp &nbsp <input type='text' name='ctreat' value='$ctreatt' onkeypress='return alphaOnly(event)'></p>";
echo "<p>3.Have you ever had serious illness or surgical operation?";
echo "<select name='hadopera' value='$hadoperat'>";
echo "<option value='yes'>Yes</option>";
echo "<option value='no'>No</option>";
echo "</select></p>";
echo "<p>&nbsp &nbsp If so , What illness or operation?";
echo "&nbsp &nbsp <input type='text' name='specopera' value='$specoperat' onkeypress='return alphaOnly(event)'></p>";
echo "<p>4.Have you ever been hospitalized?";
echo "<select name='hospit' value='$hospitt'>";
echo "<option value='yes'>Yes</option>";
echo "<option value='no'>No</option>";
echo "</select></p>";
echo "<p>&nbsp &nbsp If so , when and why?";
echo "&nbsp &nbsp <input type='text' name='whospit' value='$whospitt' onkeypress='return alphaOnly(event)'></p>";
echo "<p>5.Are you taking any prescription/non-prescription medication?";
echo "<select name='presmed' value='$presmedt'>";
echo "<option value='yes'>Yes</option>";
echo "<option value='no'>No</option>";
echo "</select></p>";
echo "<p>&nbsp &nbsp If so , please specify";
echo "&nbsp &nbsp <input type='text' name='spres' value='$sprest'onkeypress='return alphaOnly(event)'></p>";
echo "<p>6.Do you use tobacco products?";
echo "<select name='smoke' value='$smoket'>";
echo "<option value='yes'>Yes</option>";
echo "<option value='no'>No</option>";
echo "</select></p>";
echo "<p>7.Do you use/drink alcohol,cocaine or other dangerous drugs?";
echo "<select name='vices' value='$vicest'>";
echo "<option value='yes'>Yes</option>";
echo "<option value='no'>No</option>";
echo "</select></p>";
echo "<p>8.Are you allergic to any of the following:<br/>";
echo "<input type='checkbox' name='allergy[]' value='Anesthetic' />Local Anesthetic (ex. Lidocaine)";
echo "<input type='checkbox' name='allergy[]' value='sulfa'/> Sulfa Drugs<br />";
echo "<input type='checkbox' name='allergy[]' value='penicillin' /> Penicillin.Antibiotics ";
echo "<input type='checkbox' name='allergy[]' value='aspirin' />Aspirin";
echo "<input type='checkbox' name='allergy[]' value='latex' />Latex <br/>";
echo "Others<input type='text' name='allergy[]' onkeypress='return alphaOnly(event)'></p>";
echo "<p>9.Bleeding time";
echo "<input type='text' name='btime' value='$btimet'/></p>";
echo "<p>10.For women only:<br/>";
echo "&nbsp &nbsp Are you pregnant?";
echo "&nbsp &nbsp <select name='for_women1'>";
echo " <option value='Yes Pregnant'>Yes</option>";
echo "<option value='Not Pregnant'>No</option>";
echo "</select>";
echo "<br/>";
echo "&nbsp &nbsp Are you nursing?";
echo "&nbsp &nbsp <select name='for_women2'>";
echo  "<option value='Yes Nursing'>Yes</option>";
echo "<option value='Not Nursing'>No</option>";
echo "</select><br/>";
echo "&nbsp &nbsp Are you taking birth control pills?";
echo "&nbsp &nbsp <select name='for_women3'>";
echo "<option value='yes taking cp'>Yes</option>";
echo "<option value='not taking cp'>No</option>";
echo "</select>";
echo "</p>";
echo "<p>11.Blood type";
echo "<select name='btype' value='$btypet'>";
echo "<option value='a'>A</option>";
echo "<option value='b'>B</option>";
echo "<option value='o'>O</option>";
echo "<option value='ab'>AB</option>";
echo "</select>";
echo "</p>";
echo "<p>12.Blood Pressure";
echo "<input type='text' name='bpress' value='$bpresst'onkeypress='return blockNonNumbers(this, event, false, false);'>";
echo "</p>";
echo "<p>13.Do you have or have you had any of the following? Check which apply<br/>";
echo "<input type='checkbox' name='sick_bg[]' value='highbloodpressur' />High Blood Pressure";
echo "<input type='checkbox' name='sick_bg[]' value='lowbloodpressure' />Low Blood Pressure<br />";
echo "<input type='checkbox' name='sick_bg[]' value='highbloodpressure' />Heart Disease";
echo "<input type='checkbox' name='sick_bg[]' value='lowbloodpressure' />Asthma<br />";
echo "Others:";
echo "<input type='text' name='sick_bg[]'  onkeypress='return alphaOnly(event)'></p>";
echo "<input type='submit' name='omitz'/>";
echo "<a href='owninfo.php'><input type='button' value='back'/></a>";
echo "</form>";
				echo "</div>";
				
				 
				}
			if(isset($_POST['omitz'])) {
			$id = mysql_real_escape_string(stripslashes($_POST['aaaa']));
			$prev_dent= mysql_real_escape_string(stripslashes($_POST['prev']));
			$last_dent_visit= mysql_real_escape_string(stripslashes($_POST['last']));
			$name_physician= mysql_real_escape_string(stripslashes($_POST['pname']));
			$physician_specialty= mysql_real_escape_string(stripslashes($_POST['pspec']));
			$off_add= mysql_real_escape_string(stripslashes($_POST['ofadd']));
			$off_num= mysql_real_escape_string(stripslashes($_POST['ofnum']));
			$good_health= mysql_real_escape_string(stripslashes($_POST['health']));
			$under_med_treatment= mysql_real_escape_string(stripslashes($_POST['udt']));
			$condition_treated= mysql_real_escape_string(stripslashes($_POST['ctreat']));
			$had_operation= mysql_real_escape_string(stripslashes($_POST['hadopera']));
			$specify_operation= mysql_real_escape_string(stripslashes($_POST['specopera']));
			$hospitalized= mysql_real_escape_string(stripslashes($_POST['hospit']));
			$why_hospi= mysql_real_escape_string(stripslashes($_POST['whospit']));
			$prescrip_med= mysql_real_escape_string(stripslashes($_POST['presmed']));
			$specify_prescrip= mysql_real_escape_string(stripslashes($_POST['spres']));
			$do_smoke= mysql_real_escape_string(stripslashes($_POST['smoke']));
			$do_badvices= mysql_real_escape_string(stripslashes($_POST['vices']));		
			$bleed_time= mysql_real_escape_string(stripslashes($_POST['btime']));			
			$blood_type= mysql_real_escape_string(stripslashes($_POST['btype']));
			$blood_pressure= mysql_real_escape_string(stripslashes($_POST['bpress']));			
			
			$for_women = $_POST['for_women3']."|".$_POST['for_women1']."|".$_POST['for_women2'];
			
				
				 
				 
				 $allergys = $_POST['allergy'];
				 $allerstore;
						$x = count($allergys);
						for($i=0; $i < $x; $i++)
						{
						  $allerstore.=$allergys[$i]."|";
						  
						}
				 $sickdaw = $_POST['sick_bg'];
				 $sickstore;
						$x = count($sickdaw);
						for($i=0; $i < $x; $i++){
						  $sickstore.=$sickdaw[$i]."|";
						 
						}
				
				$sql = "SELECT off_num FROM users_history WHERE off_num='".mysql_real_escape_string($_POST['off_num'])."'";
                $query = mysql_query($sql) or die(mysql_error());
                $m_count = mysql_num_rows($query);
				if($m_count >= "1"){
				   echo "The Number is already exist choose another one";
				}else
				echo $for_woman;
				mysql_query("UPDATE users_history SET userid='$id',prev_dent='$prev_dent'
				,last_dent_visit='$last_dent_visit',name_physician='$name_physician',physician_specialty='$physician_specialty',
				off_add='$off_add',off_num='$off_num',good_health='$good_health',under_med_treatment='$under_med_treatment',condition_treated='$condition_treated',had_operation='$had_operation',
				specify_operation='$specify_operation',hospitalized='$hospitalized',why_hospi='$why_hospi',prescrip_med='$prescrip_med',
				specify_prescrip='$specify_prescrip',do_smoke='$do_smoke',do_badvices='$do_badvices',allergy='$allerstore',bleed_time='$bleed_time',for_women='$for_women',blood_type='$blood_type',blood_pressure='$blood_pressure',sick_bg='$sickstore'");
				echo '<meta http-equiv="refresh" content="0;url=owninfo.php">';
	            exit;
				
		}
	
        echo "</div>";		
		?>




only problem is my update fails either the column where it goes being erase or the table won't update at all.

Is This A Good Question/Topic? 0
  • +

Replies To: Updating issues

#2 codeprada  Icon User is offline

  • Changed Man With Different Priorities
  • member icon

Reputation: 946
  • View blog
  • Posts: 2,355
  • Joined: 15-February 11

Re: Updating issues

Posted 05 November 2011 - 04:29 AM

Two things you must note. Always verify that the values you're updating with aren't empty and use a WHERE clause at the end of your UPDATE statement. That is unless you want to update every row in your table.

Next time if you're going to post these long scripts of mixed languages let us know before hand the line number your problem is on.
Was This Post Helpful? 4
  • +
  • -

#3 CTphpnwb  Icon User is online

  • D.I.C Lover
  • member icon

Reputation: 2927
  • View blog
  • Posts: 10,113
  • Joined: 08-August 08

Re: Updating issues

Posted 05 November 2011 - 04:46 AM

I was wrong here. It didn't take days, weeks, or months. It took hours. You're not taking the time to organize your code, so you're going to continue to have problems.

Use functions, separate your languages, and use prepared statements either with PDO or MySQLi.

This post has been edited by CTphpnwb: 05 November 2011 - 05:42 AM
Reason for edit:: Spelling error. :(

Was This Post Helpful? 3
  • +
  • -

#4 Syfer  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 190
  • Joined: 08-October 10

Re: Updating issues

Posted 05 November 2011 - 07:01 AM

sorry for the late reply , i already fixed it .... forgot some queries to add.

This post has been edited by Syfer: 05 November 2011 - 07:05 AM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1