MySQL Connection

iceraider

I need to keep my SQL connection running through my whole, script. I need the connection only on one line. How come when my code is like this it works

$db = mysql_connect("localhost", "webew16", "andyandy1130");
mysql_select_db("webewebin_com",$db);

$result = mysql_query("SELECT * FROM links WHERE status='active' ORDER BY id DESC",$db);

when its like this it doesnt!!!

$db = mysql_connect("localhost", "webew16", "andyandy1130");
mysql_select_db("webewebin_com",$db);

function active() {
 $result = mysql_query("SELECT * FROM links WHERE status='active' ORDER BY id DESC",$db);
}

How can I make it work both ways? I need the SQL to go throguh functions so I don't have to laod it in every one.

Phantazm

Couple of questions here.. some issues I've personally ran into.. maybe they'll help.

1) Is the function in the same script, or is it in an included script (ie.. a global function script that contains all the functions you define).

2) How are you calling the function... exactly.

3) How are you returning from the function...

The following exapmle should work (I actually use it in several script for clients of mine)

// global.php
<?php
  require_once("config.php");
  require_once("special.php");
  require_once("security.php");

  mysql_connect("$db_host","$db_user","$db_passwd") or die("Fatal Error: Unable to connect to mySQL!");
  mysql_select_db("$db_name") or die("Fatal Error: Unable to open \"$db_name\" database!");

  function get_config($config)
  {
    $query = "SELECT Config FROM site_config WHERE ConfigName='$config'";
    $result = mysql_query($query) or die("Fatal Error: mySQL Query \"$query\"Failed");
    $data = mysql_fetch_array($result);
    return($data['Config']);
  }

?>
// end global.php

// config.php
<?php
  $db_host		= "localhost";			// mySQL Host System
  $db_user		= "dbusername";			// mySQL Login Name
  $db_passwd		= "dbpassword";			// mySQL Login Password
  $db_name		= "EBAMain";			// mySQL Database Name
  $template_table	= "template";			// mySQL Templates Table
  $default_template	= "MainIndex";			// Default Page To Server From index.php

?>
// end config.php

// index.php
<?php
        require_once("../EBAMain.Includes/global.php");
        $home_url = get_config('Home_URL');
        header("Location: ".get_config('Home_URL'));
?>
//end index.php

In this example, my database would have a config table, with the fields Config and ConfigName (where ConfigName=Home_URL and Config=http://www.myhome.com)

The index.php, when loaded in the brosser, would call the function get_config and redirect the visitor to the home_url...

Get it? 🙂 Hope this helps some....

Damien_Buttler

the code function active() only defines the fucntion, it does not run it. To run it you need to call it seperately. add the line action(); where you want you function to run and it will.

Weedpacket

Also, if you don't declare it global inside the function defintion, the variable $db that is inside the function won't be the same variable as the one outside the function - it will be empty, instead.

netmastan

This file save as connect.php

<?

$dbi;
connectToDB();

function connectToDB() {
$host="localhost";
$user="xxx";
$password="xx";
$db="xx";

global $dbi;

$dbi=mysql_connect($host,$user,$password);
if (! $dbi )
   die("Couldn't connect to MYSQL");
mysql_select_db($db,$dbi)
or die("Couldn't Open $db: ".mysql_error());
}
?>

This file save as test.php..this is example how to use $dbi in another file or function. When u want to connect to database just use global $dbi; MaKe sure u close connection once u finish query.

<?
 include("connect.php");

 global $dbi;

 $result = mysql_query("select field1,field2 from tablename ", $dbi);
 list($field1, field2) = mysql_fetch_row($result);

echo "$field1,$field2";


mysql_free_result($result);
mysql_close($dbi);

 ?>

i hope you got some idea...