a bit more php help

spudly1987 · August 16, 2013

Alright guys just a little more help,

below are the three pages i'm currently working with, some of it seems to be working but i'm having issues with the insert.php page, at the bottom is the results i'm seeing just need someone to guide me to resolve.

I am not getting any syntax errors at all, and all 3 files are under one folder

This is labeled index.html

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
 .labelclass{
  float: left;
  width: 150px;
 }
</style>
</head>
<body>
<img src="http://omgtechhelp.com/wp/wp-content/themes/OMGTech/images/logo7small.jpg" />
<center>
<h1><u>Notes For The Month Of August</u></h1>
</center>
<hr />
<form name="myform" action="insert.php" target="_blank" method="post">
<span class="labelclass" style="font-family:'Comic Sans MS', cursive">Customer Name: </span><input type="text" name="customername" /><br />
<span class="labelclass" style="font-family:'Comic Sans MS', cursive">Phone Number: </span><input type="tel" name="pnumber" /><br />
<span class="labelclass" style="font-family:'Comic Sans MS', cursive">E-Mail Address: </span><input type="text" name="eaddy" /><br />
<span class="labelclass" style="font-family:'Comic Sans MS', cursive">Issue: </span><input type="text" name="issue" /><br />
<span class="labelclass" style="font-family:'Comic Sans MS', cursive">Results: </span><input type="text" name="results" /><br />
<span class="labelclass" style="font-family:'Comic Sans MS', cursive">Date: </span><input type="date" name="Date" /><br />
<input type="submit" name="submit" value="submit" style="background-color:#F60" />
</body>
</html>
[/HTML]
[HR]
This is labeled db_tb.php
[PHP]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>


<body>
<?php  
$host = "localhost"; // Host name
$username = "root"; // Mysql username...please try and locate your mysql                 
                                  //configuration. i.e. your username and password. 
$password = ""; // Mysql password
// Connect to server
mysql_connect("$host", "$username", "$password") or die('ERROR: Cannot connect' .mysql_error());


//here is the newly added code..Selecting the database
mysql_query("USE mydb");


$sql = mysql_query( "CREATE TABLE UserNote (CustomerName varchar(255), Phone varchar(255), Email varchar(150), Issue varchar(255), Result varchar(255))");


if ($sql) {
echo "Database and table created succesffully";
}
else {
   die ('ERROR: Cannot connect'.mysql_error());
}
?>
</body>
</html>

This is labeled insert.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>


<center>
<h1><u>Notes For The Month Of August</u></h1>
</center>


<body>
<?php
//Protect against mysql_injection


$customername = mysql_real_escape_string(trim($_POST["customername"]));
$phonenumber = mysql_real_escape_string(trim($_POST["pnumber"]));
$email = mysql_real_escape_string(trim($_POST["eaddy"]));
$issue = mysql_real_escape_string(trim($_POST["issue"]));
$result = mysql_real_escape_string(trim($_POST["results"]));
$date = mysql_real_escape_string(trim($_POST["Date"]));


//Now check form input(Validating the form).
$errmsg_arr = array(); //Array to store validation errors
$check_Error = false; //Validation error flag


if (empty($customername)){
$errmsg_arr[]= '.Please Enter Your Name';
 $check_Error = true;
}
if (empty($phonenumber)){
$errmsg_arr[]= '.Please Enter Your Phone Number';
 $check_Error = true;
}
if (empty($email)){
$errmsg_arr[]= '.Please Enter Your Email';
 $check_Error = true;
}
if (empty($issue)){
$errmsg_arr[]= '.Please what is your issue';
 $check_Error = true;
}
if (empty($result)){
$errmsg_arr[]= '.Please what is your issue';
 $check_Error = true;
}
  if (empty($date)){
$errmsg_arr[]= '.Please what is your issue';
 $check_Error = true;
}
//Printing out any error message stored in the array.
if ($check_Error == true){
  echo '<h1>ERROR: </h1><h3>Please check below for Error Details</h3>';


  if( isset($errmsg_arr) && is_array($errmsg_arr) && count($errmsg_arr) > 0 ) {
      echo '<ul><font color="red">';
      foreach($errmsg_arr as $msg) {
        echo '<li><b>Error:    '.$msg.'</b></li><br />';
       }
         echo '</font></ul>';
   }
      //Please change the a href link to the name of your page.
      echo "<p><a href='http://localhost/site/practice5.html'>Go Back To Register</a></p>";
}
//After validating successfully
else {
/* Now we will write a query to insert user details into database */
$host = "localhost"; // Host name...change it to your configuration information.
$username = "root"; // Mysql username...change it to your configuration information.
$password = ""; // Mysql password...change it to your configuration information.
$db_name = "mydb"; // Database name...change it to your configuration information.
// Connect to server
mysql_connect("$host", "$username", "$password") or die('ERROR: Cannot connect' .mysql_error());
//connect to database
mysql_select_db("$db_name") or die ('ERROR: Cannot connect'.mysql_error());


$tbl_name = "UserNote";  //Mysql Table name...change it to your configuration information.


$sql="INSERT INTO $tbl_name (CustomerName, Phone, Email, Issue, Result, Date)
        VALUES($customername', '$phonenumber', '$email',  '$issue', '$result', '$date')";
}
if (  mysql_query($sql) ) //notice the "!" it means if the mysql_query($sql)  cannot be executed, then die error. ELSE execute the mysql_querry($sql) to
                                        //insert into table in the database.
{   
die('Error in Registration,: ' . mysql_error());
}
else
{    //Insert User into the database.
echo 'Customer Name: '. $customername . '<br />Phone Number: ' .$phonenumber . '<br />E-Mail Address: ' . $email;
echo '<br />Issue:'. $issue . '<br />Results:' . $result . '<br />' . 'Date:' .$date . '<br />' ;
}
?>
</body>
</html>

This is the error that i am running into

ERROR:

Please check below for Error Details

'; if( isset($errmsg_arr) && is_array($errmsg_arr) && count($errmsg_arr) > 0 ) { echo '

'; foreach($errmsg_arr as $msg) { echo '

Error: '.$msg.'

'; } echo '

'; } //Please change the a href link to the name of your page. echo "

Go Back To Register

"; } //After validating successfully else { /* Now we will write a query to insert user details into database */ $host = "localhost"; // Host name...change it to your configuration information. $username = "root"; // Mysql username...change it to your configuration information. $password = ""; // Mysql password...change it to your configuration information. $db_name = "mydb"; // Database name...change it to your configuration information. // Connect to server mysql_connect("$host", "$username", "$password") or die('ERROR: Cannot connect' .mysql_error()); //connect to database mysql_select_db("$db_name") or die ('ERROR: Cannot connect'.mysql_error()); $tbl_name = "UserNote"; //Mysql Table name...change it to your configuration information. $sql="INSERT INTO $tbl_name (CustomerName, Phone, Email, Issue, Result, Date) VALUES($customername', '$phonenumber', '$email', '$issue', '$result', '$date')"; } if ( mysql_query($sql) ) //notice the "!" it means if the mysql_query($sql) cannot be executed, then die error. ELSE execute the mysql_querry($sql) to //insert into table in the database. { die('Error in Registration,: ' . mysql_error()); } else { //Insert User into the database. echo 'Customer Name: '. $customername . '

Phone Number: ' .$phonenumber . '

E-Mail Address: ' . $email; echo '

Issue:'. $issue . '

Results:' . $result . '

' . 'Date:' .$date . '

' ; } ?>

PravinS · August 16, 2013

how are you executing your index.html page?

also you can not have PHP code in HTML page, check index.html page

cyberRobot · August 16, 2013

also you can not have PHP code in HTML page, check index.html page

HTML pages can be configured to run PHP.

spudly1987 · August 16, 2013

I am using xampp to run the codes, i open my html by going through to http://localhost/site/ and then click on the index.html

cyberRobot · August 16, 2013

It seems like a quote wasn't closed after

Please check below for Error Details

It seems fine in the code posted. Did you remove any code from insert.php before posting it here?

spudly1987 · August 16, 2013

Nope did not remove any coding what so ever i also have a 3rd file i'm working with labeled db_tb.php for my database which is created right, but for some reason the insert.php is the only causing issues.

cyberRobot · August 16, 2013

This may seem like a silly question, but did you post the same code as what you're actually using? Perhaps you could re-paste the code you are currently working with. Of course, you'll want to hide the database password like before.

Also, do you have it so all errors and warnings are being shown?

<?php
//REPORT ALL PHP ERRORS
error_reporting(E_ALL);
ini_set('display_errors', 1);
?>

cyberRobot · August 16, 2013

Sorry, part of the message was cut off. The rest is below.

Side note: mysql_real_escape_string() requires a database connection to be established before it's used. More information can be found here:

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

Edited August 16, 2013 by cyberRobot

spudly1987 · August 16, 2013

Below are listed all the files i am using

this is my index. html code

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
 .labelclass{
  float: left;
  width: 150px;
 }
</style>
</head>
<body>
<img src="http://omgtechhelp.com/wp/wp-content/themes/OMGTech/images/logo7small.jpg" />
<center>
<h1><u>Notes For The Month Of August</u></h1>
</center>
<hr />
<form name="myform" action="insert.php" target="_blank" method="post">
<span class="labelclass" style="font-family:'Comic Sans MS', cursive">Customer Name: </span><input type="text" name="customername" /><br />
<span class="labelclass" style="font-family:'Comic Sans MS', cursive">Phone Number: </span><input type="tel" name="pnumber" /><br />
<span class="labelclass" style="font-family:'Comic Sans MS', cursive">E-Mail Address: </span><input type="text" name="eaddy" /><br />
<span class="labelclass" style="font-family:'Comic Sans MS', cursive">Issue: </span><input type="text" name="issue" /><br />
<span class="labelclass" style="font-family:'Comic Sans MS', cursive">Results: </span><input type="text" name="results" /><br />
<span class="labelclass" style="font-family:'Comic Sans MS', cursive">Date: </span><input type="date" name="Date" /><br />
<input type="submit" name="submit" value="submit" style="background-color:#F60" />
</body>
</html>

this is my insert.php code

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<center>
<h1><u>Notes For The Month Of August</u></h1>
</center>

<body>
<?php
//Protect against mysql_injection
 
$customername = mysql_real_escape_string(trim($_POST["customername"]));
$phonenumber = mysql_real_escape_string(trim($_POST["pnumber"]));
$email = mysql_real_escape_string(trim($_POST["eaddy"]));
$issue = mysql_real_escape_string(trim($_POST["issue"]));
$result = mysql_real_escape_string(trim($_POST["results"]));
$date = mysql_real_escape_string(trim($_POST["Date"]));
 
//Now check form input(Validating the form).
$errmsg_arr = array(); //Array to store validation errors
$check_Error = false; //Validation error flag
 
if (empty($customername)){
$errmsg_arr[]= '.Please Enter Your Name';
 $check_Error = true;
}
if (empty($phonenumber)){
$errmsg_arr[]= '.Please Enter Your Phone Number';
 $check_Error = true;
}
if (empty($email)){
$errmsg_arr[]= '.Please Enter Your Email';
 $check_Error = true;
}
if (empty($issue)){
$errmsg_arr[]= '.Please what is your issue';
 $check_Error = true;
}
if (empty($result)){
$errmsg_arr[]= '.Please what is your issue';
 $check_Error = true;
}
  if (empty($date)){
$errmsg_arr[]= '.Please what is your issue';
 $check_Error = true;
}
//Printing out any error message stored in the array.
if ($check_Error == true){
  echo '<h1>ERROR: </h1><h3>Please check below for Error Details</h3>';
 
  if( isset($errmsg_arr) && is_array($errmsg_arr) && count($errmsg_arr) > 0 ) {
      echo '<ul><font color="red">';
      foreach($errmsg_arr as $msg) {
        echo '<li><b>Error:    '.$msg.'</b></li><br />';
       }
         echo '</font></ul>';
   }
      //Please change the a href link to the name of your page.
      echo "<p><a href='http://localhost/site/practice5.html'>Go Back To Register</a></p>";
}
//After validating successfully
else {
/* Now we will write a query to insert user details into database */
$host = "localhost"; // Host name...change it to your configuration information.
$username = "root"; // Mysql username...change it to your configuration information.
$password = ""; // Mysql password...change it to your configuration information.
$db_name = "mydb"; // Database name...change it to your configuration information.
// Connect to server
mysql_connect("$host", "$username", "$password") or die('ERROR: Cannot connect' .mysql_error());
//connect to database
mysql_select_db("$db_name") or die ('ERROR: Cannot connect'.mysql_error());
 
$tbl_name = "UserNote";  //Mysql Table name...change it to your configuration information.
 
$sql="INSERT INTO $tbl_name (CustomerName, Phone, Email, Issue, Result, Date)
        VALUES($customername', '$phonenumber', '$email',  '$issue', '$result', '$date')";
}
if (  mysql_query($sql) ) //notice the "!" it means if the mysql_query($sql)  cannot be executed, then die error. ELSE execute the mysql_querry($sql) to
                                        //insert into table in the database.
{   
die('Error in Registration,: ' . mysql_error());
}
else
{    //Insert User into the database.
echo 'Customer Name: '. $customername . '<br />Phone Number: ' .$phonenumber . '<br />E-Mail Address: ' . $email;
echo '<br />Issue:'. $issue . '<br />Results:' . $result . '<br />' . 'Date:' .$date . '<br />' ;
}
?>
</body>
</html>

this is my db_tb.php file

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php  
$host = "localhost"; // Host name
$username = "root"; // Mysql username...please try and locate your mysql                 
                                  //configuration. i.e. your username and password. 
$password = ""; // Mysql password
// Connect to server
mysql_connect("$host", "$username", "$password") or die('ERROR: Cannot connect' .mysql_error());

//here is the newly added code..Selecting the database
mysql_query("USE mydb");

$sql = mysql_query( "CREATE TABLE UserNote (CustomerName varchar(255), Phone varchar(255), Email varchar(150), Issue varchar(255), Result varchar(255))");

if ($sql) {
echo "Database and table created succesffully";
}
else {
   die ('ERROR: Cannot connect'.mysql_error());
}
?>
</body>
</html>

Sign In

a bit more php help

Recommended Posts

spudly1987

Link to comment

Share on other sites

PravinS

Link to comment

Share on other sites

cyberRobot

Link to comment

Share on other sites

spudly1987

Link to comment

Share on other sites

cyberRobot

Link to comment

Share on other sites

spudly1987

Link to comment

Share on other sites

cyberRobot

Link to comment

Share on other sites

cyberRobot

Link to comment

Share on other sites

spudly1987

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information