Jump to content

Help needed with php and mysql


doenci

Recommended Posts

 

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

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.

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.