|
PHP - Date Function Doesnt Insert Into The Database
i have been trying to insert date with when users post there comment but when i echo the date() with the comments..it just display 0000.00.00.00 just like that and when i checked my DB it was like that too..please what can i do.this is my code
Thankd in advance Code: [Select] <?php include"header.php"; if(isset($_POST['submit'])) { $postdate=mktime(0,0,0,date("m"),date("d")+1,date("y")); $comment=mysql_real_escape_string($_POST['comment']); if($comment!=='') { $ins="INSERT INTO post(post_content,post_date)VALUES('$comment','$postdate')"; mysql_query($ins) or die(mysql_error()); } else { echo"You can not post an empty page"; } } Similar TutorialsHi I have started my error checking for my form. I am understand that the date must be inserted in the format yyyy/mm/dd but on my form i need it to be inserted in the format dd/mm/yyyy. I have wrote some code but have only been doing php about a week properly so I can't see what my error is. Whenever I try to insert the date, the form its self does not error but if i check the database the date is simply 0000/00/00. Can anyone help? if(isset($_POST['submit'])) { $first_name = mysql_real_escape_string($_POST['first_name']); $last_name = mysql_real_escape_string($_POST['last_name']); $DOB = mysql_real_escape_string($_POST['DOB']); $sex = mysql_real_escape_string($_POST['sex']); $email = mysql_real_escape_string($_POST['email']); $username = mysql_real_escape_string($_POST['username']); $password = mysql_real_escape_string($_POST['password']); $agree = mysql_real_escape_string($_POST['agreed']); $creation_date = mysql_real_escape_string($_POST['creation_date']); $user_type = mysql_real_escape_string($_POST['member_type']); $access_level = mysql_real_escape_string($_POST['access_level']); $validation = mysql_real_escape_string($_POST['validation_id']); $club_user = mysql_real_escape_string($_POST['user_type']); $date_check = "/^([0-9]{2})/([0-9]{2})/([0-9]{4})$/"; if($first_name == "") { $message = "Please enter a first name"; $success = 0; } else if($last_name == "") { $message = "Please enter a surname"; $success = 0; } else if($DOB =="") { $message = "Please enter your date of birth."; $success = 0; } else if(!(preg_match("/^([0-9]{2})\/([0-9]{2})\/([0-9]{4})$/", $DOB))) { $message = "Please enter your birthday in the format dd/mm/yyyy"; $success = 0; } else if($email =="") { $message = "Please enter a correct email."; $success = 0; } else if($username =="") { $message = "Please enter a username."; $success = 0; } else if($password =="") { $message = "Please enter a password greater than 6 characters long."; $success = 0; } else { $DOB = $explode[2]."-".$explode[1]."-".$explode[0]; $password_md5 = md5($password); $insert_member= "INSERT INTO Members (`first_name`,`last_name`,`DOB`,`sex`,`email`,`username`,`password`,`agree`,`creation_date`,`usertype`,`access_level`,`validationID`) VALUES ('".$first_name."','".$last_name."','".$DOB."','".$sex."','".$email."','".$username."','".$password_md5."','".$agree."','".$creation_date."','".$user_type."','".$access_level."', '".$validation."')"; $insert_member_now= mysql_query($insert_member) or die(mysql_error()); $url = "thankyou.php?name=".$_POST['username']; header('Location: '.$url); hi there..im new to php mysql and im having trouble inserting a string data to mysql from a php date() function. here's my code: Code: [Select] $year = date('Y'); echo $year; $insertSQL = sprintf("INSERT INTO tbl_elections (election_id=$year)"); mysql_select_db($database_organizazone_db, $organizazone_db); $Result1 = mysql_query($insertSQL, $organizazone_db) or die(mysql_error()); when i try to output the $year variable on a webpage, it returns "2012" but when i try to insert this data into my database table, it returns an error like this: check the manual that corresponds to your MySQL server version for the right syntax to use near '=2012)' is there a way to convert "2012" into a normal string data type? HI, according to my knowledge session_destroy() function would destroy all session variables and mysql_close() would close connection with the database. i make a simply logoff.php file and close myssql connection and destroy session. but i still get values from the database and session variables. and doesnt work properly here is the code Code: [Select] <?php session_start(); /* * To change this template, choose Tools | Templates * and open the template in the editor. */ require_once '../database/db_connecting.php'; $dbname="sahansevena";//set database name $con= setConnections();//make connections use implemented methode in db_connectiong.php mysql_select_db($dbname, $con); //update the time and date of the admin table $update_time="update admin set last_logged_date =CURDATE(), last_log_time=CURTIME() where username='$uname'limit 3,4"; //my admin table contain 5 colums they are id, username,password, last_logged_date, last_log_time $link= mysql_query($update_time); // mysql_select_db($dbname, $link); //$con=mysql_connect('localhost', 'root','ijts'); $result="select * from admin where username='a'"; $result=mysql_query($result); mysql_close($con); //here i just check after closing data baseconnection whether i do get reselts but i do, why? echo "after the cnnection was closed"; echo "<html>"; echo "<table border='1' cellspacing='1' cellpadding='2' align='center'>"; echo "<thead>"; echo"<tr>"; echo "<th>"; echo ID; echo"</th>"; echo" <th>";echo Username; echo"</th>"; echo"<th>";echo Password; echo"</th>"; echo"<th>";echo Last_logged_date; echo "</th>"; echo "<th>";echo Last_logged_time; echo "</th>"; echo" </tr>"; echo" </thead>"; echo" <tbody>"; while($row= mysql_fetch_array($result,MYSQL_BOTH)){ echo "<tr>"; echo "<td>"; echo $row[0]; echo "</td>"; echo "<td>"; echo $row[1]; echo "</td>"; echo "<td>"; echo $row[2]; echo "</td>"; echo "<td>"; echo $row[3]; echo "</td>"; echo "<td>"; echo $row[4]; echo "</td>"; echo "</tr>"; } echo" </tbody>"; echo "</table>"; echo "</html>"; session_destroy(); session_commit(); echo "session and database are closed but i still get values".$_SESSION['admin']; ?> This topic has been moved to JavaScript Help. http://www.phpfreaks.com/forums/index.php?topic=351058.0 Hi, Currently I am making a module for joomla. every article has an publish date, if the article was published in 7 days ago, it will displayed as "article in last week", My idea is to use today's date - publish date, if the result is greater than 7 and smaller than 14, the article will be displayed as "article in last week. Any one know how to write this code? Here is what I have got, but not working. <?php $todays_date = date("Y-m-d"); $result = mysql_query("select * from jos_content where $test between $todays_date-14 and $todays_date-7"); while($row = mysql_fetch_array($result)) { echo "$todays_date - $row[title]"; } ?> I'm getting this Time Zone error. Perhaps it's a compatibility issue with PHP 5.3. Looked all over for an answer without finding one. Here is the error message Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /blocked.php on line 41 12/02/12 Here is the code. Line 41 is near the bottom, the one with the d,m,y. Perhaps the echo date (d/m/y") needs to be changed. Appreciate any help! Code: [Select] <table border="3" width="16%" align="center" cellspacing="0" bgcolor="#FF6600" bordercolor="red" bordercolordark="red" bordercolorlight="red"> <tr> <td width="176"> <p align="center"><?php // shows IP Number on Page echo $ip; ?> </p> </td> </tr> </table> <p align="center"><?php // Show the user agent echo 'Your user agent is: <b>'.$_SERVER['HTTP_USER_AGENT'].'</b><br />';?></p> [b]<h1 align="center"><?php echo date("d/m/y");?></h1>[/b] </td> </tr> </table [,code] hello I want query from one table and insert in another table on another domain . each database on one domain name. for example http://www.site.com $con1 and http://www.site1.com $con. can anyone help me? my code is : <?php $dbuser1 = "insert in this database"; $dbpass1 = "insert in this database"; $dbhost1 = "localhost"; $dbname1 = "insert in this database"; // Connecting, selecting database $con1 = mysql_connect($dbhost1, $dbuser1, $dbpass1) or die('Could not connect: ' . mysql_error()); mysql_select_db($dbname1) or die('Could not select database'); $dbuser = "query from this database"; $dbpass = "query from this database"; $dbhost = "localhost"; $dbname = "query from this database"; // Connecting, selecting database $con = mysql_connect($dbhost, $dbuser, $dbpass) or die('Could not connect: ' . mysql_error()); mysql_select_db($dbname) or die('Could not select database'); //query from database $query = mysql_query("SELECT * FROM `second_content` WHERE CHANGED =0 limit 0,1"); while($row=mysql_fetch_array($query)){ $result=$row[0]; $text=$row[1]."</br>Size:(".$row[4].")"; $alias=$row[2]; $link = '<a target="_blank" href='.$row[3].'>Download</a>'; echo $result; } //insert into database mysql_query("SET NAMES 'utf8'", $con1); $query3= " INSERT INTO `jos_content` (`id`, `title`, `alias`, `) VALUES (NULL, '".$result."', '".$alias."', '')"; if (!mysql_query($query3,$con1)) { die('Error: text add' . mysql_error()); } mysql_close($con); mysql_close($con1); ?> guys, im having a problem here thats making me crazy im making a system and i want to insert the current date in the mysql. I have the field called 'data' in the DB, but when i make the code to insert all the other fields, including the 'data', its work perfectly... unless that damn date! $query = "INSERT INTO news (id, titulo, mensagem, data) VALUES (NULL, '$titulo', '$mensagem', 'date(\"d/m/Y\")')"; whats wrong with that? its stores in DB as '0000-00-00'. Hi, new to php so please excuse the simplicity of my questions. I have a menu list that inserts data into a field, is it possible with php to insert a date into another field dpendent on value? For example: MenuList - Status1, Status, Status3 inserted into tblfieldStatus when selected 3 other fields in same table are Status1DateNow Status2DateNow Status3DateNow If a user selected Status2 from menu then Status2Date would be populated with the date today? Kind regards What I'm basically trying to accomplish is, that the datetime of the user posted information is registered with the Now() function in the query, BUT that the user entered information gets echo'd out with the Date showing ONLY. What I have is this: -Just as an example- INSERT INTO db (date_created) VALUES (now()) while ($row = mysqli_fetch_array($data)) { echo '<tr><td>' . $row['date_created'] . '</td></tr>'; } mysqli_close($dbc); With this way of course I get Date and Time showcased just like it's inserted into the DB. What would be a legit way of showcasing just date. Thanks for help. EDIT: or is there a better way than using now() to showcase the date when the user entered information was posted? I am trying to insert a date into a mySQL table from html drop downs with php. Right now when I enter the date it goes into the database as 0000-00-00. Can anybody see why it might be doing this? My html: Code: [Select] <label for='birthdate' >Birthdate (Optional):</label><br/> <select name='month' id='month' value='<?php echo $fgmembersite->SafeDisplay('month') ?>'> <option value="01" selected="January">January</option> <option value="02">February</option> <option value="03">March</option> etc... </select> <select name='day' id='day' value='<?php echo $fgmembersite->SafeDisplay('day') ?>'> <option value="01" selected="1">1</option> <option value="02">2</option> <option value="03">3</option> etc... </select> <select name='year' id='year' value='<?php echo $fgmembersite->SafeDisplay('year') ?>'> <option value="2010" selected="2010">2010</option> <option value="2009">2009</option> <option value="2008">2008</option> etc... </select> And my php to collect info: Code: [Select] $formvars['birthdate'] = $this->Sanitize($_POST['year'], $_POST['month'], $_POST['day']); php where I make table: Code: [Select] "birthdate DATE NOT NULL ,". php to insert into mysql: Code: [Select] $insert_query = 'insert into '.$this->tablename.'( name, address, birthdate, sex, program, guide, email, username, password, confirmcode ) values ( "' . $this->SanitizeForSQL($formvars['name']) . '", "' . $this->SanitizeForSQL($formvars['address']) . '", "' . $this->SanitizeForSQL($formvars['birthdate']) . '", "' . $this->SanitizeForSQL($formvars['sex']) . '", "' . $this->SanitizeForSQL($formvars['program']) . '", "' . $this->SanitizeForSQL($formvars['guide']) . '", "' . $this->SanitizeForSQL($formvars['email']) . '", "' . $this->SanitizeForSQL($formvars['username']) . '", "' . md5($formvars['password']) . '", "' . $confirmcode . '" )'; Thank you! Hi. Im searching for a way to enter multiple records at once to mysql databased on a date range. Lets say i want to insert from date 2010-11-23 to date 2010-11-25 a textbox with some info and the outcome could look in database like below. ---------------------------------------------------------- | ID | date | name | amount | ----------------------------------------------------------- | 1 | 2010-11-23 | Jhon | 1 | | 2 | 2010-11-24 | Jhon | 1 | | 2 | 2010-11-25 | Jhon | 1 | ----------------------------------------------------------- The reason i need the insertion to be like this is because if quering by month and by user to see vacation days then vacations that start in one month and end in another month can be summed by one month. If its in one record then it will pop up in both months. Help is really welcome. I've begun to play around with object oriented php and I was wondering how I would go about writing a method that inserts values into a table.
I have a class, called queries, and I made this very simple function:
class queries {
public function insert($table, $field, $value){
global $dbh;
$stmt = $dbh->prepare("INSERT INTO $table ($field) VALUES (:value)");
$stmt->bindParam(":value", $value);
$stmt->execute();
}
}
$queries = new queries();
how do I make the $image piece so that it inserts "images/$image.php" into the database? VALUES('$name', '$id', '$image','$event')";
Hi guys, Thanks
if(isset($_POST['send'])){
$category = $_POST['category'];
$item_type = $_POST['item_type'];
$item_size = $_POST['item_size'];
$product_name = $_POST['product_name'];
$item_qty = $_POST['item_qty'];
$price = $_POST['price'];
$total_price = $_POST['total_price'];
$item_price = $_POST['item_price'];
$sql = "
INSERT INTO shopping(
trans_ref,
category,
product_name,
item_type,
item_size,
item_qty,
item_price,
price,
date
)
VALUES(
:trans_ref,
:category,
:product_name,
:item_type,
:item_size,
:item_qty,
:item_price,
:price,
NOW()
)
";
$stmt = $pdo->prepare($sql);
$stmt->execute(array(
':trans_ref' => $_SESSION['trans_ref'],
':category' => $category,
':product_name' => $product_name,
':item_type' => $item_type,
':item_size' => $item_size,
':item_qty' => $item_qty,
':item_price' => $item_price,
':price' => $price
));
if ( $stmt->rowCount()){
echo '<div class="alert bg-success text-center">SHOPPING COMPLETED</div>';
}else{
echo '<div class="alert bg-danger text-center">SHOPPING NOT COMPLETED. A PROBLE OCCURED</div>';
}
}
I am having an issue trying to get products that I am entering through my admin panel to go into my database. I am thinking that the programmer of the script might have forgot some code possibly, but everything else does get inserted into the database regarding categories, manufactures etc. Here is the insert product php script. My db and functions are set to go to my database with website name/password etc.
<?php
if(!isset($_SESSION['customer_email'])){
echo "<script> window.open('../checkout.php','_self'); </script>";
}
$customer_email = $_SESSION['customer_email'];
$get_customer = "select * from customers where customer_email='$customer_email'";
$run_customer = mysqli_query($con,$get_customer);
$row_customer = mysqli_fetch_array($run_customer);
$customer_id = $row_customer['customer_id'];
$select_general_settings = "select * from general_settings";
$run_general_settings = mysqli_query($con,$select_general_settings);
$row_general_settings = mysqli_fetch_array($run_general_settings);
$product_vendor_status = $row_general_settings["new_product_status"];
?>
<script src="//cdn.tinymce.com/4/tinymce.min.js"></script>
<script>tinymce.init({ selector:'#product_desc,#product_features' });</script>
<div class="row"><!-- 2 row Starts -->
<div class="col-lg-12"><!-- col-lg-12 Starts -->
<div class="panel panel-default"><!-- panel panel-default Starts -->
<div class="panel-heading"><!-- panel-heading Starts -->
<h3 class="panel-title">
<i class="fa fa-money fa-fw"></i> Insert Product
</h3>
</div><!-- panel-heading Ends -->
<div class="panel-body"><!-- panel-body Starts -->
<form id="insert_product_form" method="post" enctype="multipart/form-data"><!-- form-horizontal Starts -->
<div class="row"><!-- 2 row Starts -->
<div class="col-md-9"><!-- col-md-9 Starts -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Title </label>
<input type="text" name="product_title" class="form-control" required >
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Seo Description </label>
<textarea name="product_seo_desc" class="form-control" maxlength="230" placeholder="Most search engines use a maximum of 230 chars for the description."></textarea>
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Url </label>
<input type="text" name="product_url" class="form-control" required >
<br>
<p style="font-size:15px; font-weight:bold;">
Product Url Example : navy-blue-t-shirt
</p>
</div><!-- form-group Ends -->
<div class="form-group"><!-- form-group Starts -->
<label> Product Tabs </label>
<ul class="nav nav-tabs"><!-- nav nav-tabs Starts -->
<li class="active">
<a data-toggle="tab" href="#description"> Product Description </a>
</li>
<li>
<a data-toggle="tab" href="#features"> Product Features </a>
</li>
<li>
<a data-toggle="tab" href="#video"> Sounds And Videos </a>
</li>
</ul><!-- nav nav-tabs Ends -->
<div class="tab-content"><!-- tab-content Starts -->
<div id="description" class="tab-pane fade in active"><!-- description tab-pane fade in active Starts -->
<br>
<textarea name="product_desc" class="form-control" rows="15" id="product_desc"></textarea>
</div><!-- description tab-pane fade in active Ends -->
<div id="features" class="tab-pane fade in"><!-- features tab-pane fade in Starts -->
<br>
<textarea name="product_features" class="form-control" rows="15" id="product_features"></textarea>
</div><!-- features tab-pane fade in Ends -->
<div id="video" class="tab-pane fade in"><!-- video tab-pane fade in Starts -->
<br>
<textarea name="product_video" class="form-control" rows="15"></textarea>
</div><!-- video tab-pane fade in Ends -->
</div><!-- tab-content Ends -->
</div><!-- form-group Ends -->
<div class="form-group" id="product_weight"><!-- form-group Starts -->
<label> Product Weight <small> (kg)</small> </label>
<input type="text" name="product_weight" class="form-control">
</div><!-- form-group Ends -->
<div class="form-group" id="product_price"><!-- form-group Starts -->
<label> Product Price </label>
<input type="text" name="product_price" class="form-control" required>
</div><!-- form-group Ends -->
<div class="form-group" id="product_psp_price"><!-- form-group Starts -->
<label> Product Sale Price </label>
<input type="text" name="psp_price" class="form-control">
</div><!-- form-group Ends -->
</div><!-- col-md-9 Ends -->
<div class="col-md-3"><!-- col-md-3 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Select A Product Type </label>
<select class="form-control" name="product_type"><!-- select manufacturer Starts -->
<option value="physical_product"> (Physical Product) Simple Product </option>
<option value="digital_product"> (Digital Product) Downloadable Product </option>
<option value="variable_product"> (Variable Product) Advanced Product </option>
</select><!-- select manufacturer Ends -->
</div><!-- form-group Ends -->
<div class="form-group"><!-- form-group Starts -->
<label> Select A Manufacturer </label>
<select class="form-control" name="manufacturer"><!-- select manufacturer Starts -->
<option> Select A Manufacturer </option>
<?php
$get_manufacturer = "select * from manufacturers";
$run_manufacturer = mysqli_query($con,$get_manufacturer);
while($row_manufacturer= mysqli_fetch_array($run_manufacturer)){
$manufacturer_id = $row_manufacturer['manufacturer_id'];
$manufacturer_title = $row_manufacturer['manufacturer_title'];
echo "<option value='$manufacturer_id'>
$manufacturer_title
</option>";
}
?>
</select><!-- select manufacturer Ends -->
</div><!-- form-group Ends -->
<div class="form-group"><!-- form-group Starts -->
<label> Product Category </label>
<select name="product_cat" class="form-control" >
<option> Select a Product Category </option>
<?php
$get_p_cats = "select * from product_categories";
$run_p_cats = mysqli_query($con,$get_p_cats);
while ($row_p_cats=mysqli_fetch_array($run_p_cats)) {
$p_cat_id = $row_p_cats['p_cat_id'];
$p_cat_title = $row_p_cats['p_cat_title'];
echo "<option value='$p_cat_id' >$p_cat_title</option>";
}
?>
</select>
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Category </label>
<select name="cat" class="form-control" >
<option> Select a Category </option>
<?php
$get_cat = "select * from categories";
$run_cat = mysqli_query($con,$get_cat);
while ($row_cat=mysqli_fetch_array($run_cat)) {
$cat_id = $row_cat['cat_id'];
$cat_title = $row_cat['cat_title'];
echo "<option value='$cat_id'>$cat_title</option>";
}
?>
</select>
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Image 1 </label>
<input type="file" name="product_img1" class="form-control" required >
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Image 2 </label>
<input type="file" name="product_img2" class="form-control">
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Image 3 </label>
<input type="file" name="product_img3" class="form-control">
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Keywords </label>
<input type="text" name="product_keywords" class="form-control">
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Label </label>
<input type="text" name="product_label" class="form-control">
</div><!-- form-group Ends -->
</div><!-- col-md-3 Ends -->
</div><!-- 2 row Ends -->
<div class="form-group" id="product-stock-management"><!-- form-group Starts -->
<label> Product Inventory Stock Management </label>
<div class="panel panel-default"><!-- panel panel-default Starts -->
<div class="panel-heading"><!-- panel-heading Starts -->
<strong> Inventory - Stock Options </strong>
</div><!-- panel-heading Ends -->
<div class="panel-body"><!--panel-body Starts -->
<div class="row"><!-- row Starts -->
<div class="col-sm-6" id="stock-status"><!-- col-sm-6 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Stock Status </label>
<select class="form-control" name="stock_status" required><!-- select manufacturer Starts -->
<option value="instock">In stock</option>
<option value="outofstock">Out of stock</option>
<option value="onbackorder">On backorder</option>
</select><!-- select manufacturer Ends -->
</div><!-- form-group Ends -->
</div><!-- col-sm-6 Ends -->
<div class="col-sm-6"><!-- col-sm-6 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Enable stock management at product level? </label>
<div class="radio">
<label>
<input type="radio" name="enable_stock" value="yes" required> Yes
</label>
<label>
<input type="radio" name="enable_stock" value="no" checked required> No
</label>
</div>
</div><!-- form-group Ends -->
</div><!-- col-sm-6 Ends -->
</div><!-- row Ends -->
<div class="row" id="stock-management-row"><!-- row Starts -->
<div class="col-sm-6"><!-- col-sm-6 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Stock Quantity </label>
<input type="number" name="stock_quantity" value="0" class="form-control" required>
</div><!-- form-group Ends -->
</div><!-- col-sm-6 Ends -->
<div class="col-sm-6"><!-- col-sm-6 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Allow backorders? </label>
<select class="form-control" name="allow_backorders" required><!-- select manufacturer Starts -->
<option value="no">Do not allow</option>
<option value="notify">Allow, but notify customer</option>
<option value="yes">Allow</option>
</select><!-- select manufacturer Ends -->
</div><!-- form-group Ends -->
</div><!-- col-sm-6 Ends -->
</div><!-- row Ends -->
</div><!--panel-body Ends -->
</div><!-- panel panel-default Ends -->
</div><!-- form-group Ends -->
</form><!-- form-horizontal Ends -->
<div class="form-group" id="variable_product_options"><!-- form-group Starts -->
<label> Variable Product Options </label>
<div class="panel panel-default"><!-- panel panel-default Starts -->
<div class="panel-heading"><!-- panel-heading Starts -->
<ul class="nav nav-tabs"><!-- nav nav-tabs Starts -->
<li class="active">
<a data-toggle="tab" href="#product_attributes"> Product Attributes </a>
</li>
<li>
<a data-toggle="tab" href="#product_variations"> Product Variations </a>
</li>
</ul><!-- nav nav-tabs Ends -->
</div><!-- panel-heading Ends -->
<div class="panel-body"><!--panel-body Starts -->
<div class="tab-content"><!-- tab-content Starts -->
<div id="product_attributes" class="tab-pane fade in active"><!-- product_attributes tab-pane fade in active Starts -->
<form id="insert_attribute_form" method="post"><!-- form Starts -->
<div class="row"><!-- row Starts -->
<div class="col-sm-4"><!-- col-sm-4 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Name: </label>
<input type="text" name="attribute_name" class="form-control" required>
</div><!-- form-group Ends -->
</div><!-- col-sm-4 Ends -->
<div class="col-sm-8"><!-- col-sm-8 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Value(s): </label>
<textarea name="attribute_values" class="form-control" placeholder="Enter some attributes by '|' separating values." required></textarea>
</div><!-- form-group Ends -->
</div><!-- col-sm-8 Ends -->
</div><!-- row Ends -->
<div class="form-group"><!-- form-group Starts -->
<input type="submit" value="Insert Product Attribute" class="btn btn btn-primary">
</div><!-- form-group Ends -->
</form><!-- form Ends -->
<table class="table table-hover table-bordered table-striped"><!-- table table-hover table-bordered table-striped Starts -->
<thead><!-- thead Starts -->
<tr>
<th>Attribute Name:</th>
<th>Attribute Value(s):</th>
<th>Actions:</th>
</tr>
</thead><!-- thead Ends -->
<tbody><!-- tbody Starts -->
<?php
$random_id = 152;
$select_product_attributes = "select * from product_attributes where product_id='$random_id'";
$run_product_attributes = mysqli_query($con,$select_product_attributes);
while($row_product_attributes = mysqli_fetch_array($run_product_attributes)){
$attribute_id = $row_product_attributes["attribute_id"];
$attribute_name = $row_product_attributes["attribute_name"];
$attribute_values = $row_product_attributes["attribute_values"];
?>
<tr id="tr-attribute-<?php echo $attribute_id; ?>">
<td>
<div class="edit" data-attribute="<?php echo $attribute_id; ?>"><?php echo $attribute_name; ?></div>
<input type="text" id="attribute-name" class="input-edit form-control" data-attribute="<?php echo $attribute_id; ?>" value="<?php echo $attribute_name; ?>">
</td>
<td>
<div class="edit" data-attribute="<?php echo $attribute_id; ?>"><?php echo $attribute_values; ?></div>
<input type="text" id="attribute-values" class="input-edit form-control" data-attribute="<?php echo $attribute_id; ?>" value="<?php echo $attribute_values; ?>">
</td>
<td>
<div class="btn-group">
<a href="#" class="edit-product-attribute btn btn-primary btn-sm" data-attribute="<?php echo $attribute_id; ?>">
<i class="fa fa-pencil"></i> Edit
</a>
<a href="#" class="save-product-attribute btn btn-success btn-sm" data-attribute="<?php echo $attribute_id; ?>">
<i class="fa fa-floppy-o"></i> Save
</a>
<a href="#" class="delete-product-attribute btn btn-danger btn-sm" data-attribute="<?php echo $attribute_id; ?>">
<i class="fa fa-trash-o"></i> Delete
</a>
</div>
</td>
</tr>
<?php } ?>
</tbody><!-- tbody Ends -->
</table><!-- table table-hover table-bordered table-striped Ends -->
</div><!-- product_attributes tab-pane fade in active Ends -->
<div id="product_variations" class="tab-pane fade in"><!-- product_variations tab-pane fade in Starts -->
<form id="product-variations-form" method="post" enctype="multipart/form-data"><!-- form Starts -->
<div class="form-group row"><!-- form-group Starts -->
<label class="col-sm-3 control-label"> Default Form Values: </label>
<div class="col-sm-9"><!-- col-sm-10 Starts -->
<div class="row" id="default_form_values"><!-- row default_form_values Starts -->
</div><!-- row default_form_values Ends -->
<span class="help-block">
These are the product attributes that will be pre-selected on the frontend.
</span>
</div><!-- col-sm-9 Ends -->
</div><!-- form-group Ends -->
<hr class="variation-hr">
<div class="form-group row"><!-- form-group Starts -->
<label class="col-sm-1 control-label"> Actions: </label>
<div class="col-sm-10"><!-- col-sm-10 Starts -->
<select class="form-control" id="action_select"><!-- select manufacturer Starts -->
<option value="add_variation"> Add A New Variation </option>
<option value="create_variations_from_attributes"> Create New Variations From All Attributes </option>
<option value="delete_all_variations"> Delete All Variations </option>
</select><!-- select manufacturer Ends -->
</div><!-- col-sm-10 Ends -->
<div class="col-sm-1"><!-- col-sm-1 Starts -->
<button type="button" id="go_button" class="btn btn-success form-control"> Go </button>
</div><!-- col-sm-1 Ends -->
</div><!-- form-group Ends -->
<div class="product-variations-div"><!-- product-variations-div Starts -->
</div><!-- product-variations-div Ends -->
<hr class="variation-hr">
<div class="form-group"><!-- form-group Starts -->
<input type="submit" value="Save Product Variations" class="btn btn btn-success">
</div><!-- form-group Ends -->
</form><!-- form Ends -->
<div class="ajax-response-div"></div>
</div><!-- product_variations tab-pane fade in Ends -->
</div><!-- tab-content Ends -->
</div><!--panel-body Ends -->
</div><!-- panel panel-default Ends -->
</div><!-- form-group Ends -->
<div class="form-group"><!-- form-group Starts -->
<input type="submit" name="submit" value="Insert Product" form="insert_product_form" class="btn btn-primary form-control">
</div><!-- form-group Ends -->
</div><!-- panel-body Ends -->
</div><!-- panel panel-default Ends -->
</div><!-- col-lg-12 Ends -->
</div><!-- 2 row Ends -->
<script>
$(document).ready(function(){
//Product Stock Management Code Starts
$("#stock-management-row").hide();
$("input[name='enable_stock']").click(function(){
var radio_value = $(this).val();
if(radio_value == "yes"){
$("#stock-status").hide();
$("#stock-management-row").show();
}else if(radio_value == "no"){
$("#stock-status").show();
$("#stock-management-row").hide();
}
});
//Product Stock Management Code Ends
//Change Product Type Function Code Starts
function change_product_type(){
var product_type = $("select[name='product_type']").val();
if(product_type == "physical_product"){
$("#product_weight").show();
$("#product_price").show();
$("#product_psp_price").show();
$('#product_weight input,#product_price input,#product_psp_price input').prop("disabled", false);
$("#product-stock-management").show();
$('#product-stock-management input,#product-stock-management select').prop("disabled", false);
$("#variable_product_options").hide();
}else if(product_type == "digital_product"){
$("#product_weight").hide();
$("#product_price").show();
$("#product_psp_price").show();
$('#product_weight input,#product_price input,#product_psp_price input').prop("disabled", false);
$("#product-stock-management").show();
$('#product-stock-management input,#product-stock-management select').prop("disabled", false);
$("#variable_product_options").hide();
}else if(product_type == "variable_product"){
$("#product_weight").hide();
$("#product_price").hide();
$("#product_psp_price").hide();
$('#product_weight input,#product_price input,#product_psp_price input').prop("disabled", true);
$("#product-stock-management").hide();
$('#product-stock-management input,#product-stock-management select').prop("disabled", true);
$("#variable_product_options").show();
}
}
//Change Product Type Function Code Ends
change_product_type();
$("select[name='product_type']").change(function(){
change_product_type();
});
//Load Product Attributes Function Code Starts
function load_product_attributes(){
$.ajax({
method: "POST",
url: "variable_product/load_product_attributes.php",
data: { random_id: <?php echo $random_id; ?> },
success:function(data){
$("table tbody").html(data);
$("table").removeClass("wait-loader");
}
});
}
//Load Product Attributes Function Code Ends
//Insert New Product Attribute Code Starts
$("#insert_attribute_form").submit(function(event){
event.preventDefault();
$("table").addClass("wait-loader");
$.ajax({
method: "POST",
url: "variable_product/insert_product_attribute.php",
data: $('#insert_attribute_form').serialize() + "&random_id=<?php echo $random_id; ?>",
success: function(){
$("#insert_attribute_form").find("input[type=text],textarea").val("");
load_product_attributes();
}
});
});
//Insert New Product Attribute Code Ends
//Edit Product Attribute Code Starts
$(".input-edit").hide();
$(".save-product-attribute").hide();
$(".edit-product-attribute").on('click', function(event){
event.preventDefault();
var attribute_id = $(this).data("attribute");
$(".edit").show();
$(".input-edit").hide();
$(".edit[data-attribute='" + attribute_id +"']").hide();
$(".input-edit[data-attribute='" + attribute_id +"']").show().focus();
$(".edit-product-attribute[data-attribute='" + attribute_id +"']").hide();
$(".save-product-attribute[data-attribute='" + attribute_id +"']").show();
});
//Edit Product Attribute Code Ends
//Update Save Product Attribute Code Starts
$(".save-product-attribute").on('click', function(event){
event.preventDefault();
var attribute_id = $(this).data("attribute");
$(".edit[data-attribute='" + attribute_id +"']").show();
$(".input-edit[data-attribute='" + attribute_id +"']").hide();
$(".edit-product-attribute[data-attribute='" + attribute_id +"']").show();
$(".save-product-attribute[data-attribute='" + attribute_id +"']").hide();
var attribute_name = $("#attribute-name[data-attribute='" + attribute_id +"']").val();
var attribute_values = $("#attribute-values[data-attribute='" + attribute_id +"']").val();
$("#attribute-name[data-attribute='" + attribute_id +"']").prev(".edit").text(attribute_name);
$("#attribute-values[data-attribute='" + attribute_id +"']").prev(".edit").text(attribute_values);
var random_id = <?php echo $random_id; ?>;
$.ajax({
method: "POST",
url: "variable_product/update_product_attribute.php",
data: { random_id: random_id, attribute_id: attribute_id, attribute_name: attribute_name, attribute_values: attribute_values }
});
});
//Update Save Product Attribute Code Ends
//Delete Product Attribute Code Starts
$(".delete-product-attribute").on('click', function(event){
event.preventDefault();
var attribute_id = $(this).data("attribute");
$("#tr-attribute-" + attribute_id).remove();
var random_id = <?php echo $random_id; ?>;
$.ajax({
method: "POST",
url: "variable_product/delete_product_attribute.php",
data: { random_id: random_id, attribute_id: attribute_id }
});
});
//Delete Product Attribute Code Ends
//Load Product Variations Default Form Values Function Code Starts
function load_variations_default_form_values(){
$.ajax({
method: "POST",
url: "variable_product/load_default_form_values.php",
data: { random_id: <?php echo $random_id; ?> },
success:function(data){
$("#default_form_values").html(data);
}
});
}
//Load Product Variations Default Form Values Function Code Ends
//Load Product Variations Function Code Starts
function load_product_variations(){
$.ajax({
method: "POST",
url: "variable_product/load_product_variations.php",
data: { random_id: <?php echo $random_id; ?> },
success:function(data){
$(".product-variations-div").html(data);
$(".product-variations-div").removeClass("wait-loader");
}
});
}
//Load Product Variations Function Code Ends
//Click Product Variations Tab Code Starts
$("a[href='#product_variations']").click(function(){
$(".product-variations-div").addClass("wait-loader");
load_variations_default_form_values();
load_product_variations();
});
//Click Product Variations Tab Code Ends
//Save Update Product Variations Function Code Starts
function save_update_product_variations(){
var form = document.getElementById("product-variations-form");
var form_data = new FormData(form);
form_data.append("random_id", <?php echo $random_id; ?>);
$.ajax({
method: "POST",
url: "variable_product/update_all_variations.php",
data:form_data,
contentType: false,
cache: false,
processData:false,
success: function(data){
$(".ajax-response-div").html(data);
$(".product-variations-div").removeClass("wait-loader");
}
});
}
//Save Update Product Variations Function Code Ends
//Product Variations Actions Go Button Code Starts
$("#go_button").click(function(){
var action_select = $("#action_select").val();
if(action_select == "add_variation"){
$(".product-variations-div").addClass("wait-loader");
save_update_product_variations();
$(".product-variations-div").addClass("wait-loader");
$.ajax({
method: "POST",
url: "variable_product/insert_product_variation.php",
data: { random_id: <?php echo $random_id; ?> },
success: function(){
load_product_variations();
}
});
}else if(action_select == "create_variations_from_attributes"){
var confirm_action = confirm("Are you sure you want to link all variations? This will create a new variation for each and every possible combination of variation attributes (max 50 per run).");
if(confirm_action == true){
$(".product-variations-div").addClass("wait-loader");
save_update_product_variations();
$(".product-variations-div").addClass("wait-loader");
$.ajax({
method: "POST",
url: "variable_product/create_variations_from_attributes.php",
data: { random_id: <?php echo $random_id; ?> },
success: function(data){
$(".ajax-response-div").html(data);
load_product_variations();
load_variations_default_form_values();
}
});
}
}else if(action_select == "delete_all_variations"){
var confirm_action = confirm("Are you sure you want to delete all variations? This cannot be undone.");
if(confirm_action == true){
$(".product-variations-div").addClass("wait-loader");
$.ajax({
method: "POST",
url: "variable_product/delete_all_variations.php",
data: { random_id: <?php echo $random_id; ?> },
success: function(){
load_product_variations();
load_variations_default_form_values();
}
});
}
}
});
//Product Variations Actions Go Button Code Ends
//Save Update Submit From Of Product Variations Code Starts
$("#product-variations-form").submit(function(event){
event.preventDefault();
$(".product-variations-div").addClass("wait-loader");
save_update_product_variations();
load_variations_default_form_values();
});
//Save Update Submit From Of Product Variations Code Ends
});
</script>
<?php
if(isset($_POST['submit'])){
$product_title = mysqli_real_escape_string($con, $_POST['product_title']);
$product_seo_desc = mysqli_real_escape_string($con, $_POST['product_seo_desc']);
$product_url = mysqli_real_escape_string($con, $_POST['product_url']);
$product_cat = mysqli_real_escape_string($con, $_POST['product_cat']);
$cat = mysqli_real_escape_string($con, $_POST['cat']);
$manufacturer_id = mysqli_real_escape_string($con, $_POST['manufacturer']);
$product_price = mysqli_real_escape_string($con, $_POST['product_price']);
$product_desc = mysqli_real_escape_string($con, $_POST['product_desc']);
$product_keywords = mysqli_real_escape_string($con, $_POST['product_keywords']);
$psp_price = mysqli_real_escape_string($con, $_POST['psp_price']);
$product_label = mysqli_real_escape_string($con, $_POST['product_label']);
$product_type = mysqli_real_escape_string($con, $_POST['product_type']);
$product_features = mysqli_real_escape_string($con, $_POST['product_features']);
$product_video = mysqli_real_escape_string($con, $_POST['product_video']);
$product_weight = mysqli_real_escape_string($con, $_POST['product_weight']);
$stock_status = mysqli_real_escape_string($con, $_POST['stock_status']);
$enable_stock = mysqli_real_escape_string($con, $_POST['enable_stock']);
$stock_quantity = mysqli_real_escape_string($con, $_POST['stock_quantity']);
$allow_backorders = mysqli_real_escape_string($con, $_POST['allow_backorders']);
$status = "product";
$product_img1 = $_FILES['product_img1']['name'];
$product_img2 = $_FILES['product_img2']['name'];
$product_img3 = $_FILES['product_img3']['name'];
$temp_name1 = $_FILES['product_img1']['tmp_name'];
$temp_name2 = $_FILES['product_img2']['tmp_name'];
$temp_name3 = $_FILES['product_img3']['tmp_name'];
$allowed = array('jpeg','jpg','gif','png');
$product_img1_extension = pathinfo($product_img1, PATHINFO_EXTENSION);
$product_img2_extension = pathinfo($product_img2, PATHINFO_EXTENSION);
$product_img3_extension = pathinfo($product_img3, PATHINFO_EXTENSION);
if(!in_array($product_img1_extension,$allowed)){
echo "<script> alert('Your Product Image 1 File Extension Is Not Supported.'); </script>";
$product_img1 = "";
}else{
move_uploaded_file($temp_name1,"../admin_area/product_images/$product_img1");
}
if(!empty($product_img2)){
if(!in_array($product_img2_extension,$allowed)){
echo "<script> alert('Your Product Image 2 File Extension Is Not Supported.'); </script>";
$product_img2 = "";
}else{
move_uploaded_file($temp_name2,"../admin_area/product_images/$product_img2");
}
}
if(!empty($product_img3)){
if(!in_array($product_img3_extension,$allowed)){
echo "<script> alert('Your Product Image 3 File Extension Is Not Supported.'); </script>";
$product_img3 = "";
}else{
move_uploaded_file($temp_name3,"../admin_area/product_images/$product_img3");
}
}
$insert_product = "insert into products (vendor_id,p_cat_id,cat_id,manufacturer_id,date,product_title,product_seo_desc,product_url,product_img1,product_img2,product_img3,product_price,product_psp_price,product_desc,product_features,product_video,product_keywords,product_label,product_type,product_weight,product_vendor_status,status) values ('$customer_id','$product_cat','$cat','$manufacturer_id',NOW(),'$product_title','$product_seo_desc','$product_url','$product_img1','$product_img2','$product_img3','$product_price','$psp_price','$product_desc','$product_features','$product_video','$product_keywords','$product_label','$product_type','$product_weight','$product_vendor_status','$status')";
$run_product = mysqli_query($con,$insert_product);
$product_id = mysqli_insert_id($con);
if($run_product){
if($product_type != "variable_product"){
if($enable_stock == "yes" and $stock_quantity > 0){
$stock_status = "instock";
}elseif($enable_stock == "yes" and $allow_backorders == "no" and $stock_quantity < 1){
$stock_status = "outofstock";
}elseif($enable_stock == "yes" and ($allow_backorders == "yes" or $allow_backorders == "notify") and $stock_quantity < 1){
$stock_status = "onbackorder";
}
$insert_product_stock = "insert into products_stock (product_id,enable_stock,stock_status,stock_quantity,allow_backorders) values ('$product_id','$enable_stock','$stock_status','$stock_quantity','$allow_backorders')";
$run_insert_product_stock = mysqli_query($con,$insert_product_stock);
}
$update_product_stock = "update products_stock set product_id='$product_id' where product_id='$random_id'";
$run_update_product_stock = mysqli_query($con,$update_product_stock);
$update_product_attributes = "update product_attributes set product_id='$product_id' where product_id='$random_id'";
$run_product_attributes = mysqli_query($con, $update_product_attributes);
$update_product_variations = "update product_variations set product_id='$product_id' where product_id='$random_id'";
$run_product_variations = mysqli_query($con, $update_product_variations);
echo "
<script>
alert(' Your Product Has Been Inserted Successfully. ');
window.open('index.php?products','_self');
</script>
";
}
}
?>
Hello, ive got the right output from the code below, only my mysql query doesnt seem to be working as it should. Im not too great with mysql so please any help or suggestions would be great. I have tried the code but when I check my database nothing has been inserted. !?! Code: [Select] <?php include('db.php'); include('func.php'); ?><html><head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Chained Select Boxes using PHP, MySQL and jQuery</title> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js"></script> <script type="text/javascript"> $(document).ready(function() { $('#wait_1').hide(); $('#drop_1').change(function(){ $('#wait_1').show(); $('#result_1').hide(); $.get("func.php", { func: "drop_1", drop_var: $('#drop_1').val() }, function(response){ $('#result_1').fadeOut(); setTimeout("finishAjax('result_1', '"+escape(response)+"')", 400); }); return false; }); }); function finishAjax(id, response) { $('#wait_1').hide(); $('#'+id).html(unescape(response)); $('#'+id).fadeIn(); } </script> </head> <body> <p> <form action="" method="post"> Name: <input type="text" name="Name" /><br /> Phone: <input type="text" name="Phone" /><br /> Email: <input type="text" name="Email" /><br /> Postcode: <input type="text" name="Postcode" /><br /> Web Address: <input type="text" name="Website" /><br /><br /> <select name="drop_1" id="drop_1"> <option value="" selected="selected" disabled="disabled">Select a Category</option> <?php getTierOne(); ?> </select> <span id="wait_1" style="display: none;"> <img alt="Please Wait" src="ajax-loader.gif"/> </span> <span id="result_1" style="display: none;"></span> <br /> </form> </p> <p> <?php if(isset($_POST['submit'])){ $drop = $_POST['drop_1']; $tier_two = $_POST['Subtype']; echo "You selected "; echo $drop." & ".$tier_two; } $Name = $_POST["Name"]; $Phone = $_POST["Phone"]; $Email = $_POST["Email"]; $Postcode = $_POST["Postcode"]; $Website = $_POST["Website"]; echo "<br>"; echo $Name; echo "<br>"; echo $Website; mysql_query ("INSERT INTO business (Name, Type, Subtype, Phone, Email, Postcode, Web Address) VALUES ('$Name', '$drop', '$tier_two' , '$Phone', '$Email', '$Postcode', '$Website')"); ?> Im not sure it makes a difference but, I am adding data into each column of my database with the exception of the 1st column named 'ID' which is set to auto_increment. I created this database Code: [Select] <?php $mysqli = mysqli_connect('localhost', 'admin', 'jce123', 'php_class'); if(mysqli_connect_errno()) { printf("connection failed: %s\n", mysqli_connect_error()); exit(); }else{ $q = mysqli_query($mysqli, "DROP TABLE IF EXISTS airline_survey"); if($q){echo "deleted the table airline_survey....<br>";} else{echo "damm... ".mysqli_error($mysqli);} $sql = "CREATE TABLE airline_survey ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, staff CHAR(10) NOT NULL, luggage CHAR(10) NOT NULL, seating CHAR(10) NOT NULL, clean CHAR(10) NOT NULL, noise CHAR(10) NOT NULL )"; $res = mysqli_query($mysqli, $sql); if($res === TRUE) { echo "table created"; } else { printf("Could not create table: %s\n", mysqli_error($mysqli)); } mysqli_close($mysqli); } ?> When I look at it it looks fine. I have a form that sends data to this script: Code: [Select] <?php $con = mysql_connect('localhost', 'admin', 'abc123'); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("php_class", $con); foreach ($_POST as $key => $value) { $staff = ""; $luggage = ""; $seating = ""; $clean = ""; $noise = ""; switch($key){ case "staff": $staff = $value; break; case "luggage": $luggage = $value; break; case "seating": $seating = $value; break; case "clean": $clean = $value; break; case "noise": $noise = $value; break; default: echo "we must be in the twilight zone"; } echo $staff."<br>"; [color=red] mysql_query("INSERT INTO airline_survey (staff, luggage, seating, clean, noise) VALUES ($staff, $luggage, $seating, $clean, $noise)");[/color] } ?> as you can see right before the insert query I test one of the variables to see if it has the string I'm expecting and it does. The problem is the script runs without giving me an error message but the data never gets inserted into the table. Hi... Got a slight problem with my code, it keeps telling me that there is an error in my syntax, yet I have used the same code before perfectly, and for the life of me cannot see the problem? ....any ideas? <?php if (!isset($_SESSION)) { session_start(); } // Connects to your Database mysql_connect("localhost", "justair1_mick", "guru1969") or die(mysql_error()) ; mysql_select_db("justair1_justair") or die(mysql_error()) ; $filename = ($_FILES['image']['name']); $group = $_POST['group']; $make_model = $_POST['make_model']; $seats = $_POST['seats']; $transmission = $_POST['transmission']; $doors = $_POST['doors']; $lg_bags = $_POST['lg_bags']; $sm_bags = $_POST['sm_bags']; $aircon = $_POST['aircon']; $day1 = $_POST['1_day']; $days2 = $_POST['2_days']; $days3_6 = $_POST['3_6days']; $week = $_POST['week']; $days8_13 = $_POST['8_13days']; $days14 = $_POST['14_days']; if(isset($filename)){ //This is the directory where images will be saved $target = "images/"; $target2 = $target . basename( $_FILES['image']['name']); //This gets all the other information from the form $fileA=($_FILES['image']['name']); } $updateSQL = "INSERT INTO car_groups (group, make_model, transmission, seats, doors, lg_bags, sm_bags, aircon, image) VALUES ('$group', '$make_model', '$transmission', '$seats', '$doors', '$lg_bags', '$sm_bags', '$aircon', '$filename')"; mysql_query($updateSQL) or die(mysql_error()); //Writes the photo to the server move_uploaded_file($_FILES['image']['tmp_name'], $target2); header ("Location: carhireInsert.php"); ?> It keeps telling me... "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 'group, make_model, transmission, seats, doors, lg_bags, sm_bags, aircon, image) ' at line 1" ..? Really stuck on this one... Any help would be apreciated.. thanks.. Mick. how do i insert this into a database? i need the php code please. Code: [Select] <select class="select" name="sex" id="sex"> <option value="0">Select Gender</option> <option value="1">Female</option> <option value="2">Male</option></select>I need it to insert what ever one they select Thanks |
|||||||