- Beranda
- Komunitas
- Tech
- Website, Webmaster, Webdeveloper
~ask php~tidak mau insert database
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
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
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Urutan
Terbaru
Terlama
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Komunitas Pilihan