Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource

numerical25

For some reason im getting the error below

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\www\apache\htdocs\application.php on line 21

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\www\apache\htdocs\application.php on line 25

when trying to insert a form into a mysql table.

below is what the form looks like

<?php 
	if ($_GET['update'] == 1){
		$update = new frontend;
		$update->signUp($_POST['firstName'],$_POST['lastName'],
						$_POST['sloginName'],$_POST['spassword']);
	}
	?>
	<div id="userSignUp" align="center">
	<form action="signUp.php?update=1" method="post">
		<table border="0" 
		cellspacing="0" 
		cellpadding="0"
		 style="margin:0px;">
  <tr>
    <td width="98">First Name </td>
    <td width="162"><input type="text" name="firstName" /></td>
  </tr>
  <tr>
    <td>Last Name </td>
    <td><input type="text" name="lastName" /></td>
  </tr>
  <tr>
    <td>Login Name </td>
    <td><input type="text" name="sloginName" /></td>
  </tr>
  <tr>
    <td>Password</td>
    <td><input type="password" name="spassword" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><input type="submit" name="Submit" value="Submit" /></td>
  </tr>
</table>

</form>

When the form submits. the $_POST varible values are pasted into a user defined method call signUp within a class called front end. this is what it looks like in front end

<?php
class frontend
{
public $table = "users";
public $columns = "firstName, lastName, loginName, passWord";

public function signUp($first,$last,$userName,$userPass){

	$value = array($first,$last,$userName,$userPass);
	$value = "'{".implode("}','{",$value)."}'"; 
	require_once('Connections/ok.php'); 
	mysql_select_db($database_ok, $ok); 
	$table = $this->table;
	$columns = $this->columns;
	$query = "INSERT INTO {$table} ({$columns}) VALUES ($value)";
	mysql_query($query,$ok)or die("Error: ".mysql_error());
}
}
?>

Now ive tested all the values being past. they all work. Basically everything works except for the require_once('Connections./ok.php') and mysql_select_db.

Whats funny is I use this every. about a thousand times. but for some reason it doesnt work here. Is it because it doesnt work within a class ???

Weedpacket

<?php

class foo
{
	function bar()
	{
require_once('foo.php');
		echo $ping;
	}
}



$a = new foo;
$a->bar();

<?php $ping = 42;

That worked. Must be something else.

Are $database_ok and $ok present and correct?

numerical25

Yes, I used it all around my application. I been using it and had no problems.

In the require_once('connections/ok.php') is this

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_ok = "localhost";
$database_ok = "mywebsite";
$username_ok = "user";
$password_ok = "pass";
$ok = mysql_pconnect($hostname_ok, $username_ok, $password_ok) or trigger_error(mysql_error(),E_USER_ERROR); 
?>

Im using dreamweaver so dreamweaver sets this document up

Now lets say in the form, I put my name and last name and a user login and password in the fields. press submit. but this time I will echo out the $query . this is what i get

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\www\apache\htdocs\application.php on line 21

if I echo out $query. this is what i get. Everything is working properly except for the mysql_select_db and mysql_query.

INSERT INTO users (firstName, lastName, loginName, passWord) VALUES ('{Anthony}','{Gordon}','{Numerical25}','{password}')

numerical25

Tried to echo out $database_ok, and im not getting the value

The folder connections is in the same folder as the document that is trying to call on require_once('connections/ok.php')

I echo it out of any other document and the value comes out. which is strange. all my other documents are templates of a document called insert.php. In insert.php the require_once(../connections/ok.php) <---- looks like that. application.php (the document that has my user defined class and methods are not a template of insert. and it doesnt work...???hmmm???

numerical25

Ok, im confused. all i did was change. require_once into require and it worked ?????? can someone tell me why. Its the only require on the page. there is no only require just that one so when i put require_once it doesnt work. when i put require, it works. On my other templates. I would put require_once on the same document lots of times and it worked. but yet i put require_once here and it doesnt work. but if i put require it does. Please can someone give me some idea on why this might possibly be ??

bradgrafelman

Sounds like this file was already required/included somewhere else, thus explaining why a require_once would do nothing.

Since it was most likely loaded somewhere outside the function declaration, the database variables were out of the function's scope and were thus unusable. Changing to a require() would force the script to be loaded within the function's scope.