<?php $con = mysqli_connect("mysql12.000webhost.com", "a1738747_Shri1", "Suchitra123", "a1738747_UserFin"); $oldpassword = $_POST["oldpassword"]; $newpassword = $_POST["newpassword"]; $statement = mysqli_prepare($con, "SELECT username FROM UserInfo WHERE password = ?"); mysqli_stmt_bind_param($statement, "s", $oldpassword); mysqli_stmt_execute($statement); mysqli_stmt_store_result($statement); mysqli_bind_result($statement, $username); $user = array(); while (mysqli_stmt_fetch($statement)) { $user[username] = $username; } echo json_encode($user); mysqli_stmt_close($statement); $statement1 = mysqli_prepare($con, "UPDATE UserInfo SET password = ? WHERE password= ?"); mysqli_stmt_bind_param($statement1, "ss", $newpassword, $oldpassword); mysqli_stmt_execute($statement1); mysqli_stmt_close($statement1); mysqli_close($con);
call_user_method(); call_user_method_array(); define_syslog_variables(); dl(); ereg(); ereg_replace(); eregi(); eregi_replace(); import_request_variables(); mcrypt_generic_end(); mysql_db_query(); mysql_escape_string(); mysql_list_dbs(); mysqli_bind_param(); mysqli_bind_result(); mysqli_client_encoding(); mysqli_fetch(); mysqli_param_count(); mysqli_get_metadata(); mysqli_send_long_data(); magic_quotes_runtime(); session_register(); session_unregister(); session_is_registered(); set_magic_quotes_runtime(); set_socket_blocking(); split(); spliti(); sql_regcase(); php_logo_guid();
<?php $con = mysqli_connect("mysql12.000webhost.com", "a1738747_Shri1", "Suchitra123", "a1738747_UserFin"); $position = $_POST["position"]; $experience = $_POST["experience"]; $statement = mysqli_prepare($con, "SELECT * FROM JobList WHERE domain= ? OR experience = ?"); mysqli_stmt_bind_param($statement, "ss", $position, $experience); mysqli_stmt_execute($statement); mysqli_stmt_store_result($statement); mysqli_bind_result($statement, $serial, $id, $domain, $position, $type, $description, $experience, $location, $remarks); $job = array(); while (mysqli_stmt_fetch($statement)) { $job[] = array("id" => $id, "domain" => $domain, "position" => $position, "type" => $type, "description" => $description, "experience" => $experience, "location" => $location, "remarks" => $remarks); } echo json_encode($job); mysqli_stmt_close($statement); mysqli_close($con);
<?php $con = mysqli_connect("mysql12.000webhost.com", "a1738747_Shri1", "Suchitra123", "a1738747_UserFin"); $username = $_POST["username"]; $statement = mysqli_prepare($con, "SELECT username, password FROM UserInfo WHERE username = ?"); mysqli_stmt_bind_param($statement, "s", $username); mysqli_stmt_execute($statement); mysqli_stmt_store_result($statement); mysqli_bind_result($statement, $username, $password); $user = array(); while (mysqli_stmt_fetch($statement)) { $user[username] = $username; $user[password] = $password; } echo json_encode($user); mysqli_stmt_close($statement); mysqli_close($con); ?>
<?php $con = mysqli_connect("mysql12.000webhost.com", "a1738747_Shri1", "Suchitra123", "a1738747_UserFin"); $username = $_POST["username"]; $password = $_POST["password"]; $statement = mysqli_prepare($con, "SELECT * FROM UserInfo WHERE username = ? AND password = ?"); mysqli_stmt_bind_param($statement, "ss", $username, $password); mysqli_stmt_execute($statement); mysqli_stmt_store_result($statement); mysqli_bind_result($statement, $username, $name, $password, $email, $age, $phone, $position, $experience, $curloc, $desloc, $imageuri, $com1name, $com1pos, $com1from, $com1to, $com1resp, $com2name, $com2pos, $com2from, $com2to, $com2resp, $com3name, $com3pos, $com3from, $com3to, $com3resp); $user = array(); while (mysqli_stmt_fetch($statement)) { $user[username] = $username; $user[password] = $password; $user[email] = $email; $user[age] = $age; $user[name] = $name; $user[phone] = $phone; $user[position] = $position; $user[experience] = $experience; $user[curloc] = $curloc; $user[desloc] = $desloc; $user[imageuri] = $imageuri; $user[com1name] = $com1name; $user[com1pos] = $com1pos; $user[com1from] = $com1from; $user[com1to] = $com1to; $user[com1resp] = $com1resp; $user[com2name] = $com2name; $user[com2pos] = $com2pos; $user[com2from] = $com2from;