Posted by: Anil Kumar Panigrahi in: ● August 15, 2010
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 [...]
Posted by: Anil Kumar Panigrahi in: ● July 2, 2010
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 [...]
Posted by: Anil Kumar Panigrahi in: ● April 3, 2010
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 [...]
Posted by: Anil Kumar Panigrahi in: ● March 25, 2010
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 [...]
Comments