-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 16, 2022 at 01:16 PM
-- Server version: 10.4.21-MariaDB
-- PHP Version: 8.0.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `blogdb`
--

-- --------------------------------------------------------

--
-- Table structure for table `blog_posttb`
--

CREATE TABLE `blog_posttb` (
  `id` int(11) NOT NULL,
  `my_id` varchar(255) NOT NULL,
  `blog_title` varchar(255) NOT NULL,
  `blog_decription` text NOT NULL,
  `minor_title` text NOT NULL,
  `blog_details` text NOT NULL,
  `blog_photo` varchar(255) NOT NULL,
  `blog_video` varchar(255) NOT NULL,
  `back_link_url` varchar(255) NOT NULL,
  `back_link_lebal` varchar(255) NOT NULL,
  `curr_country` varchar(255) NOT NULL,
  `curr_city` varchar(255) NOT NULL,
  `curr_day` varchar(255) NOT NULL,
  `curr_month` varchar(255) NOT NULL,
  `curr_year` varchar(255) NOT NULL,
  `curr_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `blog_posttb`
--

INSERT INTO `blog_posttb` (`id`, `my_id`, `blog_title`, `blog_decription`, `minor_title`, `blog_details`, `blog_photo`, `blog_video`, `back_link_url`, `back_link_lebal`, `curr_country`, `curr_city`, `curr_day`, `curr_month`, `curr_year`, `curr_time`) VALUES
(1, '2', 'How to find the IMEI number  of an android or iPhone', 'IMEI number  stands for International Mobile  Equipment Identity, This is  a unique code assigned to every phone device, it consists of 15 digits.', '', 'Why you need to know or want to find your phone\'s IMEI?You may probably want to find your lost or stolen phone and when you went to the police they asked you for this number. ', '1989.jpg', '', '', '', '', '', '2021-05-15', '', '', '16:38:59'),
(2, '2', 'How to make money online using cryptoTab browser in just a month.', 'Hey guys! Can you believe that you can make money online by mining BTC while watching videos or just browsing social networks? However, it’s true! The only thing you need for this is CryptoTab Browser. ', '', 'Let me tell you the easiest way to start making income in cryptocurrency. Download and install new CryptoTab browser with built-in mining algorithm and start using it. Browser will earn cryptocurrency while you just do your everyday needs like watching movies online, reading news and visiting websites. Learn more info here', '1431458120.jpg', '', ' https://cryptotabbrowser.com/23202258', 'Dwonload For Free', 'Bahrain', '', '2021-05-17', '', '', '20:17:15'),
(3, '2', 'How do I delete files on Android phone?', '1.The basic way and the shortest is deleting the files from the galley area Go to galley and open it to see all files available Tap and hold on the file (video or photo) you want to delete, then the Delete option or icon will appears. Then press the delete icon to delete the file.', '', '1.The basic way and the shortest is deleting the files from the galley area Go to galley and open it to see all files available Tap and hold on the file (video or photo) you want to delete, then the Delete option or icon will appears. Then press the delete icon to delete the file.', '572285512.jpg', '', '', '', 'Bahrain', '', '2021-05-19', '', '', '15:04:02'),
(4, '2', 'How to uninstall a program from windows 10 computer', 'There are many ways how this can be achieved this, the simplest way is go to your computer.', '', 'There are many ways how this can be achieved this, the simplest way is go to your computer,On the bottom left corner you will see the search input, then type there control panelThen the control panel app will appear click on it.You will see programs and bellow it you will see uninstall program Click on the uninstall programs and the program list will be shown so right click on the program you want to uninstall, then the uninstall button will appear then click on it to uninstall the program.', '2075773042.jpg', '', '', '', 'Bahrain', '', '2021-05-22', '', '', '10:24:05'),
(5, '2', 'Kenzo survives car accident', 'Eddy Kenzo survives a car accident on Maya road, along Kampala Masaka highway.', '', 'Eddy Kenzo survives a car accident on  Maya road, along Kampala Masaka highway.The Musician Eddy Kenzo who was travelling upcountry with other workmate involved in an accident, Kenzo and the friends only got serious injuries but no one died. Our dear brothers are in the hospital receiving treatment.  According to him, the driver of the car occupied by three people lost control due to the slippery road following the morning downpour.“We had a frightening car accident. The road was wet and slippery due to rain and when we reached Maya there was a hump in the road next to Stabex Petro station that caused my car to skid in a remarkable fashion. It did a 180-degree spin in the middle of the road, facing the wrong way!” Kenzo said in a statement on his Facebook wall, adding that their car landed into a trench next to the fuel station.', '543978396.jfif', '', '', '', 'Bahrain', '', '2021-08-08', '', '', '21:50:31'),
(8, '2', 'Its hard to date a musician says Vivian Tendo.', '', '', '', '316024963.jfif', '', '', '', 'Bahrain', '', '14', '08', '2021', '21:26:02'),
(9, '2', 'How Email Marketing Help to Grow Your Business', 'Email Marketing provides countless advantages which helps in boosting sales of businesses.', '', 'For a business, choosing the type of marketing strategy is an extremely important decision. It allows businesses to either grow considerably.', '1764360943.png', '', '', '', '', '', '15', '01', '2022', '15:02:48');

-- --------------------------------------------------------

--
-- Table structure for table `blog_post_moretb`
--

CREATE TABLE `blog_post_moretb` (
  `id` int(11) NOT NULL,
  `my_id` varchar(255) NOT NULL,
  `blog_id` varchar(255) NOT NULL,
  `blog_title` text NOT NULL,
  `blog_description` text NOT NULL,
  `minor_title` text NOT NULL,
  `blog_details` text NOT NULL,
  `bold_text` text NOT NULL,
  `blog_photo` varchar(255) NOT NULL,
  `blog_video` varchar(255) NOT NULL,
  `back_link_url` varchar(255) NOT NULL,
  `back_link_lebal` varchar(255) NOT NULL,
  `curr_country` varchar(255) NOT NULL,
  `curr_city` varchar(255) NOT NULL,
  `curr_day` varchar(255) NOT NULL,
  `curr_month` varchar(255) NOT NULL,
  `curr_year` varchar(255) NOT NULL,
  `curr_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `blog_post_moretb`
--

INSERT INTO `blog_post_moretb` (`id`, `my_id`, `blog_id`, `blog_title`, `blog_description`, `minor_title`, `blog_details`, `bold_text`, `blog_photo`, `blog_video`, `back_link_url`, `back_link_lebal`, `curr_country`, `curr_city`, `curr_day`, `curr_month`, `curr_year`, `curr_time`) VALUES
(1, '2', '1', '1.  How to get imei number by dialing.', '', '', 'The easiest way, dial *#06# into your Samsung phone or any phone brand at the press of the last character() automatically your iPhone imei number or android phone imei number will displayed on the screen.', '', '', '', '', '', 'Bahrain', '', '2021-05-16', '', '', '20:59:57'),
(2, '2', '1', '', '', '', '', '', '1327470724.jpg', '', '', '', 'Bahrain', '', '2021-05-16', '', '', '21:05:15'),
(3, '2', '1', '2.How to check imei number from the Phone.', '', '', 'Most phones with removable battery or cover have imei number written bellow the battery that is to say when you remove the battery you will be able to see the phone\'s imei written there.', '', '', '', '', '', 'Bahrain', '', '2021-05-16', '', '', '21:17:26'),
(4, '2', '1', '3. How to find imei number on android phone through settings', '', '', ' * Go to Settings then select  About, press Status and then look for IMEI information. For iPhone, Go to Settings  then select General  press About and scroll to IMEI.', '', '', '', '', '', '', '', '2021-05-16', '', '', '21:24:07'),
(5, '2', '1', '4.  How to find imei number without phone', '', '', 'If you don’t have your phone and you need to know the imei number refer to the documents or receipt given to you when acquiring the device from where you bought it from (shop). That’s why it is important to keep the box and all the stickers given to you when buying a new phone(original packaging), for in the times like these you need to refer to them or better still note the imei number on a paper or computer for future use.  Your IMEI is so important, do not expose it to anyone at any time for someone can block your device by using that unique code and it’s not easy to unlock the phone again because you will need to visit law enforcement offices.Note if you are to buy a second hand phone always check for the imei number, ask the seller the details of the device you are buying, because if you buy a stolen phone and the orginal owner reports to the police you are done  if you are found with a phone having same imei number with that the police are looking for, you will be the first suspect. Most second hand phone sellers they write the phone imei number code on the receipt given to you after paying for the phone. A receipt bearing the name of the shop or store from which are buying  the phone from.', '', '', '', '', '', 'Bahrain', '', '2021-05-16', '', '', '21:51:51'),
(6, '2', '1', '', '', '', '', '', '', 'https://www.youtube.com/embed/Cly7FU8qaZE', '', '', 'Bahrain', '', '2021-05-16', '', '', '21:54:35'),
(7, '2', '2', '', '', '', '', '', '', 'https://www.youtube.com/embed/AQk2g5aJnsQ', '', '', 'Bahrain', '', '2021-05-17', '', '', '20:39:15'),
(8, '2', '2', 'How to use your computer or mobile to mine bitcoins', '', '', 'How to use your PC wisely? Let it earn some BTC for you! CryptoTab Browser is the easiest way to start mining and make your path to the world of cryptocurrency. Completely free and ready for instant mining — try it and you’ll see the result! Enter the cryptocurrency market without additional investments. Now each of you can mine BTC and grow revenue in digital currency. Try CryptoTab Browser with a built-in mining feature and earn bitcoins while browsing the web. It’s really safe and profitable', '', '596080571.jpg', '', 'https://cryptotabbrowser.com/23202258', 'DOWNLOAD NOW', 'Bahrain', '', '2021-05-17', '', '', '21:08:47'),
(9, '2', '3', '', '', '', '', '', '', '', '', '', 'Bahrain', '', '2021-05-19', '', '', '15:09:01'),
(10, '2', '3', 'How to delete files from android phone permanently?', '', '', 'The advanced way you can directly delete files like photos, videos, mp3 and documents from your phone by going to settingsThen select Storage or device care The list of storage application for example video ', '', '', '', '', '', 'Bahrain', '', '2021-05-19', '', '', '15:33:14'),
(11, '2', '4', 'The best way to uninstall programs from a windows pc', '', '', '', '', '1579604386.jpg', '', '', '', 'Bahrain', '', '2021-05-22', '', '', '10:28:17'),
(12, '2', '4', '', 'Use the video below to fully understand, how you can easily uninstall programs from your computer', '', '', '', '', 'https://www.youtube.com/embed/X15tnE6bB6I', '', '', 'Bahrain', '', '2021-05-23', '', '', '20:56:48'),
(13, '2', '8', '', 'I can\'t date a musician, Vivian well known as Hajat wa Haji says she can not go with a musician.', '', 'Vivian Tendo well known as Hajat wa Haji a title to the song that brought her high on top, were by most of the Ugandans have listened to this song.Vivian says she can not date a musician several men would wish to have her as a wife. She is beautiful and has a good voice.Vivian has been linked to many men, but she maintains that she is single.“Until I gets a man who is ready to put a ring on it, I am single,” That was her answer when she was asked whether she can date a fellow musician.', '', '', '', '', '', 'Bahrain', '', '14', '08', '2021', '21:27:59'),
(14, '2', '8', '', '', '', '', '', '', '', 'http://craneblue.com/mp3/details.php?kvt_dp=738&kvt_alb=55', 'Vivian Tendo Music', 'Bahrain', '', '14', '08', '2021', '21:37:50'),
(15, '2', '9', 'Why Should You Care About Email So Much?', '', '', 'More than 3.8 billion active email accounts that people are using for sign-up purposes. <br><br>Why am telling you all about email is to emphasize how important it is. Everyone should have an email address today.<br><br>Most of  Android phones and iPhone\'s need an Email to boot up and also for downloading mobile apps, so most phone users have got emails.<br><br>Which makes Email Marketing so important if you are to grow your business today.<br><h3>Here are a few pointers that will help you understand why Email Marketing can be so helpful to your business.</h3>\n', '', '', '', '', '', '', '', '15', '01', '2022', '15:51:05'),
(16, '2', '9', '', '', '', '<strong>1. Confidence :- </strong>People prefer to respond to messages that are sent directly to their inbox, instead of being posted on public post areas. Emails are private and are sent in confidence. <br>Here you a have chance to explain what you want them to know about your business.', '', '', '', '', '', '', '', '15', '01', '2022', '16:15:27'),
(17, '2', '9', '', '', '', '', '', '1045890196.jpg', '', '', '', '', '', '15', '01', '2022', '16:17:06'),
(18, '2', '9', '', '', '', ' <strong>Direct 2. Targeting:-</strong> Email Marketing can be targeted to a specific market or people, this helps the business owners not to send or adverts their business to age groups that don\'t use the product, eg Children.', '', '', '', '', '', '', '', '15', '01', '2022', '16:25:24');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `blog_posttb`
--
ALTER TABLE `blog_posttb`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog_post_moretb`
--
ALTER TABLE `blog_post_moretb`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `blog_posttb`
--
ALTER TABLE `blog_posttb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `blog_post_moretb`
--
ALTER TABLE `blog_post_moretb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;