[solution] mysql_query() expects parameter 2 to be resource, object given in C:\wamp\www\Register.php on line 81

[etmurphy]

i'm recieving error 79 and 81

<?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("mysql_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;
}
}

// *** Redirect if username exists
$MM_flag="MM_insert";
if (isset($_POST[$MM_flag])) {
  $MM_dupKeyRedirect="Register.php";
  $loginUsername = $_POST['Username'];
  $LoginRS__query = sprintf("SELECT Username FROM users WHERE Username=%s", GetSQLValueString($loginUsername, "text"));
  mysql_select_db($database_localhost, $localhost);
  $LoginRS=mysql_query($LoginRS__query, $localhost) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);

  //if there is a row in the database, the username was found - can not add the requested username
  if($loginFoundUser){
    $MM_qsChar = "?";
    //append the username to the redirect page
    if (substr_count($MM_dupKeyRedirect,"?") >=1) $MM_qsChar = "&";
    $MM_dupKeyRedirect = $MM_dupKeyRedirect . $MM_qsChar ."requsername=".$loginUsername;
    header ("Location: $MM_dupKeyRedirect");
    exit;
  }
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "Registerform")) {
  $insertSQL = sprintf("INSERT INTO users (Firstname, Lastname, Email, Username, Password) VALUES (%s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['Firstname'], "text"),
                       GetSQLValueString($_POST['Lastname'], "text"),
                       GetSQLValueString($_POST['Email'], "text"),
                       GetSQLValueString($_POST['Username'], "text"),
                       GetSQLValueString($_POST['Password'], "text"));

  mysql_select_db($database_localhost, $localhost);
  $Result1 = mysql_query($insertSQL, $localhost) or die(mysql_error());

  $insertGoTo = "Login.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_localhost, $localhost);
$query_register = "SELECT * FROM users";
$register = mysqli_query($query_register, $localhost) or die(mysqli_error());
$row_register = mysql_fetch_assoc($register);
$totalRows_register = mysql_num_rows($register);
?>

Edited May 14, 2015 by Ch0cu3r
Added code tags

[etmurphy]

the error start from

 

mysql_select_db($database_localhost, $localhost);
$query_register = "SELECT * FROM users";
$register = mysqli_query($query_register, $localhost) or die(mysqli_error());
$row_register = mysql_fetch_assoc($register);
$totalRows_register = mysql_num_rows($register);

[Barand]

You can't mix mysql_ functions and mysqli_ functions,

 

Use one or the other and not mysql_.

[etmurphy]

BUT I'VE use only mysqli but still the same

[Barand]

 

$register = mysqli_query($query_register, $localhost) or die(mysqli_error());        // query params in wrong order

$row_register = mysql_fetch_assoc($register);                                                            // NOT mysqli

 

You have mixture in the above lines and in other lines in your code. To use mysqli_ you must have a mysqli connection

[etmurphy]

i wil still try more because, when i change it, i still recieve this

 

"mysqli_select_db() expects parameter 1 to be mysqli, string given in C:\wamp\www\Register.php on line 79"

[Ch0cu3r]

You can not just rename the mysql_ functions to mysqli_ as they are completely different. You should be looking at php.net/mysqli for the correct usage of these functions.

 

For what its worth your better of deleting the code generated by Dreamweaver and just writing the code yourself, with a lot few lines of code.

Edited May 14, 2015 by Ch0cu3r