parse error?

[spoonyspork]

I've been playing around with php for a while, and still don't understand it.. though I've somehow been able to make it work... sometimes. Well, I've been trying to use someone else's code to make a genology site, and in testing it, I keep getting: parse error, expecting `')' ' on line 6. The test site is at http://dragped.ionichost.com/test.php ... yeah, I know using the '.inc' extension isn't a good idea, but the whole thing is just a test database, so I'm not worried about privacy for the database logon stuff as of yet.

I also know there's another error about another .inc inclusion, but I figure I'll figure /that/ part out once I figure the fist part out. Prolly has something to do with the fact that there isn't actually any /info/ in the database yet, but.. yeah. Any help would be appreciated!

Oh! And, um, the actual database functions are in http://dragped.ionichost.com/database_functions.inc since the source doesn't actually say /where/ the .inc files are. Yeah.

[Traduim]

Haven't you realized we can't see the PHP code by just calling it?
You should either post the code, or have it copyed in a plain text file.

[spoonyspork]

Mmm... that's why it's saved in .inc and not in .php ... all you have to do is view the source, and there's all the php code! That's what's bad about saving stuff in .inc ... the php code'll still /work/ when included in html code, but all you have to do is go to the url of the .inc file and you can see all the database info. But... yeah. 🙂 Here... and yes, the database name and user name and password are all correct in the actual code on the site.

<?php

db_connect(mysql database); //Establish database connection for duration of script

//FUNCTION to connect to database
function db_connect(mysql database) {
    if (!mysql_pconnect("mysql database", "userid", "password")) {
        print "Could not connect to database server - please try again later";
    }
    if (!mysql_select_db("mysql database")) {
        print "Could not connect to database - please try again later";
    }
}

?>

[cahva]

Use these functions in your code to connect.

<?php
// dbinit.php
function open_db ($table) {
	global $conn;
	$conn= mysql_connect("localhost","user","passwd");
	mysql_select_db($table,$conn);
}


function close_db () {
	global $conn;
	mysql_close($conn);
}
?>

In every page where you need to use mysql, include dbinit.php and open connection:

<?php
include('dbinit.php');
open_db('table');
?>

To close connection, put close_db(); at the end of every page you have used mysql.