Pengaturan

Gambar

Lainnya

Tentang KASKUS

Pusat Bantuan

Hubungi Kami

KASKUS Plus

© 2024 KASKUS, PT Darta Media Indonesia. All rights reserved

joxzeAvatar border
TS
joxze
~ask php~tidak mau insert database
Spoiler for selesai:

terus kalo ane pecet tombol kirim keluar tampilan kaya dibawah, tapi hasil inputan yang di form tadi gak masuk di database..
Spoiler for hasil:

Spoiler for db:


-----------------------------------------------------------------
Code:

conn.php

<?php
$host = "localhost";
$username = "root";
$password = "";
$databasename = "dp_mail";
$connection = mysql_connect($host, $username, $password) or die("Kesalahan Koneksi ... !!");
mysql_select_db($databasename, $connection) or die("Databasenya Error");
?>


Code:

[U]dialogkirim.php[/U]

<form action="proseskirim.php" method="post">
<table border="0">
<tr>
<td width="55">To</td>
<td width="7"> : </td>
<td width="737"><input type="text" name="to" /></td>
</tr>
<tr>
<td> Subject</td>
<td> : </td>
<td><input type="text" name="Sub" /></td>
</tr>
<tr>
<td> Meseage</td>
<td> : </td>
<td><textarea name="msg" rows="10" cols="80"></textarea></td>
</tr>
</table>
<input type="submit" name="kirim" value="Kirim" />
<input type="button" name="Darft" value="Darft" />
</form>

Code:

[U]proseskirim.php[/U]

<?php
include"conn.php";
$to = $_POST['to'];
$Sub = $_POST['Sub'];
$msg = $_POST['msg'];
$sql= mysql_query ("INSERT INTO `mail`(`To`, `Subject`, `Pesan`, `From`) VALUES ([$to],[$Sub],[$msg],[$msg])");
echo "haloo ".$to.$Sub.$msg;
?>

Spoiler for jawaban:


Tapi ada masalah baru nih gan emoticon-Malu
Ane pengin bikin inbox, buat nampilin pesan yang tadi dikirim.
Code:

[U]dialogkotakmasuk.php[/U]
<?php
session_start();
$namauser = $_SESSION['namauser'];
include "conn.php";
$query=mysql_query ("SELECT * FROM 'mail' WHERE To = $namauser",$connection)or die (mysql_error());
$jumlah = mysql_num_rows($query);
echo "<table border='1'>
<tr>
<td>Pengirim
</td>
<td>Subject
</td>
<td>Pesan
</td>
</tr>";
$j=0;
while ($row=mysql_fetch_array($query)) {
echo "<tr><td>".$j++."
</td>
<td>".
$row["From"]."
</td>
<td>".
$row["Subject"]."
</td>
<td>
".
$row["Subject"]."</td></table>";
$j++;
}
echo"</table></body></html>";
?>


Spoiler for eror:


Jadi maksudnya isi database yang mau ditampilkan yangTo = Username
0
1.3K
9
GuestAvatar border
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Urutan
Terbaru
Terlama
GuestAvatar border
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Komunitas Pilihan