code to make something similar to adding 'wall' in facebook using mysql and php?

G

Girl

New member
here's the idea
there are three fields name, email, and comments, every time someone insert their data and click on submit, their data will be shown below those three fields, kinda like in facebook when someone post a wall they type their comment and then the comment will be added below the postbox, so far here's what i've got
for INSERT data
<?
if($Submit)
{
$koneksi=mysql_connect("localhost","","");
if($koneksi)
{
mysql_select_db("fb");
$strsql="insert into comments2(name,email,comments) values('$name','$email','$comments')";
$hasil=mysql_query($strsql,$koneksi);
echo("data inserted");
mysql_close($koneksi);
}
else
{
echo("failed");
}
}
else
{
include "insert2.html";
}
?>

for SHOW data
<?
$koneksi=mysql_connect("localhost","","");
if($koneksi)
{
mysql_select_db("fb");
$sqlstr="SELECT * FROM comments2";
$hasil=mysql_query($sqlstr,$koneksi);
$row=mysql_fetch_row($hasil);
if($row)
{
echo("
<body bgcolor=\"#00CCFF\">
<center>
<table width=\"450\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\">
<tr>
<td colspan=\"5\" class=\"style3\"><div align=\"center\" class=\"style4\"><font face=\"Georgia, Times New Roman, Times, serif\" size=\"3\" color=\"#FFFFFF\">DATA SISWA </font></div></td>
</tr>
<tr>

<td width=\"79\" bgcolor=\"#0000FF\"><div align=\"center\" class=\"style7\"><span class=\"style1\">NAME</span></div></td>

<td width=\"85\" bgcolor=\"#0000FF\"><div align=\"center\" class=\"style7\"><span class=\"style1\">EMAIL</span></div></td>
<td width=\"64\" bgcolor=\"#0000FF\"><div align=\"center\" class=\"style7\"><span class=\"style1\">COMMENTS</span></div></td>
</tr>
");
$i=1;
do{
list($nama,$email,$comments)=$row;
echo("
<tr>
<td bgcolor=\"#0099FF\">$name</td>
<td bgcolor=\"#0099FF\">$email</td>

<td bgcolor=\"#0099FF\">$comments</td>
</tr> ");
$i++;
}while($row=mysql_fetch_row($hasil));
}
else
{
echo("No data");
}
}
else
{
echo("No data");
mysqli_close($konesksi);
}
?>

any help would be appreciated
 
Back
Top