Home » mysql

Hi friends,In this post i would like to explain about curd operations ( add, edit and delete ) data using xml file. It is simple to maintain and rapid in the operations, it will be useful when simple operations required. Below code explain the how to insert , edit , view and delete operations using database and xml format. xml crud operations using...
Filed in: Articles, mysql, PHP Code

 

Hi friends, In this post i would like to explain about how to change the order of placements using php code. It is simple code to implement. We can use this code in admin section to change the order and display those content depends on order. Today i want to share with you all. Database Take table that 1234CREATE TABLE tblOrder (   `post_id`...
Filed in: mysql, PHP Code

 

In this post i want to explain how to create rss feeds using php code and get the data from mysql table. It is very simple to develop and use.   Step 1 : Connect to database   We already discussed about how to connect database using php code.See the following code to connect database: Code 12345678910<?php DEFINE ('DB_USER', 'root'); DEFINE...
Filed in: mysql, PHP Code, SEO

 

Hi friends, In this post, i would like to explain what is sql injection and how to prevent from this attacks to our website. SQL Injection: SQL injection is another vulnerability of PHP.  SQL injection refers to the act of anyone can inserting a MySQL statement to be run on our database without our knowledge. Injection usually occurs when you ask a...
Filed in: mysql

 

Hello friends, today i want to share some basic concepts but we need to know about import and export databases. If it is small database file, we can directly export or import from the phpmyadmin. Process to export: 1) Go to phpmyadmin -> click on database -> there we have button called “export”. 2) When we click on that button, we...
Filed in: mysql