doenci Posted September 28, 2007 Share Posted September 28, 2007 I am such a beginner but I had gone this far.... Here is the code: <?php $url = "http://www.website.com/"; // The simple url $name = "11215"; // this data coming from database $newUrl = $url . "$name"; // appending the new url header("location:$newUrl"); //the new url redirected exit; ?> So I'd like to get a $name variable (zipcode) received from a database or any file. Everytime the url/site refreshes the next or randomly picked zipcode should be the new variable for $name and the one was just used should be deleted from the database. I guess it's like an array... I have a mysql database on my server set up which I have to connect to....help would be nice there too . I am wondering if I could run the database from my local computer without connecting to any server. Any help would be great! Thank you guys... doenci Link to comment https://forums.phpfreaks.com/topic/71108-help-needed-with-php-and-mysql/ Share on other sites More sharing options...
mcmuney Posted September 29, 2007 Share Posted September 29, 2007 I don't think you want to delete the zipcode from the database after each refresh. If you do, eventually all zipcodes will be removed, leaving you with nothing. To pull a random zipcode, all you need is a SELECT statement to pull the data from the table that contains the zipcode and use RAND() at the end to pull a random result each time. Link to comment https://forums.phpfreaks.com/topic/71108-help-needed-with-php-and-mysql/#findComment-357616 Share on other sites More sharing options...
Fadion Posted September 29, 2007 Share Posted September 29, 2007 As previously said, why delete the zip code when u can keep it. I have a mysql database on my server set up which I have to connect to....help would be nice there too mysql_connect() will connect u to the db server and mysql_select_db() will select the db u want to use. I am wondering if I could run the database from my local computer without connecting to any server If u mean testing data locally before uploading to a real environment, install php, mysql and apache on your pc and ull be able to work pretty smoothly. There's also a package for beginners by ApacheFriend which will setup a (X)AMPP system for u. Link to comment https://forums.phpfreaks.com/topic/71108-help-needed-with-php-and-mysql/#findComment-357632 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.