hjkhghopjkertteerterterterertertrtoirh
bnmbertsurhetertertertertertertertpdf'tdfg
/
home
/
ubuntu
/
bmse.net
/
Upload FileeE
HOME
<?php ob_start(); session_start(); require_once('includes/configure.php'); $name1 = mysqli_connect(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME); if ($_POST['submit']!='') { $to = $_REQUEST['to']; $from = $_REQUEST['from']; $id=$_REQUEST['id']; //echo 'UPDATE `bmse_expo_rooms` SET `room_number`='.$to.' WHERE `room_number`='.$from.' and `expo_id`=477 and `type`=1'; mysqli_query($name1, 'UPDATE `bmse_expo_rooms` SET `room_number`='.$to.' WHERE `room_number`='.$from.' and `expo_id`=477 and `type`=1 and `id`='.$id.''); echo '<br/>'; if ($name1 -> affected_rows == 0) { echo "<font color='red'>Affected rows: </font>" . $name1 -> affected_rows; } else { echo "Affected rows: " . $name1 -> affected_rows; } echo '<br/>'; echo $id. ' Done'; } ?> <form method="POST" action=""> <table align="center" width="500px;" border="0" cellspacing="2" cellpadding="2"> <tr><td>Room id#:</td></tr><tr><td><input type="text" name="id"></td></tr> <tr><td>Old Number:</td></tr><tr><td><input type="text" name="from"></td></tr> <tr><td>New Number:</td></tr><tr><td><input type="text" name="to"></td></tr> <tr><td colspan="2" align="left"><input type="submit" name="submit" value="Submit"></td></tr> </table> </form>