mysqli_real_escape_string() expects parameter 1 to be mysqli, null given in
hi, everyone... i'm using dreamweaver cc 2015 , creating registration page. i'm facing error in above mentioned title using php , mysql server side programming. error found in php function code has been generated using server behavior in dreamweaver cc 2015. here complete code of my
register.php file. there can solve error in file.
here code:
-----------------------
<?php require_once('connections/user_informaion.php'); ?>
<?php
if (!function_exists("getsqlvaluestring")) {
function getsqlvaluestring($thevalue, $thetype, $thedefinedvalue = "", $thenotdefinedvalue = "")
{
if (php_version < 6) {
$thevalue = get_magic_quotes_gpc() ? stripslashes($thevalue) : $thevalue;
}
$thevalue = function_exists("mysqli_real_escape_string") ? mysqli_real_escape_string($user_informaion, $thevalue) : mysqli_escape_string($user_informaion, $thevalue);
switch ($thetype) {
case "text":
$thevalue = ($thevalue != "") ? "'" . $thevalue . "'" : "null";
break;
case "long":
case "int":
$thevalue = ($thevalue != "") ? intval($thevalue) : "null";
break;
case "double":
$thevalue = ($thevalue != "") ? doubleval($thevalue) : "null";
break;
case "date":
$thevalue = ($thevalue != "") ? "'" . $thevalue . "'" : "null";
break;
case "defined":
$thevalue = ($thevalue != "") ? $thedefinedvalue : $thenotdefinedvalue;
break;
}
return $thevalue;
}
}
$editformaction = $_server['php_self'];
if (isset($_server['query_string'])) {
$editformaction .= "?" . htmlentities($_server['query_string']);
}
if ((isset($_post["mm_insert"])) && ($_post["mm_insert"] == "register_form")) {
$insertsql = sprintf("insert ``user`` (fname, lname, email, username, password, `timestamp`) values (%s, %s, %s, %s, %s, %s)",
getsqlvaluestring($_post['firstname'], "text"),
getsqlvaluestring($_post['lastname'], "text"),
getsqlvaluestring($_post['email1'], "text"),
getsqlvaluestring($_post['email2'], "text"),
getsqlvaluestring($_post['password'], "text"));
mysqli_select_db($user_informaion, $database_user_informaion);
$result1 = mysqli_query($insertsql, $user_informaion) or die(mysqli_error());
$insertgoto = "login.php";
if (isset($_server['query_string'])) {
$insertgoto .= (strpos($insertgoto, '?')) ? "&" : "?";
$insertgoto .= $_server['query_string'];
}
header(sprintf("location: %s", $insertgoto));
}
if (!function_exists("getsqlvaluestring")) {
function getsqlvaluestring($thevalue, $thetype, $thedefinedvalue = "", $thenotdefinedvalue = "")
{
if (php_version < 6) {
$thevalue = get_magic_quotes_gpc() ? stripslashes($thevalue) : $thevalue;
}
$thevalue = function_exists("mysqli_real_escape_string") ? mysqli_real_escape_string($thevalue) : mysqli_escape_string($thevalue);
switch ($thetype) {
case "text":
$thevalue = ($thevalue != "") ? "'" . $thevalue . "'" : "null";
break;
case "long":
case "int":
$thevalue = ($thevalue != "") ? intval($thevalue) : "null";
break;
case "double":
$thevalue = ($thevalue != "") ? doubleval($thevalue) : "null";
break;
case "date":
$thevalue = ($thevalue != "") ? "'" . $thevalue . "'" : "null";
break;
case "defined":
$thevalue = ($thevalue != "") ? $thedefinedvalue : $thenotdefinedvalue;
break;
}
return $thevalue;
}
}
mysqli_select_db($user_informaion, $database_user_informaion);
$query_user_request = "select * `user`";
$user_request = mysqli_query($user_informaion, $query_user_request) or die(mysqli_error());
$row_user_request = mysqli_fetch_assoc($user_request);
$totalrows_user_request = mysqli_num_rows($user_request);
?>
<?php
// *** validate request login site.
if (!isset($_session)) {
session_start();
}
$loginformaction = $_server['php_self'];
if (isset($_get['accesscheck'])) {
$_session['prevurl'] = $_get['accesscheck'];
}
if (isset($_post['firstname'])) {
$loginusername=$_post['firstname'];
$password=$_post['password'];
$mm_flduserauthorization = "";
$mm_redirectloginsuccess = "login.php";
$mm_redirectloginfailed = "accessd.php";
$mm_redirecttoreferrer = false;
mysqli_select_db($user_informaion, $database_user_informaion);
$loginrs__query=sprintf("select fname, password `user` fname=%s , password=%s",
getsqlvaluestring($loginusername, "text"), getsqlvaluestring($password, "text"));
$loginrs = mysqli_query($loginrs__query, $user_informaion) or die(mysqli_error());
$loginfounduser = mysqli_num_rows($loginrs);
if ($loginfounduser) {
$loginstrgroup = "";
if (php_version >= 5.1) {session_regenerate_id(true);} else {session_regenerate_id();}
//declare 2 session variables , assign them
$_session['mm_username'] = $loginusername;
$_session['mm_usergroup'] = $loginstrgroup;
if (isset($_session['prevurl']) && false) {
$mm_redirectloginsuccess = $_session['prevurl'];
}
header("location: " . $mm_redirectloginsuccess );
}
else {
header("location: ". $mm_redirectloginfailed );
}
}
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>registration</title>
</head>
<body>
<h1>registration</h1>
<form method="post" action="<?php echo $loginformaction; ?>" name="register_form">
<label>first name:</label>
<input name="firstname" type="text" autofocus required="required">
<label>last name:</label>
<input name="lastname" type="text">
<br/>
<br/>
<label>email:</label>
<input name="email1" type="email" required="required">
<label>user name/email:</label>
<input name="email2" type="email" required="required">
<br/>
<br/>
<label>password:</label>
<input name="password" type="password" required="required">
<label>confirm password:</label>
<input name="passwordc" type="password" required="required">
<br/>
<br/>
<input type="submit" value="register">
</form>
<input type="hidden" name="mm_insert" value="register_form">
already have account? <a href="login.php">login</a>
</body>
</html>
<?php
mysqli_free_result($user_request);
?>
no, code has not been generated dreamweaver server behavior. have used dreamweaver server behavior, , done find , replace operation change mysql_* functions mysqli_* functions. won't work.
although mysql improved (mysqli) looks similar original php mysql extension, works differently. first argument mysqli_* function needs mysqli connection database. in original mysql extension, connection optional argument @ end.
if switching mysql_* mysql_* had been simple, adobe have updated server behaviors years ago. because needs rewritten, adobe decided instead abandon server behaviors. might rewritten @ point in future, there's no guarantee will.
there no simple fix problem. either need learn how write own php code, or need invest in third-party extension, such created dmxzone or webassist.
learning write own php code isn't difficult, takes time , effort. have written books php, , i've created lot of php video training courses lynda.com. there many other resources out there, both free , paid-for. whichever choose, make sure information you're using date. sadly, there lot of bad tutorials on internet using outdated and/or insecure code.
More discussions in Dreamweaver support forum
adobe
Comments
Post a Comment