function giving eror

[$php_mysql$]

hey guys im trying to clean my strings with this function

 

///////////////////////////////////Prevents SQL injection
    function clean($str) {
		$str = @trim($str);
		if(get_magic_quotes_gpc()) {
		$str = stripslashes($str);
		/*$str = htmlspecialchars($str);*/
	}
	return mysql_real_escape_string($str);		
    }

 

my script is connected to database and inserts data in field too but using the clean function im getting this error

 

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established

[$php_mysql$]

i get the error while submiting the form

[QuickOldCar]

Are you connected to a database before using this function?

[$php_mysql$]

yes see this is my include page

 

<?php

session_start();

error_reporting(E_ALL & ~E_NOTICE);

include  'config.php';

        include  'functions/dbfunctions.inc.php';

        include  'functions/gnrlfunctions.inc.php';

?>

[phpmady]

Hi,

 

Your code is not connected with db, Please check it, or post your include script

 

 

thanks

[$php_mysql$]

here is my include page

 

<?php
session_start();
error_reporting(E_ALL & ~E_NOTICE);	
include  'config.php';
    include  'functions/db_functions.inc.php';
    include  'functions/gn_functions.inc.php';
?>

 

my config page

 

<?php
    // Database information
    $host   = 'localhost';
    $user   = 'root';
    $password   = 'demo';
    $database   ='abcd';

?>

 

my db_functions.inc.php

 

<?php
//////////////////////database conntction////////////////
    function db_connect() {
       global $host;
       global $user;
       global $password;
       global $database;
       
        if(!$conn = mysql_connect($host, $user, $password)) {
            die("Could't connect to database server.....".mysql_error());
        } else {
            mysql_select_db($database, $conn) or die(mysql_error());
            return $conn;
        }
    }
/////////////////////////////////////SQL Execution      
    function executeSql($sql){
        $conn = db_connect();          
        $result = mysql_query($sql, $conn)
                      or die(mysql_error($conn));
        return $result;       
    }

?>

 

[phpmady]

hi,

 

It seems u are missing the function call?

 

Thanks

[$php_mysql$]

im sorry i didn get u mate, where am i missing what?

[$php_mysql$]

any help in here?

[spiderwell]

A MySQL connection is required before using mysql_real_escape_string() otherwise an error of level E_WARNING is generated, and FALSE is returned.

 

from here: http://php.net/manual/en/function.mysql-real-escape-string.php

 

this is probably why you are getting an error

[$php_mysql$]

but if you look at my include page i put first config the login and tables info, then i put db connection function and after that i included general functions and that is where the mysql_real_escape_string is so dont you think i have already connected to db?

[Alex]

As far as I can see, you're never calling db_connect().

[$php_mysql$]

oops :-) it tool me a whole day and i didn realize i wasnt even calling the function. thanks guys and Alex thanks for pointing me the right way.