Databases
StackOverflow2013
Postsdbo
POupdating filtered mysql rows in php
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POupdating filtered mysql rows in php
    text
    copied!<p>I'm trying to update different rows from mysql that they filtered by some record . in this code first the user should enter two input : classnumber and level . records that they have this fields will show in table then the user should be able to update this records information . but the problem is all of records are in one table in mysql so their id is different I mean for example the first record that match with two inputs id is 2 and then the next one is 5 and next one 6 and .... </p> <p>with this kind of situation how should I change the code below ? </p> <pre><code>&lt;form id="searchform" method="post" dir="rtl" action=""&gt; level :&lt;input name="level" style="margin-top:5px; margin-left:6px;font-family: Tahoma,Geneva,sans-serif; font-size: 12px; margin-top: 5px; padding: 5px; width: 50px;" type="text" id="level" /&gt; classnumber :&lt;input name="classnum" style="margin-top:5px; margin-left:6px;font-family: Tahoma,Geneva,sans-serif; font-size: 12px; margin-top: 5px; padding: 5px; width: 50px;" type="text" id="classnum" /&gt; &lt;input style="margin-top:10px; margin-left:120px; font-size: 14px; padding: 5px 14px;" type="submit" value="جستجو" name="enter" /&gt; &lt;/form&gt; &lt;?php if(isset($_POST['enter'])){ $sql="SELECT * FROM `".$tbl_name."` where classnum='".$_REQUEST['classnum']."' and level='".$_REQUEST['level']."' "; $result=mysql_query($sql,$link); $count=mysql_num_rows($result); } ?&gt; &lt;div class="cleaner h30"&gt;&lt;/div&gt; &lt;br&gt; &lt;form name="form1" action="" method="POST"&gt; &lt;center&gt; &lt;div&gt; &lt;div align="center" width = 615&gt; &lt;table class="stats" cellspacing="0" width="615" border="1"&gt; &lt;tr&gt; &lt;th width="20" scope="col" &gt;Id&lt;/th&gt; &lt;th width="60" scope="col"&gt;Name&lt;/th&gt; &lt;th width="60" scope="col"&gt;Last Name&lt;/th&gt; &lt;th width="42" scope="col"&gt;Midterm&lt;/th&gt; &lt;th width="54" scope="col"&gt;Class mark&lt;/th&gt; &lt;th width="42" scope="col"&gt;Final Quiz&lt;/th&gt; &lt;th width="54" scope="col"&gt;State&lt;/th&gt; &lt;th width="54" scope="col"&gt;Details&lt;/th&gt; &lt;/tr&gt; &lt;?php while($rows=mysql_fetch_array($result)){ $id[]=$rows['id']; ?&gt; &lt;tr&gt; &lt;td align="center"&gt; &lt;input name="id[]" type="text" id="id" value="&lt;? echo $rows['id']; ?&gt;" style=" font-family: Tahoma,Geneva,sans-serif; font-size: 12px; padding: 5px; width: 10px;"&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input style=" font-family: Tahoma,Geneva,sans-serif; font-size: 12px; padding: 5px; width: 60px;" type="text" name="name[]" id="name" value= "&lt;? echo $rows['name']; ?&gt;" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input style=" font-family: Tahoma,Geneva,sans-serif; font-size: 12px; padding: 5px; width: 60px;" type="text" name="lastname[]" id="lastname" value= "&lt;? echo $rows['lastname']; ?&gt;" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input style=" font-family: Tahoma,Geneva,sans-serif; font-size: 12px; padding: 5px; width: 50px;" type="text" name="midmark[]" id="midmark" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input style=" font-family: Tahoma,Geneva,sans-serif; font-size: 12px; padding: 5px; width: 50px;" type="text" name="classmark[]" id="classmark" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input style=" font-family: Tahoma,Geneva,sans-serif; font-size: 12px; padding: 5px; width: 50px;" type="text" name="finalmark[]" id="finalmark" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input style=" font-family: Tahoma,Geneva,sans-serif; font-size: 12px; padding: 5px; width: 50px;" type="text" name="state[]" id="state" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input style=" font-family: Tahoma,Geneva,sans-serif; font-size: 12px; padding: 5px; width: 50px;" type="text" name="details[]" id="details" /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;?php } ?&gt; &lt;/table&gt; &lt;/div&gt; &lt;/div&gt; &lt;/center&gt; &lt;input style="margin-top:10px; float:right; margin-right:175px; font-size: 14px; padding: 5px 14px;" type="submit" value="ثبت" name="Submit" /&gt; &lt;/form&gt; &lt;?php // Check if button name "Submit" is active, do this if(isset($_POST['Submit'])) { for($i=0;$i&lt;$count;$i++) { $sql1=mysql_query(" UPDATE `".$tbl_name."` SET midmark='".$_REQUEST['midmark'][$i]."' , classmark='".$_REQUEST['classmark'][$i]."' , finalmark='".$_REQUEST['finalmark'][$i]."' , state='".$_REQUEST['state'][$i]."' , details='".$_REQUEST['details'][$i]."' WHERE id='".$_REQUEST['id'][$i]."' "); $result1=mysql_query($sql1); } } if($result1){ header("location:results.php"); } mysql_close(); ?&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload