Ik had vanavond niks te doen, en ik zag in de scripts sectie een klik hier niet script staan en toen dacht ik dat kan makkelijker en ja hoor dat kan
de sql:
PHP
CREATE TABLE `messages` (
`id` tinyint(4) NOT NULL auto_increment,
`message` text collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=10 ;
INSERT INTO `messages` VALUES(1, 'You shouldn''t came here...');
INSERT INTO `messages` VALUES(2, 'I');
INSERT INTO `messages` VALUES(3, 'Annoy');
INSERT INTO `messages` VALUES(4, 'You');
INSERT INTO `messages` VALUES(5, 'This is fun');
INSERT INTO `messages` VALUES(6, 'And you know what...');
INSERT INTO `messages` VALUES(7, 'This can keep on going and going');
INSERT INTO `messages` VALUES(8, 'Until I say..');
INSERT INTO `messages` VALUES(9, 'STOP');
Toon Meer
en het script zelf:
PHP
<?php
/**
* @author Patrick Rennings
* @copyright 2009
*/
$username = "";
$hostname = "";
$password = "";
$database = "";
if (!empty($username) && !empty($hostname)) {
$connect = mysql_connect($hostname, $username, $password) or die(mysql_error());
}
else {
die("Required data not enterd.");
}
if (!empty($database)) {
mysql_select_db($database, $connect) or die(mysql_error());
}
else {
die("Required data not enterd.");
}
$query = mysql_query("SELECT * FROM messages") or die(mysql_error());
while ($row = mysql_fetch_array($query, MYSQL_BOTH))
{
echo('<script language="javascript">
alert("'.$row['message'].'");
</script>');
}
echo("You made it.");
?>
Toon Meer
have fun with it