Waakaas SQL code-ka

INSERT INTO `categories` (`id`, `name`, `created_at`) VALUES
(1, 'technology', '2019-11-20 12:28:02'),
(2, 'programming', '2019-11-20 12:28:02'),
(3, 'security', '2019-11-20 12:28:22'),
(4, 'tutorials', '2019-11-20 12:28:22');

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

-- Dumping data for table `posts`
--

INSERT INTO `posts` (`id`, `title`, `body`, `cat_id`, `image`, `created_at`) VALUES
(1, 'Microsoft Office 365 Is Now Available On Apple’s Mac Store', 'Last year at WWDC Apple promised to launch Microsoft Office 365. Apple has finally announced on Thursday that Microsoft Office 365 is now available on Mac App Store. Users can now directly download the signature Microsoft apps such as Outlook, Word, PowerPoint, OneNote, and Excel on their MacOS computers.', 1, 'image2.jpg', '2019-11-01 10:05:41'),
(2, 'Poisonous Gas Sensor On IPhone And Apple Watch', 'Recently Apple has been granted a patent for small-sized sensors that could detect the presence of harmful gases like carbon monoxide. These sensors could be installed on future Apple products like iPhone, iPad, and Apple WatchThis small-sized sensor can detect major harmful gases like Carbon Monoxide (CO), Ozone (O3), Nitrogen Dioxide (NO2), Nitrogen Monoxide (NO), Sulphur Dioxide (SO2), Methane (CH4) and volatile organic compounds (VOCs).', 2, 'image3.jpg', '2019-11-01 10:05:41'),
(3, '5 Best Artificial Intelligence Books', 'Recently Apple has been granted a patent for small-sized sensors that could detect the presence of harmful gases like carbon monoxide. These sensors could be installed on future Apple products like iPhone, iPad, and Apple Watch.\r\n This small-sized sensor can detect major harmful gases like Carbon Monoxide (CO), Ozone (O3), Nitrogen Dioxide (NO2), Nitrogen Monoxide (NO), Sulphur Dioxide (SO2), Methane (CH4) and volatile organic compounds (VOCs).', 3, 'image1.jpg', '2019-11-01 10:07:11'),
(4, 'Best IOS System Repaire Tool To Get You Out Of All Kinds Of IPhone ', 'Tenorshare ReiBoot is a wonderful iOS devices boot repair tool which enables you to fix various issues such as recovery mode, white Apple logo, black screen, frozen screen, disabled screen, headphone mode etc., without losing even a single byte of data.', 1, 'image3.jpg', '2019-11-01 10:16:16');

--
-- Indexes for dumped tables
0 Discussions
Login to add comment

No comments yet

Baro PHP adoo ku dhisaya website admin leh

By Abdifatah
Course content
Back to Home

Introduction

Local Server Setup

Changing file extensions

Including Partial Files

Creating Database Scheme

Playing...

Connecting to database

Code Refactoring

Fetching Data

Embedding Data

Introducing Functions

Retreating Data

Adding Arguments

Built in Functions

Getting Data 1

Passing Data

Getting Data 2

Getting Data 3

Error Handling 1

Error Handling 2

Error Handling 3

Using Prepared Statements

Securing Folders

Escaping Output

Exception Handling

Adding Admin Template

Configuring Database

Adding Dynamic Function 1

Adding Dynamic Function 2

Adding GET Links

Introducing Superglobals

Inserting Category Data

Deleting Category Data

Updating Category Data

Data Validations

Introducing CSRF

Implementing CSRF

Code Refactoring 2

Dynamic Insert Function

Dynamic Update Function

Dynamic Delete Function

Uploading Image

Editing Post Data

User Registration

Adding Data Validation

Adding Login Page

implementing Login

Implementing Logout

Adding Post Author

Adding User Roles

Adding RichText