Can't connect to database inside function
Posted: Sun Dec 04, 2005 11:24 pm
It connects fine on the load. But when I click submit, it fails. Any way to fix this???
Code: Select all
/****************************************
modules/League/includes/league_functions.php
****************************************/
function connection($sql_db, $sql_username, $sql_pw){
$hostname = "localhost";
$database = "$sql_db";
$username = "$sql_username";
$password = "$sql_pw";
$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
mysql_select_db("$database",$dbh)
or die("Error: Could not connect to database: $database ");
}Code: Select all
<?
/****************************************
create_clan.php
****************************************/
<?
include("modules/League/includes/league_functions.php");
$user_id = $cookie[0];
$player_id = $_GET[pid];
$current_ladder = $_GET[lid];
$ladders = sql_query("SELECT ladder_id, ladder_name, ladder_directory, sql_db, sql_username, sql_pw, sql_prefix, pri_color, sec_color
FROM ".$prefix."_league_ladders WHERE ladder_id = $current_ladder");
list($ladder_id, $ladder_name, $ladder_directory, $sql_db, $sql_username, $sql_pw, $sql_prefix, $pri_color, $sec_color) = sql_fetch_row($ladders);
connection($sql_db, $sql_username, $sql_pw);
function show_form($clan_name="",$clan_tag="", $clan_email="", $clan_avatar="", $clan_website="", $clan_aim="", $clan_msnm="",
$clan_icq="", $clan_xfire="", $clan_yim="", $clan_challenge="", $clan_viewemail="") {
?>
<form action="modules.php?name=League&file=create_clan" method="post">
Clan Name:
<input type=text name=clan_name value="<?echo $clan_name?>"><br>
Clan Tag:
<input type=text name=clan_tag value="<?echo $clan_tag?>"><br>
Clan Email:
<input type=text name=clan_email value="<?echo $clan_email?>"><br>
AOL:
<input type=text name=clan_aim value="<?echo $clan_aim?>"><br>
MSN:
<input type=text name=clan_msnm value="<?echo $clan_msnm?>"><br>
ICQ:
<input type=text name=clan_icq value="<?echo $clan_icq?>"><br>
YAHOO:
<input type=text name=clan_yim value="<?echo $clan_yim?>"><br>
X-FIRE:
<input type=text name=clan_xfire value="<?echo $clan_xfire?>"><br>
Recieve Challenges:
<input type=radio name=clan_challenge value=1 <?php if($_POST['clan_challenge'] == 1); ?>>Yes
<input type=radio name=clan_challenge value=0<?php if($_POST['clan_challenge'] == 0); ?> >No
Other Clans View Email?:<br>
<input type=radio name=clan_viewemail value=1 <?php if($_POST['clan_viewemail'] == 1); ?>>Yes
<input type=radio name=clan_viewemail value=0<?php if($_POST['clan_viewemail'] == 0); ?> >No
<input type=submit>
</form>
<? }
if(!isset($clan_name)) {
show_form();
}
else {
if(empty($clan_name) or empty($clan_tag) or empty($clan_email)){
echo "Error 01: You did not fill in all required fields, please try again<p>";
show_form($clan_name,$clan_tag, $clan_email, $clan_avatar, $clan_website, $clan_aim, $clan_msnm,
$clan_icq, $clan_xfire, $clan_yim, $clan_challenge, $clan_viewemail);
}
else{
$sql_clans = 'SELECT clan_id, clan_tag AS clantag, clan_name AS clanname FROM `'.$sql_prefix.'_clans`';
$result_clans = mysql_query($sql_clans) or die('SQL ['.$sql_clans.'] caused: '. mysql_error());
$clans = array();
while ($row = mysql_fetch_assoc($result_clans)) {
$clans[] = $row['clan_id'];
}
$num_clans = count($clans);
for ($x = 0; $x <= $num_clans; $x ++) {
if ($clan_name == $clanname){
echo "Error 02: Clan Name already exists. Please change it.";
die();
}else if ($clan_tag == $clantag){
echo "Error 03: Clan Tag already exists. Please change it.";
die();
}else
$create_clan = mysql_query("INSERT INTO `".sql_prefix."_clans` ( //fields )
VALUES ( //values);");
echo "Clan was successfully created!";
}
}
}
?>