Fatal error: Call to undefined function: getsqlvaluestring()

im kinda new in using php, I have a script here that have an eror Fatal error: Call to undefined function: getsqlvaluestring() on line 10. Hope somebody can help me with this.


<?php
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];
$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

if ((isset($HTTP_POST_VARS["MM_update"])) && ($HTTP_POST_VARS["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE stud SET s_fname=%s, s_mname=%s, s_lname=%s, user_name=%s, pass_word=%s WHERE s_num=%s",
GetSQLValueString($HTTP_POST_VARS['s_num'], "int"),
GetSQLValueString($HTTP_POST_VARS['s_fname'], "text"),
GetSQLValueString($HTTP_POST_VARS['s_mname'], "text"),
GetSQLValueString($HTTP_POST_VARS['s_lname'], "text"),
GetSQLValueString($HTTP_POST_VARS['user_name'], "text"),
GetSQLValueString($HTTP_POST_VARS['pass_word'], "text"));


mysql_select_db($database_vino, $hotel_vino);
$Result1 = mysql_query($updateSQL, $hotel_vino) or die(mysql_error());
}

$maxRows_Recordset1 = 1;
$pageNum_Recordset1 = 0;
if (isset($HTTP_GET_VARS['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $HTTP_GET_VARS['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

mysql_select_db($database_vino, $hotel_vino);
//$query_Recordset1 = "SELECT * FROM stud where agency_id = $current_agency_id";
$query_Recordset1 = "SELECT * FROM stud";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $hotel_vino) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($HTTP_GET_VARS['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $HTTP_GET_VARS['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;

$queryString_Recordset1 = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
$params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Recordset1") == false &&
stristr($param, "totalRows_Recordset1") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Recordset1 = "&" . implode("&", $newParams);
}
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?>

 

You need a seperate function called GetSQLValueString, if you don't have this the script won't work.

 

well, tnx for the reply but i have used this same script in my previous program and that work. the only thing that changed is the value and the and variable. here is the script that works.

<?php
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];
$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

if ((isset($HTTP_POST_VARS["MM_update"])) && ($HTTP_POST_VARS["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE seaman_agency_jobpostings SET agency_id=%s, job=%s, salary_range=%s, posted=%s, expiry=%s WHERE job_id=%s",
GetSQLValueString($HTTP_POST_VARS['agency_id'], "int"),
GetSQLValueString($HTTP_POST_VARS['job'], "text"),
GetSQLValueString($HTTP_POST_VARS['salary_range'], "text"),
GetSQLValueString($HTTP_POST_VARS['posted'], "date"),
GetSQLValueString($HTTP_POST_VARS['expiry'], "date"),
GetSQLValueString($HTTP_POST_VARS['job_id'], "int"));

mysql_select_db($database_seaman_com, $seaman_com);
$Result1 = mysql_query($updateSQL, $seaman_com) or die(mysql_error());
}

$maxRows_Recordset1 = 1;
$pageNum_Recordset1 = 0;
if (isset($HTTP_GET_VARS['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $HTTP_GET_VARS['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

mysql_select_db($database_seaman_com, $seaman_com);
$query_Recordset1 = "SELECT * FROM seaman_agency_jobpostings where agency_id = $current_agency_id";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $seaman_com) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($HTTP_GET_VARS['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $HTTP_GET_VARS['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;

$queryString_Recordset1 = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
$params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Recordset1") == false &&
stristr($param, "totalRows_Recordset1") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Recordset1 = "&" . implode("&", $newParams);
}
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?>

 

There must be a file you included that defines that function. You must have forgotten to include that in the new script.

By the way, use the VB [php][/php] tag around code to make it readable for us.

Looks like you need this:

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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;
}

PHP:

 

Dude! thanks you so much. You are right, I forgot to include that function. Now works like a charm.