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 ![]()