[php] simple shout script with mysql database

[bokepwap]

juat simple script with database MySQL

first you need make a table in your mysql database
for example, table name is contoh_tabel_shout.
make this table with PHPMyAdmin

  CREATE TABLE `contoh_tabel_shout` (
`id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`username` CHAR( 32 ) NOT NULL ,
`time` INT( 11 ) NOT NULL ,
`text` TEXT NOT NULL
) ENGINE = MYISAM 
  

there are 4 fields:
- id
- username
- time
- text

[bokepwap]

This is the shout.php script code:

<?php
$serper_host = 'localhost'; // database host
$serper_username = 'username_database'; // database username
$serper_password = 'password_database'; // database password
$serper_database = 'nama_database'; // database name
$nama_tabel = 'contoh_tabel_shout'; // database table name

mysql_connect($serper_host, $serper_username, $serper_password)
or die("Could not connect: " . mysql_error());
mysql_select_db($serper_database);


if ($_SERVER['REQUEST_METHOD']=='POST')
{
$username = htmlspecialchars(addslashes(stripslashes($_POST['username'])));
$text = htmlspecialchars(addslashes(stripslashes($_POST['text'])));
$query = mysql_query("
INSERT INTO $nama_tabel
(username, time, text)
VALUES
('$username', ".time().", '$text')
");
if (!$query)
{
die ("Ga bisa masukin post baru".mysql_error());
exit;
}
}

$result = mysql_query("
SELECT username, time, text
FROM $nama_tabel
ORDER BY time DESC
LIMIT 0,5
");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
printf("%s [%s]: &nbsp;
%s
<br/>
",
$row['username'],
gmdate('d m/H:i', $row['time']+(7*3600)),
$row['text']
);
}
?>
<br/><br/>
<form action="<?=$_SERVER['PHP_SELF']?>?" method="post">
<div>
Username:<br/><input type="text" name="username" size="16"/>
<br/>
Text:<br/><input type="text" name="text" size="40"/>
<br/>
<input type="submit" value="Shout!"/>
</div>
</form>
<?php
mysql_free_result($result);
?>