- out.JPG (45.98 KiB) Viewed 1822 times
i need help on php mysql
Moderators: macek, egami, gesf
-
surfacesicks
- New php-forum User
- Posts: 5
- Joined: Wed Jun 26, 2013 5:55 pm
i need help on php mysql
dear masters, need help on how to do the coding like below image, its like when you enter the info in the form, it will display the below item (highlite in red) those info are from sql server, hope anyone can help me with this..i am totaly lost...
-
surfacesicks
- New php-forum User
- Posts: 5
- Joined: Wed Jun 26, 2013 5:55 pm
Re: i need help on php mysql
Hell OO...not much help here...hell oo...?? 
Re: i need help on php mysql
Go ahead and create that form. When a user fills the form, use ajax to transfer those input to a php script which will call mysql, get the details from the database and populate back on the page below the form.
-
surfacesicks
- New php-forum User
- Posts: 5
- Joined: Wed Jun 26, 2013 5:55 pm
Re: i need help on php mysql
that exactly what i want to do..but the problem here is how?
Re: i need help on php mysql
Here is an example:http://www.w3schools.com/php/php_ajax_livesearch.asp
-
surfacesicks
- New php-forum User
- Posts: 5
- Joined: Wed Jun 26, 2013 5:55 pm
Re: i need help on php mysql
<?php
include "function.php";
if(isset($_POST['add_serial'])){
$date = date("Y-m-d H:i:s");
$data = "'".$_POST['out_location']."','".$date."','".$_POST['out_qty']."','".$_POST['out_wo']."','";
$data .= $_POST['reciever']."','".$_POST['Ship_to']."','";
$data .= $_POST['out_serial']."','0'";
$column = "(`out_location`, `out_qty`, `out_wo`, `out_serial`, `Receiver`, `ship_to`, `remark`, `tmp`)";
$sql = "INSERT INTO kwip ".$column." VALUES(".$data.")";
insert_data_sql($sql);
exit;
}
if(isset($_POST['change_status'])){
$sql = "UPDATE kwip SET tmp='1' WHERE Serial='".$_POST['serial_no']."'";
insert_data_sql($sql);
exit;
function add_serial(){
var serial = $('#serial_array').val();
var serial_array = serial.split(',');
for (var i=0;i<serial_array.length;i++)
{
$.post("checkout.php", { serial_no: serial_array[i], change_status: "change" } );
}
location.reload();
}
function add_serial_tmp() {
var out_location= $('#out_location').val();
var out_qty= $('#out_qty').val();
var out_wo= $('#out_wo').val();
var out_serial= $('#out_serial').val();
var reciever= $('#Reciever').val();
var ship_to= $('#ship_to').val();
var remark= $('#remark').val();
$.post("checkout.php", {
out_location: out_location,
out_qty: out_qty,
out_wo: out_wo,
out_serial: out_serial,
reciever: reciever,
ship_to: ship_to,
remark: remark,
add_serial: "add"
})
.done(function (data) {
if (data = '0') {
$('#serial_holder tr:last').after('<tr id="so-' + so + '"><td>' + so + '</td><td><button onclick="delete_serial(\'$this\')">Delete</button></td></tr>');
var serial_array = $('#serial_array').val();
if(serial_array == '0'){
$('#serial_array').val(so);
}else{
$('#serial_array').val($('#serial_array').val()+','+so);
}
} else {
alert('error');
}
});
}
$(function () {
});
</script>
</head>
<body>
<p align="center" class="style1"><img src="../bannerLogo.png" width="1006" height="87" /><span class="style3"><a href="mainpage.css">Menu</a> <a href="report"></a></span> </p>
<p align="center" class="style1">Board Check-Out Information </p>
<table width="1000" border="0" align="center" bordercolor="#666666" background="../grey.jpg" bgcolor="#FFFFCC">
<tr>
<td bgcolor="#666666"> </td>
<td nowrap bgcolor="#666666"> </td>
</tr>
<tr>
<td width="414">
<strong>Out_Location</strong>
<label for="select"></label>
<label for="select"></label>
<select name="out_location" id="out_location">
<option value="SELECT">SELECT</option>
<option value="FG">FG</option>
<option value="Intel">Intel</option>
<option value="Production">Production</option>
</select>
</td>
<td width="570" nowrap><strong>Out_Qty</strong>
<label for="textfield"></label>
<input type="text" name="invoice" id="out_qty" />
</td>
</tr>
<tr>
<td> </td>
<td nowrap> </td>
</tr>
<tr>
<td><strong>Out_Serial</strong>
<label for="label"></label>
<label for="Submit"></label>
<label for="label"></label>
<input type="text" id="out_serial" />
<input onclick="add_serial_tmp();" id="add_in" type="button" id="add_in" value="add" />
</td>
<td> </td>
</tr>
<tr>
<td nowrap bgcolor="#666666"> </td>
<td nowrap bgcolor="#666666"> </td>
</tr>
<tr>
<td> </td>
<td nowrap> </td>
</tr>
<tr>
<td>
<td nowrap><strong>Reciever </strong>
<label for="textfield"></label>
<input name="reciever" type="text" id="reciever" value="" />
</td>
</tr>
<tr>
<td> </td>
<td nowrap> </td>
</tr>
<tr>
<td height="30"><strong>Ship_To</strong>
<label for="textfield"></label>
<input type="text" name="ship_to" id="ship_to" />
</td>
<td nowrap><strong>Remark</strong>
<label for="textfield"></label>
<input type="text" name="remark" id="remark" />
</td>
</tr>
<tr>
<td bgcolor="#666666"> </td>
<td nowrap bgcolor="#666666"> </td>
</tr>
<tr>
<td> </td>
<td nowrap> </td>
</tr>
<tr>
<td><label for="Submit"></label>
<input onclick="add_serial();" name="Submit2" type="submit" id="Submit2" value="Board Check Out!" />
</td>
<td nowrap> </td>
</tr>
<tr>
<td> </td>
<td nowrap> </td>
</tr>
<tr>
<td bgcolor="#666666"> </td>
<td nowrap bgcolor="#666666"> </td>
</tr>
</table>
<input type="hidden" id="serial_array" value="0">
<table id="serial_holder" width="500">
<th colspan="2" bgcolor="grey" align="left">Serial</th>
<tr>
<td></td>
<td></td>
</tr>
</table>
</body>
</html>
this is what i did..any comment?
include "function.php";
if(isset($_POST['add_serial'])){
$date = date("Y-m-d H:i:s");
$data = "'".$_POST['out_location']."','".$date."','".$_POST['out_qty']."','".$_POST['out_wo']."','";
$data .= $_POST['reciever']."','".$_POST['Ship_to']."','";
$data .= $_POST['out_serial']."','0'";
$column = "(`out_location`, `out_qty`, `out_wo`, `out_serial`, `Receiver`, `ship_to`, `remark`, `tmp`)";
$sql = "INSERT INTO kwip ".$column." VALUES(".$data.")";
insert_data_sql($sql);
exit;
}
if(isset($_POST['change_status'])){
$sql = "UPDATE kwip SET tmp='1' WHERE Serial='".$_POST['serial_no']."'";
insert_data_sql($sql);
exit;
function add_serial(){
var serial = $('#serial_array').val();
var serial_array = serial.split(',');
for (var i=0;i<serial_array.length;i++)
{
$.post("checkout.php", { serial_no: serial_array[i], change_status: "change" } );
}
location.reload();
}
function add_serial_tmp() {
var out_location= $('#out_location').val();
var out_qty= $('#out_qty').val();
var out_wo= $('#out_wo').val();
var out_serial= $('#out_serial').val();
var reciever= $('#Reciever').val();
var ship_to= $('#ship_to').val();
var remark= $('#remark').val();
$.post("checkout.php", {
out_location: out_location,
out_qty: out_qty,
out_wo: out_wo,
out_serial: out_serial,
reciever: reciever,
ship_to: ship_to,
remark: remark,
add_serial: "add"
})
.done(function (data) {
if (data = '0') {
$('#serial_holder tr:last').after('<tr id="so-' + so + '"><td>' + so + '</td><td><button onclick="delete_serial(\'$this\')">Delete</button></td></tr>');
var serial_array = $('#serial_array').val();
if(serial_array == '0'){
$('#serial_array').val(so);
}else{
$('#serial_array').val($('#serial_array').val()+','+so);
}
} else {
alert('error');
}
});
}
$(function () {
});
</script>
</head>
<body>
<p align="center" class="style1"><img src="../bannerLogo.png" width="1006" height="87" /><span class="style3"><a href="mainpage.css">Menu</a> <a href="report"></a></span> </p>
<p align="center" class="style1">Board Check-Out Information </p>
<table width="1000" border="0" align="center" bordercolor="#666666" background="../grey.jpg" bgcolor="#FFFFCC">
<tr>
<td bgcolor="#666666"> </td>
<td nowrap bgcolor="#666666"> </td>
</tr>
<tr>
<td width="414">
<strong>Out_Location</strong>
<label for="select"></label>
<label for="select"></label>
<select name="out_location" id="out_location">
<option value="SELECT">SELECT</option>
<option value="FG">FG</option>
<option value="Intel">Intel</option>
<option value="Production">Production</option>
</select>
</td>
<td width="570" nowrap><strong>Out_Qty</strong>
<label for="textfield"></label>
<input type="text" name="invoice" id="out_qty" />
</td>
</tr>
<tr>
<td> </td>
<td nowrap> </td>
</tr>
<tr>
<td><strong>Out_Serial</strong>
<label for="label"></label>
<label for="Submit"></label>
<label for="label"></label>
<input type="text" id="out_serial" />
<input onclick="add_serial_tmp();" id="add_in" type="button" id="add_in" value="add" />
</td>
<td> </td>
</tr>
<tr>
<td nowrap bgcolor="#666666"> </td>
<td nowrap bgcolor="#666666"> </td>
</tr>
<tr>
<td> </td>
<td nowrap> </td>
</tr>
<tr>
<td>
<td nowrap><strong>Reciever </strong>
<label for="textfield"></label>
<input name="reciever" type="text" id="reciever" value="" />
</td>
</tr>
<tr>
<td> </td>
<td nowrap> </td>
</tr>
<tr>
<td height="30"><strong>Ship_To</strong>
<label for="textfield"></label>
<input type="text" name="ship_to" id="ship_to" />
</td>
<td nowrap><strong>Remark</strong>
<label for="textfield"></label>
<input type="text" name="remark" id="remark" />
</td>
</tr>
<tr>
<td bgcolor="#666666"> </td>
<td nowrap bgcolor="#666666"> </td>
</tr>
<tr>
<td> </td>
<td nowrap> </td>
</tr>
<tr>
<td><label for="Submit"></label>
<input onclick="add_serial();" name="Submit2" type="submit" id="Submit2" value="Board Check Out!" />
</td>
<td nowrap> </td>
</tr>
<tr>
<td> </td>
<td nowrap> </td>
</tr>
<tr>
<td bgcolor="#666666"> </td>
<td nowrap bgcolor="#666666"> </td>
</tr>
</table>
<input type="hidden" id="serial_array" value="0">
<table id="serial_holder" width="500">
<th colspan="2" bgcolor="grey" align="left">Serial</th>
<tr>
<td></td>
<td></td>
</tr>
</table>
</body>
</html>
this is what i did..any comment?
Re: i need help on php mysql
if that is what you want and if it is working then I have no comments.
-
surfacesicks
- New php-forum User
- Posts: 5
- Joined: Wed Jun 26, 2013 5:55 pm
Re: i need help on php mysql
its not working...
Re: i need help on php mysql
What is the problem, what is the error that you are getting?
Re: i need help on php mysql
that exactly what i want to do..
Re: i need help on php mysql
what is the error that you are getting?
Return to “mySQL & php coding”
Who is online
Users browsing this forum: Google [Bot] and 1 guest