View Single Post
  #1 (permalink)  
Old 08-11-2009, 11:08 PM
bmcoll3278's Avatar
bmcoll3278 bmcoll3278 is offline
Senior Member
 
Join Date: Jun 2009
Posts: 303
bmcoll3278 is on a distinguished road
Default how to update your links with a sql database

This post is about using php and sql to update all links on your site from a admin page.

I am including the zip file with the files you will need. so here is how it works.

This will allow you to create a data base to store all links for your website and the next post will show you how to display them on your pages.

You can ad or remove the links from the data base and that will update all pages on your site where the links are displayed

Step1 use PHPadmin to create a new database on your server and assign it a user id and password.

Step2 Download the attached zip file and unzip it

step 3 use PHPadmin again to goto your new data base click on import and import the file called sql.sql

step 4 open each of the files index.php, delete.php, linkchanger.php

At the top of each file you will see this

Code:
$mysqluser = "your database user id"; 

$mysqlpass = "your database password";

$mysqldb = "your database name";
change each to your database info.

Create a new file folder on you server and password protect it

Upload the files index.php, delete.php, linkchanger.php

Now point your browser at yoursite.com/new-folder-name

And you are ready to start inserting links be sure you have set the permissions on the files to 755

See the next post to see how to display the links to your site.
Attached Files
File Type: zip dyn_menu.zip (2.5 KB, 217 views)
__________________
I hope to build a site with something for every body
www.bmcoll.com

Last edited by bmcoll3278; 08-12-2009 at 12:47 AM.
Reply With Quote