Category: mysql

How to Simple and Best Pagination using PHP and MySQL

Pagination is useful to show large data records into chunks of data.  Its very easy to apply pagination. Its very basic tutorial to teach you how to apply pagination. So you have to give start point and a limit. “Select * from table Limit {starting Point}, Limit”. You may also like How to Ajax Pagination in PHP, How to Ajax Pagination in […]

How to Login System using PHP with MYSQL database

This is a simple login script using php and mysql. In this script, a form will be displayed with two fields, email and password. When user is submitting with valid email and password, then he can access authenticated page. First we will connect to the database. Since we already have our table created “iosr_user_detail”. HTML […]

How to Upload Image to Database and Server using HTML,PHP and MySQL

In this tutorial I’m going to teach you how you can Upload Image to Database and Server using HTML, PHP and MySQL. Image Uploading is very easy there are two ways you can upload the image either to the database or to the server as you like. You may also like Multiple file upload in Codeigniter and Multiple […]

MySQL – Create Trigger mysql

MySQL – Create Trigger

A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. DML triggers execute when a user tries to modify data through a data manipulation language (DML) event. DML events are INSERT, UPDATE, or DELETE statements on a table or view. MySQL trigger syntax In order to create a new […]

How to get maximum value in MySQL table column using Codeigniter CodeIgniter-Technology

How to get maximum value in MySQL table column using Codeigniter

To find max value form query select_max method in codeigniter CodeIgniter is a framework based on MVC principles. As a result, you would usually separate application logic, data abstraction and “output” into their respective areas for CodeIgniter use. In this case: controllers, models and views. Codeigniter provides select_max method to get maximum value in mysql table column. Writes […]

How to create an array and insert record in MySQL database using Codeigniter

I’ll share to you very basic tutorial with codeignter,here is inserting data toyou database.Oke make it simple,first of all you must create a table in your database obviously after create form and save create array and save data in database table. You may also like How to Add, Edit and Delete Records Using jQuery, Ajax, PHP […]