mysql « ANIL KUMAR PANIGRAHI 's Blog

Posts Tagged ‘mysql’

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 [...]

Tags: Anil Kumar Panigrahi, change order, mysql, Php

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 [...]

Tags: Anil, Anil Labs, blog, mysql, PHP Code, rss

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 [...]

Tags: backup, database, export, import, mysql, mysqldump, process

How to get list of table names from database in mysql?

Posted by: Anil Kumar Panigrahi in: ● March 25, 2010

In: PHP Code| mysql
1 Comment

Hi friends,
I got the requirement to display the list of table names from the database using php code. I got the solution for it, once check the below code.
1) Connect to database:
mysql_connect(“dbserver”,”dbuser”,”dbpassword”);
2)Get the list of tables from table
$result = mysql_list_tables(“dbname”);
3) Count the total number of tables
$num_tables = mysql_num_rows($result);
3) Display the tables names
for($i=0;$i<$num_rows;$i++)
{
echo “Table : <b>”.mysql_tablename($result,$i).”</b>”;
}
mysql_free_result($result);
In [...]