- Beranda
- 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
Mari bergabung, dapatkan informasi dan teman baru!
Website, Webmaster, Webdeveloper
23.3KThread•4.4KAnggota
Terlama
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru