[SOLVED] Urgent helpppppppppppp.

whizzykid · May 4, 2009

Hi all,

I designed a database on dreamweaver,i uploaded it on my server for my website i created a form but any time i click on it it shows no database selected,I have tried to edit it,it still shows no database selected when i click d form,

this is the code pls help what am i nt doing right?

<?php

# FileName="Connections"

# Type="MYSQL"

# HTTP="true"

$hostname_inteecom_ellen = "localhost";

$database_inteecom_ellen = "inteecom_ellen";

$username_inteecom_ellen = "inteecom_lara";

$password_inteecom_ellen = "adebimpe";

$inteecom_ellen = mysql_pconnect($hostname_inteecom_ellen, $username_inteecom_ellen, $password_inteecom_ellen) or trigger_error(mysql_error(),E_USER_ERROR);

?>

this is the second one

<?php

# FileName="Connections"

# Type="MYSQL"

# HTTP="true"

$hostname_inteecom_ellen = "localhost";

$database_inteecom_ellen = "inteecom_ellen";

$username_inteecom_ellen = "inteecom_lara";

$password_inteecom_ellen = "adebimpe";

$inteecom_ellen = mysql_pconnect($hostname_inteecom_ellen, $username_inteecom_ellen, $password_inteecom_ellen) or trigger_error(mysql_error(),E_USER_ERROR);

?>

the form itself.

<?php require_once(Connections/ellen.php'); ?>

<?php require_once(Connections/customer.php'); ?>

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

if (PHP_VERSION < 6) {

$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {

case "text":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "long":

case "int":

$theValue = ($theValue != "") ? intval($theValue) : "NULL";

break;

case "double":

$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

break;

case "date":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "defined":

$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

break;

}

return $theValue;

}

$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {

$insertSQL = sprintf("INSERT INTO `Call Back form` (Firstname, LastName, `Company Name`, `Phone Number`) VALUES (%s, %s, %s, %s)",

GetSQLValueString($_POST['Firstname'], "text"),

GetSQLValueString($_POST['LastName'], "text"),

GetSQLValueString($_POST['Company_Name'], "text"),

GetSQLValueString($_POST['Phone_Number'], "int"));

mysql_select_db($database_inteecom_ellen, $inteecom_ellen);

$Result1 = mysql_query($insertSQL, $inteecom_ellen) or die(mysql_error());

$insertGoTo = "public_html/index.html";

if (isset($_SERVER['QUERY_STRING'])) {

$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";

$insertGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $insertGoTo));

}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {

$insertSQL = sprintf("INSERT INTO `Call Back form` (Firstname, LastName, `Company Name`, `Phone Number`, `Brief Comments`) VALUES (%s, %s, %s, %s, %s)",

GetSQLValueString($_POST['Firstname'], "text"),

GetSQLValueString($_POST['LastName'], "text"),

GetSQLValueString($_POST['Company_Name'], "text"),

GetSQLValueString($_POST['Phone_Number'], "int"),

GetSQLValueString($_POST['Brief_Comments'], "text"));

mysql_select_db($database_inteecom_ellen, $inteecom_ellen);

$Result1 = mysql_query($insertSQL, $inteecom_ellen) or die(mysql_error());

$insertGoTo = "public_html/index.html";

if (isset($_SERVER['QUERY_STRING'])) {

$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";

$insertGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $insertGoTo));

}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form5")) {

$insertSQL = sprintf("INSERT INTO `Call Back form` (Firstname, LastName, `Company Name`, `Phone Number`, Email, `Brief Comments`) VALUES (%s, %s, %s, %s, %s, %s)",

GetSQLValueString($_POST['Firstname'], "text"),

GetSQLValueString($_POST['LastName'], "text"),

GetSQLValueString($_POST['Company_Name'], "text"),

GetSQLValueString($_POST['Phone_Number'], "int"),

GetSQLValueString($_POST['Email'], "text"),

GetSQLValueString($_POST['Brief_Comments'], "text"));

mysql_select_db($database_inteecom_ellen, $inteecom_ellen);

$Result1 = mysql_query($insertSQL, $database_inteecom_ellen) or die(mysql_error());

$insertGoTo = "file:///C|/DOCUME~1/AM/LOCALS~1/Temp/index.html";

if (isset($_SERVER['QUERY_STRING'])) {

$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";

$insertGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $insertGoTo));

}

mysql_select_db($$database_inteecom_ellen, $inteecom_ellen);

$query_Recordset1 = "SELECT * FROM `Call Back form`";

$Recordset1 = mysql_query($query_Recordset1, $inteecom_ellen) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

$totalRows_Recordset1 = mysql_num_rows($Recordset1);

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

body {

background-color: #E8E8E8;

}

#apDiv1 {

position:absolute;

left:314px;

top:28px;

width:413px;

height:101px;

z-index:1;

}

#apDiv2 {

position:absolute;

left:363px;

top:73px;

width:280px;

height:26px;

z-index:1;

}

#apDiv3 {

position:absolute;

left:356px;

top:145px;

width:341px;

height:37px;

z-index:2;

}

#apDiv4 {

position:absolute;

left:355px;

top:195px;

width:345px;

height:35px;

z-index:3;

}

#apDiv5 {

position:absolute;

left:366px;

top:263px;

width:354px;

height:124px;

z-index:4;

}

#apDiv6 {

position:absolute;

left:115px;

top:4px;

width:346px;

height:11px;

z-index:5;

}

#apDiv7 {

position:absolute;

left:298px;

top:182px;

width:437px;

height:24px;

z-index:1;

}

#apDiv8 {

position:absolute;

left:316px;

top:91px;

width:406px;

height:24px;

z-index:2;

}

#apDiv9 {

position:absolute;

left:308px;

top:135px;

width:428px;

height:21px;

z-index:3;

}

#apDiv10 {

position:absolute;

left:315px;

top:30px;

width:420px;

height:36px;

z-index:4;

}

-->

</style>

<!--

function MM_validateForm() { //v4.0

if (document.getElementById){

var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;

for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=document.getElementById(args);

if (val) { nm=val.name; if ((val=val.value)!="") {

if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');

if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';

} else if (test!='R') { num = parseFloat(val);

if (isNaN(val)) errors+='- '+nm+' must contain a number.\n';

if (test.indexOf('inRange') != -1) { p=test.indexOf(':');

min=test.substring(8,p); max=test.substring(p+1);

if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';

} } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; }

} if (errors) alert('The following error(s) occurred:\n'+errors);

document.MM_returnValue = (errors == '');

} }

//-->

</script>

</head>

<body>

<div id="apDiv7">

<form id="form2" name="form2" method="post" action="">

Which Department do you need assistant with?

<select name="Which Department do you need assistant with?" size="1" id="Which Department do you need assistant with?">

<option>Customer Support</option>

<option>Accounts</option>

<option>General</option>

<option>Sales and Marketing</option>

</select>

</form>

</div>

<div id="apDiv8">

<form id="form3" name="form3" method="post" action="">

<input type="radio" name="radio" id="Mr" value="Mr" />

Mr

<input type="radio" name="radio" id="Mrs" value="Mrs" />

Mrs

<input type="radio" name="radio" id="Ms" value="Ms" />

Ms

<input type="radio" name="radio" id="Others" value="Others" />

others

</form>

</div>

<div id="apDiv9">

<form id="form4" name="form4" method="post" action="">

Best time to call you

<select name="Best time to call you" size="1" id="Best time to call you">

<option>Now</option>

<option>Later</option>

<option>Morning</option>

<option>Afternoon</option>

<option>Evening</option>

</select>

</form>

</div>

<div id="apDiv10">

<legend>Call us Back Form.</legend>

<legend><strong> Ask for one of our advisors to call you back</strong></legend>

</div>

<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1" onsubmit="MM_validateForm('Firstname','','R');MM_validateForm('Brief_Comments','','R');MM_validateForm('Phone_Number','','RisNum');MM_validateForm('Phone_Number','','RisNum');return document.MM_returnValue">

<p> </p>

<input type="hidden" name="MM_insert" value="form1" />

</form>

<form action="<?php echo $editFormAction; ?>" method="post" name="form5" id="form5">

<table align="center">

<tr valign="baseline">

<td nowrap="nowrap" align="right">Firstname:</td>

<td><input type="text" name="Firstname" value="" size="32" /></td>

</tr>

<tr valign="baseline">

<td nowrap="nowrap" align="right">LastName:</td>

<td><input type="text" name="LastName" value="" size="32" /></td>

</tr>

<tr valign="baseline">

<td nowrap="nowrap" align="right">Company Name:</td>

<td><input type="text" name="Company_Name" value="" size="32" /></td>

</tr>

<tr valign="baseline">

<td nowrap="nowrap" align="right">Phone Number:</td>

<td><input type="text" name="Phone_Number" value="" size="32" /></td>

</tr>

<tr valign="baseline">

<td nowrap="nowrap" align="right">Email:</td>

<td><input type="text" name="Email" value="" size="32" /></td>

</tr>

<tr valign="baseline">

<td nowrap="nowrap" align="right">Brief Comments:</td>

<td><input type="text" name="Brief_Comments" value="" size="32" /></td>

</tr>

<tr valign="baseline">

<td nowrap="nowrap" align="right"> </td>

<td><input type="submit" value="Insert record" /></td>

</tr>

</table>

<input type="hidden" name="MM_insert" value="form5" />

</form>

<p> </p>

</body>

</html>

<?php

mysql_free_result($Recordset1);

?>

What is the problem cause any time i clcik on the form it shows no database selected. ???

Ken2k7 · May 4, 2009

Read rules #13 and #14 - http://www.phpfreaks.com/page/forum-rules

Try mysql_connect instead of mysql_pconnect.

whizzykid · May 4, 2009

Thank you i will try that now.

mrMarcus · May 4, 2009

and please only post relevant code .. posting all your CSS and HTML only makes for more time spent on looking through unneeded code.

whizzykid · May 4, 2009

Oh my gosh still doesnt work.

Ken2k7 · May 4, 2009

After your mysql_connect(), use mysql_select_db to select a database on the server. You can run the SQL "use database_name" as well if you want.

whizzykid · May 4, 2009

After your mysql_connect(), use mysql_select_db to select a database on the server. You can run the SQL "use database_name" as well if you want.

Hi thank you so much now it shows the form but when i click on submit it shows this error

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/inteecom/public_html/Call back form.php on line 87

and this is the line code on line 87

$Result1 = mysql_query($insertSQL, $database_inteecom_ellen) or die(mysql_error());

Ken2k7 · May 4, 2009

Take out $database_inteecom_ellen. Or replace it with $inteecom_ellen.

whizzykid · May 4, 2009

Hi thank you, just did but still shows the same thing.

Ken2k7 · May 4, 2009

Post your updated code. Remember rule #13.

premiso · May 4, 2009

mysql_select_db($$database_inteecom_ellen, $inteecom_ellen);

Notice the extra $ infront of database. Remove that.

That with the change that ken suggested should get you running.

whizzykid · May 4, 2009

$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {

$insertSQL = sprintf("INSERT INTO `Call Back form` (Firstname, LastName, `Company Name`, `Phone Number`) VALUES (%s, %s, %s, %s)",

GetSQLValueString($_POST['Firstname'], "text"),

GetSQLValueString($_POST['LastName'], "text"),

GetSQLValueString($_POST['Company_Name'], "text"),

GetSQLValueString($_POST['Phone_Number'], "int"));

mysql_select_db($database_inteecom_ellen, $inteecom_ellen);

$Result1 = mysql_query($insertSQL, $inteecom_ellen) or die(mysql_error());

$insertGoTo = "jpg.1";

if (isset($_SERVER['QUERY_STRING'])) {

$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";

$insertGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $insertGoTo));

}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {

$insertSQL = sprintf("INSERT INTO `Call Back form` (Firstname, LastName, `Company Name`, `Phone Number`, `Brief Comments`) VALUES (%s, %s, %s, %s, %s)",

GetSQLValueString($_POST['Firstname'], "text"),

GetSQLValueString($_POST['LastName'], "text"),

GetSQLValueString($_POST['Company_Name'], "text"),

GetSQLValueString($_POST['Phone_Number'], "int"),

GetSQLValueString($_POST['Brief_Comments'], "text"));

mysql_select_db($database_inteecom_ellen, $inteecom_ellen);

$Result1 = mysql_query($insertSQL, $inteecom_ellen) or die(mysql_error());

$insertGoTo = "jpg.1";

if (isset($_SERVER['QUERY_STRING'])) {

$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";

$insertGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $insertGoTo));

}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form5")) {

$insertSQL = sprintf("INSERT INTO `Call Back form` (Firstname, LastName, `Company Name`, `Phone Number`, Email, `Brief Comments`) VALUES (%s, %s, %s, %s, %s, %s)",

GetSQLValueString($_POST['Firstname'], "text"),

GetSQLValueString($_POST['LastName'], "text"),

GetSQLValueString($_POST['Company_Name'], "text"),

GetSQLValueString($_POST['Phone_Number'], "int"),

GetSQLValueString($_POST['Email'], "text"),

GetSQLValueString($_POST['Brief_Comments'], "text"));

mysql_select_db($database_inteecom_ellen, $inteecom_ellen);

$Result1 = mysql_query($insertSQL, $inteecom_ellen) or die(mysql_error());

$insertGoTo = "jpg.1";

if (isset($_SERVER['QUERY_STRING'])) {

$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";

$insertGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $insertGoTo));

}

mysql_select_db($database_inteecom_ellen, $inteecom_ellen);

$query_Recordset1 = "SELECT * FROM `Call Back form`";

$Recordset1 = mysql_query($query_Recordset1, $inteecom_ellen) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

$totalRows_Recordset1 = mysql_num_rows($Recordset1);

Thank you.

Ken2k7 · May 4, 2009

Read rule #13 - http://www.phpfreaks.com/page/forum-rules

Also, do you need further help? What's the problem this time?

whizzykid · May 4, 2009

Hi thank u i have resolved it.I have 2 files so i have editted them.

Ken2k7 · May 4, 2009

Oh cool! Mark this solved then and you're welcome.

whizzykid · May 4, 2009

Thanks sooooooooo much ken.

Sign In

[SOLVED] Urgent helpppppppppppp.

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information