File for ‘mysql’ Category
how to change order of display posts using php
Posted by: Anil Kumar Panigrahi in: ● August 15, 2010
- In: PHP Code| mysql
- 2 Comments
Hi friends,
This post is to change the order in admin and display those content depends on order. Today i want to share with you all.
Take table that
CREATE TABLE tblOrder (
`post_id` int(11) ,
`sortorder` int(11) NOT NULL default ‘0′,
)
At the admin section: PHP Code
manageorder.php
<?php
$query = "SELECT * FROM tblOrder order [...]
How to create rss feeds using php and mysql
Posted by: Anil Kumar Panigrahi in: ● July 2, 2010
- In: PHP Code| mysql
- 5 Comments
Hi friends,
In this post i want to explain how to create rss feeds using php code and get the data from mysql table.
1) Connect to database:
We already discussed about how to connect database using php code.See the following code to connect database:
1
2
3
4
5
6
7
8
9
10
11
<?php
DEFINE (’DB_USER’, ‘root’);
DEFINE (’DB_PASSWORD’, ‘root’);
DEFINE (’DB_HOST’, ‘localhost’);
DEFINE (’DB_NAME’, ‘rss’);
// Make the connnection and then [...]
How to prevent php website from sql injection
Posted by: Anil Kumar Panigrahi in: ● April 12, 2010
- In: mysql
- 4 Comments
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 [...]
How to import and export big database files
Posted by: Anil Kumar Panigrahi in: ● April 3, 2010
- In: mysql
- 2 Comments
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 [...]
About Me
 |
Anil Kumar Panigrahi | |
| Software Engineer (PHP) | ||
| Blogger & Founder of Anil Labs | ||
| Baruva, India |
You can share with me . . .
My Own Contributions
1) First contribution for codeigniter framework ( multi language support using google translate API ). we can get files from
2) Audio and Video Streaming using FFMpeg and PHP -complete doc file : http://www.docstoc.com/docs/8300349/Audio-and-Video-Streaming
Twitter Updates
-
We will always be thankful to our teacher for all the hard work and efforts they have put in, for educating us.- Happy teachers Day . . .
- posted on 05/09/2010 05:39:13
- Working on shipping cost functionality (UPS and USPS) for oscommerce shopping cart - posted on 01/09/2010 09:40:03
- If your freedom hurts others, you are not free. You must not hurt others. - Vivekananda - posted on 31/08/2010 06:02:49
- Another day starts with full of energy . Good Morning - posted on 31/08/2010 02:54:12
- Nice explanation about php oops concept : http://youropensource.com/projects/182-OOPS-Concepts-in-PHP - posted on 30/08/2010 19:56:17
Comments