CheckInDB PHP代码示例

示例#1

0

显示文件

文件： profile_change_php.php 项目： adriansnep/little_facebook

<?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;

示例#2

0

显示文件

文件： cont_reusit_php.php 项目： adriansnep/little_facebook

<?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);

示例#3

0

显示文件

文件： profile_php_view.php 项目： adriansnep/little_facebook

<?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);

示例#4

0

显示文件

文件： del_log_php.php 项目： adriansnep/little_facebook

<?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;
    }

示例#5

0

显示文件

文件： add_frd_togrp_php.php 项目： adriansnep/little_facebook

<?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);

示例#6

0

显示文件

文件： cont_detail_php.php 项目： adriansnep/little_facebook

<?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) {

示例#7

0

显示文件

文件： profile_del_group_php.php 项目： adriansnep/little_facebook

<?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;

示例#8

0

显示文件

文件： sent_msg_php.php 项目： adriansnep/little_facebook

<?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;

示例#9

0

显示文件

文件： acc_frd_php.php 项目： adriansnep/little_facebook

<?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);

示例#10

0

显示文件

文件： profile_new_pass_php.php 项目： adriansnep/little_facebook

<?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);

示例#11

0

显示文件

文件： chat_group_php.php 项目： adriansnep/little_facebook

<?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;
    }

PHP CheckInDB示例