Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- echo "<strong>Update multiple rows in mysql</strong><br>";
- $host="localhost"; // Host name
- $username=$_SESSION['myusername']; // Mysql username
- $password=$_SESSION['mypassword'];
- $db_name="teams"; // Database name
- $tbl_name=$_GET['team'];// Table name
- // Connect to server and select databse.
- mysql_connect("$host", "$username", "$password")or die("cannot connect");
- mysql_select_db("$db_name")or die("cannot select DB");
- $sql="SELECT * FROM $tbl_name";
- $result=mysql_query($sql);
- $sql2="SELECT * FROM site ORDER BY PLACE";
- $wynik=mysql_query($sql2);
- //$place = mysql_query("SELECT PLACE FROM site, $tbl_name WHERE 'ID'='FK_PLACE'") or die ('blad');
- //$num=mysql_query($place);
- // Count table rows
- $count=mysql_num_rows($result);
- function kurwa($j, $b ) {
- echo $j;
- echo $b;
- $sql2="SELECT * FROM site ORDER BY PLACE";
- $wynik=mysql_query($sql2);
- ?>
- <select name="site[<?php echo $j?>]"><option selected="selected">Pick a Site</option><?php
- while($sit = mysql_fetch_array($wynik))
- {
- $site_name=$sit['PLACE'];?>
- <option name='place' value="<?php echo $sit["ID"]?>" ><?php echo $site_name;?></option>
- <?php
- }
- return $site[$j];
- }
- ?>
- <table align="center" width="500" border="1" cellspacing="1" cellpadding="0" bgcolor="#800080">
- <form name="form1" method="get" action="update_ac_mem.php">
- <tr>
- <td>
- <table align="center" width="500" border="0" cellspacing="1" cellpadding="0" bgcolor="#FFFFFF">
- <tr>
- <td align="center"><strong>Id</strong></td>
- <td align="center"><strong>Member</strong></td>
- <td align="center"><strong>Phone</strong></td>
- <td align="center"><strong>Site</strong></td>
- <td align="center"><strong><font color="red">Delete</font></strong></td>
- </tr>
- <?php
- $j=0;
- while($rows=mysql_fetch_array($result)){
- ?>
- <tr>
- <td align="center"><?php echo $rows['ID']; ?></td>
- <td align="center"><input name="memb[<?php echo $j?>]" type="text" id="memb" value="<?php echo $rows['MEMBER']; ?>"></td>
- <td align="center"><input name="phone[<?php echo $j?>]" type="text" id="phone" value="<?php echo $rows['PHONE']; ?>"></td>
- <td align="center"><?php kurwa($j, $rows['FK_SITE'])?>
- </td>
- <td align="center"><input name="checkbox[<?php echo $j?>]" type="checkbox" id="checkbox" value="<?php echo $rows['ID']; ?>"></td>
- <td align="center"><input name="count" type="hidden" id="count" value="<?php echo $count ?>" ></td>
- <td align="center"><input name="table" type="hidden" id="table" value="<?php echo $tbl_name ?>" ></td>
- <td align="center"><input name="id[<?php echo $j?>]" type="hidden" id="id" value="<?php echo $rows['ID']; ?>" ></td>
- </tr>
- <?php
- $j++;
- }?>
- <tr>
- <td colspan="8" align="center"><input type="submit" name="Submit" value="Submit"></td>
- </tr>
- </table>
- </td>
- </tr>
- </form>
- </table>
- <center><a href="list_records.php">Update and Delete Team names</a><br></center>
- <?php
- // Check if button name "Submit" is active, do this
- mysql_close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement