Selasa, 05 November 2013

PHP Indonesia - Facebook: agan dan sista mau tanya dong ini gimana yah buat...

PHP Indonesia - Facebook
PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ 
Learn Adobe Illustrator CS6 Master Techniques from an Adobe Guru!

With over 25 years of experience teaching, Robert Farrell has been a trusted instructor for individuals and companies who want to improve their Adobe skills.
From our sponsors
agan dan sista mau tanya dong ini gimana yah buat...
Nov 5th 2013, 16:23, by PinkLove Cassiopeia

PinkLove Cassiopeia 4:23pm Nov 5
agan dan sista mau tanya dong ini
gimana yah buat inputan 2 kali dlm 1 tabel
aku punya tabel a dengan field 1, 2, 3, 4, 5, 6, 7
nah yg field 1, 2, 3, 4 itu udah di input ama admin...
sedangkan yg field 5, 6, 7 itu di inputin oleh user...
mohon bantuannya

Arie Yuniarto 4:26pm Nov 5
update where id =...

PinkLove Cassiopeia 4:27pm Nov 5
$query =mysql_query ("UPDATE tpa SET c2 = '$c2', c3 = '$c3', c4 = '$c4' WHERE id_tpa='$id_tpa'");

ni ndak mau masuk database

Arie Yuniarto 4:34pm Nov 5
koneksi nya mana kk

Roosyen Marthen 4:34pm Nov 5
ijin nyimak gan :)

Arie Yuniarto 4:34pm Nov 5
http://www.tutorialspoint.com/mysql/mysql-update-query.htm

PinkLove Cassiopeia 4:37pm Nov 5
kyak'nya udah sesuai deh bang...

<?php
//membuat koneksi kedatabase
$dbhost = 'localhost';
$dbuser = 'root';
$dbpassword = '';
$dbname = 'ssistem';
$koneksi = mysql_connect($dbhost,$dbuser,$dbpassword);
mysql_select_db($dbname,$koneksi);

//membuat variabel dari inputan form
echo $_GET['id_tpa'];
$id_tpa =$_GET['id_tpa'];
$c2 = $_POST['c2'];
$c3 = $_POST['c3'];
$c4 = $_POST['c4'];

if($c2 == "" or $c3 == "" or $c4 == "" )
{
echo ("Kolom tidak boleh kosong<br><br>");
echo ("<a href='a_nilai.php'>Kembali</a>");
}
else
{
$query =mysql_query ("UPDATE tpa SET c2 = '$c2', c3 = '$c3', c4 = '$c4' WHERE id_tpa='$id_tpa'");
//cek apakah querynya berhasil atau tidak
if ($query) {

//jika berhasil maka tampilkan pesan
echo 'berhasil membuat kriteria ';
header('location:nilai.php');
} else {

//tampilkan pesan error jika query tidak berhasil
echo 'gagal membuat kriteria';
}
//tutup koneksi ke database
}mysql_close();
?>

Albert Septiawan 4:38pm Nov 5
mksdnya ,ngedit data gitu ya ?

PinkLove Cassiopeia 4:41pm Nov 5
bukan ngedit tapi inputin data field yg blm terisi di tabel yg udah ada id-nya bang

tabel a dengan field 1, 2, 3, 4, 5, 6, 7
field 1, 2, 3, 4 itu udah di input ama admin...
sedangkan yg field 5, 6, 7 itu di inputin oleh user...
nah buat user'nya ini yg drtd gbisa

Arie Yuniarto 4:42pm Nov 5
$query =mysql_query ("UPDATE tpa SET c2 = '$c2', c3 = '$c3', c4 = '$c4' WHERE id_tpa='$id_tpa'");
vs
$retval = mysql_query( $sql, $conn );

ada yg beda gak?

Albert Septiawan 4:43pm Nov 5
ak blm mudeng -_- , bisa SS projectnya ?

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar