The future: PHP 6 and Zend Engine 3
I'll try to do some script but i have proble with
while($sql_login_rst = mysql_fetch_array getting error "PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource"
tq
if(isset($_POST['btn_login'])){
$displayName = "Admin";
$sql_login = "Select * From user_access Where username='".$_POST['log_username']."' And password='".$_POST['log_password']."'";
$sql_login_qry = mysql_query($sql_login);
while($sql_login_rst = mysql_fetch_array($sql_login_qry)){
$_SESSION['UID'] = $sql_login_rst['UID'];
$_SESSION['LVL'] = $sql_login_rst['level'];
$_SESSION['FTIME'] = $sql_login_rst['firsttime'];
FAQ: Frequently Asked Questions
add a note
User Contributed NotesFAQ
zad_k at yahoo dot com
20-Jul-2010 04:59
20-Jul-2010 04:59
djnigelharkness at yahoo dot com
12-May-2010 12:40
12-May-2010 12:40
<?php
$gHostName ="localhost";
$gUserName ="root";
$gPassword ="mypassword";
$gDBName ="dbName";
$mysqli = new mysqli($gHostName, $gUserName, $gPassword,
$gDBName);
$username="username"; $email="user@xxx.edu";
$password="3442f6e94a733237a3e844f0286b92f559bf794d";
//insert
// $stmt = $mysqli->prepare("INSERT INTO j_user
(username,email,password) VALUES (?, ?, ?)");
// $stmt->bind_param('sss',$username, $email, $password);
// $stmt->execute();
// $stmt->close();
//delete
// $stmt = $mysqli->prepare("DELETE FROM j_user WHERE
username=?");
// $stmt->bind_param('s',$username);
// $stmt->execute();
// $stmt->close();
//update
// $stmt = $mysqli->prepare("UPDATE j_user SET email=? WHERE
username='wjw6349'");
// $stmt->bind_param('s',$email);
// $stmt->execute();
// $stmt->close();
if ($mysqli->connect_error){
echo("Connect failed: ".mysqli_connect_error()); exit();
}
$querySelect = "SELECT * FROM j_user";
$resultSet = $mysqli->query($querySelect);
if($resultSet->num_rows > 0){
while($row = $resultSet->fetch_assoc()){
foreach($row as $fieldValue){
$bigString .= "<em>$fieldValue</em><br />n";
}
$bigString .= "<hr />";
}
$mysqli->close();
echo $bigString;
}
function __autoload($className) {
require_once $className.'.class.php';
}
//start the session and create it
session_start();
$_SESSION['name'] = $_POST['username']."_".time();
//encrypt the password
sha1($_POST['password']) == $password
header("Location:admin.php");
//check if the session is set
session_start();
if (isset($_SESSION['name'])) { }
?>
djnigelharkness at yahoo dot com
12-May-2010 12:39
12-May-2010 12:39
<?php
$gHostName ="localhost";
$gUserName ="root";
$gPassword ="mypassword";
$gDBName ="dbName";
$mysqli = new mysqli($gHostName, $gUserName, $gPassword,
$gDBName);
$username="username"; $email="user@xxx.edu";
$password="3442f6e94a733237a3e844f0286b92f559bf794d";
//insert
// $stmt = $mysqli->prepare("INSERT INTO j_user
(username,email,password) VALUES (?, ?, ?)");
// $stmt->bind_param('sss',$username, $email, $password);
// $stmt->execute();
// $stmt->close();
//delete
// $stmt = $mysqli->prepare("DELETE FROM j_user WHERE
username=?");
// $stmt->bind_param('s',$username);
// $stmt->execute();
// $stmt->close();
//update
// $stmt = $mysqli->prepare("UPDATE j_user SET email=? WHERE
username='wjw6349'");
// $stmt->bind_param('s',$email);
// $stmt->execute();
// $stmt->close();
if ($mysqli->connect_error){
echo("Connect failed: ".mysqli_connect_error()); exit();
}
$querySelect = "SELECT * FROM j_user";
$resultSet = $mysqli->query($querySelect);
if($resultSet->num_rows > 0){
while($row = $resultSet->fetch_assoc()){
foreach($row as $fieldValue){
$bigString .= "<em>$fieldValue</em><br />n";
}
$bigString .= "<hr />";
}
$mysqli->close();
echo $bigString;
}
function __autoload($className) {
require_once $className.'.class.php';
}
//start the session and create it
session_start();
$_SESSION['name'] = $_POST['username']."_".time();
//encrypt the password
sha1($_POST['password']) == $password
header("Location:admin.php");
//check if the session is set
session_start();
if (isset($_SESSION['name'])) { }
?>
djnigelharkness at yahoo dot com
12-May-2010 12:39
12-May-2010 12:39
<?php
$gHostName ="localhost";
$gUserName ="root";
$gPassword ="mypassword";
$gDBName ="dbName";
$mysqli = new mysqli($gHostName, $gUserName, $gPassword,
$gDBName);
$username="username"; $email="user@xxx.edu";
$password="3442f6e94a733237a3e844f0286b92f559bf794d";
//insert
// $stmt = $mysqli->prepare("INSERT INTO j_user
(username,email,password) VALUES (?, ?, ?)");
// $stmt->bind_param('sss',$username, $email, $password);
// $stmt->execute();
// $stmt->close();
//delete
// $stmt = $mysqli->prepare("DELETE FROM j_user WHERE
username=?");
// $stmt->bind_param('s',$username);
// $stmt->execute();
// $stmt->close();
//update
// $stmt = $mysqli->prepare("UPDATE j_user SET email=? WHERE
username='wjw6349'");
// $stmt->bind_param('s',$email);
// $stmt->execute();
// $stmt->close();
if ($mysqli->connect_error){
echo("Connect failed: ".mysqli_connect_error()); exit();
}
$querySelect = "SELECT * FROM j_user";
$resultSet = $mysqli->query($querySelect);
if($resultSet->num_rows > 0){
while($row = $resultSet->fetch_assoc()){
foreach($row as $fieldValue){
$bigString .= "<em>$fieldValue</em><br />n";
}
$bigString .= "<hr />";
}
$mysqli->close();
echo $bigString;
}
function __autoload($className) {
require_once $className.'.class.php';
}
//start the session and create it
session_start();
$_SESSION['name'] = $_POST['username']."_".time();
//encrypt the password
sha1($_POST['password']) == $password
header("Location:admin.php");
//check if the session is set
session_start();
if (isset($_SESSION['name'])) { }
?>