tag:blogger.com,1999:blog-4516147737488469652024-03-13T13:14:22.643-07:00Aplikasi PHP MySQLadminhttp://www.blogger.com/profile/11440739257392613074noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-451614773748846965.post-18913412349724869822012-06-13T00:53:00.000-07:002012-06-13T00:53:37.357-07:00Teknik Dasar Menggunakan variable $_GET<span class="" id="result_box" lang="id"><span class="hps"></span><span class="hps"></span><span class="hps">Variabel</span> <i><span class="hps">$</span> <span class="hps">_GET</span></i> <span class="hps">standar digunakan</span> <span class="hps">untuk mengumpulkan</span> <span class="hps">nilai dalam</span> <span class="hps">formulir dengan</span> <span class="hps">metode =</span> <i><span class="hps">"get"</span></i><br />
<br />
<span class="hps">Informasi</span> <span class="hps">yang dikirim dari</span> <span class="hps">formulir dengan</span> <span class="hps">metode<i> GET</i></span> <span class="hps">dapat dilihat oleh</span> <span class="hps atn">semua orang (</span><span class="">ini akan ditampilkan</span> <span class="hps">di address bar</span> <span class="hps">browser</span><span>) dan memiliki</span> <span class="hps">batasan pada</span> <span class="hps">jumlah informasi</span> <span class="hps">untuk mengirim.</span><br />
<span class="hps"> </span></span><br />
<span class="" id="result_box" lang="id"><span class="hps">Contoh</span></span><br />
<span class="" id="result_box" lang="id"><span class="hps"> <i><form action="welcome.php" method="get"><br />
Name: <input type="text" name="fname" /><br />
Age: <input type="text" name="age" /><br />
<input type="submit" /><br />
</form> </i></span></span><br />
<span class="" id="result_box" lang="id"><span class="hps"><br />
</span></span><br />
<span class="" id="result_box" lang="id"><span class="hps">Ketika</span> <span class="hps">pengguna mengklik</span> <span class="hps atn">"</span><span>Kirim</span><span class="">" tombol,</span> <i><span class="hps">URL</span></i> <span class="hps">dikirim ke server</span> <span class="hps">bisa terlihat seperti</span> <span class="hps">ini:</span></span><br />
<br />
<span class="" id="result_box" lang="id"><span class="hps"> <i>http://www.w3schools.com/welcome.php?fname=Peter&age=37 </i></span></span><br />
<br />
<span class="" id="result_box" lang="id"><span class="hps atn"><i>"</i></span><i><span>welcome.php</span></i><span><i>"</i> file</span> <span class="hps">sekarang dapat menggunakan</span> <span class="hps">variabel <i>$</i></span><i> <span class="hps">_GET</span></i> <span class="hps">untuk mengumpulkan</span> <span class="hps">data formulir</span> <span class="hps atn">(</span><span>nama-nama</span> <span class="hps">kolom formulir</span> <span class="hps">secara otomatis</span> <span class="hps">akan menjadi</span> <span class="hps">kunci</span> <span class="hps">dalam <i>array</i></span><i> <span class="hps">$ _GET</span></i><span class="">):</span></span><br />
<br />
<span class="" id="result_box" lang="id"><span class=""><i>Welcome <?php echo $_GET["fname"]; ?>.<br /><br />
You are <?php echo $_GET["age"]; ?> years old! </i></span></span><br />
<span class="" id="result_box" lang="id"><span class="hps"><br />
</span></span>adminhttp://www.blogger.com/profile/11440739257392613074noreply@blogger.com1tag:blogger.com,1999:blog-451614773748846965.post-26256086382091038192012-06-13T00:38:00.001-07:002012-06-13T00:39:01.918-07:00Dasar Membuat Form Input Untuk User Dengan PHP<span class="short_text" id="result_box" lang="id"><span class="hps alt-edited">Form </span></span><span class="short_text" id="result_box" lang="id"><span class="hps">PHP</span> <span class="hps alt-edited"> dan</span> <span class="hps">User Input</span></span><br />
<span class="short_text" id="result_box" lang="id"><span class="hps"></span></span><span class="" id="result_box" lang="id"><span class="hps">Menangani Form PHP </span><span class="hps"></span><span class="hps"></span><br />
<span class="hps">Yang paling</span> <span class="hps">penting untuk diperhatikan</span> <span class="hps">ketika berhadapan</span> <span class="hps">dengan bentuk-bentuk</span> <span class="hps">HTML dan PHP</span> <span class="hps">adalah bahwa setiap</span> <span class="hps">elemen form</span> <span class="hps">dalam sebuah halaman</span> <span class="hps">HTML secara otomatis</span> <span class="hps">akan tersedia untuk</span> <a href="http://www.panduanskripsi.net/"><b><span class="hps">skrip</span> <span class="hps">PHP</span></b></a> <span class="hps">Anda</span>.<br />
<span class="hps"></span><br />
<span class="hps">Contoh di bawah ini</span> <span class="hps">berisi</span> <span class="hps">bentuk HTML</span> <span class="hps">dengan dua</span> <span class="hps">field input</span> <span class="hps">dan sebuah</span> <span class="hps">tombol submit</span>:</span><br />
<span class="" id="result_box" lang="id"> <i><html><br />
<body><br />
<form action="welcome.php" method="post"><br />
Name: <input type="text" name="fname" /><br />
Age: <input type="text" name="age" /><br />
<input type="submit" /><br />
</form><br />
</body><br />
</html> </i></span><br />
<br />
<span class="" id="result_box" lang="id"><span class="hps">Ketika pengguna</span> <span class="hps">mengisi</span> <span class="hps">form</span> <span class="hps">di atas dan</span> <span class="hps">klik pada</span> <span class="hps">tombol submit</span>, <span class="hps">data formulir</span> <span class="hps">dikirim ke</span> <span class="hps">sebuah file PHP</span><span class="atn">, yang disebut <i>"</i></span><i>welcome.php</i><i>"</i>:<br />
<br />
<span class="hps atn">"</span><i>welcome.php"</i> <span class="hps">terlihat seperti ini:</span></span><br />
<i><span class="" id="result_box" lang="id"><span class="hps"><html><br />
<body><br />
Welcome <?php echo $_POST["fname"]; ?>!<br /><br />
You are <?php echo $_POST["age"]; ?> years old.<br />
</body><br />
</html> </span></span></i><br />
<span class="" id="result_box" lang="id"><span class="hps"><br />
</span></span><br />
<span class="short_text" id="result_box" lang="id"><span class="hps">Keluaran</span> <span class="hps">bisa menjadi sesuatu</span> <span class="hps">seperti ini:</span></span><br />
<span class="short_text" id="result_box" lang="id"><span class="hps"> <i>Welcome John!<br />
You are 28 years old. </i></span></span>adminhttp://www.blogger.com/profile/11440739257392613074noreply@blogger.com0tag:blogger.com,1999:blog-451614773748846965.post-72890217628783377382012-06-13T00:27:00.000-07:002012-06-13T00:27:00.367-07:00Membuat Nilai Return DAlam Fungsi PHP<span class="" id="result_box" lang="id"><span class="hps">Fungsi</span> <span class="hps">PHP</span> <span class="hps">-</span> <span class="hps">nilai</span> <span class="hps">Kembali</span><br />
<span class="hps">Untuk membiarkan</span> <span class="hps">suatu fungsi</span> <span class="hps">mengembalikan nilai,</span> <span class="hps">menggunakan</span> <span class="hps">pernyataan kembali</span><span class="">.</span></span><br />
<br />
<span class="" id="result_box" lang="id"><span class="">Contoh: </span></span><br />
<div style="font-family: "Courier New",Courier,monospace;"><i><span class="" id="result_box" lang="id"><span class=""> <html><br />
<body><br />
<?php<br />
function add($x,$y)<br />
{<br />
$total=$x+$y;<br />
return $total;<br />
}<br />
echo "1 + 16 = " . add(1,16);<br />
?><br />
</body><br />
</html></span></span></i></div><br />
<span class="" id="result_box" lang="id"><span class="">Hasilnya:</span></span><br />
<span class="" id="result_box" lang="id"><span class=""><i><span style="font-family: "Courier New",Courier,monospace;">1 + 16 = 17 </span></i></span></span>adminhttp://www.blogger.com/profile/11440739257392613074noreply@blogger.com0tag:blogger.com,1999:blog-451614773748846965.post-62057185126583583452012-06-13T00:20:00.001-07:002012-06-13T00:22:24.017-07:00Cara Menambahkan Parameter Dalam Fungsi PHP<span class="" id="result_box" lang="id"><span class="hps">Fungsi</span> <span class="hps">PHP</span> <span class="hps">-</span> <span class="hps">Menambahkan</span> <span class="hps">parameter</span><br />
<br />
<span class="hps">Untuk menambahkan</span> <span class="hps">fungsionalitas lebih</span> <span class="hps">ke fungsi,</span> <span class="hps">kita dapat menambahkan</span> <span class="hps">parameter.</span> <span class="hps">Parameter A</span> <span class="hps">adalah seperti</span> <span class="hps">variabel.</span><br />
<span class="hps">Parameter</span> <span class="hps">yang ditetapkan</span> <span class="hps">setelah</span> <span class="hps">nama fungsi</span>, di dalam <span class="hps">kurung.</span><br />
<span class="hps">Contoh 1</span><br />
<span class="hps">Contoh berikut</span> <span class="hps">akan menulis</span> <span class="hps">nama</span> <span class="hps">pertama yang berbeda</span><span class="">, tapi</span> <span class="hps">nama belakang</span> <span class="hps">sama</span><span class="">:</span></span><br />
<div style="font-family: "Courier New",Courier,monospace;"><i><span class="" id="result_box" lang="id"><span class=""> <html><br />
<body><br />
<?php<br />
function writeName($fname)<br />
{<br />
echo $fname . " Refsnes.<br />";<br />
}<br />
echo "My name is ";<br />
writeName("Kai Jim");<br />
echo "My sister's name is ";<br />
writeName("Hege");<br />
echo "My brother's name is ";<br />
writeName("Stale");<br />
?><br />
</body><br />
</html> </span></span></i></div><br />
<span class="" id="result_box" lang="id"><span class="">Hasilnya:</span></span><br />
<div style="font-family: "Courier New",Courier,monospace;"><i><span class="" id="result_box" lang="id"><span class="">My name is Kai Jim Refsnes.<br />
My sister's name is Hege Refsnes.<br />
My brother's name is Stale Refsnes.</span></span></i></div><br />
<span class="" id="result_box" lang="id"><span class=""></span></span><span class="short_text" id="result_box" lang="id"><span class="hps">Contoh 2</span><br />
<span class="hps">Fungsi</span> <span class="hps">memiliki dua parameter</span> <span class="hps">berikut</span>:</span><br />
<br />
<span class="" id="result_box" lang="id"><span class=""><i><span style="font-family: "Courier New",Courier,monospace;"> <html></span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"><body></span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"><?php</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">function writeName($fname,$punctuation)</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">{</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">echo $fname . " Refsnes" . $punctuation . "<br />";</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">}</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">echo "My name is ";</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">writeName("Kai Jim",".");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">echo "My sister's name is ";</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">writeName("Hege","!");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">echo "My brother's name is ";</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">writeName("Ståle","?");</span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;">?></span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"></body></span><br style="font-family: "Courier New",Courier,monospace;" /><span style="font-family: "Courier New",Courier,monospace;"></html></span></i> </span></span><br />
<span class="" id="result_box" lang="id"><span class=""><br />
</span></span><br />
<span class="" id="result_box" lang="id"><span class="">Hasilnya:</span></span><br />
<div style="font-family: "Courier New",Courier,monospace;"><i><span class="" id="result_box" lang="id"><span class="">My name is Kai Jim Refsnes.<br />
My sister's name is Hege Refsnes!<br />
My brother's name is Ståle Refsnes? </span></span></i></div>adminhttp://www.blogger.com/profile/11440739257392613074noreply@blogger.com1tag:blogger.com,1999:blog-451614773748846965.post-40560422262393994502012-06-13T00:07:00.000-07:002012-06-13T00:07:35.464-07:00Membuat Sebuah Fungsi Dalam Skrip PHP<span class="" id="result_box" lang="id"><span class="hps"></span><span class="hps"></span></span><span class="" id="result_box" lang="id"><span class="hps"></span><span class="hps">Untuk menjaga</span> <a href="http://www.panduanskripsi.net/"><b><span class="hps">script</span> PHP</b></a> <span class="hps">pada waktu dijalankan</span><span class="hps"></span><span class="hps"></span><span>, Anda dapat</span> <span class="hps">memasukkannya ke dalam</span> <span class="hps">fungsi.</span><br />
<span class="hps">Sebuah fungsi</span> <span class="hps">akan dieksekusi</span> <span class="hps">dengan sebuah panggilan ke</span> <span class="hps">fungsi.</span><br />
<span class="hps">Anda bisa</span> <span class="hps">memanggil fungsi</span> <span class="hps">dari manapun di</span> <span class="hps">page.</span></span><br />
<br />
<span class="" id="result_box" lang="id"><span class="hps">Memb</span></span><span class="" id="result_box" lang="id"><span class="hps">uat</span> <span class="hps">Fungsi PHP</span><br />
<span class="hps">Sebuah fungsi</span> <span class="hps">akan dieksekusi</span> <span class="hps">dengan sebuah panggilan ke</span> <span class="hps">fungsi.</span></span><br />
<br />
<span class="" id="result_box" lang="id"><span class="hps">Sintaknya:</span></span><br />
<span class="" id="result_box" lang="id"><span class="hps"> </span></span><i><span class="" id="result_box" lang="id" style="font-family: "Courier New",Courier,monospace;"><span class="hps"> function functionName()<br />
{<br />
code to be executed;<br />
} </span></span></i><br />
<span class="" id="result_box" lang="id"><span class="hps"><br />
</span></span><br />
<span class="" id="result_box" lang="id"> <span class="hps">Pedoman </span></span><span class="" id="result_box" lang="id"><span class="hps">fungsi PHP</span><span class="hps"></span><span>:</span><br />
<br />
<span class="hps">Berikan</span> <span class="hps">fungsi</span> <span class="hps">nama yang</span> <span class="hps">mencerminkan apa</span> <span class="hps">fungsi</span> <span class="hps">tidak</span><br />
<span class="hps">Nama</span> <span class="hps">fungsi dapat</span> <span class="hps">mulai dengan</span> <span class="hps">huruf atau underscore</span> <span class="hps atn">(</span><span>bukan angka</span><span>)</span><br />
<br />
<span class="hps">Contoh</span><br />
<span class="hps"></span><span class="hps"></span></span><br />
<br />
<div style="font-family: "Courier New",Courier,monospace;"><i><span class="" id="result_box" lang="id"><span class="hps">< html><br />
<body><br />
<?php<br />
function writeName()<br />
{<br />
echo "Kai Jim Refsnes";<br />
}<br />
<br />
echo "My name is ";<br />
writeName();<br />
?><br />
</body><br />
</html> </span></span></i></div><br />
Hasilnya:<br />
<i><span style="font-family: "Courier New",Courier,monospace;"> My name is Kai Jim Refsnes </span></i><br />
<span class="" id="result_box" lang="id"><span class="hps"><br />
</span></span>adminhttp://www.blogger.com/profile/11440739257392613074noreply@blogger.com0tag:blogger.com,1999:blog-451614773748846965.post-88607566623962675132012-06-12T23:36:00.001-07:002012-06-12T23:37:47.341-07:00Cara menghapus Data Dari Database MySQL<span class="" id="result_box" lang="id"><span class="hps">Klausa<i> DELETE FROM</i> adalah </span><span class="hps">pernyataan yang</span> <span class="hps">digunakan untuk</span> <span class="hps">menghapus catatan</span> <span class="hps">dari tabel database</span><span class="">.</span></span><br />
<span class="" id="result_box" lang="id"><span class=""> </span><br />
<span class="hps">Sintaksis</span></span><br />
<i><span class="" id="result_box" lang="id"><span class="hps">DELETE FROM table_name<br />
WHERE some_column = some_value </span></span></i><br />
<span class="" id="result_box" lang="id"><span class="hps"><br />
</span></span><br />
<span class="" id="result_box" lang="id"><span class="hps">Catatan:</span> </span><br />
<span class="" id="result_box" lang="id"><span class="hps">Perhatikan</span> <span class="hps">klausa <i>WHERE</i></span> <span class="hps">dalam sintaks</span> <span class="hps"><i>DELETE</i>.</span> <span class="hps">Klausa<i> WHERE</i></span><i> </i><span class="hps">menentukan</span> <span class="hps">yang merekam</span> <span class="hps">atau catatan</span> <span class="hps">yang harus</span> <span class="hps">dihapus.</span> <span class="hps">Jika Anda menghilangkan</span> <span class="hps">klausa <i>WHERE</i></span><span class="">,</span> <span class="hps">semua<i> record</i> akan</span> <span class="hps">dihapus!</span></span><br />
<br />
<span class="" id="result_box" lang="id"><span class="hps">Untuk mendapatkan</span> <span class="hps">PHP untuk</span> <span class="hps">mengeksekusi</span> <span class="hps">pernyataan di atas</span> <span class="hps">kita harus menggunakan</span> </span><span class="" id="result_box" lang="id"><span class="hps">fungsi</span></span><span class="" id="result_box" lang="id"> <i><span class="hps">mysql_query</span> </i><span class="hps"><i>()</i>.</span> <span class="hps">Fungsi ini digunakan</span> <span class="hps">untuk mengirim</span> <span class="hps">query atau</span> <span class="hps">perintah</span> <span class="hps">ke koneksi</span><b> </b><span class="hps"><a href="http://www.panduanskripsi.net/"><b>MySQL</b></a>.</span><br />
<span class="hps"> </span></span><br />
<span class="" id="result_box" lang="id"><span class="hps">contoh</span><br />
<span class="hps">Lihatlah</span> <span class="hps">tabel berikut</span> <span class="hps">"Persons"</span><span class="">:</span></span><br />
<br />
<span class="" id="result_box" lang="id"><span class=""> </span></span><span class="" id="result_box" lang="id"><span class="hps">First Name</span> : </span><span class="" id="result_box" lang="id"><span class="hps">Peter, </span></span><span class="" id="result_box" lang="id"><span class="hps">Glenn</span></span><br />
<span class="" id="result_box" lang="id"> <span class="hps">Last Name</span> : </span><span class="" id="result_box" lang="id"><span class="hps">Griffin, </span></span><span class="" id="result_box" lang="id"> <span class="hps"></span><span class="hps">Quagmire</span></span><span class="" id="result_box" lang="id"><span class="hps"></span></span><br />
<span class="" id="result_box" lang="id"><span class="hps"> Age </span></span> : <span class="" id="result_box" lang="id"><span class="hps">35, </span></span><span class="" id="result_box" lang="id"> <span class="hps">33</span></span><br />
<span class="" id="result_box" lang="id"> <span class="hps"></span> <span class="hps"></span><br />
<span class="hps"></span></span><br />
<span class="" id="result_box" lang="id"><span class="hps"> </span></span><span class="" id="result_box" lang="id"><span class="hps">Akan menghapus</span> <span class="hps">contoh berikut</span> <span class="hps">semua catatan</span> <span class="hps atn">dalam tabel <i>"</i></span><i>Persons"</i> <span class="hps">di mana</span> <span class="hps">Last Name</span> <span class="hps atn">= '</span><span class="">Griffin</span><span class="">':</span></span><br />
<br />
<span class="" id="result_box" lang="id"><span class=""> <i><?php<br />
$con = mysql_connect("localhost","peter","abc123");<br />
if (!$con)<br />
{<br />
die('Could not connect: ' . mysql_error());<br />
}<br />
<br />
mysql_select_db("my_db", $con);<br />
<br />
mysql_query("DELETE FROM Persons WHERE LastName='Griffin'");<br />
<br />
mysql_close($con);<br />
?> </i></span></span><br />
<br />
<span class="" id="result_box" lang="id"><span class="hps">Setelah</span> <span class="hps">penghapusan,</span> <span class="hps">table akan</span> <span class="hps">terlihat seperti ini:</span><br />
<span class="hps"></span></span><span class="" id="result_box" lang="id"><span class=""></span></span><span class="" id="result_box" lang="id"><span class="hps">First Name</span> : </span><span class="" id="result_box" lang="id"><span class="hps"> </span></span><span class="" id="result_box" lang="id"><span class="hps">Glenn</span></span><br />
<span class="" id="result_box" lang="id"> <span class="hps">Last Name</span> : </span><span class="" id="result_box" lang="id"><span class="hps"></span></span><span class="" id="result_box" lang="id"> <span class="hps">Quagmire</span></span><span class="" id="result_box" lang="id"><span class="hps"></span></span><br />
<span class="" id="result_box" lang="id"><span class="hps"> Age </span></span> : <span class="" id="result_box" lang="id"><span class="hps"></span></span><span class="" id="result_box" lang="id"> <span class="hps">33</span></span><br />
<span class="" id="result_box" lang="id"><span class=""><br />
</span></span>adminhttp://www.blogger.com/profile/11440739257392613074noreply@blogger.com0tag:blogger.com,1999:blog-451614773748846965.post-6839121485243303462012-06-12T21:37:00.001-07:002012-06-12T21:45:38.855-07:00Cara Memanggil Data Dari Databse MySQL<span class="" id="result_box" lang="id"><span class="hps">Pernyataan</span> <i><span class="hps">SELECT</span></i> <span class="hps">digunakan untuk memilih</span> <span class="hps">data dari</span> <span class="hps">database.</span><br />
<span class="hps">Sintaksis:</span></span><br />
<br />
<span class="" id="result_box" lang="id"><span class="hps"><i>SELECT column_name(s)<br />
FROM table_name</i> </span></span><br />
<span class="" id="result_box" lang="id"><span class="hps"><br />
</span></span><br />
<span class="" id="result_box" lang="id"><span class="hps">Untuk mendapatkan</span> <span class="hps">PHP untuk</span> <span class="hps">mengeksekusi</span> <span class="hps">pernyataan di atas</span> <span class="hps">kita harus menggunakan </span></span><span class="" id="result_box" lang="id"><span class="hps">fungsi</span></span><span class="" id="result_box" lang="id"><span class="hps"></span> <i><span class="hps">mysql_query</span> </i><span class="hps"><i>()</i>.</span> <span class="hps">Fungsi ini digunakan</span> <span class="hps">untuk mengirim</span> <span class="hps">query atau</span> <span class="hps">perintah</span> <span class="hps">ke koneksi</span><b> </b><span class="hps"><a href="http://www.panduanskripsi.net/"><b>MySQL</b></a>.</span><br />
<span class="hps"></span><br />
<span class="hps">Contoh berikut</span> <span class="hps">memilih semua</span> <span class="hps">data yang disimpan</span> <span class="hps atn">dalam tabel </span></span><i>"Persons"</i> <span class="" id="result_box" lang="id"><span class="hps atn"></span> <span class="hps atn">(</span>Karakter <span class="hps">'*'</span> <span class="hps">memilih semua</span> <span class="hps">data dalam tabel</span>):</span><br />
<i><?php<br />
$con = mysql_connect("localhost","peter","abc123");<br />
if (!$con)<br />
{<br />
die('Could not connect: ' . mysql_error());<br />
}<br />
<br />
mysql_select_db("my_db", $con);<br />
<br />
$result = mysql_query("SELECT * FROM Persons");<br />
<br />
while($row = mysql_fetch_array($result))<br />
{<br />
echo $row['FirstName'] . " " . $row['LastName'];<br />
echo "<br />";<br />
}<br />
<br />
mysql_close($con);<br />
?> </i><br />
<span class="" id="result_box" lang="id"><span class="hps">Contoh di atas</span> <span class="hps">toko</span> <span class="hps">data yang dikembalikan</span> <span class="hps">oleh</span> </span><span class="" id="result_box" lang="id"><span class="hps"> fungsi </span></span><span class="" id="result_box" lang="id"><i><span class="hps">mysql_query</span> <span class="hps">()</span></i> <span class="hps">dalam variabel</span> <i><span class="hps">$ hasil</span></i>.<br />
<br />
<span class="hps">Selanjutnya,</span> <span class="hps">kita menggunakan</span> </span><span class="" id="result_box" lang="id"><span class="hps">fungsi</span></span><span class="" id="result_box" lang="id"> <i><span class="hps">mysql_fetch_array</span> </i><span class="hps"><i>()</i> </span><span class="hps">untuk mengembalikan</span> <span class="hps">baris pertama</span> <span class="hps">dari</span> <span class="hps">recordset</span> <span class="hps">sebagai array.</span> <span class="hps">Setiap panggilan ke</span> <i><span class="hps">mysql_fetch_array</span> </i><span class="hps"><i>()</i> mengembalikan</span> <span class="hps">baris</span> <span class="hps">berikutnya dalam</span> <span class="hps">recordset</span>. <span class="hps">Sementara loop</span> <span class="hps">loop melalui</span> <span class="hps">semua catatan dalam</span> <span class="hps">recordset</span>. <span class="hps">Untuk mencetak</span> <span class="hps">nilai dari</span> <span class="hps">setiap baris,</span> <span class="hps">kita menggunakan</span> <span class="hps">variabel</span> <i><span class="hps">$ row</span> <span class="hps atn">PHP (</span><span class="">$ row</span> <span class="hps atn">['</span><span class="">FirstName</span><span class="">']</span> <span class="hps">dan</span> <span class="hps">$ row</span> <span class="hps atn">['</span>LastName']</i><i>)</i>.<br />
<br />
<span class="hps">Output dari</span> <span class="hps">kode di atas</span> <span class="hps">akan menjadi:</span></span><br />
<span class="" id="result_box" lang="id"><span class="hps"><i>Peter Griffin<br />
Glenn Quagmire </i></span></span><br />
<br />
<span class="" id="result_box" lang="id"><span class="hps">Menampilkan</span> <span class="hps">Hasil</span> <span class="hps">dalam</span> <span class="hps">Tabel</span> <span class="hps">HTML</span><br />
<br />
<span class="hps">Contoh berikut</span> <span class="hps">memilih data</span> <span class="hps">yang sama seperti</span> <span class="hps">contoh di atas,</span> <span class="hps">tetapi akan</span> <span class="hps">menampilkan data dalam</span> <span class="hps">sebuah tabel HTML</span><span class="">:</span></span><br />
<br />
<span class="" id="result_box" lang="id"><span class=""><i><?php<br />
$con = mysql_connect("localhost","peter","abc123");<br />
if (!$con)<br />
{<br />
die('Could not connect: ' . mysql_error());<br />
}<br />
<br />
mysql_select_db("my_db", $con);<br />
<br />
$result = mysql_query("SELECT * FROM Persons");<br />
<br />
echo "<table border='1'><br />
<tr><br />
<th>Firstname</th><br />
<th>Lastname</th><br />
</tr>";<br />
<br />
while($row = mysql_fetch_array($result))<br />
{<br />
echo "<tr>";<br />
echo "<td>" . $row['FirstName'] . "</td>";<br />
echo "<td>" . $row['LastName'] . "</td>";<br />
echo "</tr>";<br />
}<br />
echo "</table>";<br />
<br />
mysql_close($con);<br />
?></i> </span></span>adminhttp://www.blogger.com/profile/11440739257392613074noreply@blogger.com1tag:blogger.com,1999:blog-451614773748846965.post-27425857280339528692012-06-12T21:22:00.000-07:002012-06-12T21:22:52.820-07:00Cara Mingisikan Data Ke Table Database MySQL<span class="" id="result_box" lang="id"><i><span class="hps">INSERT</span> <span class="hps">INTO</span> </i><span class="hps">digunakan untuk</span> <span class="hps">menambahkan<i> record</i></span> <span class="hps">baru ke</span> <span class="hps">tabel <i>database</i>.</span><br />
<span class="hps">Hal ini dimungkinkan untuk</span> <span class="hps">menulis</span> <span class="hps">perintah INSERT INTO</span> <span class="hps">dalam dua bentuk.</span><br />
<br />
<span class="hps">Bentuk pertama</span> <span class="hps">tidak menentukan</span> <span class="hps">nama kolom</span> <span class="hps">di mana</span> <span class="hps">data akan</span> <span class="hps">dimasukkan,</span> <span class="hps">hanya</span> <span class="hps">nilai-nilai mereka</span><span class="">:</span></span><br />
<br />
<span class="" id="result_box" lang="id"><span class=""> <i>INSERT INTO table_name<br />
VALUES (value1, value2, value3,...) </i></span></span><br />
<span class="" id="result_box" lang="id"><span class=""><br />
</span></span><br />
<span class="" id="result_box" lang="id"><span class="hps">Bentuk kedua</span> <span class="hps">menetapkan</span> <span class="hps">kedua nama</span> <span class="hps">kolom dan</span> <span class="hps">nilai-nilai</span> <span class="hps">yang akan dimasukkan</span><span class="">:</span></span><br />
<br />
<i><span class="" id="result_box" lang="id"><span class="">INSERT INTO table_name (column1, column2, column3,...)<br />
VALUES (value1, value2, value3,...) </span></span></i><br />
<span class="" id="result_box" lang="id"><span class=""><br />
</span></span><br />
<span class="" id="result_box" lang="id"><span class="hps">Untuk mempelajari lebih lanjut</span> <span class="hps">tentang SQL</span><span>, silakan kunjungi</span><b> <a href="http://www.panduanskripsi.net/">tutorial SQL</a></b><a href="http://www.blogger.com/goog_1459637889"><b><span class="hps"></span></b></a><span class="hps"> kami.</span><br />
<br />
<span class="hps">Untuk mendapatkan</span> <span class="hps">PHP untuk</span> <span class="hps">mengeksekusi</span> <span class="hps">pernyataan di atas</span> <span class="hps">kita harus menggunakan</span> </span><span class="" id="result_box" lang="id"><span class="hps">fungsi</span></span><span class="" id="result_box" lang="id"> <i><span class="hps">mysql_query</span> </i><span class="hps"><i>()</i>.</span> <span class="hps">Fungsi ini digunakan</span> <span class="hps">untuk mengirim</span> <span class="hps">query atau</span> <span class="hps">perintah</span> <span class="hps">ke koneksi</span><b> </b><span class="hps"><a href="http://www.panduanskripsi.net/"><b>MySQL</b></a>.</span> <span class="hps"></span></span><span class="" id="result_box" lang="id"></span><br />
<span class="" id="result_box" lang="id"><span class="hps"></span><br />
<span class="hps">Dalam bab</span> <span class="hps">sebelumnya kita</span> <span class="hps">membuat</span> <span class="hps">tabel bernama</span> <span class="hps"></span></span> <i>"Persons"</i><span class="" id="result_box" lang="id"><span class="hps"></span><span>, dengan tiga</span> <span class="hps">kolom;</span> </span><i>"Firstname", "Lastname" and "Age"</i><span class="" id="result_box" lang="id"><i><span></span></i><span>.</span> <span class="hps">Kami akan menggunakan</span> <span class="hps">tabel yang sama</span> <span class="hps">dalam contoh ini.</span> <span class="hps">Contoh berikut</span> <span class="hps">menambahkan</span> <span class="hps">dua catatan</span> <span class="hps">baru ke</span> <span class="hps atn">tabel </span></span><i>"Persons"</i><span class="" id="result_box" lang="id"><span class="hps"></span><span></span></span><span class="" id="result_box" lang="id"><span class="hps atn"></span><span class="">:</span></span><br />
<br />
<i><span class="" id="result_box" lang="id"><span class=""> <?php<br />
$con = mysql_connect("localhost","peter","abc123");<br />
if (!$con)<br />
{<br />
die('Could not connect: ' . mysql_error());<br />
}<br />
<br />
mysql_select_db("my_db", $con);<br />
<br />
mysql_query("INSERT INTO Persons (FirstName, LastName, Age)<br />
VALUES ('Peter', 'Griffin',35)");<br />
<br />
mysql_query("INSERT INTO Persons (FirstName, LastName, Age)<br />
VALUES ('Glenn', 'Quagmire',33)");<br />
<br />
mysql_close($con);<br />
?></span></span></i><br />
<br />
<span class="" id="result_box" lang="id"><span class=""> </span></span><span class="" id="result_box" lang="id"><span class="hps">Memasukkan</span> <span class="hps">Data Dari</span> <span class="hps">Formulir</span> <span class="hps">Ke</span> <span class="hps">Database</span><br />
<br />
<span class="hps">Sekarang kita akan membuat</span> <span class="hps">form HTML</span> <span class="hps">yang dapat digunakan</span> <span class="hps">untuk</span> <span class="hps">menambahkan record</span> <span class="hps">baru ke dalam tabel</span> <span class="hps"></span></span><i>"Persons"</i><span class="" id="result_box" lang="id"><span class="hps"></span><span></span></span><span class="" id="result_box" lang="id"><span class="hps"></span><span>.</span></span><br />
<span class="" id="result_box" lang="id"></span><br />
<span class="" id="result_box" lang="id"><br />
<span class="hps">Berikut adalah</span> <span class="hps">bentuk HTML</span><span class="">:</span></span><br />
<br />
<i><span class="" id="result_box" lang="id"><span class=""> <html><br />
<body><br />
<form action="insert.php" method="post"><br />
Firstname: <input type="text" name="firstname" /><br />
Lastname: <input type="text" name="lastname" /><br />
Age: <input type="text" name="age" /><br />
<input type="submit" /><br />
</form><br />
<br />
</body><br />
</html> </span></span></i><br />
<span class="" id="result_box" lang="id"><span class=""><br />
</span></span><br />
<span class="" id="result_box" lang="id"><span class="hps">Bila pengguna mengklik</span> <span class="hps">tombol submit</span> <span class="hps">dalam bentuk</span> <span class="hps">HTML</span> <span class="hps">pada contoh di atas</span><span>,</span> <span class="hps">data formulir</span> <span class="hps">dikirim ke</span> <i><span class="hps atn">"</span><span>insert.php</span><span>".</span></i><br />
</span><br />
<span class="" id="result_box" lang="id"> <span class="hps atn"><i>"</i></span><i><span>insert.php</span></i><span><i>"</i> file</span> <span class="hps">menghubungkan</span> <span class="hps">ke database,</span> <span class="hps">dan mengambil</span> <span class="hps">nilai dari</span> <span class="hps">formulir dengan</span> </span><span class="" id="result_box" lang="id"> <span class="hps">variabel</span></span><span class="" id="result_box" lang="id"> <i><span class="hps">$</span> <span class="hps">_POST</span></i><span class="hps"> PHP</span><span>.</span><br />
<br />
<span class="hps">Kemudian, </span></span><span class="" id="result_box" lang="id"><span class="hps">fungsi</span></span><span class="" id="result_box" lang="id"> <i><span class="hps">mysql_query</span> </i><span class="hps"><i>()</i> </span> <span class="hps">mengeksekusi</span><i> <span class="hps">INSERT</span> <span class="hps">INTO</span></i><span>, dan</span> <span class="hps">rekor baru</span> <span class="hps">akan ditambahkan ke</span> <span class="hps atn">tabel <i>"</i></span><i><span>Persons"</span></i><span>.</span><br />
<br />
<span class="hps atn">Berikut adalah </span></span><span class="" id="result_box" lang="id"><span>halaman</span><span></span></span><span class="" id="result_box" lang="id"><span class="hps atn"> "</span><span>insert.php</span><span>" </span><span>:</span></span><br />
<br />
<i><span class="" id="result_box" lang="id"><span> <?php<br />
$con = mysql_connect("localhost","peter","abc123");<br />
if (!$con)<br />
{<br />
die('Could not connect: ' . mysql_error());<br />
}<br />
<br />
mysql_select_db("my_db", $con);<br />
<br />
$sql="INSERT INTO Persons (FirstName, LastName, Age)<br />
VALUES<br />
('$_POST[firstname]','$_POST[lastname]','$_POST[age]')";<br />
<br />
if (!mysql_query($sql,$con))<br />
{<br />
die('Error: ' . mysql_error());<br />
}<br />
echo "1 record added";<br />
<br />
mysql_close($con);<br />
?> </span></span></i><br />
<span class="" id="result_box" lang="id"><span><br />
</span></span>adminhttp://www.blogger.com/profile/11440739257392613074noreply@blogger.com0tag:blogger.com,1999:blog-451614773748846965.post-61866411328560480682012-06-12T21:05:00.000-07:002012-06-12T21:05:35.826-07:00Membuat Database Dan Table Dalam Skrip PHP dan MySQL<span class="" id="result_box" lang="id"><span class="hps">Pertama kali membuat</span> <span class="hps">Database</span><br />
<br />
<span class="hps">Pernyataan</span> <i><span class="hps">CREATE DATABASE</span></i> <span class="hps">digunakan untuk</span> <span class="hps">membuat database</span> <span class="hps">di <b>MySQL</b>.</span><span class="hps"> </span></span><br />
<br />
<span class="" id="result_box" lang="id"><span class="hps">Sintaknya:</span></span><br />
<i><span class="" id="result_box" lang="id"><span class="hps"> CREATE DATABASE database_name </span></span></i><br />
<span class="" id="result_box" lang="id"><span class="hps"><br />
</span></span><br />
<span class="" id="result_box" lang="id"><span class="hps">Untuk mendapatkan</span> <span class="hps">PHP untuk</span> <span class="hps">mengeksekusi</span> <span class="hps">pernyataan di atas</span> <span class="hps">kita harus menggunakan</span> </span><span class="" id="result_box" lang="id"><span class="hps">fungsi</span></span><span class="" id="result_box" lang="id"> <i><span class="hps">mysql_query</span> </i><span class="hps"><i>()</i>.</span> <span class="hps">Fungsi ini digunakan</span> <span class="hps">untuk mengirim</span> <span class="hps">query atau</span> <span class="hps">perintah</span> <span class="hps">ke koneksi</span> <span class="hps"><b>MySQL</b>.</span><br />
<span class="hps"></span><br />
<span class="hps">Contoh berikut membuat</span> <span class="hps">database yang disebut</span><i> <span class="hps atn">"</span><span class="">my_db</span></i><span class=""><i>"</i>:</span></span><br />
<span class="" id="result_box" lang="id"><span class=""> <i><?php<br />
$con = mysql_connect("localhost","peter","abc123");<br />
if (!$con)<br />
{<br />
die('Could not connect: ' . mysql_error());<br />
}<br />
<br />
if (mysql_query("CREATE DATABASE my_db",$con))<br />
{<br />
echo "Database created";<br />
}<br />
else<br />
{<br />
echo "Error creating database: " . mysql_error();<br />
}<br />
<br />
mysql_close($con);<br />
?> </i></span></span><br />
<span class="" id="result_box" lang="id"><span class=""><br />
</span></span><br />
<span class="" id="result_box" lang="id"><span class="hps">Membuat</span> <span class="hps">Tabel</span><br />
<span class="hps">Pernyataan</span> <i><span class="hps">CREATE TABLE</span></i> <span class="hps">digunakan untuk</span> <span class="hps">membuat tabel</span> <span class="hps">di <a href="http://www.panduanskripsi.net/"><b>MySQL</b></a>.</span><br />
<span class="hps"> </span></span><br />
<span class="" id="result_box" lang="id"><span class="hps">Sintaksnya :</span></span><br />
<span class="" id="result_box" lang="id"><span class="hps"> <i>CREATE TABLE table_name<br />
(<br />
column_name1 data_type,<br />
column_name2 data_type,<br />
column_name3 data_type,<br />
....<br />
)</i></span></span><br />
<br />
<span class="" id="result_box" lang="id"><span class="hps"></span></span><span class="" id="result_box" lang="id"><span class="hps"> </span></span><span class="" id="result_box" lang="id"><span class="hps">Kita harus</span> <span class="hps">menambahkan</span> <span class="hps">pernyataan <i>CREATE</i></span><i> </i><span class="hps"><i>TABLE</i> untuk</span> <span class="hps"></span></span><span class="" id="result_box" lang="id"><span class="hps">fungsi </span></span><span class="" id="result_box" lang="id"><i><span class="hps">mysql_query</span> </i><span class="hps"><i>()</i> </span><span class="hps">untuk mengeksekusi perintah</span><span>.</span><br />
<span class="hps">contoh</span><br />
<br />
<span class="hps">Contoh berikut membuat</span> <span class="hps">tabel bernama</span> <i><span class="hps">"Persons"</span></i><span>, dengan tiga</span> <span class="hps">kolom yaitu</span><span class="hps atn"> <i>"</i></span><i><span class="">FirstName</span></i><span class="atn"><i>"</i>, <i>"</i></span><i><span class="">LastName</span></i><span class="atn"><i>" </i>dan<i> "</i></span><span class=""><i>Age"</i>:</span></span><br />
<br />
<i><span class="" id="result_box" lang="id"><span class=""> <?php<br />
$con = mysql_connect("localhost","peter","abc123");<br />
if (!$con)<br />
{<br />
die('Could not connect: ' . mysql_error());<br />
}<br />
<br />
// Create database<br />
if (mysql_query("CREATE DATABASE my_db",$con))<br />
{<br />
echo "Database created";<br />
}<br />
else<br />
{<br />
echo "Error creating database: " . mysql_error();<br />
}<br />
<br />
// Create table<br />
mysql_select_db("my_db", $con);<br />
$sql = "CREATE TABLE Persons<br />
(<br />
FirstName varchar(15),<br />
LastName varchar(15),<br />
Age int<br />
)";<br />
<br />
// Execute query<br />
mysql_query($sql,$con);<br />
<br />
mysql_close($con);<br />
?></span></span></i><br />
<br />
<span class="" id="result_box" lang="id"><span class="hps">Penting:</span> <span class="hps">Database</span> <span class="hps">harus dipilih sebelum</span> <span class="hps">tabel</span> <span class="hps">dapat dibuat.</span> <span class="hps">Basis data</span> <span class="hps">dipilih dengan</span> </span><span class="" id="result_box" lang="id"><span class="hps">fungsi<i> </i></span></span><span class="" id="result_box" lang="id"><i><span class="hps">mysql_select_db</span> </i><span class="hps"><i>()</i>.</span><br />
<br />
<span class="hps">Catatan:</span> </span><br />
<span class="" id="result_box" lang="id"><span class="hps">Bila Anda membuat</span> <span class="hps">field database</span> <span class="hps">tipe varchar</span><span>, Anda harus menentukan</span> <span class="hps">panjang maksimum</span> field<span class="hps">,</span> <span class="hps">misalnya</span> <span class="hps">varchar</span> <span class="hps">(15).</span></span><br />
<span class="" id="result_box" lang="id"><span class="hps"> </span><br />
<span class="hps"></span></span>adminhttp://www.blogger.com/profile/11440739257392613074noreply@blogger.com0tag:blogger.com,1999:blog-451614773748846965.post-14263486187149644002012-06-12T20:34:00.001-07:002012-06-12T20:35:07.273-07:00Cara Dasar Menghubungkan PHP MySQL ke Database<div style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;"><span class="" id="result_box" lang="id"><span class="hps">Membuat</span> <span class="hps">Koneksi</span> <span class="hps">ke</span> <span class="hps">Database MySQL</span></span><span class="" id="result_box" lang="id"><br />
<span class="hps" style="font-family: Times,"Times New Roman",serif;">Sebelum Anda</span><span style="font-family: Times,"Times New Roman",serif;"> </span><span class="hps" style="font-family: Times,"Times New Roman",serif;">dapat mengakses data</span><span style="font-family: Times,"Times New Roman",serif;"> </span><span class="hps" style="font-family: Times,"Times New Roman",serif;">dalam database</span><span style="font-family: Times,"Times New Roman",serif;">, Anda harus membuat</span><span style="font-family: Times,"Times New Roman",serif;"> </span><span class="hps" style="font-family: Times,"Times New Roman",serif;">koneksi</span><span style="font-family: Times,"Times New Roman",serif;"> </span><span class="hps" style="font-family: Times,"Times New Roman",serif;">ke database.</span><br style="font-family: Times,"Times New Roman",serif;" /> <span class="hps" style="font-family: Times,"Times New Roman",serif;">Dalam PHP</span><span class="" style="font-family: Times,"Times New Roman",serif;">, hal ini dilakukan</span><span style="font-family: Times,"Times New Roman",serif;"> </span><span class="hps" style="font-family: Times,"Times New Roman",serif;">dengan fungsi</span><span style="font-family: Times,"Times New Roman",serif;"> </span><i style="font-family: Times,"Times New Roman",serif;"><span class="hps">mysql_connect</span> </i><span class="hps" style="font-family: Times,"Times New Roman",serif;"><i>()</i>.</span></span></div><span class="" id="result_box" lang="id"><span class="hps"> </span><br />
<span class="hps">Sintaknya:</span></span><br />
<span class="" id="result_box" lang="id"><span class="hps"> <i>mysql_connect(servername,usern</i></span></span><span class="" id="result_box" lang="id"><span class="hps"><i>ame,password);</i> </span></span><br />
<span class="" id="result_box" lang="id"><span class="hps">Contoh</span><br />
<span class="hps">Pada contoh berikut</span> <span class="hps">kita menyimpan</span> <span class="hps">koneksi dalam</span> <span class="hps atn">sebuah variabel <i>(</i></span><i>$ con)</i> <span class="hps">untuk digunakan</span> <span class="hps">dalam script.</span> <span class="hps atn">"die</span>" bagian <span class="hps">akan dieksekusi jika</span> <span class="hps">koneksi gagal</span><span class="">:</span></span><br />
<br />
<i><span class="" id="result_box" lang="id"><span class=""> <?php<br />
$con = mysql_connect("localhost","peter","abc123");<br />
if (!$con)<br />
{<br />
die('Could not connect: ' . mysql_error());<br />
}<br />
// some code<br />
?></span></span></i><br />
<i><span class="" id="result_box" lang="id"><span class=""> </span></span><span class="" id="result_box" lang="id"><span class=""> </span></span></i><br />
<div style="font-family: "Helvetica Neue",Arial,Helvetica,sans-serif;"><span class="" id="result_box" lang="id"><span class=""> </span></span><span class="short_text" id="result_box" lang="id"><span class="hps">Menutup Sebuah</span> <span class="hps">Koneksi</span><span class="hps"></span></span></div><span class="" id="result_box" lang="id"><span class="hps">Koneksi ke database akan</span> <span class="hps">tertutup secara otomatis</span> <span class="hps">ketika script</span> <span class="hps">berakhir.</span> <span class="hps">Untuk menutup</span> <span class="hps">sambungan</span> <span class="hps">sebelumnya,</span> <span class="hps">gunakan</span> fungsi<i> <span class="hps">mysql_close</span> </i><span class="hps"><i>()</i>:</span></span><br />
<span class="" id="result_box" lang="id"><span class="hps"> <i><?php<br />
$con = mysql_connect("localhost","peter","abc123");<br />
if (!$con)<br />
{<br />
die('Could not connect: ' . mysql_error());<br />
}<br />
// some code<br />
mysql_close($con);<br />
?></i></span></span>adminhttp://www.blogger.com/profile/11440739257392613074noreply@blogger.com0