First you can download our test.csv file here.

Now we are going to open the file for reading using the fopen() function in PHP. Will will specify the location of the file and also the mode in which we want to open it. In this case we are using the “R” mode which stands for read. Other possible uses of this function can be found on the manual page for fopen().

<?php

$handle = fopen("test.csv", "r");

?>

Next we are going to create a while loop. We will use this loop to parse each line of the CSV.

<?php
$handle = fopen("test.csv", "r");

while () {

}
?>

Next we are going to use the fgetcsv() function to “split” each line of our CSV file into an array called $data. When there are no lines left the condition will be false and will end the loop. In the fgetcsv() function we will pass the file handle, length (optional) and the separating character (which is a comma in this case.
test

<?php

$handle = fopen("test.csv", "r");

while (($data = fgetcsv($handle, 5000, ",")) !== FALSE) {

}
?>

*note: If you data fields are encapsulated using a character such as – (for ease of example) you can specify the enclosure filed like so: fgetcsv($handle, 5000, “,”,”-”). By default the enclosure character is a double quote, but the function will also handle no enclosure character.

Next all we have to do is echo the fields that we want to see. We will use the field number in the array to do this. I will echo the second value in the CSV.

<?php

$handle = fopen("test.csv", "r");
$row = 1;
while (($data = fgetcsv($handle, 5000, ",")) !== FALSE) {
	echo $data[2];
	echo "</br>";
}
?>

Another note. If you do not know which value the field you are looking for will be in the array just print the array like this:

<?php

$handle = fopen("test.csv", "r");

while (($data = fgetcsv($handle, 5000, ",")) !== FALSE) {
	echo "<pre>";
	print_r($data);
	echo "<pre>";
}
?>

As you can see it is pretty simple to parse csv using this method. You may have issue with memory if you try to open large files using fopen. in that case you will want to read the file line-by-line, but that is another tutorial.

Related Posts

• March 30, 2009 — How to Return MySQL Results to a Table (4)
• March 13, 2009 — Editing MySQL Data Using PHP (17)
• February 22, 2009 — How to Get a Users Geo Location? (5)
• September 21, 2008 — Creating Checkboxes Based on SQL Results (3)
• August 25, 2008 — Simple PHP Website Templates (8)

<script type="text/javascript" src="includes/js/validate_email.js"></script>

<form method="post" action="register.php" name="user">
<h2>User Creation</h2>
UserName (Display Name):<input type="text" name="display_name" id="display_name"/> <br />
First Name:<input type="text" name="fname" id="name"/><br />
Last Name:<input type="text" name="lname" id="surname"/><br />
E-mail:<input type="text" name="email" id="email" onBlur="checkEmail()"/><div id="emailflag" style="display:inline;"><img src="images/failure.gif"></div><br />
Password:<input type="password" name="pass" id="pass"/>
Confirm PW:<input type="password" name="pass2" id="pass2" />
<br  />
</form>

Only a few things to note here: the onBlur command in the e-mail textbox is the first. This is going to call the email function (which is included in the script include at the beginning of the file) every time that textbox is tabbed or clicked away from. Also, note the div after the textbox, that contains the failure image now as we will use that ID to change the image later. Next, we need to create the php file that will actually do the validation when the AJAX calls it. Let’s call this file validate_email.php. I’ll break this one down a little to explain what’s going on.

<?php
if (isset($_GET['email'])){
	isValidEmail($_GET['email']);
}

This couple of lines simply checks for a variable to be set and if it is, calls the function to validate the address – this will prevent from someone going straight to this file or going to it with a blank string. As you can see we pass the value in the variable to the function.

function isValidEmail($email)
	{
	$myReg="/^[A-Za-z0-9\._-]+@[A-Za-z0-9_-]+\.([A-Za-z0-9_-][A-Za-z0-9_]+)$/";
		if(preg_match($myReg, $email)){
			if(domain_exists($_GET['email']))
			{
				echo("<img src=\"images/success.gif\">");
			}
			else
			{
				echo("<img src=\"images/failure.gif\">");
			}
		}
		else
		{
			echo("<img src=\"images/failure.gif\">");
		}
	}

The function looks worse than it actually is due to the reg-ex. They can be a little confusing, but once you understand what it does, it’s not that bad….but that is another tutorial. For now just know it checks the string that is passed to it to be formatted correctly. First we set the reg-ex and then we pass the address to it through the preg_match command. This will process the string to match the reg-ex and output true or false. If it passes validation, we then pass it to our function to check the MX record. If that passes we echo the path to success.gif (which is a green check-mark), otherwise we echo the path to failure.gif (which is a red x). Note that for these to work you will need to put the images in the proper locations or change the path to the images. Finally, in this file we need to create the domain_exists fcuntion that we called in the above section of code.

function domain_exists($email,$record = 'MX')
{
	list($user,$domain) = split('@',$email);
	return checkdnsrr($domain,$record);
}
?>

This simply runs the e-mail(after splitting the email at the @ symbol) through the checkdnsrr which checks for the MX record to be retrievable from the domain name. This essentially just checks for a server to be responding at that domain name. Technically we could still put an e-mail that doesn’t exist, as all we check is for the domain to exist. Next, we need to create the AJAX call file. We’ll call this file validate_email.js.

function checkEmail(){
	httpObject = getHTTPObject();
	if (httpObject != null) {
		if (!document.getElementById('email').value== ""){
			httpObject.open("GET", "../includes/php/checkemail.php?email="+document.getElementById('email').value, true);
			httpObject.send(null);
			httpObject.onreadystatechange = setImage;
		}
		else
		{
			document.getElementById('emailflag').innerHTML = "<img src=\"images/failure.gif\">";
		}
	}
}

This file has 3 functions in it. The first one is the function that we are calling from the form in the first file. This function calls the getHTTPObject function to initialize the AJAX call that we will use. Next, we check for the email field in the form to contain information and if it does, we do an HTTP GET request to call the php file and pass it the email that is currently in the textbox. If it contains no data it sets the div that is created right after the textbox to contain the failure image. Once the HTTP object state changes, we call the function that will pass the image contents.

function getHTTPObject(){
if (window.ActiveXObject) return new ActiveXObject("Microsoft.XMLHTTP");
else if (window.XMLHttpRequest) return new XMLHttpRequest();
else {
alert("Your browser does not support AJAX.");
return null;
}}

This function declares the httpObject that we will be using and throws an error in the browser if it does not support the call.

function setImage(){
if(httpObject.readyState == 4){
document.getElementById('emailflag').innerHTML = httpObject.responseText;
}}

This final function checks for the state of the object to be 4 (completed) and if it is it sets the innerHTML of the ID from the form to whatever was echoed from the PHP file (either the success or the failure gif). That completes the files. Ensure that all the files are in the right place. I have my php file in /includes/php/validate_email.php and the javascript file is /includes/js/validate_email.js.

This is the form that should be shown when you go to the main form.

When you type a valid e-mail into the e-mail box, the checkmark should appear where the X was like above.

If you put in a improperly formatted e-mail like above, it should switch it back to an X. It will also go back to an X if you blank out the text box.

That completes this tutorial. Some of this can be hard to follow so please leave any questions or comments you have in the comments sections and we’ll help you out where we can. Also, I made the reg-ex fit as many things as I could, if you find a valid e-mail that it fails, please let me know so that I can modify it to work. Thanks for viewing this tutorial and I hope it was easy to follow.

Other Related Tutorials

• June 10, 2008 — Professional Javascript Based Photo Viewer (6)
• April 10, 2007 — Photoshop Darkness Logo Tutorial (46)
• September 6, 2007 — Make an invisible folder on the desktop. (7)
• June 6, 2007 — Configure Windows XP Automatic Updates (0)
• May 31, 2007 — Introduction To Online Advertising (3)

To start you will want to click on the Start orb and type msconfig into the box for it to find what you are looking for (alternatively if you use the classic start menu, click on run and type msconfig and press enter).

The above window will appear. This is the configuration setting for a lot of Windows components and features. We will not want to click on the tools tab to open the section with our UAC settings.

This is the tools tab. This tab allows you access to some pre built scripts and features of the Windows Operating System.

Scroll down until you see Disable UAC. Click on it once and click the Launch button at the bottom of the screen.

The above window will appear to let you know that is has completed successfully or give you any error it may have encountered. That is all there is to it. As you may have noticed, there is also an option to Enable UAC which will allow you to turn it back on if you decide you would like to. I hope this tutorial was easy to follow and thanks for reading.

WootStat offers:

• User Voting
• Price Comparison
• Sharing Capabilities
• Past items
• Woot-Off Predictions
• Top Users
• Best and Worst Items
• Email Notifications
• …and more to come

The user who refers the most friends this month will win a $50 NewEgg.com Gift Card. At the time of this post the leader has only 3 referrals. All you have to do is add WootStat and then Invite Your Friends.

If you want to check out the app you can check it out at WootStat.com.

See the Facebook about page

What is woot?

I hope that this would lead to some Facebook API tutorials, but I can’t promise anything. As usual if you have any question post them below or feel free to use the contact form. We generally respond to all inquires.

Related Posts

• September 21, 2008 — Creating Checkboxes Based on SQL Results (3)
• September 7, 2008 — jQuery Pop Over Effects (3)
• August 18, 2008 — Password Verification and Strength Checker (7)
• August 13, 2008 — JavaScript Progress Bar 2 (4)
• August 12, 2008 — JavaScript Progress Bar (2)

First off. I am going to use a table that I created in the past tutorials on this site.

The table contains the following fields:

ID – auto generated integer
FName – First Name, varchar
LName – Last Name, varchar
PHON – Phone number, varchar

Create the table and populate some test data if you haven’t done so already. If you don’t know how to do this please visit some of our other MySQL tutorials.

Create your database connection

<?php
//create a database connection
mysql_connect("localhost","your username","password") or die("Error: ".mysqlerror());
//select your database
mysql_select_db("your db");
?>

Next we need to setup the table. We will add the column headings.

<?php
//create a database connection
mysql_connect("localhost","your username","password") or die("Error: ".mysqlerror());
//select your database
mysql_select_db("your db");
?>

<html>
<body>

<table border=1>
  <tr>
   <th>ID</th>
   <th>First Name</th>
   <th>Last Name</th>
   <th>Phone Number</th>
  </tr>

As you can see above we ended our PHP code and create an HTML table. The TR tage is used to defined a table row and the TH tag is used for Table Headings.

In php you can “break” out of code and execute HTML and then continue writing php code. Do do this you simply end your php code with then start a new

So the next setup will be to add the php code to select our items from the database.

<?php
//create a database connection
mysql_connect("localhost","your username","password") or die("Error: ".mysqlerror());
//select your database
mysql_select_db("your db");
?>

<html>
<body>

<table border=1>
  <tr>
   <th>ID</th>
   <th>First Name</th>
   <th>Last Name</th>
   <th>Phone Number</th>
  </tr>

<?php
//create the query
$query = mysql_query("select * from `TestTable`");

//return the array and loop through each row
while ($row = mysql_fetch_array($query)){

	$id = $row['ID'];
	$fname = $row['FName'];
	$lname = $row['LName'];
	$phone = $row['PHON'];

?>

Above you will see that we executed a query and returned the results as an array. We will loop through each record and echo the results in the table. Take notice that I DID NOT CLOSE the if statment here on purpose.

Now to we will add the HTML for the rows that are returned. We will use php and echo the results.

<?php
//create a database connection
mysql_connect("localhost","your username","password") or die("Error: ".mysqlerror());
//select your database
mysql_select_db("your db");
?>

<html>
<body>

<table border=1>
  <tr>
   <th>ID</th>
   <th>First Name</th>
   <th>Last Name</th>
   <th>Phone Number</th>
  </tr>

<?php
//create the query
$query = mysql_query("select * from `TestTable`");

//return the array and loop through each row
while ($row = mysql_fetch_array($query)){

	$id = $row['ID'];
	$fname = $row['FName'];
	$lname = $row['LName'];
	$phone = $row['PHON'];

?>

  <tr>
   <th><?php echo $id;?></th>
   <th><?php echo $fname;?></th>
   <th><?php echo $lname;?></th>
   <th><?php echo $phone;?></th>
  </tr>

Now all we have to do is end the if statement and close all of our open HTML tags.

<?php
//create a database connection
mysql_connect("localhost","your username","password") or die("Error: ".mysqlerror());
//select your database
mysql_select_db("your db");
?>

<html>
<body>

<table border=1>
  <tr>
   <th>ID</th>
   <th>First Name</th>
   <th>Last Name</th>
   <th>Phone Number</th>
  </tr>

<?php
//create the query
$query = mysql_query("select * from `TestTable`");

//return the array and loop through each row
while ($row = mysql_fetch_array($query)){

	$id = $row['ID'];
	$fname = $row['FName'];
	$lname = $row['LName'];
	$phone = $row['PHON'];

?>

  <tr>
   <th><?php echo $id;?></th>
   <th><?php echo $fname;?></th>
   <th><?php echo $lname;?></th>
   <th><?php echo $phone;?></th>
  </tr>

<?php } //this ends the if?>

</table>
</html>

If you do it right you will get something like this:

Related Posts

• March 13, 2009 -- Editing MySQL Data Using PHP (17)
• September 21, 2008 -- Creating Checkboxes Based on SQL Results (3)
• August 25, 2008 -- Simple PHP Website Templates (8)
• July 16, 2008 -- Creating a Form that will Search a MySQL Database (32)
• June 18, 2008 -- Setting Up a WAMP Server (30)

If you haven’t taken a look at the past tutorials you may want to:
How to Access a MySQL Database Using PHP
Inserting Data Into a MySQL Database using PHP

You are going to need to create the database if you haven’t done so yet. I called my table `TestTable` and populated the following fields:

ID – Integer, Auto increment
FName – varchar (first name)
LName – varchar (last name)
PHON – varchar (phone number)

Populate some test data into your database and you should be ready to go.

We are going to need to create two files in order to edit the date.
editinfo.php – We will get the user info from the DB and put it into a form.
updateinfo.php – We will send the changes from editinfo.php to this for and update the database.

First create editinfo.php

We are going to connect to the database:

<?php
mysql_connect("localhost","USERNAME","PASSWORD") or die("Error: ".mysql_error()); //add your DB username and password
mysql_select_db("DBNAME");//add your dbname

?>

Since I am only editing 1 row I am going to just use the user with ID 1. If you were using this in an application you would have this information store when the user is authenticated, but I am going to hard code the user ID into my queries for the example.

<?php
mysql_connect("localhost","USERNAME","PASSWORD") or die("Error: ".mysql_error()); //add your DB username and password
mysql_select_db("DBNAME");//add your dbname

$sql = "select * from `TestTable` where ID = 1";
$query = mysql_query($sql);

while ($row = mysql_fetch_array($query)){

	$id = $row['ID'];
	$fname = $row['FName'];
	$lname = $row['LName'];
	$phone = $row['PHON'];

	//we will echo these into the proper fields

}
mysql_free_result($query);
?>

As you can see by the comment about, we will return the rows as an array called $row. Once we build the HTML form we will be able to populate the data into the field. Now I will start with the HTML for the form.

<html>
<head>
<title>Edit User Info</title>
</head>

<body>

<form action="updateinfo.php" method="post">

</form>
</body>
</html>

The important things to note in the HTML above is the form action and method. Action is where we will be sending the data. We want to pass all the changes to updateinfo.php and then updateinfo.php will update the database. The method is the method that we will be using to transmit the variables. You can use either GET or POST variables. GET variables will be displayed in the url, for this example we do not want that, we can you the post method.

Next add the form fields. We will use the input tag for this form. Pay attention to the different values if you are not familiar with them.

type=”text” –just means we are using a text field
value=”" –this is what the box will display by default.
name=”id” –this is what the variable will be named. This is what we will send to updateinfo.php

<html>
<head>
<title>Edit User Info</title>
</head>

<body>

<form action="updateinfo.php" method="post">

userid:<br/>
<input type="text" value="" name="id" disabled/>

<br/>

Last Name:<br/>
<input type="text" value="" name="fname"/>

<br/>

Last Name:<br/>
<input type="text" value="" name="lname"/>

<br/>

Phone Number:<br/>
<input type="text" value="" name="phon"/>

</br>

<input type="submit" value="submit changes"/>

</form>

</form>
</body>
</html>

Now we have the fields setup. You will notice that the input box for id is disable. This is because I do not want the user to be able to change their ID.

Next step is to populate the form with some data. We will echo the values that we set above in the PHP code.

<html>
<head>
<title>Edit User Info</title>
</head>

<body>

<form action="updateinfo.php" method="post">

userid:<br/>
<input type="text" value="<?php echo $id;?>" name="id" disabled/>

<br/>

Last Name:<br/>
<input type="text" value="<?php echo $fname;?>" name="fname"/>

<br/>

Last Name:<br/>
<input type="text" value="<?php echo $lname;?>" name="lname"/>

<br/>

Phone Number:<br/>
<input type="text" value="<?php echo $phone;?>" name="phon"/>

</br>

<input type="submit" value="submit changes"/>

</form>
</body>
</html>

Now you should have you fields populated. The next step is to create the updateinfo.php file and actually update some data. We will start by capturing the data. First connect to your database.

<?php
mysql_connect("localhost","USERNAME","PASSWORD") or die("Error: ".mysql_error()); //add your DB username and password
mysql_select_db("DBNAME");//add your dbname

//get the variables we transmitted from the form
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$phon = $_POST['phon'];

?>

Build the update query and execute.

<?php
mysql_connect("localhost","USERNAME","PASSWORD") or die("Error: ".mysql_error()); //add your DB username and password
mysql_select_db("DBNAME");//add your dbname

//get the variables we transmitted from the form
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$phon = $_POST['phon'];

//replace TestTable with the name of your table
//replace id with the ID of your user
$sql = "UPDATE `TestTable` SET `FName` = '$fname',`LName` = '$lname',`PHON` = '$phon' WHERE `TestTable`.`ID` = '$id' LIMIT 1";

mysql_query($sql) or die ("Error: ".mysql_error());

echo "Database updated. <a href='editinfo.php'>Return to edit info</a>";

?>

That is all you need to allow a user to update their info. Now this is a very basic version. If you were to use this on a production web site you would want to do form validation and also protect yourself from sql injection in the update form.

Here is the full source for both files:

editinfo.php

<?php

//replace usernaem,password, and yourdb with the information for your database
mysql_connect("localhost","USERNAME","PASSWORD") or die("Error: ".mysqlerror());
mysql_select_db("YOURDB"); 

//replace TestTable with the name of your table
//also in a real app you would get the id dynamically
$sql = "select * from `TestTable` where ID = 1";
$query = mysql_query($sql);

while ($row = mysql_fetch_array($query)){

	$id = $row['ID'];
	$fname = $row['FName'];
	$lname = $row['LName'];
	$phone = $row['PHON'];

	//we will echo these into the proper fields

}
mysql_free_result($query);
?>

<html>
<head>
<title>Edit User Info</title>
</head>

<body>

<form action="updateinfo.php" method="post">

userid:<br/>
<input type="text" value="<?php echo $id;?>" name="id" disabled/>

<br/>

Last Name:<br/>
<input type="text" value="<?php echo $fname;?>" name="fname"/>

<br/>

Last Name:<br/>
<input type="text" value="<?php echo $lname;?>" name="lname"/>

<br/>

Phone Number:<br/>
<input type="text" value="<?php echo $phone;?>" name="phon"/>

</br>

<input type="submit" value="submit changes"/>

</form>
</body>
</html>

updateinfo.php

<?php
//replace usernaem,password, and yourdb with the information for your database
mysql_connect("localhost","USERNAME","PASSWORD") or die("Error: ".mysqlerror());
mysql_select_db("YOURDB"); 

//get the variables we transmitted from the form
$id = $_POST['id'];
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$phon = $_POST['phon'];

//replace TestTable with the name of your table
$sql = "UPDATE `TestTable` SET `FName` = '$fname',`LName` = '$lname',`PHON` = '$phon' WHERE `TestTable`.`ID` = '$id' LIMIT 1";

mysql_query($sql) or die ("Error: ".mysql_error());

echo "Database updated. <a href='editinfo.php'>Return to edit info</a>";
?>

If you are going to ask a question please take the time to go through the tutorial first. Thanks.

Related Posts

• July 16, 2008 — Creating a Form that will Search a MySQL Database (32)
• March 30, 2009 — How to Return MySQL Results to a Table (4)
• September 21, 2008 — Creating Checkboxes Based on SQL Results (3)
• June 18, 2008 — Setting Up a WAMP Server (30)
• June 18, 2009 — How to Parse a CSV File Using PHP (1)

Click on Create next to Project to create our project.

Name the project what you want and place it where you want as well. I called mine tutorial and stored it in a folder named mike on my desktop. Next we need to make the form. The first picture is what is should look like and the second is the items labeled with what I named each control so that yours can be the same.

Note that the plus sign is just a label with the “+” plus symbol as the text. Then we have two textboxes (txt1 and txt2) and finally a command button (cmdCalculate). Now, let’s double click on the button to begin our programming.

        Try
            MsgBox(CInt(txt1.Text) + CInt(txt2.Text))
        Catch ex As Exception
            MsgBox("This message shows when it errors to tell you why:" & ex.Message)
        Finally
            MsgBox("This message shows whether it errors or not")
            txt1.Text = Nothing
            txt2.Text = Nothing
  End Try

All of this code should go in the sub for the button press. This is all the programming we will have to do to understand what this phrase does and why it can be so useful. First we initialize the “Try” statement. Anything under this section will be run once the code gets to this point. You can put multiple things in here and it will step through them until it completes or errors out. Here, we are attempting to convert anything in the textboxes to an integer so that they can be added together and show the result. Anything in the “Catch” section will be executed in the event that anything in the “Try” statement fails. Here we are popping a message box up and giving the user the information of why it failed. The “ex.message” is whatever message the exception that occurred carries so that we can inform the user of why it crashed. Anything in the finally statement will be executed either way. This is useful for connections and stuff so that whether the transaction fails or completes it will close the connection. In this sample, we are making a message box appear as well as clearing both text boxes whether the process fails or not. Finally we end the try statement. Let’s run it and make sure it does what it is supposed to.

Let’s start by putting in two numbers to make sure it adds them together correctly. I put in 34 and 54.

You should get the above message box if it worked. Mine came to 88 which means it is working as it is expected.

Then you will get the above message box as well because it is in the finally section of the code which is run either way. The textboxes should now clear as well. Next we will try to make sure our try, catch statement works properly.

Lets put 34 in the first box and “35t” (thirty five and then the letter t). Then click the calculate button.

Since we are trying to convert the text in txt2 to an integer and it contains a letter, that won’t work and it will error out with the above message. “Conversion from string “35t” to type ‘Integer’ is not valid” is the text that was stored in “ex.message”. Normally the app would have crashed due to an unhandled exception and made the user start over from scratch (which in our case isn’t a big deal, but when you are working on more advanced apps and a lot of data is involved it can be very annoying to have to start over).

Finally, you will get the message that appears whether the try works or not and the text boxes will be cleared. That concludes this tutorial. I hope you can see why the try, catch, finally statement is so important. It is a very common part of programming and is used to some extent in every language. Once you get used to it, you can use multiple catch statements to catch different types of errors and do different things based on what type of error is caught. I hope this is helpful and that you were able to understand. Thanks for reading.

Other Related Tutorials

• May 8, 2007 — Generate Traffic with Ekstreme Socializer Plugin for Wordpress (3)
• June 25, 2007 — Blue and Chrome Text (9)
• May 22, 2007 — Show File Extension in Windows XP (6)
• August 13, 2008 — JavaScript Progress Bar 2 (4)
• June 5, 2007 — Do you like our Kontera Ads? (4)

MaxMind offers a paid version of this script that probably offers much more functionality. For what I need though, the free database does the job. I checked the results via a few proxies and they matched the US city fine. I am not sure how this works with international visitors, but I use it for US targeted traffic (It does pick up Canadian cities and Provinces fine….eh)..

First off you are going to need to download the Database and PHP API code:

MaxMind GeoLiteCity
Geoip.inc
Geoipcity.php
Geoipregionvars.php

Once you download all of the files. Extract them all and upload them to the same folder on your server.

Now to use the API we need to include a few files. Then we are going to open the database and check the users location:

include("geoip.inc");
include("geoipcity.inc");
include("geoipregionvars.php");
$gi = geoip_open("./GeoLiteCity.dat", GEOIP_STANDARD);
$rsGeoData = geoip_record_by_addr($gi, $_SERVER['REMOTE_ADDR']);
geoip_close($gi);

This will grab the information, but what can we do with it. To find out what variables you can use print out the array:

include("geoip.inc");
include("geoipcity.inc");
include("geoipregionvars.php");
$gi = geoip_open("./GeoLiteCity.dat", GEOIP_STANDARD);
$rsGeoData = geoip_record_by_addr($gi, $_SERVER['REMOTE_ADDR']);
geoip_close($gi);

print "<pre>";
print_r($rsGeoData);
print "</pre>";

The results should output something like this:

geoiprecord Object
(
    [country_code] => US
    [country_code3] => USA
    [country_name] => United States
    [region] => TN
    [city] => Memphis
    [postal_code] =>
    [latitude] => 35.1242
    [longitude] => -89.9521
    [area_code] => 901
    [dma_code] => 640
)

I ran the above code using a Memphis based proxy. As you can see MaxMinds database gives us:
Country Abbreviation in two formats,
Full country name,
Region (state/province),
City,
Postal code (this usually works but is blank in the example),
Latitude,
Longitude,
Area Code,
DMA code (Designated Market Area as in Nielsen Media tv/radio market areas in the US)

Ok so now that we know what everything is, all we have to do is echo the results in the proper places. For example:

echo $rsGeoData->city;
echo ' ,';
echo $rsGeoData->region;

Would out put: Memphis, TN.
So if you were going to use this in a template you would use something like this in the header:

<?php
include("geoip.inc");
include("geoipcity.inc");
include("geoipregionvars.php");
$gi = geoip_open("./GeoLiteCity.dat", GEOIP_STANDARD);
$rsGeoData = geoip_record_by_addr($gi, $_SERVER['REMOTE_ADDR']);
geoip_close($gi);

$location =  $rsGeoData->city.','.$rsGeoData->region;

?>

Then in your template wherever you want the City, State to display simple:

<h1>Meet girls near <?php echo $location;?></h1>

The your site might look something like this:

Related Posts

• June 18, 2009 — How to Parse a CSV File Using PHP (1)
• March 30, 2009 — How to Return MySQL Results to a Table (4)
• March 13, 2009 — Editing MySQL Data Using PHP (17)
• September 21, 2008 — Creating Checkboxes Based on SQL Results (3)
• August 25, 2008 — Simple PHP Website Templates (8)

Since you are trying to convert the date I am assuming you can connect to a database, runa query, and display the results. If not check out some of our older tutorials:

How to Access a MySQL Database Using PHP

Creating a Form that will Search a MySQL Database

You can use the function in the query to convert the date or after the results are returned.

Using date_format()

Here is an example of how to call the function in a query:

$query = mysql_query("select * date_format(date, '%b %d') as newdate from `table`")

Then when your results are returned simple echo $row[newdate]. The date I used will output the date in this format: Feb 18th (abbreviated month and numeric day with suffix).
You need to pass the date string and the format mask to the function: date_format($date, $format)

You can pretty much do this the same way after your results are returned.
For example:

	$query = mysql_query("select * from `table` ");
	while ($row = mysql_fetch_array($query)){
		$newdate = date_format(strtotime($row[date]), '%b %d');
	}

strtotime will convert a string date to a time stamp.

Other formatting option for date_format()

edit:
This can also be done using the date function. Something like:

$day = date(”d”,strtotime($row['date']));
$month = date(”M”,strtotime($row['date']));

would give you Mar 03

Other Related Tutorials

• March 20, 2008 — Horizontal Menu – From Photoshop to the Web (10)
• September 6, 2007 — Make an invisible folder on the desktop. (7)
• February 25, 2008 — Alternating Table Row Color With CSS Classes (3)
• May 29, 2007 — How to Add Users in Windows Vista (4)
• September 25, 2007 — Eliminating Viruses with AVG Free Edition (5)

First you need to decide which method you are going to use to give users access to the database. The first (and slightly less secure way) is to create an actual login for each person going to use the database. This will require you to get the users credentials in a form before attempting a connection to the database. The alternative to this method is to create only on login for a specific application and then create a table with an encrypted field for the password for the users. Then when the application connects to the database (using the credentials you created every time), it will look into a table to see if the credentials the user supplied are correct. I will walk you though both methods in this tutorial. Both steps require you to start from the beginning. Let’s get started.

First let’s open our Microsoft SQL Server Management Studio by going to Start->Programs->Microsoft SQL Server 2008->Microsoft SQL Server Management Studio.

Once in, you should see a pane to the left of the window that looks like the above image. Expand the Security group.

You screen should now look like above.

Right-click on the logins group and select new login.

You will then be presented the above screen. This is the screen we will use to configure the user to have access to the database.

Fill in the login name with what you want the username to be. If you are using the table method for authenticating, it is common practice to name this something like “appname_login” where appname is the name of your application that is connecting to it. Select the SQL Server Authentication radial button. Now you need to type in the password you want that user to start out with in the boxes provided twice. Then select whether they will be forced to adhere to password policies (change x amount of days, certain length, certain types of text, ect…), and password expirations. Also check the box if you want the user to have to change there password the next time they log-on. Finally select the default database (which in this case is TT) and select the default language.

Now, in the left pane, click on User Mapping and check the box for the database we want the user to have access to and then select the access type from the bottom window on the right that you want them to have.

Now if you expand the Login directory you will see the user we just created. The user will also appear listed under the users group that is under the security group of TT since we mapped his credentials to that database. Simply do this for each user that you want to have access to the database if you are using the login for each user method. If you do not want to use the table method, you can discontinue reading here as the remaining steps will be fore creating a table for credentials and how to set it up. There are two ways to create a table, you can do it in the Graphical Interface, or you can write the script yourself. What I would recommend if you are new to SQL is to create it in the graphical interface and then view the code that it creates so that you can get an understanding of what the commands and syntax of SQL are. Let’s do it in the graphical interface:

Expand the databases collection, and then expand your database that you created. Once you do that right click on the table collections and select New Table…

Once the information loads, you will see a properties window to the right that will allow you to name the table. Name it something like ‘Users’ or ‘Credentials’. Once you do that we need to fill out the information for the table.

To create the info just begin typing in the appropriate box. Once you insert information into the box and move to the next field, the builder will auto-create the next line(column for the table). Make three columns to match what I have above. This will allow us to store the username, password, as role as a role for the user. This will allow us to use this field in our application to determine what the users can and can’t do easier. Also note that I have made the length of the password 255 characters. This is because I intend to encrypt the password that goes into this field which will take up more characters than required. I will cover this in a future tutorial.

Now that we have finished making our changes we can save the table but first let’s take a look at the code that this is going to generate. Right-click anywhere on the editor window and a menu will pop-up allowing you to select ‘Generate Change Script…’.

Once you select that menu option, the above window will appear with the script that the system would run to create the table. Look over it and try to understand what they do. Look the commands up in the help file and Google them to see what they do. This will be a good way to understand the commands. You can copy and paste this information into an SQL file and run it to create the table. Click on No to close the window once you are done and you will be taken back to the original screen.

Once you have everything in the table we will need, we can right-click on the tab for the editor and select save. This will save the table to our database.

Once the file finishes saving you should see it in the tables folder if you expand it’s view as above.

Now we need to insert some info into the table. Right-click on our database and select New Query as pictured above.

The query to insert people in this table will be as follows: -Note- It is good practice to capitalize all SQL command and tables so that you get differentiate the text easily.

INSERT INTO DBName..TableName VALUES(‘UserName’,’Password’,’Role’)

For example, if I wanted to create a user in the table for me with the password of password123 and the role of Admin the query would look like this:

INSERT INTO TT..USERS VALUES('MMaguire','password123','Admin')

Type your query into the text box and click on the green play button on the top portion of the screen to run the query.

You should see this message if your query has been successfully ran. If not, please check your query for mistakes. Now we can do a select statement on the table to see our user that we just inserted.

SELECT * FROM TT..USERS

Once you run the select statement, the screen in the middle will show you the results returned as above. You can now do the above steps for each user (inserting them with the query). Once you do that your table is completed. This will conclude this tutorial. Next, we will look at using Visual Basic to call this table and verify a user has permissions.

Related Posts

• November 10, 2008 — Configuring and Creating a Database in MS SQL 2008 (8)
• November 9, 2008 — Installing Microsoft SQL 2008 Express Edition (4)
• July 16, 2008 — Creating a Form that will Search a MySQL Database (32)