Skip to content

Instantly share code, notes, and snippets.

@amardeep18
Created July 19, 2020 05:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save amardeep18/2bc7df88692cfc0d3feaaba3b31a8678 to your computer and use it in GitHub Desktop.
Save amardeep18/2bc7df88692cfc0d3feaaba3b31a8678 to your computer and use it in GitHub Desktop.
--
-- Table structure for table `tbl_blog`
--
CREATE TABLE IF NOT EXISTS `tbl_blog` (
`blog_id` int(11) NOT NULL AUTO_INCREMENT,
`blog_title` varchar(300) NOT NULL,
`blog_link` varchar(100) NOT NULL,
PRIMARY KEY (`blog_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;
--
-- Dumping data for table `tbl_blog`
--
INSERT INTO `tbl_blog` (`blog_id`, `blog_title`, `blog_link`) VALUES
(1, 'How to add live search functionality to your website?', 'https://www.devopsschool.com/blog/how-to-add-live-search-functionality-to-your-website/'),
(2, '40+ Online Tools & Resources For Web Developers & Designers', 'https://www.devopsschool.com/blog/40-online-tools-resources-for-web-developers-designers/'),
(3, 'User registration using nodejs and mysql with example', 'https://www.devopsschool.com/blog/user-registration-using-nodejs-and-mysql-with-example/'),
(4, 'Searching, Column Sorting with Pagination using Ajax in Laravel 5.5', 'https://www.devopsschool.com/blog/searching-column-sorting-with-pagination-using-ajax-in-laravel-5-5/'),
(5, 'Design Resources For Developers', 'https://www.devopsschool.com/blog/design-resources-for-developers/'),
(6, 'How to Create Multiple Role Based Authentication and Access Control in Laravel Application', 'https://www.devopsschool.com/blog/how-to-create-multiple-role-based-authentication-and-access-control-in-laravel-application/'),
(7, 'How to do Auto Load and Refresh Div every Seconds with jQuery and Ajax with PHP Script.', 'https://www.devopsschool.com/blog/how-to-do-auto-load-and-refresh-div-every-seconds-with-jquery-and-ajax-with-php-script/'),
(8, 'Laravel – Remove Public from URL using htaccess', 'https://www.devopsschool.com/blog/laravel-remove-public-from-url-using-htaccess/'),
(9, 'How to send pdf file through phpmailer?', 'https://www.devopsschool.com/blog/how-to-send-pdf-file-through-phpmailer/');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment