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
Mari bergabung, dapatkan informasi dan teman baru!
Website, Webmaster, Webdeveloper
Website, Webmaster, WebdeveloperKASKUS Official
23.3KThread4.4KAnggota
Terlama
GuestAvatar border
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Ikuti KASKUS di
© 2023 KASKUS, PT Darta Media Indonesia. All rights reserved.