PHP - Script Not Inserting All User Input From Array Into Database

I am trying to array data to database against same id. Here is code. form.php

<form name="users" method="post" action="order_submit.php" enctype="multipart/form-data" onSubmit="return validate();" id="inv_form">
<div class="formSep">
<select name="company" onChange="showSubcat(this);">
<option value="">Company</option>
<?php $s1 = mysql_query("select * from leads where lead_customer='Lead' ") or die (mysql_error());
while($s2 = mysql_fetch_array($s1))
{ ?>
<option value="<?php echo $s2['id']; ?>"><?php echo $s2['company']; ?></option>


<?php 


} ?>
</select>

</div>

<div class="formSep">

<table class="table invE_table">
<thead>
<tr>
<th></th>
<th>Item</th>
<th>Unit</th>
<th>Unit Cost ($)</th>
<th>Qty</th>
<th>Tax (%)</th>
<th>Total ($)</th>
</tr>
</thead>
<tbody>
<tr class="inv_row">
<td class="inv_clone_row"><i class="icon-plus inv_clone_btn"></i></td>
<td><input type="text" class="span12" name="invE_item[]" /></td>
<td><input type="text" class="span12" name="invE_description[]" /></td>
<td><input type="text" class="span12 jQinv_item_unit" name="invE_unit_cost[]" /></td>
<td><input type="text" class="span12 jQinv_item_qty" name="invE_qty[]" /></td>
<td><input type="text" class="span12 jQinv_item_tax" name="invE_tax[]" /></td>
<td><input type="text" readonly class="span12 jQinv_item_total" name="invE_total[]" /></td>
</tr>
<tr class="last_row">
<td colspan="5">&nbsp;</td>
<td colspan="2">
<p class="clearfix">Subtotal: <span class="invE_subtotal">$<span>0.00</span></span></p>
<p>Tax: <span class="invE_tax">$<span>0.00</span></span></p>
<p>Discount: <span class="invE_discount">$<span>0.00</span></span></p>
<p><strong>Balance: <span class="invE_balance">$<span>0.00</span></span></strong></p>
</td>
</tr>
</tbody> 
</table>
</div>

Here invE_item[], invE_description[], invE_unit_cost[].... are the array , i mean dynamically one can add as many as items and its details. In my order_submit.php page

<?php

error_reporting(0);
include("connect.php");
include("admin_auth.php"); 

if(isset($_POST['save']))
{

$company = $_POST['company'];
$contact_person = $_POST['contact_person'];
$billing = $_POST['billing_address'];
$shipping = $_POST['shipping_address'];
$reference = $_POST['reference'];
$t_c = $_POST['t_c'];
$payment = $_POST['payment'];
$ship_in = $_POST['ship_inst'];
$validity = $_POST['validity'];
$currency = $_POST['currency'];
$order_for = $_POST['order_for'];
$assigned_to = $_POST['assigned_to'];
$item = $_POST['invE_item'];
$unit = $_POST['invE_description'];
$price = $_POST['invE_unit_cost'];  
$qty= $_POST['invE_qty'];   
$tax = $_POST['invE_tax'];  
$total = $_POST['invE_total'];  

$sql = mysql_query("insert into orders (order_id, company_id, contact_person, billing_address, shipping_address, reference, t_c, payment, shipping_inst, validity, order_for, currency, assigned_to, last_modified, order_quote) values ('', ".$company.", '".$contact_person."', '".$billing."', '".$shipping."', '".$reference."', '".$t_c."', '".$payment."', '".$ship_in."', ".$validity.", '".$order_for."', '".$currency."', '".$assigned_to."', NOW(), 'Order')");

$last_id = mysql_insert_id();

$msql = "insert into order_line_items (id, order_id, company_id, item, unit, unit_cost, quantity, tax, total) values ('', ".$last_id.", ".$company.", '".$item."', '".$unit."', ".$price.", ".$qty.", ".$tax.", ".$total.")";


$l1 = mysql_query($msql) or die (mysql_error());    
} 

I want to insert each item in different row with $last_id , as in the attached image .   Please somebody help me in this Attached Files  db.PNG   11.01KB   4 downloads

I am trying to create a website that after you receive an email you have to use the email address and password to confirm account. Then the next page allows you to change your password. I want to save the users email from the first page and use it in the SQL statement in the second page to locate the user in the DB and update the data.

There must be some problem with the way I have my code logically set up. It will make it to the 2nd step but then it will go back to the main email confirmation page.

<?php
include('common.php');
include('db.php');

session_start();
session_register('umail');
session_register('password');
session_register('pwd1');
session_register('pwd2');

  if(!isset($_POST['email']) && !isset($_POST['password']))
  {

  ?>
  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "BLOCKED URL">
  <html>
  <head> This is a test of my patience</head>
  <meta http-equov="Content-Type" content="text/html; charset=iso-8859-1"/>
  </head>
  <body>
  <form method="post" action="<?=$_SERVER['PHP_SELF']?>">
  Email: <input type="text" name="email" size="8" />
  password:<input type="password" name="password" size="8" />
  <input type ="submit" name ="submit" value ="submit" />
  </form>
  </body>
  </html>
  <? exit;
  }
   else
  {
  $umail = $_SESSION['umail'] = $_POST['email'];
  $password = $_SESSION['password'] = $_POST['password'];

  dbConnect("web2");
  $sql ="SELECT * FROM `user` WHERE email ='$umail'";
  $result = mysql_query($sql);
  $row = mysql_fetch_assoc($result);

    if(!$result)
    error('Contact DB admin');
    if($result='')
    error('not in db');

    if($_SESSION['umail'] != $row['email'] && $_SESSION['password'] != $row['password'])
    error('Wrong email or password');
  }



  if(!isset($_POST['pwd1']) && !isset($_POST['pwd2']))
  {

  ?>
  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

  "BLOCKED URL">
  <html>
  <head> This is a test of my patience</head>
  <meta http-equov="Content-Type" content="text/html; charset=iso-8859-1"/>
  </head>
  <body>
  <form method="post" action="<?=$_SERVER['PHP_SELF']?>">
  password: <input type="text" name="pwd1" size="8" />
  password confirmation:<input type="password" name="pwd2" size="8" />
  <input type ="submit" name ="submit" value ="submit" />
  </form>
  </body>
  </html>
  <?
  }
  else
  {
  $pwd1 = $_SESSION['pwd1'] = $_POST['pwd1'];
  $pwd2 = $_SESSION['pwd2'] = $_POST['pwd2'];

    if($_SESSiON['pwd1'] == $_SESSION['pwd2'])
    {

    dbConnect("web2");
    mysql_query("UPDATE user SET password ='$pwd1'
                WHERE email ='$umail'");
    $sql="SELECT * FROM 'user' WHERE email='$umail'";
    $result = mysql_query($sql);
    $row = mysql_fetch_assoc($result);

     if($_SESSION['pwd1'] != $row['password'])
      {
      ?>
      <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
      "(BLOCKED URl">
      <html>
      <head> This is a test of my patience</head>
      <meta http-equov="Content-Type" content="text/html; charset=iso-8859-1"/>
      </head>
      <body>
      <form method="post" action="<?=$_SERVER['PHP_SELF']?>">
      password: <input type="text" name="pwd1" size="8" />
      password confirmation:<input type="password" name="pwd2" size="8" />
      <input type ="submit" name ="submit" value ="submit" />
      </form>
      </body>
      </html>
      <?
      }
      else
      {
      error(' the man');
      session_unset();
      session_destroy();
      }
    }
  }

?> 

I'm creating a newsletter and the unsubscribe isn't deleting the database entry like I'm asking it to. Everything else works fine, it even successfully says the user has been removed, but it doesn't actually delete the database entry.

I've spent  two days trying to figure out why. Here's the code:

Newsletter sign up:
 

<?php
//DB Connect Info
$servername = "";
$database = "";
$username = "";
$password = "";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $database);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

/*$createTable = $conn->prepare ("CREATE TABLE IF NOT EXISTS email_user (
  id int(11) NOT NULL AUTO_INCREMENT,
  email varchar(200) NOT NULL,
  hash varchar(250) NOT NULL,
  PRIMARY KEY (id)
)");

$createTable->execute();
*/

function input_security($data)
{
    $data = trim($data);
    $data = stripslashes($data);
    $data = htmlspecialchars($data);
    return $data;
}

$email = input_security($_POST['email']);

$insertData = input_security($insertData);

if(isset($_POST['submit']))
{  
  extract($_POST);
  if($email!="") :
    $email=mysqli_real_escape_string($conn,$email);
    $emailval = '/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$/';    
    if(preg_match($emailval, $email)) :
      $db_check=$conn->query("SELECT * FROM email_user WHERE email='$email'");
      $count=mysqli_num_rows($db_check);
      if($count< 1) :         
         $hash=md5($email.time());
         $link = '/unsubscribe.php?key='.$hash;

        // Change your domain        
         $fetch=$conn->query("INSERT INTO email_user(email,hash) VALUES('$email','$hash')");
         $to="$email"; //change to ur mail address
         $strSubject="Maintenance Fee Relief, LLC | Email Subscription";
         $message = '<p>Thank you for subscribing with us.</p>' ;              
         $message .= '<p>Click here to unsubscribe your email : <a href="'.$link.'">unsubscribe</p>' ;              
         $headers = 'MIME-Version: 1.0'."\r\n";
         $headers .= 'Content-type: text/html; charset=iso-8859-1'."\r\n";
         $headers .= "From: info@";            
         $mail_sent=mail($to, $strSubject, $message, $headers);  
         $msg_sucess="Your request has been accepted!.";
      else :
        $msg="This $email email address is already subscribe with us.";
      endif;  
    else :
      $msg="Please enter your valid email id";
    endif;      
  else :
    $msg="Please fill all mandatory fields";
  endif;
}
?>

<div class="newsletter-sign-up-header-form">
<div id="logerror"><?php echo @$msg; ?><?php echo @$msg_sucess; ?></div>
<form  method="post">
<span><input type="email" name="email" placeholder="Email Address - Join Newsletter" class="newsletter-sign-up-header-email" required></span>
<span><button name="submit" value="submit" title="Submit" class="newsletter-sign-up-header-submit-button">Submit</button></span>
</form>
</div>

<?php
//DB Connect Info
$servername = "";
$database = "";
$username = "";
$password = "";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $database);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>

<?php
if(@$_GET['key']!=""):
    $hash=mysqli_real_escape_string($conn,$_GET['key']);
    $fetch=$conn->query("SELECT * FROM email_user WHERE hash = '$hash'");
    $count=mysqli_num_rows($fetch);
    if($count==1) :
      $row=mysqli_fetch_array($fetch);      
        $conn->query("DELETE email_user WHERE id='$user_id'");
        $msg="Your email id unsubscribe with us";
    else :
      $msg="Please click valid link.";
    endif;
else :
    header("Location:404.php");
endif;
?>

<!doctype html>
<html lang="en">
<head>
   <title>Unsubscribe</title>
</head>
<body>
    <div align="center">
    <h2><?php echo $msg; ?></h2>
        <a href="https://www.--.com">--.com</a>                                                
    </div>
    

 

Quote

 

 

This script works well as far as getting the form information onto the database but for some reason the confirmation email is not being sent to the user.

Could someone take a quick look at my script? Please? I've attached the included files as well. I guess I just need another set of eyes to look over this script. It would be much appreciated


<?php
// Created BY Adam Khoury @ www.developphp.com

// let's initialize vars to be printed to page in the HTML section so our script does not return errors
// they must be initialized in some server environments
$errorMsg = "";
$firstname = "";
$lastname = "";
$country = "";
$state = "";
$city = "";
$zip = "";
$website = "";
$youtube = "";
$email1 = "";
$email2 = "";
$pass1 = "";
$pass2 = "";

// This code runs only if the form submit button is pressed
if (isset ($_POST['firstname'])){
   
   /* Example of cleaning variables in a loop
   $vars = "";
   foreach ($_POST as $key => $value) {
       $value = stripslashes($value);
       $vars .= "$key = $value<br />";
    }
    print "$vars";
    exit();
   */
     $firstname = $_POST['firstname'];
     $lastname = $_POST['lastname'];
     $country = $_POST['country'];
     $state = $_POST['state'];
     $city = $_POST['city'];
     $zip = $_POST['zip'];
     $website = $_POST['website'];
     $youtube = $_POST['youtube'];
     $email1 = $_POST['email1'];
     $email2 = $_POST['email2'];
     $pass1 = $_POST['pass1'];
     $pass2 = $_POST['pass2'];
     $humancheck = $_POST['humancheck'];

     $firstname = stripslashes($firstname);
     $lastname = stripslashes($lastname);
     $state = stripslashes($state);
     $city = stripslashes($city);
     $zip = stripslashes($zip);
     $website = stripslashes($website);
     $youtube = stripslashes($youtube);
     $email1 = stripslashes($email1);
     $pass1 = stripslashes($pass1);
     $email2 = stripslashes($email2);
     $pass2 = stripslashes($pass2);

     $firstname = strip_tags($firstname);
    $lastname = strip_tags($lastname);
     $state = strip_tags($state);
     $city = strip_tags($city);
    $zip = strip_tags($zip);
     $website = strip_tags($website);
     $youtube = strip_tags($youtube);
     $email1 = strip_tags($email1);
     $pass1 = strip_tags($pass1);
     $email2 = strip_tags($email2);
     $pass2 = strip_tags($pass2);

     // Connect to database
     include_once "connect_to_mysql.php";
     $emailCHecker = mysql_real_escape_string($email1);
    $emailCHecker = eregi_replace("`", "", $emailCHecker);
     // Database duplicate e-mail check setup for use below in the error handling if else conditionals
   
mysql_select_db("perry100_users", $myConnection);

 
     $sql_email_check = mysql_query("SELECT email FROM myMembers WHERE email='$emailCHecker'", $myConnection);
    $email_check = mysql_num_rows($sql_email_check);// or die(mysql_error());      
   

     // Error handling for missing data
     if ((!$firstname) || (!$lastname) || (!$country) || (!$state) || (!$city) || (!$zip) || (!$email1) || (!$email2) || (!$pass1) || (!$pass2)) {

     $errorMsg = 'ERROR: You did not submit the following required information:<br /><br />';
 
     if(!$firstname){
       $errorMsg .= ' * First Name<br />';
     }
    if(!$lastname){
       $errorMsg .= ' * Last Name<br />';
     }
     if(!$country){
       $errorMsg .= ' * Country<br />';
     }    
    if(!$state){
       $errorMsg .= ' * State or Provice<br />';     
     }
    if(!$city){
       $errorMsg .= ' * City<br />';       
     }
    if(!$zip){
       $errorMsg .= ' * Postal or Zip Code<br />';       
     }       
    if(!$email1){
       $errorMsg .= ' * Email Address<br />';     
     }
    if(!$email2){
       $errorMsg .= ' * Confirm Email Address<br />';       
     }    
    if(!$pass1){
       $errorMsg .= ' * Login Password<br />';     
     }
    if(!$pass2){
       $errorMsg .= ' * Confirm Login Password<br />';       
     }    
   
     } else if ($email1 != $email2) {
              $errorMsg = 'ERROR: Your Email fields below do not match<br />';
     } else if ($pass1 != $pass2) {
              $errorMsg = 'ERROR: Your Password fields below do not match<br />';
     } else if ($humancheck != "") {
              $errorMsg = 'ERROR: The Human Check field must be cleared to be sure you are human<br />';      
     } else if ($email_check > 0){
              $errorMsg = "<u>ERROR:</u><br />Your Email address is already in use inside our database. Please use another.<br />";
      
     } else { // Error handling is ended, process the data and add member to database
     ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
   
    $firstname = mysql_real_escape_string($firstname);
    $lastname = mysql_real_escape_string($lastname);
     $state = mysql_real_escape_string($state);
     $city = mysql_real_escape_string($city);
    $zip = mysql_real_escape_string($zip);
     $website = mysql_real_escape_string($website);
    $youtube = mysql_real_escape_string($youtube);
     $email1 = mysql_real_escape_string($email1);
     $pass1 = mysql_real_escape_string($pass1);
   
    $firstname = eregi_replace("`", "", $firstname);
    $lastname = eregi_replace("`", "", $lastname);
    $state = eregi_replace("`", "", $state);
    $city = eregi_replace("`", "", $city);
    $zip = eregi_replace("`", "", $zip);
    $website = eregi_replace("`", "", $website);
    $youtube = eregi_replace("`", "", $youtube);
    $email1 = eregi_replace("`", "", $email1);
    $pass1 = eregi_replace("`", "", $pass1);

     $website = eregi_replace("http://", "", $website);
    $youtube = eregi_replace("http://www.youtube.com/user/", "", $youtube);
   
     // Add MD5 Hash to the password variable
     $db_password = md5($pass1);

     // Add user info into the database table for the main site table(knirv.com)
     $sql = mysql_query("INSERT INTO myMembers (firstname, lastname, country, state, city, zip, email, password, sign_up_date, website, youtube)
     VALUES('$firstname','$lastname','$country','$state','$city','$zip','$email1','$db_password', now(),'$website','$youtube')") 
     or die (mysql_error());
 
     $id = mysql_insert_id();
   
    // Create directory(folder) to hold each user's files(pics, MP3s, etc.)      
     mkdir("members/$id", 0755);   

    //!!!!!!!!!!!!!!!!!!!!!!!!!    Email User the activation link    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
     $myemail = "admin@knirv.com";
       $emess = "First Name: $firstname\n";
       $emess.= "Last Name: $lastname\n";
       $emess.= "Email 1: $email1\n";
       $emess.= "Email 2: $email2\n";
       $emess.= "City: $city\nState: $state\nZip/Post Code:$zip\n";
       $emess.= "Country: $scountry\n";
       $emess.= "Phone number 1: $phone1\n";
       $emess.= "Phone number 2: $phone2\n";
       $emess.= "Phone number 3: $phone3\n";
       $emess.= "Comments: $sendmail";
       $ehead = "From: $myemail\r\n";
       $subj = "Complete knirv.com registration!";
      $mailsend=mail("$myemail","$subj","$emess","$ehead");
          //Begin HTML Email Message
    $message = "Hi $firstname,

   Complete this step to activate your login identity at knirv.com.

   Click the line below to activate when ready.

   http://www.knirv.com/activation.php?id=$id&sequence=$db_password
   If the URL above is not an active link, please copy and paste it into your browser address bar

   Login after successful activation using your: 
   E-mail Address: $email
   Password: $password

   See you on the site!
   admin@knirv.com";
   //end of message
       unset($_GET['do']);
 
       header("Location: thank_you.php");
     break;
 
   }
   
   $msgToUser = "<h2>One Last Step - Activate through Email</h2><h4>OK $firstname, one last step to verify your email identity:</h4><br />
   In a moment you will be sent an Activation link to your email address.<br /><br />
   <br />
   <strong><font color=\"#990000\">VERY IMPORTANT:</font></strong>
   If you check your email with your host providers default email application, there may be issues with seeing the email contents.  If this happens to you and you cannot read the message to activate, download the file and open using a text editor. If you still cannot see the activation link, contact site admin and briefly discuss the issue.<br /><br />
   ";


   include_once 'msgToUser.php';

   exit();

   } // Close else after duplication checks

 else { // if the form is not posted with variables, place default empty variables
    
     $errorMsg = "Fields marked with an [ * ] are required";
      $firstname = "";
     $lastname = "";
     $country = "";
     $state = "";
     $city = "";
     $zip = "";
     $website = "";
     $youtube = "";
     $email1 = "";
     $email2 = "";
     $pass1 = "";
     $pass2 = "";
}

?>
<!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=iso-8859-1" />
<meta name="Kinetic Network" content="Register to knirv.com" />
<meta name="Knirv Registration" content="register, www.knirv.com" />
<meta name="rating" content="General" />
<title>Register Your Account</title>
<link rel="icon" href="favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="favicon.ico" type="image/x-icon" />
<style type="text/css">
<!--
.style26 {color: #FF0000}
.style28 {font-size: 14px}
.brightRed {
   color: #F00;
}
.textSize_9px {
   font-size: 9px;
}
-->
</style>
<link href="CSS/site_layout.css" rel="stylesheet" type="text/css" />
</head>

<body>
<?php include_once "header_template.php";
   if ($message)
   echo "<p>$message</p>";
?>
<table width="950" align="center">
  <tr>
    <td width="758">
      <blockquote>
        <h2><br />
          Create Your Account Below </h2>
      </blockquote>
      <table width="600" align="center" cellpadding="5">
        <form action="register.php" method="post" enctype="multipart/form-data">
          <tr>
            <td width="125" class="style7"><div align="center"><strong>Please Do First &rarr;</strong></div></td>
            <td width="447" bgcolor="#FFFFFF">Add <a href="mailto:admin@yknirv.com"><u>admin@knirv.com</u></a> to your email white list or safe sender list now, or else you might not get the activation email that is necessary for logging in successfully. </td>
          </tr>
          <tr>
            <td colspan="2"><font color="#FF0000"><?php print "$errorMsg"; ?></font></td>
          </tr>
          <tr>
            <td align="right" class="alignRt">First Name:<span class="brightRed"> *</span></td>
            <td><input name="firstname" type="text" class="formFields" id="firstname" value="<?php print "$firstname"; ?>" size="32" maxlength="20" /></td>
          </tr>
          <tr>
            <td align="right" class="alignRt">Last Name:<span class="brightRed"> *</span></td>
            <td><input name="lastname" type="text" class="formFields" id="lastname" value="<?php print "$lastname"; ?>" size="32" maxlength="20" /></td>
          </tr>                   
          <tr>
            <td align="right" class="alignRt">Country:<span class="brightRed"> *</span></td>
            <td>
              <select name="country" class="formFields">
                <option value="<?php print "$country"; ?>"><?php print "$country"; ?></option>
                <option value="United States of America">United States of America</option>
                <option value="Afghanistan">Afghanistan</option>
                <option value="Albania">Albania</option>
                <option value="Algeria">Algeria</option>
                <option value="American Samoa">American Samoa</option>
                <option value="Andorra">Andorra</option>
                <option value="Angola">Angola</option>
                <option value="Anguilla">Anguilla</option>
                <option value="Antigua and Barbuda">Antigua and Barbuda</option>
                <option value="Argentina">Argentina</option>
                <option value="Armenia">Armenia</option>
                <option value="Aruba">Aruba</option>
                <option value="Australia">Australia</option>
                <option value="Austria">Austria</option>
                <option value="Azerbaijan">Azerbaijan</option>
                <option value="Bahamas">Bahamas</option>
                <option value="Bahrain">Bahrain</option>
                <option value="Bangladesh">Bangladesh</option>
                <option value="Barbados">Barbados</option>
                <option value="Belarus">Belarus</option>
                <option value="Belgium">Belgium</option>
                <option value="Belize">Belize</option>
                <option value="Benin">Benin</option>
                <option value="Bermuda">Bermuda</option>
                <option value="Bhutan">Bhutan</option>
                <option value="Bolivia">Bolivia</option>
                <option value="Bonaire">Bonaire</option>
                <option value="Bosnia and Herzegovina">Bosnia and Herzegovina</option>
                <option value="Botswana">Botswana</option>
                <option value="Brazil">Brazil</option>
                <option value="British Indian Ocean Ter">British Indian Ocean Ter</option>
                <option value="Brunei">Brunei</option>
                <option value="Bulgaria">Bulgaria</option>
                <option value="Burkina Faso">Burkina Faso</option>
                <option value="Burundi">Burundi</option>
                <option value="Cambodia">Cambodia</option>
                <option value="Cameroon">Cameroon</option>
                <option value="Canada">Canada</option>
                <option value="Canary Islands">Canary Islands</option>
                <option value="Cape Verde">Cape Verde</option>
                <option value="Cayman Islands">Cayman Islands</option>
                <option value="Central African Republic">Central African Republic</option>
                <option value="Chad">Chad</option>
                <option value="Channel Islands">Channel Islands</option>
                <option value="Chile">Chile</option>
                <option value="China">China</option>
                <option value="Christmas Island">Christmas Island</option>
                <option value="Cocos Island">Cocos Island</option>
                <option value="Columbia">Columbia</option>
                <option value="Comoros">Comoros</option>
                <option value="Congo">Congo</option>
                <option value="Cook Islands">Cook Islands</option>
                <option value="Costa Rica">Costa Rica</option>
                <option value="Cote D'Ivoire">Cote D'Ivoire</option>
                <option value="Croatia">Croatia</option>
                <option value="Cuba">Cuba</option>
                <option value="Curacao">Curacao</option>
                <option value="Cyprus">Cyprus</option>
                <option value="Czech Republic">Czech Republic</option>
                <option value="Denmark">Denmark</option>
                <option value="Djibouti">Djibouti</option>
                <option value="Dominica">Dominica</option>
                <option value="Dominican Republic">Dominican Republic</option>
                <option value="East Timor">East Timor</option>
                <option value="Ecuador">Ecuador</option>
                <option value="Egypt">Egypt</option>
                <option value="El Salvador">El Salvador</option>
                <option value="Equatorial Guinea">Equatorial Guinea</option>
                <option value="Eritrea">Eritrea</option>
                <option value="Estonia">Estonia</option>
                <option value="Ethiopia">Ethiopia</option>
                <option value="Falkland Islands">Falkland Islands</option>
                <option value="Faroe Islands">Faroe Islands</option>
                <option value="Fiji">Fiji</option>
                <option value="Finland">Finland</option>
                <option value="France">France</option>
                <option value="French Guiana">French Guiana</option>
                <option value="French Polynesia">French Polynesia</option>
                <option value="French Southern Ter">French Southern Ter</option>
                <option value="Gabon">Gabon</option>
                <option value="Gambia">Gambia</option>
                <option value="Georgia">Georgia</option>
                <option value="Germany">Germany</option>
                <option value="Ghana">Ghana</option>
                <option value="Gibraltar">Gibraltar</option>
                <option value="Great Britain">Great Britain</option>
                <option value="Greece">Greece</option>
                <option value="Greenland">Greenland</option>
                <option value="Grenada">Grenada</option>
                <option value="Guadeloupe">Guadeloupe</option>
                <option value="Guam">Guam</option>
                <option value="Guatemala">Guatemala</option>
                <option value="Guinea">Guinea</option>
                <option value="Guyana">Guyana</option>
                <option value="Haiti">Haiti</option>
                <option value="Hawaii">Hawaii</option>
                <option value="Honduras">Honduras</option>
                <option value="Hong Kong">Hong Kong</option>
                <option value="Hungary">Hungary</option>
                <option value="Iceland">Iceland</option>
                <option value="India">India</option>
                <option value="Indonesia">Indonesia</option>
                <option value="Iran">Iran</option>
                <option value="Iraq">Iraq</option>
                <option value="Ireland">Ireland</option>
                <option value="Isle of Man">Isle of Man</option>
                <option value="Israel">Israel</option>
                <option value="Italy">Italy</option>
                <option value="Jamaica">Jamaica</option>
                <option value="Japan">Japan</option>
                <option value="Jordan">Jordan</option>
                <option value="Kazakhstan">Kazakhstan</option>
                <option value="Kenya">Kenya</option>
                <option value="Kiribati">Kiribati</option>
                <option value="Korea North">Korea North</option>
                <option value="Korea South">Korea South</option>
                <option value="Kuwait">Kuwait</option>
                <option value="Kyrgyzstan">Kyrgyzstan</option>
                <option value="Laos">Laos</option>
                <option value="Latvia">Latvia</option>
                <option value="Lebanon">Lebanon</option>
                <option value="Lesotho">Lesotho</option>
                <option value="Liberia">Liberia</option>
                <option value="Libya">Libya</option>
                <option value="Liechtenstein">Liechtenstein</option>
                <option value="Lithuania">Lithuania</option>
                <option value="Luxembourg">Luxembourg</option>
                <option value="Macau">Macau</option>
                <option value="Macedonia">Macedonia</option>
                <option value="Madagascar">Madagascar</option>
                <option value="Malaysia">Malaysia</option>
                <option value="Malawi">Malawi</option>
                <option value="Maldives">Maldives</option>
                <option value="Mali">Mali</option>
                <option value="Malta">Malta</option>
                <option value="Marshall Islands">Marshall Islands</option>
                <option value="Martinique">Martinique</option>
                <option value="Mauritania">Mauritania</option>
                <option value="Mauritius">Mauritius</option>
                <option value="Mayotte">Mayotte</option>
                <option value="Mexico">Mexico</option>
                <option value="Midway Islands">Midway Islands</option>
                <option value="Moldova">Moldova</option>
                <option value="Monaco">Monaco</option>
                <option value="Mongolia">Mongolia</option>
                <option value="Montserrat">Montserrat</option>
                <option value="Morocco">Morocco</option>
                <option value="Mozambique">Mozambique</option>
                <option value="Myanmar">Myanmar</option>
                <option value="Nambia">Nambia</option>
                <option value="Nauru">Nauru</option>
                <option value="Nepal">Nepal</option>
                <option value="Netherland Antilles">Netherland Antilles</option>
                <option value="Netherlands">Netherlands</option>
                <option value="Nevis">Nevis</option>
                <option value="New Caledonia">New Caledonia</option>
                <option value="New Zealand">New Zealand</option>
                <option value="Nicaragua">Nicaragua</option>
                <option value="Niger">Niger</option>
                <option value="Nigeria">Nigeria</option>
                <option value="Niue">Niue</option>
                <option value="Norfolk Island">Norfolk Island</option>
                <option value="Norway">Norway</option>
                <option value="Oman">Oman</option>
                <option value="Pakistan">Pakistan</option>
                <option value="Palau Island">Palau Island</option>
                <option value="Palestine">Palestine</option>
                <option value="Panama">Panama</option>
                <option value="Papua New Guinea">Papua New Guinea</option>
                <option value="Paraguay">Paraguay</option>
                <option value="Peru">Peru</option>
                <option value="Philippines">Philippines</option>
                <option value="Pitcairn Island">Pitcairn Island</option>
                <option value="Poland">Poland</option>
                <option value="Portugal">Portugal</option>
                <option value="Puerto Rico">Puerto Rico</option>
                <option value="Qatar">Qatar</option>
                <option value="Reunion">Reunion</option>
                <option value="Romania">Romania</option>
                <option value="Russia">Russia</option>
                <option value="Rwanda">Rwanda</option>
                <option value="St Barthelemy">St Barthelemy</option>
                <option value="St Eustatius">St Eustatius</option>
                <option value="St Helena">St Helena</option>
                <option value="St Kitts-Nevis">St Kitts-Nevis</option>
                <option value="St Lucia">St Lucia</option>
                <option value="St Maarten">St Maarten</option>
                <option value="St Pierre and Miquelon">St Pierre and Miquelon</option>
                <option value="St Vincent and Grenadines">St Vincent and Grenadines</option>
                <option value="Saipan">Saipan</option>
                <option value="Samoa">Samoa</option>
                <option value="Samoa American">Samoa American</option>
                <option value="San Marino">San Marino</option>
                <option value="Sao Tome and Principe">Sao Tome and Principe</option>
                <option value="Saudi Arabia">Saudi Arabia</option>
                <option value="Senegal">Senegal</option>
                <option value="Seychelles">Seychelles</option>
                <option value="Serbia and Montenegro">Serbia and Montenegro</option>
                <option value="Sierra Leone">Sierra Leone</option>
                <option value="Singapore">Singapore</option>
                <option value="Slovakia">Slovakia</option>
                <option value="Slovenia">Slovenia</option>
                <option value="Solomon Islands">Solomon Islands</option>
                <option value="Somalia">Somalia</option>
                <option value="South Africa">South Africa</option>
                <option value="Spain">Spain</option>
                <option value="Sri Lanka">Sri Lanka</option>
                <option value="Sudan">Sudan</option>
                <option value="Suriname">Suriname</option>
                <option value="Swaziland">Swaziland</option>
                <option value="Sweden">Sweden</option>
                <option value="Switzerland">Switzerland</option>
                <option value="Syria">Syria</option>
                <option value="Tahiti">Tahiti</option>
                <option value="Taiwan">Taiwan</option>
                <option value="Tajikistan">Tajikistan</option>
                <option value="Tanzania">Tanzania</option>
                <option value="Thailand">Thailand</option>
                <option value="Togo">Togo</option>
                <option value="Tokelau">Tokelau</option>
                <option value="Tonga">Tonga</option>
                <option value="Trinidad and Tobago">Trinidad and Tobago</option>
                <option value="Tunisia">Tunisia</option>
                <option value="Turkey">Turkey</option>
                <option value="Turkmenistan">Turkmenistan</option>
                <option value="Turks and Caicos Is">Turks and Caicos Is</option>
                <option value="Tuvalu">Tuvalu</option>
                <option value="Uganda">Uganda</option>
                <option value="Ukraine">Ukraine</option>
                <option value="United Arab Emirates">United Arab Emirates</option>
                <option value="United Kingdom">United Kingdom</option>
                <option value="United States of America">United States of America</option>
                <option value="Uruguay">Uruguay</option>
                <option value="Uzbekistan">Uzbekistan</option>
                <option value="Vanuatu">Vanuatu</option>
                <option value="Vatican City State">Vatican City State</option>
                <option value="Venezuela">Venezuela</option>
                <option value="Vietnam">Vietnam</option>
                <option value="Virgin Islands (Brit)">Virgin Islands Brit</option>
                <option value="Virgin Islands (USA)">Virgin Islands USA</option>
                <option value="Wake Island">Wake Island</option>
                <option value="Wallis and Futana Is">Wallis and Futana Is</option>
                <option value="Yemen">Yemen</option>
                <option value="Zaire">Zaire</option>
                <option value="Zambia">Zambia</option>
                <option value="Zimbabwe">Zimbabwe</option>
              </select>
            </td>
          </tr>
          <tr>
            <td align="right" class="alignRt">State/Province: <span class="brightRed">*</span></td>
            <td><input name="state" type="text" class="formFields" id="state" value="<?php print "$state"; ?>" size="32" maxlength="36" /></td>
          </tr>
          <tr>
            <td align="right" class="alignRt">City: <span class="brightRed">*</span></td>
            <td><input name="city" type="text" class="formFields" id="city" value="<?php print "$city"; ?>" size="32" maxlength="36" /></td>
          </tr>
          <tr>
            <td align="right" class="alignRt">Postal / Zip Code: <span class="brightRed">*</span></td>
            <td><input name="zip" type="text" class="formFields" id="zip" value="<?php print "$zip"; ?>" size="32" maxlength="24" /></td>
          </tr>
          <tr>
            <td align="right" class="alignRt">Website:</td>
            <td><strong>http://</strong>
            <input name="website" type="text" class="formFields" id="website" value="<?php print "$website"; ?>" size="40" maxlength="88" /></td>
          </tr>
          <tr>
            <td align="right" class="alignRt">Youtube Channel:</td>
            <td><strong>http://www.youtube.com/user/</strong>
            <input name="youtube" type="text" class="formFields" id="youtube" value="<?php print "$youtube"; ?>" size="32" maxlength="88" /></td>
          </tr>         
          <tr>
            <td align="right" class="alignRt">Email Address: <span class="brightRed">*</span></td>
            <td><input name="email1" type="text" class="formFields" id="email1" value="<?php print "$email1"; ?>" size="32" maxlength="48" /></td>
          </tr>
          <tr>
            <td align="right" class="alignRt">Confirm Email:<span class="brightRed"> *</span></td>
            <td><input name="email2" type="text" class="formFields" id="email2" value="<?php print "$email2"; ?>" size="32" maxlength="48" /></td>
          </tr>
          <tr>
            <td align="right" class="alignRt">Create Password:<span class="brightRed"> *</span></td>
            <td><input name="pass1" type="password" class="formFields" id="pass1" maxlength="16" />
              <span class="textSize_9px"><span class="greyColor">Alphanumeric Characters Only</span></span></td>
          </tr>
          <tr>
            <td align="right" class="alignRt">Confirm Password:<span class="brightRed"> *</span></td>
            <td><input name="pass2" type="password" class="formFields" id="pass2" maxlength="16" />
            <span class="textSize_9px"><span class="greyColor">Alphanumeric Characters Only</span></span></td>
          </tr>
          <tr>
            <td align="right" class="alignRt"><br />
              Human Check: <span class="brightRed">*</span></td>
            <td><br />
              <input name="humancheck" type="text" class="formFields" id="humancheck" value="Please remove all of this text" size="38" maxlength="32" />
            </td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td><p><br />
              <input type="submit" name="Submit3" value="Submit Form" />
            </p></td>
          </tr>
        </form>
      </table>
      <br />
      <br /></td>
    <td width="180" valign="top"><?php include_once "right_AD_template.php"; ?></td>
  </tr>
</table>
<?php include_once "footer_template.php"; ?>
</body>
</html>

I am trying to insert a new user into my database from my php code.

This is the error message that I am getting from the webpage:

Quote

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order, previousOrder) VALUES ('c_s@gmail.com','test','3','callulm','Smith','17' at line 1


This is the code that I am using:

Code: [Select]
<?php
$con = mysql_connect("localhost","root","");

if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
  
mysql_select_db("deliverpizza", $con);



$sql="INSERT INTO customer(userName, password, privilege, firstName,  lastName, address, postCode, order, previousOrder)
VALUES
('$_POST[username]','$_POST[password]','$_POST[privilege]','$_POST[firstname]','$_POST[lastname]','$_POST[address]','$_POST[postcode]','$_POST[order]','$_POST[previousOrder]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($con)
?>

Hi Group,

I looked through the internet and couldn't find an answer, but I was wondering on the appropriate syntax on inserting PHP code into an input element. See below.

<input type="text" name="id" value="<?php echo $main['id']; ?>"  size="10" />

Now this is purely an example (and I'm aware of php short tags, just don't want to use them). I only ask cause I've used CodeLobster and Eclipse and they don't really know what to do with the added php syntax. CodeLobster and Eclipse wouldn't finish marking up the rest of the line in the appropriate colors (all the text was black after the < in <?php like how I showed it above), however Eclipse's built in debug system thinks this is a syntax error.

It runs just fine in the browser and does what I want it to, but I'd like the appropriate systax to get rid of this "error".

Thanks in advance,

ImmortalFirefly

hello. I need your help please. I'm building logistics website with user panel and admin panel. I've done all login and register forms. now I want to : admin can add package with: tracking number , weight , cost , and declaration form. user can fill declaration form after admin add package to user panel. then admin can see the declared form. is it possible in php? thank you in advance

Hi guys.....

I'm having a problem that I've been tearing my hair out over for way too long. I'm hoping that some of you may be able to help me or at least point me in the right direction.

I'm using MySQL 5.0.91 (via PHPmyAdmin from GoDaddy).

This query should basically grab the data from the Facebook API and insert it into the database. It's not doing that. After inserting the data, it queries the database, and redirects the user to their profile page (USERNAME.php). Because there is no data in the database for that user, it has no idea what their username is, so it redirects them to ".php"....yes, that is "[dot]php".

I'm not entirely sure how to debug this either. I've tried a few var_dump()'s with not much luck.

Is there a specific order in which this stuff needs to be in? Maybe that's the problem, so I'm also including a screenshot from PHPmyAdmin of the database table.

Here's the code:


// user not in db, insert details
if(!empty($user)){
         $apiGet = array(
         'method' => 'users.getinfo',
                'uids' => $uid,
                'fields' => 'uid, name, first_name, last_name, pic_square, pic_big, sex, email, birthday_date, activities, interests, status, about_me' //theses are the fields it pulls from the Facebook API
                 );                                                                                                            
         // create array to hold returned values
         $fbi = $facebook->api($apiGet);
// insert details
$iString = "oauth_provider, oauth_uid, username, name, first_name, last_name, sex, pic_big, email, joined, lastLogon, birthday_date, user_activities, user_interests, user_status, user_about_me";

$iArray = array(); //the following are the values of the fields
array_push($iArray,'facebook');
array_push($iArray,$user['id']);
array_push($iArray,$user['name']);
array_push($iArray,$fbi[0]['name']);
array_push($iArray,$fbi[0]['first_name']);
array_push($iArray,$fbi[0]['last_name']);
array_push($iArray,$fbi[0]['sex']);
array_push($iArray,$fbi[0]['pic_big']);
array_push($iArray,$fbi[0]['email']);
array_push($iArray,time());
array_push($iArray,time());
array_push($iArray,$fbi[0]['birthday_date']);
array_push($iArray,$fbi[0]['user_activities']);
array_push($iArray,$fbi[0]['user_interests']);
array_push($iArray,$fbi[0]['user_status']);
array_push($iArray,$fbi[0]['user_about_me']);
var_dump($email);
$db->insert('users',$iArray,$iString);
$where = "oauth_uid = '{$uid}'";
$db->select('*','users',$where);
$result = $db->getResult();
                  // the next line creates a profile page. After that, there are lines that point the user to that page.
                  createProfile($result['username']);


I've added some comments to it to articulate what is going on.

Thanks in advance!
Alex

Hi.

Am trying to make an install script but have run into a problem.

----
variables.php - holds the variables that I need
install.php - connects to the database and inserts all the values.

Now I have a problem.  When I execute the install.php it outputs:

Creating tables...

Connected to database server
Database webleague is selected

Players table
Games table
News table
Rules table
Games table
Vars table

Inserting default values
Inserting news
Inserting rules
Inserting themes
Inserting vars

Done.

but doesnt insert ANYTHING into the database.

Can anyone help?

Variables.php:

<?php

//start

//configure database info
 $databaseserver = "localhost"; //usually localhost
 $databasename = "xxxxxxxxx"; //the name of your database
 $databaseuser = "xxxxxxxxx"; //the name of the database user
 $databasepass = "xxxxxxxxx"; // the password to your database
 $directory ="http://xxxxxxxxxxxxxxxxxx" ; //the location of your WebLeague directory (no trailing slash)

//configure the tables in the database
 $playerstable = "webl_players"; //the name of the table that contains information about the players
 $gamestable = "webl_games"; //the name of the table that stores the played games
 $newstable = "webl_news"; // the name of the table that stores the news
 $themestable = "webl_themes"; //the name of the table that stores the themes
 $varstable = "webl_vars"; //the name of the table that stores various information
 $rulestable = "webl_rules"; //the name of the table the stores the rules

//set some general information on your league
 $leaguename = "IRC League"; //the name of your league
 $title = ".: IRC League :."; //the title of your pages
 $favicon = "$directory/WebLeaguefavicon.ico" ; //the location of the shortcut icon
 $report = "winner"; //who reports? winner/loser
 $pointswin = "3"; //the number of points awarded for a win
 $pointsloss = "-1"; //the number of points awarded for a loss

//set the username and password for the admin panel
 $LOGIN = "xxxxxxxxxx"; //the username to access the admin panel
 $PASSWORD = "xxxxxxxxx"; //the passoword to access the admin panel

// finish

?>



And this is install.php:



Creating tables...<br><br>
<?php

include "variables.php";

$db = mysql_connect($databaseserver, $databaseuser, $databasepass)
or die("Connection Failure to Database Server");
echo "Connected to database server<br>";
        mysql_select_db($databasename, $db) or die ($databasename . " Database not found." . 

$databaseuser);
echo "Database " . $databasename . " is selected<br><br>";

if ($db==false) die("Failed to connect to MySQL server<br>\n");

$sql = "CREATE TABLE $playerstable (player_id int(10) DEFAULT '0' NOT NULL auto_increment, name 

varchar(40) DEFAULT '' NOT NULL, passworddb varchar(10), mail varchar(50), icq varchar(15), aim varchar

(40), country varchar(40), games int(10) DEFAULT '0', wins int(10) DEFAULT '0', losses int(10) DEFAULT 

'0', points int(10) DEFAULT '0', totalwins int(10) DEFAULT '0', totallosses int(10) DEFAULT '0', 

totalpoints int(10) DEFAULT '0', totalgames int(10) DEFAULT '0', penalties int(10) DEFAULT '0', staff 

varchar(10), streakwins int(10) DEFAULT '0', streaklosses int(10) DEFAULT '0', PRIMARY KEY (player_id))";

mysql_query($sql,$db);

$sql = "ALTER TABLE $playerstable ADD UNIQUE(name) ";

mysql_query($sql,$db);

        echo"Players table<br>";

$sql = "CREATE TABLE $gamestable (game_id int(10) DEFAULT '0' NOT NULL auto_increment, winner 

varchar(40), loser varchar(40), date varchar(40), PRIMARY KEY (game_id))";

mysql_query($sql,$db);
        echo"Games table<br>";

$sql = "CREATE TABLE $newstable (news_id int(10) DEFAULT '0' NOT NULL auto_increment, news text, 

PRIMARY KEY (news_id))";

mysql_query($sql,$db);
        echo"News table<br>";

$sql = "CREATE TABLE $rulestable (rules_id int(10) DEFAULT '0' NOT NULL auto_increment, rules 

text, PRIMARY KEY (rules_id))";

mysql_query($sql,$db);
        echo"Rules table<br>";

$sql = "CREATE TABLE $themestable (theme_id int(10) DEFAULT '0' NOT NULL auto_increment, name 

varchar(40), color1 varchar(40), color2 varchar(40), color3 varchar(40), color4 varchar(40), aimthemepic 

varchar(80), bottomleftpic varchar(80), bottommiddlepic varchar(80), bottomrightpic varchar(80), 

headerbgpic varchar(80), headermenuleftpic varchar(80), headermenurightpic varchar(80), sideleftpic 

varchar(80), siderightpic varchar(80), topleftpic varchar(80), topmiddlepic varchar(80), toprightpic 

varchar(80), PRIMARY KEY (theme_id))";

mysql_query($sql,$db);
        echo"Games table<br>";

$sql = "CREATE TABLE $varstable (vars_id int(10) DEFAULT '0' NOT NULL auto_increment, theme varchar(20), 

font varchar(80), fontcolor varchar(40), headerfont varchar(80), numgamespage int(10), numplayerspage int

(10), statsview varchar(10), stats1view varchar(10), stats2view varchar(10), stats3view varchar(10), 

stats4view varchar(10), stats5view varchar(10), stats6view varchar(10), stats7view varchar(10), statsnum 

int(10), rulesview varchar(10), standingsnogames varchar(10), pctnum varchar(10), hotcoldnum varchar(10), 

gamesmaxday int(10), PRIMARY KEY (vars_id))";

mysql_query($sql,$db);
        echo"Vars table<br><br>";

        echo"Inserting default values<br>";

$sql = "INSERT INTO $newstable (news) VALUES ('Welcome to WebLeague<br><br>WebLeague is an automated 

league system, that makes organizing an online league a piece of cake.<br><br>To put your own news here, 

go to the news section in your admin panel<br><br>Have fun using WebLeague')";
       

mysql_query($sql,$db);
        echo"Inserting news<br>";

$sql = "INSERT INTO $rulestable (rules) VALUES ('Insert your rules by going to the rules section in the 

admin panel')";
       

mysql_query($sql,$db);
        echo"Inserting rules<br>";

$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('blue','#0080FF','#000066', '#FFFFFF', 

'#000099', '/themes/blue/aim.jpg', '/themes/blue/bottomleft.jpg', '/themes/blue/bottommiddle.jpg', 

'/themes/blue/bottomright.jpg', '/themes/blue/headerbg.jpg', '/themes/blue/headermenuleft.jpg', 

'/themes/blue/headermenuright.jpg', '/themes/blue/sideleft.jpg', '/themes/blue/sideright.jpg', 

'/themes/blue/topleft.jpg', '/themes/blue/topmiddle.jpg', '/themes/blue/topright.jpg')";

mysql_query($sql,$db);
$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('blue2','#66809A','#29293D', '#FFFFFF', 

'#444466', '/themes/blue2/aim.jpg', '/themes/blue2/bottomleft.jpg', '/themes/blue2/bottommiddle.jpg', 

'/themes/blue2/bottomright.jpg', '/themes/blue2/headerbg.jpg', '/themes/blue2/headermenuleft.jpg', 

'/themes/blue2/headermenuright.jpg', '/themes/blue2/sideleft.jpg', '/themes/blue2/sideright.jpg', 

'/themes/blue2/topleft.jpg', '/themes/blue2/topmiddle.jpg', '/themes/blue2/topright.jpg')";

mysql_query($sql,$db);
$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('red','#FF0000','#660000', '#FFFFFF', 

'#990000', '/themes/red/aim.jpg', '/themes/red/bottomleft.jpg', '/themes/red/bottommiddle.jpg', 

'/themes/red/bottomright.jpg', '/themes/red/headerbg.jpg', '/themes/red/headermenuleft.jpg', 

'/themes/red/headermenuright.jpg', '/themes/red/sideleft.jpg', '/themes/red/sideright.jpg', 

'/themes/red/topleft.jpg', '/themes/red/topmiddle.jpg', '/themes/red/topright.jpg')";

mysql_query($sql,$db);
$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('red2','#9A666C','#3D2929', '#FFFFFF', 

'#664444', '/themes/red2/aim.jpg', '/themes/red2/bottomleft.jpg', '/themes/red2/bottommiddle.jpg', 

'/themes/red2/bottomright.jpg', '/themes/red2/headerbg.jpg', '/themes/red2/headermenuleft.jpg', 

'/themes/red2/headermenuright.jpg', '/themes/red2/sideleft.jpg', '/themes/red2/sideright.jpg', 

'/themes/red2/topleft.jpg', '/themes/red2/topmiddle.jpg', '/themes/red2/topright.jpg')";

mysql_query($sql,$db);
$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('green','#00FF00','#006600', '#FFFFFF', 

'#009900', '/themes/green/aim.jpg', '/themes/green/bottomleft.jpg', '/themes/green/bottommiddle.jpg', 

'/themes/green/bottomright.jpg', '/themes/green/headerbg.jpg', '/themes/green/headermenuleft.jpg', 

'/themes/green/headermenuright.jpg', '/themes/green/sideleft.jpg', '/themes/green/sideright.jpg', 

'/themes/green/topleft.jpg', '/themes/green/topmiddle.jpg', '/themes/green/topright.jpg')";

mysql_query($sql,$db);
$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('green2','#6C9A66','#2D3D29', '#FFFFFF', 

'#446644', '/themes/green2/aim.jpg', '/themes/green2/bottomleft.jpg', '/themes/green2/bottommiddle.jpg', 

'/themes/green2/bottomright.jpg', '/themes/green2/headerbg.jpg', '/themes/green2/headermenuleft.jpg', 

'/themes/green2/headermenuright.jpg', '/themes/green2/sideleft.jpg', '/themes/green2/sideright.jpg', 

'/themes/green2/topleft.jpg', '/themes/green2/topmiddle.jpg', '/themes/green2/topright.jpg')";

mysql_query($sql,$db);
$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('orange','#FF8000','#662200', '#FFFFFF', 

'#994000', '/themes/orange/aim.jpg', '/themes/orange/bottomleft.jpg', '/themes/orange/bottommiddle.jpg', 

'/themes/orange/bottomright.jpg', '/themes/orange/headerbg.jpg', '/themes/orange/headermenuleft.jpg', 

'/themes/orange/headermenuright.jpg', '/themes/orange/sideleft.jpg', '/themes/orange/sideright.jpg', 

'/themes/orange/topleft.jpg', '/themes/orange/topmiddle.jpg', '/themes/orange/topright.jpg')";

mysql_query($sql,$db);
$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('orange2','#9A7E66','#3D3129', '#FFFFFF', 

'#664444', '/themes/orange2/aim.jpg', '/themes/orange2/bottomleft.jpg', 

'/themes/orange2/bottommiddle.jpg', '/themes/orange2/bottomright.jpg', '/themes/orange2/headerbg.jpg', 

'/themes/orange2/headermenuleft.jpg', '/themes/orange2/headermenuright.jpg', 

'/themes/orange2/sideleft.jpg', '/themes/orange2/sideright.jpg', '/themes/orange2/topleft.jpg', 

'/themes/orange2/topmiddle.jpg', '/themes/orange2/topright.jpg')";

mysql_query($sql,$db);
$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('purple','#9900FF','#330066', '#FFFFFF', 

'#660099', '/themes/purple/aim.jpg', '/themes/purple/bottomleft.jpg', '/themes/purple/bottommiddle.jpg', 

'/themes/purple/bottomright.jpg', '/themes/purple/headerbg.jpg', '/themes/purple/headermenuleft.jpg', 

'/themes/purple/headermenuright.jpg', '/themes/purple/sideleft.jpg', '/themes/purple/sideright.jpg', 

'/themes/purple/topleft.jpg', '/themes/purple/topmiddle.jpg', '/themes/purple/topright.jpg')";

mysql_query($sql,$db);
$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('purple2','#83669A','#32293D', '#FFFFFF', 

'#664466', '/themes/purple2/aim.jpg', '/themes/purple2/bottomleft.jpg', 

'/themes/purple2/bottommiddle.jpg', '/themes/purple2/bottomright.jpg', '/themes/purple2/headerbg.jpg', 

'/themes/purple2/headermenuleft.jpg', '/themes/purple2/headermenuright.jpg', 

'/themes/purple2/sideleft.jpg', '/themes/purple2/sideright.jpg', '/themes/purple2/topleft.jpg', 

'/themes/purple2/topmiddle.jpg', '/themes/purple2/topright.jpg')";

mysql_query($sql,$db);
$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('black','#666666','#000000', '#FFFFFF', 

'#999999', '/themes/black/aim.jpg', '/themes/black/bottomleft.jpg', '/themes/black/bottommiddle.jpg', 

'/themes/black/bottomright.jpg', '/themes/black/headerbg.jpg', '/themes/black/headermenuleft.jpg', 

'/themes/black/headermenuright.jpg', '/themes/black/sideleft.jpg', '/themes/black/sideright.jpg', 

'/themes/black/topleft.jpg', '/themes/black/topmiddle.jpg', '/themes/black/topright.jpg')";

mysql_query($sql,$db);
$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('yellow','#FFEF00','#635200', '#FFFFFF', 

'#999900', '/themes/yellow/aim.jpg', '/themes/yellow/bottomleft.jpg', '/themes/yellow/bottommiddle.jpg', 

'/themes/yellow/bottomright.jpg', '/themes/yellow/headerbg.jpg', '/themes/yellow/headermenuleft.jpg', 

'/themes/yellow/headermenuright.jpg', '/themes/yellow/sideleft.jpg', '/themes/yellow/sideright.jpg', 

'/themes/yellow/topleft.jpg', '/themes/yellow/topmiddle.jpg', '/themes/yellow/topright.jpg')";

mysql_query($sql,$db);
$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('yellow2','#9A9666','#3D3A29', '#FFFFFF', 

'#666644', '/themes/yellow2/aim.jpg', '/themes/yellow2/bottomleft.jpg', 

'/themes/yellow2/bottommiddle.jpg', '/themes/yellow2/bottomright.jpg', '/themes/yellow2/headerbg.jpg', 

'/themes/yellow2/headermenuleft.jpg', '/themes/yellow2/headermenuright.jpg', 

'/themes/yellow2/sideleft.jpg', '/themes/yellow2/sideright.jpg', '/themes/yellow2/topleft.jpg', 

'/themes/yellow2/topmiddle.jpg', '/themes/yellow2/topright.jpg')";

mysql_query($sql,$db);
$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('pink','#FF00EF','#660066', '#FFFFFF', 

'#990099', '/themes/pink/aim.jpg', '/themes/pink/bottomleft.jpg', '/themes/pink/bottommiddle.jpg', 

'/themes/pink/bottomright.jpg', '/themes/pink/headerbg.jpg', '/themes/pink/headermenuleft.jpg', 

'/themes/pink/headermenuright.jpg', '/themes/pink/sideleft.jpg', '/themes/pink/sideright.jpg', 

'/themes/pink/topleft.jpg', '/themes/pink/topmiddle.jpg', '/themes/pink/topright.jpg')";

mysql_query($sql,$db);
$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('pink2','#9A6696','#3C293D', '#FFFFFF', 

'#664466', '/themes/pink2/aim.jpg', '/themes/pink2/bottomleft.jpg', '/themes/pink2/bottommiddle.jpg', 

'/themes/pink2/bottomright.jpg', '/themes/pink2/headerbg.jpg', '/themes/pink2/headermenuleft.jpg', 

'/themes/pink2/headermenuright.jpg', '/themes/pink2/sideleft.jpg', '/themes/pink2/sideright.jpg', 

'/themes/pink2/topleft.jpg', '/themes/pink2/topmiddle.jpg', '/themes/pink2/topright.jpg')";

mysql_query($sql,$db);
$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('greenblue','#00FFEA','#006654', '#FFFFFF', 

'#009999', '/themes/greenblue/aim.jpg', '/themes/greenblue/bottomleft.jpg', 

'/themes/greenblue/bottommiddle.jpg', '/themes/greenblue/bottomright.jpg', 

'/themes/greenblue/headerbg.jpg', '/themes/greenblue/headermenuleft.jpg', 

'/themes/greenblue/headermenuright.jpg', '/themes/greenblue/sideleft.jpg', 

'/themes/greenblue/sideright.jpg', '/themes/greenblue/topleft.jpg', '/themes/greenblue/topmiddle.jpg', 

'/themes/greenblue/topright.jpg')";

mysql_query($sql,$db);
$sql = "INSERT INTO $themestable (name, color1, color2, color3, color4, aimthemepic, bottomleftpic, 

bottommiddlepic, bottomrightpic, headerbgpic, headermenuleftpic, headermenurightpic, sideleftpic, 

siderightpic, topleftpic, topmiddlepic, toprightpic) VALUES ('greenblue2','#679B97','#293D39', '#FFFFFF', 

'#446666', '/themes/greenblue2/aim.jpg', '/themes/greenblue2/bottomleft.jpg', 

'/themes/greenblue2/bottommiddle.jpg', '/themes/greenblue2/bottomright.jpg', 

'/themes/greenblue2/headerbg.jpg', '/themes/greenblue2/headermenuleft.jpg', 

'/themes/greenblue2/headermenuright.jpg', '/themes/greenblue2/sideleft.jpg', 

'/themes/greenblue2/sideright.jpg', '/themes/greenblue2/topleft.jpg', '/themes/greenblue2/topmiddle.jpg', 

'/themes/greenblue2/topright.jpg')";

mysql_query($sql,$db);
        echo"Inserting themes<br>";

$sql = "INSERT INTO $varstable (theme, font, fontcolor, headerfont, numgamespage, numplayerspage, 

statsview, stats1view, stats2view, stats3view, stats4view, stats5view, stats6view, stats7view, statsnum, 

rulesview, standingsnogames, pctnum, hotcoldnum, gamesmaxday) VALUES ('blue','Arial', '#FFFFFF', 'Arial 

Black', '20', '30', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', '10', 'yes', 'no', '10', '5', 

'2')";
       

mysql_query($sql,$db);
        echo"Inserting vars<br><br>";

echo"Done.";
?>




Once again... it says its done when i execute the code in the browser but is not inserting anything into my database.

Weird...

if (($update_avatar1 == 'http://images.toxicpets.co.cc/vPets/Acara11.gif') OR ($update_avatar1 == 'http://images.toxicpets.co.cc/vPets/Aisha5.gif'))
{
mysql_query("UPDATE avatar SET avatar = '$update_avatar1' WHERE username = '$username' AND game = '$game'") or die ("Database error: ".mysql_error());
mysql_query("INSERT INTO avatar ($update_avatar1 WHERE id = '$userid')");

This is an avatar System But It Is Not Inserting Into The Database

Hi there I have a problem here, I think I may know what it is but just wanted some guidance on this issue.

I took the logic from a previous help from the people on this forum and here is my landing page:

<?php
// ini_set("display_errors", 1);

// randomly starts a session!

session_name("jeremyBasicLogin");
session_start();

if(isset($_SESSION['username']))  {

// display whatever when the user is logged in:

echo <<<ADDENTRY

<html>
<head>
<title>User is now signed in:<title>
</head>

<body>
<h1>You are now signed in!</h1>
<p>You can do now what you want to do!</p>
</body>
</html>
ADDENTRY;

} else {
// If anything else dont allow access and send back to original page!

header("location: signin.php");

}
?>


This is where the user goes to when they go to this system (not a functional system, ie it doesnt actually do anything its more for my own theory.

As you wont have a session on the first turn to this page it goes to:

signin.php which contains:
<?php
// ini_set("display_errors", 1);

require_once('func.db.connect.php');

if(array_key_exists('submit',$_POST)) {

dbConnect(); // connect to database anyways!

// Do a procedure to log the user in:

// Santize User Inputs
$username = trim(stripslashes(mysql_real_escape_string($_POST['username']))); // cleans up with PHP first!
$password = trim(stripslashes(mysql_real_escape_string(md5($_POST['password'])))); // cleans up with PHP first!

$sql = "SELECT * FROM users WHERE username='$username' AND password='$password'";
$result = mysql_query($sql);

if(mysql_num_rows($result) == 1) {

session_name("jeremyBasicLogin");
session_start();
$_SESSION['is_logged_in'] = true;
$_SESSION['username'] = $username;
//print_r($_SESSION);  // debug purposes only!
$_SESSION['time_loggedin'] = time(); // this is adding to the array (have seen the output in the SESSION vars!

// call function to update the time stamp in MySQL?


header("location: index.php");

} else if(mysql_num_rows($result) != 1) {
$message = "You typed the wrong password or Username Please retry!";
}
} else {
$message = "";
}
// displays the login page:
echo <<<LOGIN
<html>
<body>
<h1>Example Login</h1>

<form id="login" name="login" action="{$_SERVER['PHP_SELF']}" method="post">
<label for="username">Username: </label><input type="text" id="username" name="username" value="" /><br>
<label for="password">Password: </label><input type="text" id="password" name="password" value="" /><br>
<input type="submit" id="submit" name="submit" value="Login" />
</form>
LOGIN;
echo "<p>" . $message . "</p>";
echo <<<LOGIN

<p>Please Login to View and Edit Your Entries</p>
<p><a href="register.php">Click Here To Signup</a><p>
</body>
</html>
LOGIN;
?>


This checks through user inputs and hopefully logs them in, when Ive inserted the data into the database itself it works, if I try and login but if a user fills in this form:

signup.php:

<?php
//ini_set("display_errors", 1);

$message ='';

require_once('func.db.connect.php');

if(array_key_exists('submit',$_POST)) {

dbConnect(); // connect to database anyways!

// do some safe protecting of the users variables, apply it to all details!
$username = trim(stripslashes(mysql_real_escape_string($_POST['username']))); // cleans up with PHP first!
$email = trim(stripslashes(mysql_real_escape_string($_POST['email']))); // cleans up with PHP first!
$password = trim(stripslashes(mysql_real_escape_string(md5($_POST['password'])))); // does as above but also encrypts it using the md5 function!
$password2 = trim(stripslashes(mysql_real_escape_string(md5($_POST['password2'])))); // does as above but also encrypts it using the md5 function!

if($username != '' && $email != '' && $password != '' && $password2 != '') {
// do whatever when not = to nothing/empty fields!

if($password === $password2) {
// do database stuff to enter users details

$sql = "INSERT INTO `test`.`users` (`id` ,`username` ,`password`) VALUES ('' , '$username', MD5( '$password' ));";
$result = mysql_query($sql);
if($result) {
$message = 'You may now login by clicking <a href="index.php">here</a>';
}

} else {
// echo out a user message says they got their 2 passwords incorrectly typed:
$message = 'Pleae re enter your password';
}

} else {
// they where obviously where empty
$message = 'You missed out some required fields, please try again';
}

}

echo <<<REGISTER

<html>
<body>
<h1>Register Form</h1>
<p>Please fill in this form to register</p>
<form id="register" name="register" action="{$_SERVER['PHP_SELF']}" method="post">

<table>
<tr>
<td><label for="username">Username: </label></td>
<td><input type="text" id="username" name="username" value="" /></td>
</tr>

<tr>
<td><label for="email">Email: </label></td>
<td><input type="text" id="email" name="email" value="" /></td>
</tr>

<tr>
<td><label for="password">Password: </label></td>
<td><input type="text" id="password" name="password" value="" /></td>
</tr>

<tr>
<td><label for="password">Confirm Password: </label></td>
<td><input type="text" id="password2" name="password2" value="" /></td>
</tr>

<tr>
<td><input type="submit" id="submit" name="submit" value="Register" /></td>
</tr>

<table>

REGISTER;
echo "<p>" . $message . "</p>";
echo <<<REGISTER

</form>
</body>
</html>
REGISTER;
?>


As I said when the user signs up when submitting the above form, it doesnt work, keeps coming up with a different value for the password, so I am about 99% certain its the password, but I have been maticulous about copying in the sanitize function for SQL injections and it just doesnt still work, really puzzled now.

Any helps appreciated,
Jeremy.

Hey all Im working on an assignment for school and currently I am trying to inser the variable $uid which currently = 2..
But for someone reason when the post happens it inserts a 0 instead of a 2.

Here is my insert
Code: [Select]
mysql_query( "INSERT INTO blog_posts (title, post, author_id, date_posted) ". "VALUES ('$btitle', '$bpost', '$uid', CURDATE())" );

im trying to write a script takes an xml files with tv show info, splits it into the show and the eppisode info and the place it into a table, i have got it to proccess all the info and print it out on a web page, but i cant, for the life of me, get it to insert said data into the table, it seems to be just ignoring the code and prints out the data as if nothing happens, no errors or anything. here is my code (abit messy but im only just starting and its my test.php)

Code: [Select]
<?php
$tvdb_mirror = "http://www.thetvdb.com/api/";
$tvdb_time = "http://www.thetvdb.com/api/Updates.php?type=none";
$dbname = "mediadb";
$dbuser = "root";
$dbpass = "";
$dbserv = "127.0.0.1";

$rss = simplexml_load_file('sample.xml');

$showName = "Show Name = ".$rss->Series->SeriesName;
print $showName;
print "<br />Show Discription = ".$rss->Series->Overview;
print "<br />";

mysql_connect('127.0.0.1', 'root', '');
@mysql_select_db('mediadb') or die("Unable to select database");

foreach ($rss->Episode as $item) {
$seasonnum = $item->Combined_season;
$EpisodeNumber = $item->EpisodeNumber;
 if($EpisodeNumber < 10){
$EpisodeNumber = "0".$EpisodeNumber;
 };
$EpisodeName = $item->EpisodeName;
$Overview = $item->Overview;
$airdate = $item->FirstAired;
$tvdbid = $item ->id;

$query = "INSERT INTO eppisodes VALUES('', '1', ".$EpisodeName.", ".$Overview.", ".$airdate.", '1', ".$tvdbid.", '-1', ".$seasonnum.", ".$EpisodeNumber.")";
mysql_query($query);

print "<br />".$showName." - ".$seasonnum."x".$EpisodeNumber." - ".$EpisodeName." Overview:<br />".$Overview;
}
mysql_close();
?>
i am a noob @ php and mysql, but i have doubke and triple checked the names of the db and table.

here is an sql dump of my db
Code: [Select]
-- phpMyAdmin SQL Dump
-- version 3.3.5
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Nov 13, 2010 at 12:48 PM
-- Server version: 5.1.49
-- PHP Version: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `mediadb`
--

-- --------------------------------------------------------

--
-- Table structure for table `eppisodes`
--

CREATE TABLE IF NOT EXISTS `eppisodes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `showID` int(11) NOT NULL,
  `eppname` varchar(255) NOT NULL,
  `eppdesc` longtext NOT NULL,
  `airdate` date NOT NULL,
  `format` int(11) NOT NULL,
  `tvdbid` varchar(20) NOT NULL,
  `dohave` tinyint(1) NOT NULL,
  `season` varchar(2) NOT NULL,
  `eppisode` varchar(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `eppisodes`
--


-- --------------------------------------------------------

--
-- Table structure for table `shows`
--

CREATE TABLE IF NOT EXISTS `shows` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `TVDBID` int(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `shows`
--

INSERT INTO `shows` (`id`, `name`, `description`, `TVDBID`) VALUES
(1, 'higogo', 'some info', 67546);

any help would be very much appericiated.

fyi im running win7 with easyPHP 5.3.3 with php 5.3.3, mysql 5.1.49 apache 2.2.16

Hi, first time poster here. Pretty new to PHP.

Yesterday my PHP code was inserting into my MySQL database fine and as of today it isn't inserting anything into the database.

Is there any common error in my PHP code that i'm forgetting?

I'm using XAMPP.

I think I may be posting in the wrong area.

Also any pointers on my code would be appreciated.

Below is my code:
<html>
<head>
<title> Sign up! </title>
</head>
<body>
<form id = "signup"  method = "post" action = "<?php echo $_SERVER['PHP_SELF'];?>" onsubmit= "return formValidator()">
Please enter your name:
<input type = "text" id = "name">
<br />
Please enter the password you would like:
<input type ="password" id = "password"/>
<br />
Please enter your Date Of Birth :
<select type ="text" size = "1" id = "dayofbirth"/>
<option value = "1"> 01 </option>
<option value = "2"> 02 </option>
<option value = "3"> 03 </option>
<option value = "4"> 04 </option>
<option value = "5"> 05 </option>
<option value = "6"> 06 </option>
<option value = "7"> 07 </option>
<option value = "8"> 08 </option>
<option value = "9"> 09 </option>
<option value = "10"> 10 </option>
<option value = "11"> 11 </option>
<option value = "12"> 12 </option>
<option value = "13"> 13 </option>
<option value = "14"> 14 </option>
<option value = "15"> 15 </option>
<option value = "16"> 16 </option>
<option value = "17"> 17 </option>
<option value = "18"> 18 </option>
<option value = "19"> 19 </option>
<option value = "20"> 20 </option>
<option value = "21"> 21 </option>
<option value = "22"> 22 </option>
<option value = "23"> 23 </option>
<option value = "24"> 24 </option>
<option value = "25"> 25 </option>
<option value = "26"> 26 </option>
<option value = "27"> 27 </option>
<option value = "28"> 28 </option>
<option value = "29"> 29 </option>
<option value = "30"> 30 </option>
<option value = "31"> 31 </option>
</select>
<select type ="text" size = "1" id = "monthofbirth"/>
<option value = "1">January</option>
<option value = "2">February</option>
<option value = "3">March</option>
<option value = "4">April</option>
<option value = "5">May</option>
<option value = "6">June</option>
<option value = "7">July</option>
<option value = "8">August</option>
<option value = "9">September</option>
<option value = "10">October</option>
<option value = "11">November</option>
<option value = "12">December</option>
</select>

<select type ="text" size = "1" id = "yearofbirth"/>
<option value = "1994">1994</option>
<option value = "1993">1993</option>
<option value = "1992">1992</option>
<option value = "1991">1991</option>
<option value = "1990">1990</option>
<option value = "1989">1989</option>
<option value = "1988">1988</option>
<option value = "1987">1987</option>
<option value = "1986">1986</option>
<option value = "1985">1985</option>
<option value = "1984">1984</option>
<option value = "1983">1983</option>
<option value = "1982">1982</option>
<option value = "1981">1981</option>
<option value = "1980">1980</option>
<option value = "1979">1979</option>
<option value = "1978">1978</option>
<option value = "1977">1977</option>
<option value = "1976">1976</option>
<option value = "1975">1975</option>
<option value = "1974">1974</option>
<option value = "1973">1973</option>
<option value = "1972">1972</option>
<option value = "1971">1971</option>
<option value = "1970">1970</option>
<option value = "1969">1969</option>
<option value = "1968">1968</option>
<option value = "1967">1967</option>
<option value = "1966">1966</option>
<option value = "1965">1965</option>
<option value = "1964">1964</option>
<option value = "1963">1963</option>
<option value = "1962">1962</option>
<option value = "1961">1961</option>
<option value = "1960">1960</option>
<option value = "1959">1959</option>
<option value = "1958">1958</option>
<option value = "1957">1957</option>
<option value = "1956">1956</option>
<option value = "1955">1955</option>
<option value = "1954">1954</option>
<option value = "1953">1953</option>
<option value = "1952">1952</option>
<option value = "1951">1951</option>

</select>
<br />
Please enter your e-mail address:
<input type ="text" id = "email"/>
<br />
Please enter your address:
<input type ="text" id = "address"/>
<br />
Please enter your city:
<input type ="text" id = "city"/>
<br />
Please enter your postcode
<input type ="text" id = "postcode"/>
<br />
Please enter your telephone number:
<input type ="text" id = "telephoneno"/>
<br />
<input type= "submit" id = "submit" value ="Submit me!"/>
</body>
<?php
$conn = mysql_connect("localhost", "root", "") or die("cannot connect server "); 
mysql_select_db("nightsout") or die ("cannot find database");

if(isset($_POST['submit']))
{
$username = $_POST['name'];
$password = $_POST['password'];
$day = $_POST['dayofbirth'];
$month = $_POST['monthofbirth'];
$year = $_POST['yearofbirth'];
$date = ($year.'-'.$month.'-'.$day);
$email = $_POST['email'];
$address = $_POST['address'];
$city = $_POST['city'];
$postcode = $_POST['postcode'];
$telephoneno = $_POST['telephoneno'];
$duplicate = mysql_query("SELECT * FROM users WHERE emailaddress = '$email'", $conn) or die('Cannot Execute:'. mysql_error());
if(mysql_num_rows($duplicate) == 0) 
{
mysql_query("INSERT INTO users (username, password, DOB, emailaddress,  address, city, postcode, telephonenumber) 
VALUES ('{$username}', '{$password}', '{$date}', '{$email}' ,'{$address}', '{$city}', '{$postcode}', '{$telephoneno}')");
}else if(mysql_num_rows($duplicate) > '1')
{
?>
<p>This E-mail address already exists please use another one or <a href="home.php">Login.</a> </p>
<?php
}
}

mysql_close($conn);
?>

Many thanks.

Hi guys,

I am building a website with basic e-commerce functionality, using php and using xampp to test it.
I am having issues when attempting to submit a quantity (into table orders) using a form and validating it against an existing value (from table products), giving a response on whether there is sufficient quantity in the second table. I am then, in another page (same one performing the validations), attempting to then show a result based on the initial quantity entered, with a summary of the order details and calculation of the quantity * price to display a total as well. This has all been built from scratch, however I may have taken the wrong approach for these two pages... any assistance or insight as to where I am going wrong would be greatly appreciated.


Here is the page I have placed the products, existing quantity and a text field they are able to enter their desired quantity:

Code: [Select]
<?php
session_start();
require_once "../database/db.php";
require_once "../includes/functions.php";

$page_title = 'Product Catalogue';
include_once "header.php";

$conn = mysqli_connect ($dbhost, $dbuser, $dbpassword, $dbname);

$query = "SELECT * from products";

$result = mysqli_query($conn, $query);

if (!$result)
{
include_once "header.php";
die ("Error, could not query the database");
}

else 
{ $rows = mysqli_num_rows($result);

if ($rows>0)
{

while ($row = mysqli_fetch_array($result))
{
?>
<form>
                <br />
                <br />
                <br />
                <table>
                <tr>
                <td style="width: 200px">Product Code:</td>
                <td><?php echo $row['ProductCode']; ?></td>
                </tr>
                <tr>
                <td>Product Name:</td>
                <td><?php echo $row['ProductName']; ?></td>
                </tr>
                <tr>
                <td>Product Description:</td>
                <td><?php echo $row['ProductDescription']; ?></td>
                </tr>
                <tr>
                <td>Product Colour:</td>
                <td><?php echo $row['ProductColour']; ?></td>
                </tr>
                <tr>
                <td>Product Price:</td>
                <td>$<?php echo number_format($row['ProductPrice'],2); ?></td>
                </tr>
                <tr>
                <td>Product Image:</td>
                <td><img src="<?php echo $row['ProductImagePath']?>"/></td>
                </tr>
                <tr>
                <td>Quantity in Stock:</td>
                <td><?php echo $row['ProductQuantity']; ?></td>
                </tr>
                </table>
                </form>
                <form method="post"action="processQuantity.php">
                <table>
                <tr>
                <td style="width: 200px">Quantity:</td>
                <td><input type="number" name="Quantity" id="Quantity" value="<?php if (isset ($quantity)) echo $quantity; ?>"size = "20" /></td>
                <td><input type="submit" name="Purchase" value= "Purchase" /></td>
                </tr>
                </table>
                </form>
                <hr />
                <?php
}
include "footer.html";
}
}
?>
Here is the page that I am using to validate the data as well as show a result based on the entered amount:

Code: [Select]
<?php

session_start();

require_once "../includes/functions.php";
require_once "../database/db.php";

$quantity = $_POST['Quantity'];
$productquantity = $_POST['ProductQuantity'];
$orderid = $_POST['orderid'];
$productcode = $_POST['productcode'];
$productprice = $_POST['productprice'];
$total = $quantity * $productprice;

$error_message = '';

if ($error_message != '')
{
include_once "displayCatalogue-PlaceOrder.php";
exit();

$conn = mysqli_connect ($dbhost, $dbuser, $dbpassword, $dbname);

if (!$conn)
{
echo "Error";
}
else
{
//sanitise date
$scustomerid = sanitiseMySQL($customerid);
$sproductcode = sanitiseMySQL($productcode);
$squantity = sanitiseMySQL($quantity);
$sproductprice = sanitiseMySQL($productprice);
$sorderdate = sanitiseMySQL($orderdate);

$query = "select productquantity from products where productcode = '$sproductcode'";

$result = msqli_query ($conn, $query);

$productquantity = mysqli_num_rows($result);

if ($quantity < $productquantity)
{
$error_message = "You cannot order more than what is currently instock";
include_once "displayCatalogue-PlaceOrder.php";
exit ();
}
else
{
$row = mysqli_fetch_row($result);

$query = "INSERT into orders (customerid, productcode, quantity, productprice, orderdate) values ('$scustomerid', $sproductcode', '$squantity', '$sproductprice', '$sorderdate')";

$result = mysqli_query($conn, $query);

$row = mysqli_affected_rows($conn);

if ($row > 0)
{
include "header.php";?>
            <h3>Order Confirmation</h3>
            <p>Thank you, your order is now being processed.</p>
                <table>
<tr>
<td style="width: 200px">Order Number:</td>
                <td><?php echo $orderid; ?></td>
                </tr>
                <tr>
                <td>Product Code:</td>
                <td><?php echo $productcode; ?></td>
                </tr><tr>
                <td>Quantity:</td>
                <td><?php echo $quantity; ?></td>
                </tr>
                <tr>
                <td>Price:</td>
                <td><?php echo $productPrice; ?></td>
                </tr>
                <tr>
                <td>Total Cost of Order:</td>
                <td><?php echo $total; ?></td>
                </tr>
                </table>

                <?php
include "footer.html";
}
else
{
$error_message ="Error placing your order, please try again";
include "displayCatalogue-PlaceOrder.php";
exit();
}
}
}
}
//this is used to validate the quantity entered against what is available in the database
?>