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 […]
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 […]
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 […]
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 […]
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 […]
here is an example of how you can Import Excel to MySQL using PHP. Import Excel to MySQL database is a very important method. Sometimes you have a very big list of items in an excel file and at sometimes you need to import all that list into your database so you can see that […]
In this tutorial we are going to explain you how to perform CodeIgniter select query to fetch data from database using ID or name with form get method. In this demo we are using input box and student id and student name. In input box you can enter an ID which you want to search […]
Code
Generates an insert string based on the data you supply, and runs the query. You can either pass an array or an object to the function. Note: All values are escaped automatically producing safer queries. Let’s create a inser() method in 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 […]
