MySQL & INC files.

[Anon]

Finally having the chance to write a PHP program that needs functions in a seprate file, I tried to start by putting the mysql connect stuff in a function, and returned the link identifier - no luck.

Next, I tried mysql pconnect, no luck (that should work without a link ident, right? But I have tried it both ways)

I am running the latest PHP (4.0.3pl1) on FreeBSD.

Can anyone tell me the right way to abstract all my db functions and init's into a seprate inc file?

Thanks,

M. Gamble

[Anon]

Hi,

I am not very clear form your problem but, u can check two things :

1) Check whether the .inc extension been enabled for PHP parsing in your srm.conf or httpd.conf file on apache.

eg.
AddType application/x-httpd-php .php .php3 .html .inc
AddType application/x-httpd-php-source .phps

2) Check whether the script and functions in your .INC file has been treated like normal PHP coding. I mean opening and closing tags for php are there or not <?php and ?>.

I hope this will solve your problem.

--Bhavin.

[Anon]

If what you are trying to do, in a nutshell, is pulls chunks of code out of a db and run them, I don't think you're going to have any luck. It's a security issue.

However, by using the eval() function, you should be able to execute strings pulled out of db's. Check out the function in the manual.

Later on,
morpheus()

[Anon]

I'm assuming that you have your DB connect code in a separate text file. Just write the code as usual and then include the file with something like:

include("includes/inc.php");

Is this not working?

If you are using a function you wrote to do the DB connect, the link identifier might not be visible outside that function. You might need to declare it as global.

[Anon]

I can not get ur question. it not clear what is the actual problem is.

I think you have a seperate file (.inc) to include the database connection and query.

i have define a class to connect the database and query. just include this file and using it.

$mydb = new db;
$mydb ->connect("databasename")
$sql = "select field1, field2 from table";
$row =$mydb->selectqry($sql);

I think this will solve your problem.

class db {
var $result;
var $dbname;
var $row;
var $no_of_rows;
var $effrow;
var $link;

//Data base Connection Function
// in your Program You should use like
// $mydb = new db; this create a new object.
//$mydb->connect($dbname); you have to
//pass your database name to connect that.

function connect($dbname)
{
$this->dbname = $dbname;
$this->link = mysql_connect ("ipaddress","user","password");
mysql_select_db($dbname);
}

//For Select Query, where you have to pass sql query from your program.

function  selectqry($sql)

{
	$row=mysql_db_query($this->dbname,$sql);
	return $row;    // row will return the record set.
}

// This function will load all the record into the array. 
function fetch ($row)
{
    	$dataarray= mysql_fetch_row($row);
	return $dataarray; // dataarray is the array with the all the record.
     }

// This function to find out total number of record in your record set and
// will return the value into the Noofrows varaible.

function numrows($row)

{
    	$num_rows= mysql_num_rows($row);
	return $num_rows;
     }

// this function to insert, update, Delete the record from the table.
// effrow varible return to the value of effected rows of table.

function query ($sql)
{

	$effrow=mysql_db_query($this->dbname,$sql);
    	return $effrow;
	}


function close ()
{
	mysql_close($this->link);
}

}
?>