Whats wrong with this code?

fairyfan · June 2, 2003

I keep getting a fatal error :

Fatal error: Call to undefined function: connect_to_db() in /home/user/public_html/script/scripts.php on line 96

Starting at line 96 this is the code:

$db = connect_to_db();

if($db == 0) {

echo \"The script tried to connect to the MySQL database, however it was impossible to establish connection.n\";

echo \"There are two cases why this happened. The first is that the MySQL server is not open. The second\";

echo \" case is that you haven\'t set ad_config.php variables correctly. Please, check the variables again.n\";

echo \"<A HREF=\"\",$PHP_SELF,\"?step2\">Re-check MySQL connection.</A>n\";

echo \"<A HREF=\"\",$PHP_SELF,\"\">Go back to step 1.</A>n\";

}

So if its not connect_to_db() what would it be?

shivabharat · June 2, 2003

I guess connect_to_db is a function u wrote . Include the script if u have written the function in seperate file.

fairyfan · June 2, 2003

First Shiv <bowing to your greatness> :lol:

Thanks! I am going nuts. I havent been able to connect to a DB for 2 months!. I dont think its me either???

I didnt write that function my sorry webhost \"support\" dude wrote it. The fact that he wrote it there and no where else would so not surprise me. Here goes my best possible explanation of what I have;

script consists of:

ad.php

ad_admin.php

ad_installer.php

ad_click.php

ad_config.php

ad_client.php

ad_installer.php is where the error is occurring when trying to connect because it doesnt understand the function my \"host support\" put in there.

Here is a link to the \"original\" script (*NOTE - all the changes to the script were done via my \"host support person\". They first said the script was trying to connect to the wrong .sock. Now this)

http://www.ravencrypt.com/scripts/scripts.html

Scroll down to the Banner rotator script.

Ps. If you know of another good banner script that allows client to view stats on thier banner and wont be a huge pain in my arse like this one, please send me there cuz this is rediculous. Though I think its my host not the script since this is the 5th banner script I have tried and failed :evil:

shivabharat · June 2, 2003

I will surely have a look at the script and let u know what exactly u have to do.

I am sure there must be lots of ppl must have done that and I am sure they will help u.

fairyfan · June 2, 2003

Here is the code from ad_config.php / ad_installer.php

ad_config.php

<?php

/* ******************************************** */

/* ******** JMK Advertisement Rotator ********* */

/* ******************************************** */

/* Released under the GPL license: */

/* http://www.gnu.org/copyleft/gpl.html */

/* ad_config.php: Configuration file */

// MySQL Information

$hostname = \"localhost\";

$username = \"xxxxxx_xxxxxx\";

$password = \"xxxxxx\";

$database = \"xxxxxx_jmkads\";

$banner_table = \"jmk_ads_xxxxxx\"; // Table where all info will be stored.

$client_table = \"jmk_ads_xxxxxx\"; // The owners of banners and their login info

$pos_table = \"jmk_ads_xxxxxx\"; // Small table with positions for

// circular rotation

// Administration password

$admin_password = \"xxxxxxxxxxxxxx\";

// The path where the JMK Advertisement Rotator images are found. Remember

// the trailing slash at the end.

$img_dir = \"images/\";

// Location of ad_click.php in the web

$redir = \"http://www.mysite.com/jmkads/ad_click.php\";

// Default banner, to show if error occurs (e.g. no banners in database)

// This could be sth saying \"Advertise on our site\" for example

$default_banner = \"http://www.mysite.com/banner.gif\";

$default_url = \"http://www.mysite.com/\";

// Webmaster, in case of error:

$webmaster = \"webmaster@mysite.com\";

// Redir site in case of error:

$redir_site = \"http://www.mysite.com/\";

// Message to put under advertisement. leave blank for no message

$message = \"\";

/* ##########################################################

* The config section has ended. Common functions used by all

* programs follow. You don\'t need to change them

* ########################################################## */

$dbh=mysql_connect(\"localhost\",\"xxxxxx_xxxxxx\",\"xxxxxxxx\") or die

(\'cannot connect to the database because: \'.mysql_error());

mysql_select_db (\"xxxxxxx_jmkads\");

?>

ad_installer.php

<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 3.2//EN\">

<?php require \"ad_config.php\" ?>

<HTML>

<HEAD>

<TITLE>JMK Advertisement Rotator Installation</TITLE>

</HEAD>

<BODY BACKGROUND=\"<? echo $img_dir; ?>background.gif\" TEXT=\"#000000\" LINK=\"#007bff\" VLINK=\"#007bff\" ALINK=\"#007bff\"

TOPMARGIN=\"0\" LEFTMARGIN=\"0\" MARGINHEIGHT=\"0\" MARGINWIDTH=\"0\">

<IMG SRC=\"<? echo $img_dir; ?>logo.gif\" ALT=\"JMK Advertisement Rotator\">

<TR>

<TD WIDTH=\"10\"><IMG SRC=\"<? echo $img_dir; ?>empty.gif\" HEIGHT=\"20\" WIDTH=\"1\"></TD>

<TD WIDTH=\"140\" COLSPAN=\"2\"><IMG SRC=\"<? echo $img_dir; ?>empty.gif\"></TD>

<H1>Installation</H1>

</TD>

<TR>

<TD WIDTH=\"5\"><IMG SRC=\"<? echo $img_dir; ?>empty.gif\"></TD>

<?php if($QUERY_STRING == \"\"): ?>

First step:

Configuring the script\'s settings and preferences

</TD>

<TD WIDTH=\"20\"><IMG SRC=\"<? echo $img_dir; ?>empty.gif\"></TD>

Thank you for trying out JMK Advertisement Rotator. This script will guide you through the installation

procedure. Most of the job is done by the script itself, so you need not worry. I\'ve made this script

easy enough so that you only need to know a few basic PHP stuff and nothing more.

The first thing you need to do is change the variable values of ad_config.php. This file

contains all the variables that are nessecary to be set for the script to function correctly. These

variables concern the communication with the MySQL database, as well as how the script will display

the banners. So, let\'s have a look at the variables and their usage.

ad_config.php variables:

$hostname, $username, $password, $database:

These variables are used when connecting with the MySQL database server. The $username and

$password variables are your username and password for the MySQL database (and they don\'t

have to do with your login info). If you haven\'t set a password for MySQL, you can set $password to \"\".

You don\'t have to worry about passwords stored in the database, since they are automaticly encrypted.

$hostname is usually \"localhost\" and in case you don\'t know what its value should be, just leave

it \"localhost\", it will usually work. The database in which $database points must already exist.

$banner_table, $client_table, $pos_table:

These are the names of the tables used by JMK Advertisement Rotator. Unless the default tables already

exist (most unlikely), you can change their name. Under normal circumstances, you can just leave these

variables as they are.

$admin_password:

This is the password you need to enter in order to gain access to the administration menu.

$img_dir:

The path where the script\'s images are found. Remember to add the trailing slash at the end. Example: \"images/\".

$redir:

This variable should always point to the URL of ad_click.php. It is important to notice that we need

the URL (i.e. its place on the web), not its local path.

$default_banner, $default_url:

This should point to a banner that would appear in case an error occurs. This way, your site won\'t

look ugly with an error message, instead a banner (which could say, for example, \"Advertise in our site\")

appears. The URL is where the client goes when he clicks the default banner.

$webmaster:

This should be changed to your e-mail adress. In case of an error, an e-mail will be sent to you.

$redir_site:

In case there is an error in ad_click.php (i.e. when the user clicks the banner), this site appears.

$message:

Unless blank, this message appears just below the ad banner.

You need not change anything that follows in ad_config.php. If you\'ve done these

changes, you can process with installation by clicking the link below, and the script

will check the validity of the first pack of variables that deal with the database.

<A HREF=\"<?php echo $PHP_SELF; ?>?step2\">Done with ad_config.php, go to step 2</A>.

</TD></TR>

<?php elseif($QUERY_STRING == \"step2\"): ?>

Second step:

Checking validity of data and creating tables.

</TD>

<TD WIDTH=\"20\"><IMG SRC=\"<? echo $img_dir; ?>empty.gif\"></TD>

<?php

// First, let\'s test if the settings are OK and communication with MySQL is achievable.

$db = connect_to_db(); <--------im sure this is the problem

if($db == 0) {

echo \"The script tried to connect to the MySQL database, however it was impossible to establish connection.n\";

echo \"There are two cases why this happened. The first is that the MySQL server is not open. The second\";

echo \" case is that you haven\'t set ad_config.php variables correctly. Please, check the variables again.n\";

echo \"<A HREF=\"\",$PHP_SELF,\"?step2\">Re-check MySQL connection.</A>n\";

echo \"<A HREF=\"\",$PHP_SELF,\"\">Go back to step 1.</A>n\";

}

else {

echo \"The script tried to connect to the MySQL database and the attemp was successful!n\";

echo \"You can now head to the final step of the installation, which will create the nessecary tables in MySQL database.n\";

echo \"<A HREF=\"\",$PHP_SELF,\"?step3\">Process with table creation and finish.</A>n\";

}

?>

</TD></TR>

<?php elseif($QUERY_STRING == \"step3\"): ?>

Final step:

Creation of tables.

</TD>

<TD WIDTH=\"20\"><IMG SRC=\"<? echo $img_dir; ?>empty.gif\"></TD>

<?php

$db = connect_to_db();

$query = mysql_query(\"CREATE TABLE $client_table (id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(80), email VARCHAR(80), login CHAR(10), passwd CHAR(16), info TEXT);\");

if(!$query) {

echo \"Unable to create $client_table table. Table may already exist. Installation has stopped.n\";

echo \"</TD></TR></TABLE></BODY></HTML>n\";

exit;

}

$query = mysql_query(\"CREATE TABLE $banner_table (id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), status ENUM(\'ok\', \'expired\'), title VARCHAR(80), url VARCHAR(160) NOT NULL, image_url VARCHAR(160) NOT NULL, alt_text TEXT, banner_group VARCHAR(80), client_id INT NOT NULL, width CHAR(5), height CHAR(5), expiration_date DATE, expiration_displays INT UNSIGNED, expiration_clicks INT UNSIGNED, displays_life BIGINT UNSIGNED NOT NULL, displays_day INT UNSIGNED NOT NULL, clicks_life BIGINT UNSIGNED NOT NULL, clicks_day INT UNSIGNED NOT NULL);\");

if(!$query) {

echo \"Unable to create $banner_table table. Table may already exist. Installation has stopped.n\";

echo \"</TD></TR></TABLE></BODY></HTML>n\";

exit;

}

$query = mysql_query(\"CREATE TABLE $pos_table (title CHAR(80) NOT NULL DEFAULT \'\', PRIMARY KEY(title), position INT NOT NULL DEFAULT 0);\");

if(!$query) {

echo \"Unable to create $pos_table table. Table may already exist. Installation has stopped.n\";

echo \"</TD></TR></TABLE></BODY></HTML>n\";

exit;

}

?>

The installation has been successfully finished!

You can now start the administration of the banner system using <A HREF=\"ad_admin.php\">ad_admin.php</A> file. The login

password was set in variable $admin_password in ad_config.php. You can also delete this file, ad_installer.php, if

you like, but it cannot create any damage to you or your banner database, so you need not worry.

Thank you for using JMK Advertisement Rotator and hope you are satisfied. Enjoy!

</TD></TR>

<?php endif; ?>

</TABLE>

</BODY>

</HTML>

Sorry for the post being so long just wanted you to see the original code and the code I have.

Thanks so much, I am trying like heck to get at least one database to work in hopes I can get some other programs that require it to work.

Sign In

Whats wrong with this code?

Recommended Posts

fairyfan

Link to comment

Share on other sites

shivabharat

Link to comment

Share on other sites

fairyfan

Link to comment

Share on other sites

shivabharat

Link to comment

Share on other sites

fairyfan

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information