Databases
StackOverflow2013
Postsdbo
POFatal error: Call to undefined function getsqlvaluestring()
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFatal error: Call to undefined function getsqlvaluestring()
    text
    copied!<p>Hey guys I get this error when I try to login with a default Dreamweaver Login Module, please help me - this is a though one, I'm just an html designer trying to make a simple login script for a small site I'm working one. It's be great if you can help</p> <pre><code> &lt;?php require_once('../Connections/dsfsdfsdfd.php'); ?&gt; &lt;?php // *** Validate request to login to this site. if (!isset($_SESSION)) { session_start(); } $loginFormAction = $_SERVER['PHP_SELF']; if (isset($_GET['accesscheck'])) { $_SESSION['PrevUrl'] = $_GET['accesscheck']; } if (isset($_POST['username'])) { $loginUsername=$_POST['username']; $password=$_POST['password']; $MM_fldUserAuthorization = "access_level"; $MM_redirectLoginSuccess = "index.php"; $MM_redirecttoReferrer = true; mysql_select_db($database_promocenter, $promocenter); $LoginRS__query=sprintf("SELECT username, password, destination_page FROM users WHERE username=%s AND password=%s", GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "int")); $LoginRS = mysql_query($LoginRS__query, $promocenter) or die(mysql_error()); $loginFoundUser = mysql_num_rows($LoginRS); if ($loginFoundUser) { $loginStrGroup = mysql_result($LoginRS,0,'access_level'); if (PHP_VERSION &gt;= 5.1) {session_regenerate_id(true);} else {session_regenerate_id();} //declare two session variables and assign them $_SESSION['MM_Username'] = $loginUsername; $_SESSION['MM_UserGroup'] = $loginStrGroup; if (isset($_SESSION['PrevUrl']) &amp;&amp; true) { $MM_redirectLoginSuccess = $_SESSION['PrevUrl']; } header("Location: " . $MM_redirectLoginSuccess ); } else { header("Location: ". $MM_redirectLoginFailed ); } } ?&gt; &lt;?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION &lt; 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_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; } } mysql_select_db($database_promocenter, $promocenter); $query_rs_users_login = "SELECT * FROM users"; $rs_users_login = mysql_query($query_rs_users_login, $promocenter) or die(mysql_error()); $row_rs_users_login = mysql_fetch_assoc($rs_users_login); $totalRows_rs_users_login = mysql_num_rows($rs_users_login); ?&gt; </code></pre> <p>Sorry guys, the error is Fatal error: Call to undefined function getsqlvaluestring() in /u1/home/xxxxxx/public_html/newsletters/Resources/promocenter/admin/login.php on line 22 This is standard dreamweaver cs5 code.</p> <p>Connecting to a database etc. I'm sure I have the file included right at the top of my code, please have a look there. I can also say that this code worked perfectly fine for a year and all of a sudden it gave me this error everytime I try to login. The normal front end still shows fields from the database. It's just the /admin/ login side that give the issue</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload