This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- | |
-- Table structure for table `tbl_products` | |
-- | |
CREATE TABLE `tbl_products` ( | |
`id` int(11) NOT NULL, | |
`product_name` varchar(500) NOT NULL, | |
`price` varchar(500) NOT NULL, | |
`category` varchar(500) NOT NULL | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!-- Here is a basic HTML table --> | |
<table> | |
<tr> | |
<th>ID</th> | |
<th>Name</th> | |
<th>Power Rating</th> | |
<th>Created on</th> | |
</tr> | |
<!-- A foreach loop creates an array that we can then use to loop through --> | |
<?php foreach ($records as $record) : ?> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Get data from database | |
// Replace 'your-table' with the name of your own table | |
$query = "SELECT * FROM your-table"; | |
$statement = $db->prepare($query); | |
$statement->execute(); | |
$heros = $statement->fetchAll(PDO::FETCH_ASSOC); | |
$statement->closeCursor(); | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- | |
-- Table structure for table `user_data` | |
-- | |
CREATE TABLE `user_data` ( | |
`id` int(5) NOT NULL, | |
`username` varchar(25) NOT NULL, | |
`email` varchar(25) NOT NULL | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
COMMIT; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE IF NOT EXISTS `tbl_users` ( | |
`user_id` int(11) NOT NULL AUTO_INCREMENT, | |
`user_name` varchar(25) NOT NULL, | |
`user_password` varchar(255) NOT NULL, | |
PRIMARY KEY (`user_id`) | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE `boxers` ( | |
`boxerID` int(11) NOT NULL, | |
`boxerName` varchar(20) NOT NULL, | |
`weight` varchar(50) NOT NULL, | |
`boxerPic` varchar(200) NOT NULL | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
INSERT INTO `boxers` (`boxerID`, `boxerName`, `weight`, `boxerPic`) VALUES | |
(1, 'George Forman', 'Heavyweight', '895803.jpg'), |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
To add animations with no scroll - just use animated in the class e.g. | |
<h1 class="animated infinite bounce">Example</h1> | |
To use WOW scroll to animate - just use wow in the class e.g. | |
<div class="wow bounceInUp"> | |
Content to Reveal Here | |
</div> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<script src="js/wow.min_.js"></script> | |
<script>new WOW().init();</script> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<link rel="stylesheet" href="css/animate.css"> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Table structure for table `products` | |
-- | |
CREATE TABLE `products` ( | |
`productID` int(11) NOT NULL, | |
`categoryID` int(11) NOT NULL, | |
`productCode` varchar(10) NOT NULL, | |
`productName` varchar(255) NOT NULL, | |
`date` date NOT NULL, |
NewerOlder