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