Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /*
- koneksi ke mysql lalu pilih databasenya
- */
- $c=mysql_connect('localhost', 'root', '') or die(mysql_error());
- $c=mysql_select_db('work_fb') or die (mysql_error());
- /*
- seharusnya tidak boleh memakai mysql karena di prog dasarnya
- sudah menggunakan mysqli
- */
- /* untuk menghasilkan nama sales*/
- if (isset($_GET[idSales])){
- $sql2=mysql_query("select * from sales where idsales='$_GET[idSales]' limit 1");
- $row=mysql_fetch_array($sql2);
- die( $row[namasales] );
- }
- ?><html>
- <head>
- <title>DATA PESANAN</title>
- <!-- sesuaikan posisi jquerynya -->
- <script type='text/javascript' src='jquery/jquery-1.7.2.min.js'></script>
- <script type='text/javascript'>
- var str="awal";
- getTabel();
- function getTabel(){
- $.post("kontrolData.php", { sendToValue: str },
- function(data){
- $('#display').html(data.kembalianDrPHP);
- }, "json");
- clearInput();
- }
- function insertBaris(form){
- var nomerpesan = form.nomerPesan.value;
- var jumlahpesan = form.jumlahPesan.value;
- var Idsales = form.idSales.value;
- var Namasales = form.namasales.value;
- var Tanggal = form.tanggal.value;
- var all = nomerpesan+","+jumlahpesan+","+Idsales+","+Namasales+","+Tanggal;
- $.post( "kontrolData.php", {'arrData[]': [nomerpesan,jumlahpesan,Idsales,Namasales,Tanggal]},
- function(data){
- $('#display').html(data.kembalianDrPHP);
- }, "json");
- clearInput();
- }
- function clearInput(){
- $('input[name=nomerPesan]').val('');
- $('input[name=jumlahPesan]').val('');
- $('select[name=idsales]').val('');
- $('input[name=namasales]').val('');
- $('input[name=tanggal]').val('');
- }
- function hapus(id){
- var id_sales = id;
- $.post("kontrolData.php", { deleteData: id_sales },
- function(data){
- $('#display').html(data.kembalianDrPHP);
- }, "json");
- clearInput();
- }
- function edit(idpesan){
- var id_pesan = idpesan;
- $.post("kontrolData.php", { editData:id_pesan },
- function(data){
- $('#display').html(data.kembalianDrPHP);
- }, "json");
- clearInput();
- }
- function update(form){
- var id = form.nomerPesan.value;
- var nama = form.jumlahPesan.value;
- var alamat = form.idSales.value;
- var nomer = form.namasales.value;
- var nr = form.tanggal.value;
- var all = id+","+nama+","+alamat+","+nomer+","+nr;
- $.post( "kontrolData.php", {'arrData1[]': [ id,nama,alamat,nomer,nr]},
- function(data){
- $('#display').html(data.kembalianDrPHP);
- }, "json");
- clearInput();
- }
- </script>
- </head>
- <body bgcolor="#CAB4D1">
- <div style="width:910px;margin: 0px auto;">
- <div style="background-color:green;text-align:center">
- <h1> Data Pemesan</h1>
- </div>
- <form name="form1" onSubmit="CheckForm()">
- <h4>DATA PEMESANAN</h4>
- <table id="input"><tr><td>
- Nomer Pesan
- </td><td>
- <input type="text" name="nomerPesan" size="3">
- </td></tr>
- <tr><td>
- Jumlah Pesanan
- </td><td>
- <input type="text" name="jumlahPesan">
- </td></tr>
- <tr><td>
- <td align="left"><input type="button" value= "mengecek"onclick="insertBaris(this.form);">
- </td></tr>
- <tr><td>
- Id Sales
- </td><td>
- <select type ="text" name='idSales' id="IdSales" >
- <!-- onchange="this.form.submit()" -->
- <?
- if ($_GET[idSales]==""){
- echo "<option value=''>-- Pilih --</option>
- ";
- }
- $q=mysql_query('select * from sales');
- while($r=mysql_fetch_array($q)){
- if ($_GET[idSales]!=""){
- echo "<option value=".$_GET[idSales].">".$_GET[idSales]."</option>";
- }
- else{
- echo "<option value=$r[idsales]>$r[idsales]</option>";
- }}
- echo " </select>";
- echo "<input type=text name=namasales readonly class=namesales />";
- ?>
- <!-- inilah yang membuat nama sales NONGOL -->
- <script>
- $("#IdSales").change(function(){
- t=$("select#IdSales :selected").text();
- url="?idSales="+t;
- $.get(url,function(e){
- $(".namesales").val(e);
- });
- });</script>
- <?
- /*
- if (isset($_GET[idSales])){
- $sql2=mysql_query("select * from sales where idsales='$_GET[idSales]'");
- while ($row=mysql_fetch_array($sql2)){
- echo "Nama Sales
- </td><td><input type=text name=namasales value=$row[namasales]";
- }
- }
- */
- ?>
- </td></tr>
- <tr><td>
- Tanggal
- </td><td>
- <input type="text" name="tanggal">
- </td></tr>
- <tr><td>
- <td align="left"><input type="button" value= "Simpan"onclick="insertBaris(this.form); ">
- </table>
- </form>
- <div id="display" ></div>
- </body>
- </td></tr>
- <div style="background-color:green;width:900px;
- clear:both;text-align:center;">footer</div>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement