Hello friends,
I’m new to php programming. I know less than nothing. I designed html page in which i want contact form which will be used to send the information to the given email ID.
I done the php script part by the help of material and online tutorials. but when i upload the files to the server, I’m getting error like this,
Access denied for user ‘root’@’Localhost’ to database ‘form’
when i asked this to my hosting provider, they asked me to provide my database connecting settings in my mysql connection string that i’m using in my code. But quite frankly i don’t know what that does mean.
I’m really in a tight position to upload the file to the server.
Here are my codes. Can anyone really help me to how to fix this issue?
config.php
[code=php]<?php
$host = ‘Localhost’;
$user = ‘root’;
$pass = ”;
$dbname = ‘form’;
$conn = mysql_connect($host,$user,$pass) or die(mysql_error());
$selectdb = mysql_select_db($dbname,$conn) or die(mysql_error());
?>
function1.php
[code=php]<?php
require_once ‘config.php’;
session_start();
if(isset($_REQUEST[‘process’]))
{
$name=$_REQUEST[‘name’];
$email=$_REQUEST[’email’];
$mobile=$_REQUEST[‘mobile’];
$mess=$_REQUEST[‘message’];
$to=”[email protected]”;
$to=”[email protected]”;
$subject = “Contact Us”;
$message=”<html><head><title></title></head><body><center></center><br /><table border=’0′ cellpadding=’5′ cellspacing=’5′ align=’center’><tr><td> Name: </td><td>”.$name.”</td></tr> <tr><td> Email: </td><td>”.$email.”</td></tr> <tr><td> Mobile : </td><td>”.$mobile.”</td></tr> <tr><td> Message : </td><td>”.$mess.”</td></tr></table></body></html>”;
$headers = “MIME-Version: 1.0” . “rn”;
$headers .= “Content-type: text/html; charset=iso-8859-1” . “rn”;
$headers .= “From: “.’calltuktuk.com’.” <from_address@your_domain.com>rn”;
$headers .= “Reply-To: “.’calltuktuk.com’.” <to_address@your_domain.com>rn”;
@mail($to, $subject, $message, $headers);
header(‘Location: index.php?true’);exit;
}
/*Contact form*/
function myform($vars)
{
$name= $vars[‘name’];
$email=$vars[’email’];
$mobile = $vars[‘mobile’];
$message = $vars[‘message’];
$selqry = “SELECT * FROM contact_form”;
$rsqry = mysql_query($selqry)or die(mysql_error()) ;
$cnt = mysql_num_rows($rsqry);
$insert = “INSERT INTO contact_form(name,email,mobile,message) VALUES(‘$name’,’$email’,’$mobile’,’$message’)”;
$rscourse=mysql_query($insert) or die (mysql_error());
$lastid = mysql_insert_id();
header(‘Location:index.php?true’);exit;
}
?>
Thanks in advance.
Regards,
Sam