hye.
i'm new here.
in php coding as well.
sorry in advance if my questions are stupid question.
but i just can't find the solution even after googled it.
here is my question.
i'm developing an online ordering system.in one part.user need to select the quatity of their order.i'm using select box.the choice limited from 1 to 10.however, even after the user select the quantity (e.g: 6 ) the value will not inserted into database.what i mean is there is no value for the quantity of order in database.is there any specific php coding to made the value inserted in database?
i'm using dreamweaver 8 and MySql.
thank you in advance
6  24274   Atli 5,058
Expert 4TB
Hey. Welcome!
How does your code look like now?
I don't know enough about your code to offer any specific help, but in general, this is how you would insert a value from a select box into a database.
Given a form like this: - <!DOCTYPE html>
-
<head>
-
<title>Example</title>
-
</head>
-
<body>
-
<form action="insert.php" method="post">
-
Qty: <select name="qantity">
-
<option value="1">1</option>
-
<option value="1">3</option>
-
<option value="1">5</option>
-
<option value="1">10</option>
-
</select>
-
<br>
-
<input type="submit">
-
</form>
-
</body>
-
</html>
The PHP code to insert the selected value into a database would look something like this: - <?php
-
if(isset($_POST['qty'])) {
-
// Fetch and clean the <select> value.
-
// The (int) makes sure the value is really a integer.
-
$qty = (int)$_POST['qty'];
-
-
// Create the INSERT query.
-
$sql = "INSERT INTO `table`(`quantity`)
-
VALUES ({$qty})";
-
-
// Connect to a database and execute the query.
-
$dbLink = mysql_connect('host', 'user', 'pwd') or die(mysql_error());
-
mysql_select_db('dbName', $dbLink) or die(mysql_errno());
-
-
$result = mysql_query($sql);
-
-
// Check the results and print the appropriate message.
-
if($result) {
-
echo "Record successfully inserted!";
-
}
-
else {
-
echo "Record not inserted! (". mysql_error() .")";
-
}
-
}
-
?>
sorry in advance if my questions are stupid question.
There are no stupid questions. Even the most experienced of us had to learn the beginner stuff at some point :)
You generally don't need to check mysql_affected_rows() for INSERT queries. The query will throw an error if it does not succeed. mysql_affected_rows() is moreso for UPDATE queries.
Secondly... It's standard to use typecasting instead of intval(), unless you are using non-decimal values (i.e. hex, binary).
Atli 5,058
Expert 4TB
You generally don't need to check mysql_affected_rows() for INSERT queries. The query will throw an error if it does not succeed. mysql_affected_rows() is moreso for UPDATE queries.
True. Nice catch ;-)
That example was originally a part of a larger UPDATE example. I just edited the query and posted it here. Should have read it through more carefully xD
I'll correct the example, for the sake of future readers.
Secondly... It's standard to use typecasting instead of intval(), unless you are using non-decimal values (i.e. hex, binary).
Why do you say that? I've never really found any real benefit from using typecasting over the variable functions, other than a very minor (almost negligible) performance gain. I'd be happy to be proven wrong on this, though.
I tend to use the functions in basic examples like these because it is simpler for newbies to understand. Besides, I never really liked typecasting. Doesn't seem to fit in a loosely-typed language... but that's just me :P
One of the disadvantages of loosely-typed languages is that we have to check all of our types before using them, especially when it comes to times that a variable could be scalar or non-scalar. When we force typing via typecasting, we can always be sure of what we have.
Plus, calling a function will always be slower than using a language construct, like you said. :P
hi.
thanks a lot for you help.but i just didn't get it yet.
sorry again guys.i just didn't explain my coding problem in detail before.i have a table consist of Product Code, Product Name, Bil of Product Ordered, Order and Update. Bil of Product Ordered is where the select box is where user need to choose their quantity of product.here part of my coding where i created the table. -
<table width="98%" border="0" bgcolor="#99CCFF" align="center" height="100">
-
<tr bgcolor="#99CCFF" align="center">
-
<td bgcolor="#99FFFF" align="center" height="27">
-
<div align="center"><b>Product Code</b></div>
-
</td>
-
<tr bgcolor="#99CCFF" align="center">
-
<td bgcolor="#99FFFF" align="center" height="27">
-
<div align="center"><b>Product Name</b></div>
-
</td>
-
<tr bgcolor="#99CCFF" align="center">
-
<td bgcolor="#99FFFF" align="center" height="27">
-
<div align="center"><b>Bil of Product Ordered</b></div>
-
</td>
-
<tr bgcolor="#99CCFF" align="center">
-
<td bgcolor="#99FFFF" align="center" height="27">
-
<div align="center"><b>Order</b></div>
-
</td>
-
<tr bgcolor="#99CCFF" align="center">
-
<td bgcolor="#99FFFF" align="center" height="27">
-
<div align="center"><b>Update</b></div>
-
</td>
-
do {
-
echo
-
'<tr bgcolor="#99CCFF" align="center">
-
<td bgcolor="#FFFFFF" align="center">' .$myrow["code_product"] . '</td>' . '
-
<td bgcolor="#FFFFFF" align="center">' . ucwords($myrow["product_name"]) . '</td>' . '
-
<td bgcolor="#FFFFFF" align="center">
-
<select name="bil_product" size="1">
-
<option>-</option>
-
<option value="1">1</option>
-
<option value="2">2</option>
-
<option value="3">3</option>
-
<option value="4">4</option>
-
<option value="5">5</option>
-
<option value="6">6</option>
-
<option value="7">7</option>
-
<option value="8">8</option>
-
<option value="9">9</option>
-
<option value="10">10</option>
-
</select> / Box
-
</font></td>
-
-
<td bgcolor="#FFFFFF" align="center"><a href="addorder.php?id_product=' . $myrow["id_product"] . '"><font face="Arial, Helvetica, sans-serif" size="2"><b><font color="#000099"><input type="Radio" name="RadioButton" value="RadioButton"> </font></b></font> </div></a></td>' . '
-
-
<td bgcolor="#FFFFFF" align="center"><a href="addorder.php?id_product=' . $myrow["id_product"] . '"><font face="Arial, Helvetica, sans-serif" size="2"><b><font color="#000099">[ Order ]</font></b></font> </div></a></td>' . '
so.when the user click at the radio button and Order link.all the database supppose to be inserted.
here is part of my coding at addorder.php file -
$trh = ( date("d/m/y"));
-
echo "<br>";
-
$sql = "INSERT INTO orders (roc_comp,id_product,code_product,stat_order,bil_product,date_order,date_up)
-
VALUES ('$nokp','$idproduct','$code_product','H','$bil_product','$trh','$trh')";
-
$result = mysql_query($sql);
-
i just don't know where to put you coding. however, i will try and error while waiting for your reply.
hope you guys can understand my coding.
sorry for my poor english.
Whenever the form is submitted, perform the business logic.
To check if a form has been submitted, check if the $_POST array is empty().
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Coz |
last post by:
Hi all,
I'm looking for help again!!! I have been writing a page to update a
database but now have another 'silly' problem with listbox's...Grrr...
I'm trying to populate the list box with...
|
by: Chris Gilbert |
last post by:
I'm quite stuck with this:
I have an import table called ReferenceMatchingImport which contains
data that has been sucked from a data submission. The contents of
this table have to be imported...
|
by: garimapuri |
last post by:
hi
ihad an array in php and iwant to insert its value in database
the coding is:
<?php
$nv_pairs = explode('&',$query_string);
$array;
list ($name, $value) = explode ('=',$nv_pairs);
$i = 0;...
|
by: jtocci |
last post by:
I'm having a big problem with CREATE RULE...ON INSERT...INSERT
INTO...SELECT...FROM...WHERE when I want to INSERT several (20~50)
records based on a single INSERT to a view. Either I get a 'too...
|
by: pb648174 |
last post by:
I have the following basic statements being executed:
Create a temp table, #TempPaging
Insert Into #TempPaging (Col1, Col2)
Select Col1, Col2 From SomeOtherTable Order By Col2, Col1
Select...
|
by: Phil Latio |
last post by:
I am inserting data into user table which contains 5 fields, sounds simple
enough normally but 2 of the fields are designated as UNIQUE. If someone
does enter a value which already exists, how do I...
|
by: julianomartins |
last post by:
Hi friends,
how I make to recoup the value of database and to keep selected in combobox to edit my form?
in script below it is selected field of the table that possesss id of the first item of...
|
by: cooperkuo |
last post by:
Dear all,
I have a question about ADO in the subform. I know how to use ADO to insert/update/select data into the sigin form, but wehn I try to do it in the form with subform((Datasheet). I don't...
|
by: Fary4u |
last post by:
Hi
is any body know where is actual problem is coz it's look me some problem ?
to insert value into the MS ACCESS DATABASE after the value is true form html
<input type="checkbox"...
|
by: chathura86 |
last post by:
public void insertData(String sql)
{
if(conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn ; //setting the connection to sql command
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |
