<td> <hr> </td> <td> <hr> </td> <td> <hr> </td> <td> <hr> </td> <td> <hr> </td> </tr> <?php $user_id = $_SESSION["user_id"]; include 'mysql.php'; if ($resid) { $count = MySQLi_Query($resid, "select frnd_two_id from are_friends where frnd_one_id = {$user_id} union select frnd_one_id from are_friends where frnd_two_id = {$user_id}"); echo "<tr align='center'> <td colspan='5'>Your Friends:- </td> </tr> <tr align='center'> <td colspan='5'><table align='center' >"; echo " <table align='center' cellspacing='5' cellpadding='5'> \n\t\t\t\t<tr> <th> Name: </th> <th> Email: </th> <th> Gender: </th> </tr>"; while (($rows = MySQLi_Fetch_Row($count)) == True) { $query = "select name,email,gender from students where id = {$rows['0']} "; $result = MySQLi_Query($resid, $query); if ($result) { while (($rows = MySQLi_Fetch_Row($result)) == True) { echo "<tr align='center'>"; echo "<td> {$rows['0']} </td> <td> {$rows['1']} </td> <td> {$rows['2']} </td>"; echo "</tr>"; } } } echo "</table> "; } ?> </table> <footer align='center'> © All Rights Reserved. </footer>
if (MySQLi_Connect_Errno()) { echo "<tr align='center'> <td colspan='5'> Failed to connect to MySQL </td> </tr>"; } else { $check_email = MySQLi_Query($res_id, "select name from students where email='" . $email . "'"); $r_email = MySQLi_Fetch_Row($check_email); if ($r_email) { echo "<tr align='center'> <td colspan='5'> <font color='red'> Email already Registered, Registration Failed! </font> </td> </tr>"; } else { $count = MySQLi_Query($res_id, "select (max(id)+1) as count from students"); $count_id = MySQLi_Fetch_Assoc($count); if ($count_id["count"]) { $query = "insert into students values (" . $count_id["count"] . ",'{$name}','{$email}',{$age},'{$gender}','{$password}')"; } else { $query = "insert into students values (1,'{$name}','{$email}',{$age},'{$gender}','{$password}')"; } $res = MySQLi_Query($res_id, $query); if ($res) { echo "<tr align='center'> <td colspan='5'> <font color='green'> Registration Successful! </font> You may login now from here:- <a href='login.php'>Login</a></td> </tr>"; } else { echo "<tr align='center'> <td colspan='5'> <font color='red'> Registration Failed! </font> </td> </tr>"; } } MySQLi_Close($res_id); } } ?> </table> <footer align='center'> © All Rights Reserved. </footer>
$MySQL = @MySQLi_Connect($__SETTINGS['db-server'], 'root', $__SETTINGS['db-root'], $__SETTINGS['db-name'], $__SETTINGS['db-port']); if ($MySQL) { #------------------------------------------------------------------------- $Query = SPrintF("UPDATE `mysql`.`user` SET `Super_priv` = 'Y' WHERE `user` = '%s';", $__SETTINGS['db-user']); #------------------------------------------------------------------------- $Result = @MySQLi_Query($MySQL, $Query); if ($Result) { #----------------------------------------------------------------------- $Query = SPrintF("GRANT ALL ON `%s`.* TO '%s'@'%%';", $__SETTINGS['db-user'], $__SETTINGS['db-name']); #----------------------------------------------------------------------- $Result = @MySQLi_Query($MySQL, $Query); if ($Result) { #--------------------------------------------------------------------- $Query = 'flush privileges;'; #--------------------------------------------------------------------- $Result = @MySQLi_Query($MySQL, $Query); if ($Result) { #------------------------------------------------------------------- Message('Права для пользователя успешно установлены'); #------------------------------------------------------------------- $__STEP_ID = 8; } else { Error(SPrintF('Не удалось выполнить запрос (%s) (%s)', $Query, MySQLi_Error($MySQL))); } } else { Error(SPrintF('Не удалось выполнить запрос (%s) (%s)', $Query, MySQLi_Error($MySQL))); } } else { Error(SPrintF('Не удалось выполнить запрос (%s) (%s)', $Query, MySQLi_Error($MySQL))); } } else {
</tr> <?php //Session_start(); if (isset($_SESSION["user_id"])) { $id = $_SESSION["user_id"]; $query = "select * from messages where receiver_id=" . $id . " order by id desc"; $res_id = MySQLi_Connect('localhost', 'root', '@connectme', 'shangout'); if (MySQLi_Connect_Errno()) { echo "<tr align='center'> <td colspan='5'> Failed to connect to MySQL </td> </tr>"; } else { $result = MySQLi_Query($res_id, $query); $data = MySQLi_Fetch_Row($result); if ($data) { $query = "select name,email from students where id=" . $data[1] . ""; $sender = MySQLi_Query($res_id, $query); $sender = MySQLi_Fetch_Row($sender); //if($data) { echo "<tr align='center'> <td colspan='5'> <table cellpadding='4' cellspacing='5' width='100%' style='table-layout:fixed'> <col width='100%'> "; echo "<td>From:- <font color='blue'>" . $sender[0] . " </font> [" . $sender[1] . "] </td> </tr>"; echo "<tr> <td style='word-wrap:break-word'>Message:-" . $data[3] . "</td> </tr>"; echo "</table> </td> </tr>"; } else { echo "<tr align='center'> <td colspan='5'> <font color='lightblue'> No Messages! </font> </td> </tr>"; } MySQLi_Close($res_id); } } else { echo "<tr align='center'> <td colspan='5'> <font color='red'> Sorry, You not Logged in! </font> Login again:- <a href='login.php'>Login</a> </td> </tr>"; } ?>
$res4 = MySQLi_Fetch_Row($result4); } if ($res4[0] == NULL and $res4[1] == NULL) { $flo = 0; } else { if ($res4[0] == 0 and $res4[1] == 0) { $flo = 1; } else { $flo = 2; } } //START:- Exclude those who are engaged and self; $query2 = "select status from are_friends where frnd_one_id=" . $_SESSION["user_id"] . " and frnd_two_id=" . $rows[0] . ""; $query3 = "select status from are_friends where frnd_one_id=" . $rows[0] . " and frnd_two_id=" . $_SESSION["user_id"] . ""; $result2 = MySQLi_Query($res_id, $query2); $result3 = MySQLi_Query($res_id, $query3); if ($result2 == true) { $res2 = MySQLi_Fetch_Row($result2); } if ($result3 == true) { $res3 = MySQLi_Fetch_Row($result3); } if ($rows[0] == $_SESSION["user_id"]) { $flori = 1; } else { $flori = 2; } if ($res2[0] == 1 or $res3[0] == 1 or $flo == 1 or $flori == 1) { } else { echo "<tr align='center'> <td align='left'>" . $rows[1] . "</td> <td align='left'> <form method='POST' action='sendfr.php'>\n\t\t\t\t\t\t\t<input type='hidden' name='h1' value='" . $rows[0] . "'>\n\t\t\t\t\t\t\t<input type='hidden' name='h2' value='" . $rows[1] . "'>\n\t\t\t\t\t\t\t<input type='submit' name='sfr' value='Send Request'>\n\t\t\t\t\t\t\t</form></td> </tr>"; }