<?php session_start(); $id = $_SESSION['user_id']; $nume = $_POST['nume']; $prenume = $_POST['prenume']; $munca = $_POST['munca']; $scoala = $_POST['scoala']; $loc = $_POST['loc']; $mail = $_POST['mail']; if (!CheckInDB($id, $nume, $prenume, $munca, $scoala, $loc, $mail)) { $res = array(2, 'b'); echo json_encode($res); return; } return; function CheckInDB($idd, $nume, $prenume, $munca, $scoala, $loc, $mail) { $hostname_conn = "localhost"; $database_conn = "tema_web"; $username_conn = "root"; $password_conn = ""; $conn = mysql_pconnect($hostname_conn, $username_conn, $password_conn) or trigger_error(mysql_error(), E_USER_ERROR); mysql_select_db($database_conn, $conn); var_dump($nume); $qry = "UPDATE profile " . "SET first_name = '{$nume}',last_name='{$prenume}',work_at='{$munca}',school='{$scoala}',live_in='{$loc}',`e-mail`='{$mail}' " . " where user_id='{$idd}' "; $result = mysql_query($qry, $conn); $info = mysql_fetch_array($result); if (!$result || mysql_num_rows($result) <= 0) { mysql_close($conn); return false;
<?php session_start(); $id = $_SESSION['user_id']; $password = trim($_POST['pass']); $username = trim($_POST['user']); if (!CheckInDB($id, $password, $username)) { $res = 1; echo $res; return; } $res = 2; echo json_encode($res); return; function CheckInDB($id, $password, $username) { $hostname_conn = "localhost"; $database_conn = "tema_web"; $username_conn = "root"; $password_conn = ""; $conn = mysql_pconnect($hostname_conn, $username_conn, $password_conn) or trigger_error(mysql_error(), E_USER_ERROR); mysql_select_db($database_conn, $conn); $pwdmd5 = md5($password); $qry = "INSERT into users " . "(username,password) " . "VALUES('{$username}','{$pwdmd5}')"; $result = mysql_query($qry, $conn); $info = mysql_fetch_array($result); if (!$result || mysql_num_rows($result) <= 0) { mysql_close($conn); return false; } mysql_close($conn);
<?php session_start(); $nm = $_POST['username']; if (!CheckInDB($nm)) { $res = array(2, 'b'); echo json_encode($res); return; } return; function CheckInDB($nm) { $hostname_conn = "localhost"; $database_conn = "tema_web"; $username_conn = "root"; $password_conn = ""; $conn = mysql_pconnect($hostname_conn, $username_conn, $password_conn) or trigger_error(mysql_error(), E_USER_ERROR); mysql_select_db($database_conn, $conn); $qry1 = "Select user_id from users " . " where username='******' "; $result1 = mysql_query($qry1, $conn); $info1 = mysql_fetch_array($result1); $qry = "Select first_name,last_name,work_at,school,live_in,`e-mail` from profile " . " where user_id='{$info1['0']}' "; $result = mysql_query($qry, $conn); $info = mysql_fetch_array($result); $res = array($info[0], $info[1], $info[2], $info[3], $info[4], $info[5]); echo json_encode($res); if (!$result || mysql_num_rows($result) <= 0) { mysql_close($conn); return false; } mysql_close($conn);
<?php session_start(); $id = $_POST['iddt']; if (!CheckInDB($id)) { $res = 'nu'; echo json_encode($res); return; } $res = 'da'; echo json_encode($res); return; function CheckInDB($id) { $hostname_conn = "localhost"; $database_conn = "tema_web"; $username_conn = "root"; $password_conn = ""; $r = $_SESSION['username']; $conn = mysql_pconnect($hostname_conn, $username_conn, $password_conn) or trigger_error(mysql_error(), E_USER_ERROR); mysql_select_db($database_conn, $conn); $qry1 = "Select user_id from users " . " where username='******' "; $result1 = mysql_query($qry1, $conn); $info = mysql_fetch_array($result1); $qry = "Delete from log_in " . " where user_id='{$info['0']}' "; $result = mysql_query($qry, $conn); if (!$result || mysql_num_rows($result) <= 0) { session_destroy(); mysql_close($conn); return false; }
<?php session_start(); $frd_name = trim($_POST['frd_name']); $grp_name = trim($_POST['grp_name']); $id = $_SESSION['user_id']; if (!CheckInDB($frd_name, $id, $grp_name)) { $res = 1; echo $res; return; } $res = 2; echo json_encode($res); return; function CheckInDB($frd_name, $id, $grp_name) { $hostname_conn = "localhost"; $database_conn = "tema_web"; $username_conn = "root"; $password_conn = ""; $conn = mysql_pconnect($hostname_conn, $username_conn, $password_conn) or trigger_error(mysql_error(), E_USER_ERROR); mysql_select_db($database_conn, $conn); $qry1 = "Select group_id from groups " . " where name='{$grp_name}' "; $result1 = mysql_query($qry1, $conn); $info1 = mysql_fetch_array($result1); $qry2 = "Select user_id from users " . " where username='******' "; $result2 = mysql_query($qry2, $conn); $info2 = mysql_fetch_array($result2); var_dump($id); $qryy = "INSERT INTO users_groups" . "(user_id,group_id,friend_id) " . "VALUES('{$id}','{$info1['0']}','{$info2['0']}')"; $result = mysql_query($qryy, $conn);
<?php session_start(); $username = trim($_POST['user']); $firstname = trim($_POST['first']); $lastname = trim($_POST['last']); if (!CheckInDB($username, $firstname, $lastname)) { $res = 1; echo $res; return; } $res = 2; echo json_encode($res); return; function CheckInDB($username, $firstname, $lastname) { $hostname_conn = "localhost"; $database_conn = "tema_web"; $username_conn = "root"; $password_conn = ""; $conn = mysql_pconnect($hostname_conn, $username_conn, $password_conn) or trigger_error(mysql_error(), E_USER_ERROR); mysql_select_db($database_conn, $conn); var_dump($username); $qry = "Select user_id,username from users " . " where username='******' "; $result = mysql_query($qry, $conn); $info = mysql_fetch_array($result); var_dump($info[0]); $qryy = "INSERT INTO profile" . "(user_id,first_name,last_name) " . "VALUES('{$info['0']}','{$firstname}','{$lastname}')"; $result = mysql_query($qryy, $conn); $info2 = mysql_fetch_array($result); if (!$result || mysql_num_rows($result) <= 0) {
<?php session_start(); $name = trim($_POST['name']); $id = $_SESSION['user_id']; if (!CheckInDB($name, $id)) { $res = 1; echo $res; return; } $res = 2; echo json_encode($res); return; function CheckInDB($name, $id) { $hostname_conn = "localhost"; $database_conn = "tema_web"; $username_conn = "root"; $password_conn = ""; $conn = mysql_pconnect($hostname_conn, $username_conn, $password_conn) or trigger_error(mysql_error(), E_USER_ERROR); mysql_select_db($database_conn, $conn); $qryy = "DELETE FROM groups" . " where name='{$name}' and user_id='{$id}'"; $result = mysql_query($qryy, $conn); $info2 = mysql_fetch_array($result); if (!$result || mysql_num_rows($result) <= 0) { mysql_close($conn); return false; } mysql_close($conn); session_write_close(); return true;
<?php session_start(); $id = $_SESSION['user_id']; $usr = trim($_POST['usr']); $msg = trim($_POST['msg']); if (!CheckInDB($id, $msg, $usr)) { $res = 1; echo $res; return; } $res = 2; echo json_encode($res); return; function CheckInDB($id, $msg, $usr) { $hostname_conn = "localhost"; $database_conn = "tema_web"; $username_conn = "root"; $password_conn = ""; $conn = mysql_pconnect($hostname_conn, $username_conn, $password_conn) or trigger_error(mysql_error(), E_USER_ERROR); mysql_select_db($database_conn, $conn); $qry1 = "Select user_id from users " . " where username='******' "; $result1 = mysql_query($qry1, $conn); $info1 = mysql_fetch_array($result1); $qry = "INSERT into messages " . "(sursa,dest,message) " . "VALUES('{$id}','{$info1['0']}','{$msg}')"; $result = mysql_query($qry, $conn); $info = mysql_fetch_array($result); if (!$result || mysql_num_rows($result) <= 0) { mysql_close($conn); return false;
<?php session_start(); $frd_name = trim($_POST['frd_name']); $id = $_SESSION['user_id']; if (!CheckInDB($frd_name, $id)) { $res = 1; echo $res; return; } $res = 2; echo json_encode($res); return; function CheckInDB($frd_name, $id) { $hostname_conn = "localhost"; $database_conn = "tema_web"; $username_conn = "root"; $password_conn = ""; $conn = mysql_pconnect($hostname_conn, $username_conn, $password_conn) or trigger_error(mysql_error(), E_USER_ERROR); mysql_select_db($database_conn, $conn); $qry2 = "Select user_id from users " . " where username='******' "; $result2 = mysql_query($qry2, $conn); $info2 = mysql_fetch_array($result2); var_dump($id); $qryy = "INSERT INTO users_groups" . "(user_id,group_id,friend_id) " . "VALUES('{$id}','0','{$info2['0']}')"; $result = mysql_query($qryy, $conn); $info3 = mysql_fetch_array($result); $r = $_SESSION['username']; $qry1 = "DELETE from friend_req " . " where usr_name='{$r}' "; $result1 = mysql_query($qry1, $conn);
<?php session_start(); $id = $_SESSION['user_id']; $password = trim($_POST['pass']); if (!CheckInDB($id, $password)) { $res = 1; echo $res; return; } $res = 2; echo json_encode($res); return; function CheckInDB($id, $password) { $hostname_conn = "localhost"; $database_conn = "tema_web"; $username_conn = "root"; $password_conn = ""; $conn = mysql_pconnect($hostname_conn, $username_conn, $password_conn) or trigger_error(mysql_error(), E_USER_ERROR); mysql_select_db($database_conn, $conn); var_dump($password); $pwdmd5 = md5($password); $qry = "UPDATE users " . "SET password='******' " . " where user_id='{$id}' "; $result = mysql_query($qry, $conn); $info = mysql_fetch_array($result); if (!$result || mysql_num_rows($result) <= 0) { mysql_close($conn); return false; } mysql_close($conn);
<?php session_start(); $num = $_POST['name']; $id = $_SESSION['user_id']; if (!CheckInDB($num, $id)) { return; } return; function CheckInDB($num, $id) { $hostname_conn = "localhost"; $database_conn = "tema_web"; $username_conn = "root"; $password_conn = ""; $conn = mysql_pconnect($hostname_conn, $username_conn, $password_conn) or trigger_error(mysql_error(), E_USER_ERROR); mysql_select_db($database_conn, $conn); $qry1 = "Select group_id from groups " . " where name='{$num}' and user_id='{$id}'"; $result1 = mysql_query($qry1, $conn); $info = mysql_fetch_array($result1); $qry = "Select friend_id from users_groups " . " where group_id='{$info['0']}' and user_id='{$id}'"; $result = mysql_query($qry, $conn); $dServer = array(); while ($row = mysql_fetch_assoc($result)) { $dServer[] = $row['friend_id']; } echo json_encode($dServer); if (!$result || mysql_num_rows($result) <= 0) { mysql_close($conn); return false; }