Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- define("FW_INC", TRUE);
- require_once("./system/framewerk.php");
- $framewerk = new framewerk();
- $db = $framewerk->database->connect("mysqli", "localhost", "root", "", "framewerk", 3306);
- $db->query("CREATE TABLE IF NOT EXISTS `users`(
- `id` INT NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(50) DEFAULT '',
- PRIMARY KEY(`id`)
- ) Engine=InnoDB;");
- $name = $db->escape("Caelan Stewart");
- for($i = 0; $i < 4; $i++)
- {
- $db->query("INSERT INTO `users`(
- `name`
- ) VALUES (
- '$name'
- )");
- }
- $result = $db->query("SELECT * FROM `users` WHERE `name` = '$name' AND `id` < 100 ORDER BY `id`");
- while($array = $db->fetch_array($result))
- {
- print_r($array);
- print "<br />";
- }
- $db->close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment