<?php
############ API SETUP #########
include("api.php");
$api_key = "034e508fee51a02c388444283a26cba6"; # the API Key given to you when creating a module
$ownerid = $_GET['ownerid'];
$userid = $_GET['userid'];
$ownerinfo = api_get_data($api_key,"members.info(".$ownerid.")");
$birthdate = $ownerinfo['birthdate'];
$avatar = $ownerinfo['avatar'];
$name = $ownerinfo['name'];
########## END API SETUP ########

############# mysqlSETUP ###########
$host="localhost"; // Host name
$username="apikid_fpsb"; // Mysql username
$password="XXXXXXXXXXXXXX"; // Mysql password
$database="apikid_fpsb"; // Database name
$tbl_name="storeinfo"; // Table name
$query1 = "INSERT INTO storeinfo VALUES ('','$first','$last','$phone','$mobile','$fax','$email','$web')";
$query2="SELECT * FROM storeinfo VALUES ('','$first','$last','$phone','$mobile','$fax','$email','$web')";
############ end mysqlSETUP ##########

################# mysql CONNECT #############
mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$result2 = mysql_query($query2);
$result1 = mysql_query($query1);
################# end mysql CONNECT #############

############### mysql TABLES ###############

$first = $_POST['first'];
$last = $_POST['last'];
$phone = $_POST['phone'];
$mobile = $_POST['mobile'];
$fax = $_POST['fax'];
$email = $_POST['email'];
$web = $_POST['web'];
############ end mysql TABLES ###############

echo "<b><center>Database Output</center></b><br><br>";
$i=0;
$num = mysql_num_rows($result1);

# Displays Information
while ($i < $num)
{

$first=mysql_result($result2,$i,"first");
$last=mysql_result($result2,$i,"last");
$phone=mysql_result($result2,$i,"phone");
$mobile=mysql_result($result2,$i,"mobile");
$fax=mysql_result($result2,$i,"fax");
$email=mysql_result($result2,$i,"email");
$web=mysql_result($result2,$i,"web");

echo "<b>$first $last</b><br>Phone:
$phone<br>Mobile: $mobile<br>Fax: $fax<br>E-mail:
$email<br>Web: $web<br><hr><br>";

$i++;
}

################## ACTUAL MODULE ###############
echo "<form method=\"post\">First Name:";
echo api_form_id(234);
echo "<input class=\"textbox\" type=\"text\" name=\"first\"><br>";
echo "Last Name: <input class=\"textbox\" type=\"text\" name=\"last\"><br>";
echo "Phone: <input class=\"textbox\" type=\"text\" name=\"phone\"><br>";
echo "Mobile: <input class=\"textbox\" type=\"text\" name=\"mobile\"><br>";
echo "Fax: <input class=\"textbox\" type=\"text\" name=\"fax\"><br>";
echo "E-mail: <input class=\"textbox\" type=\"text\" name=\"email\"><br>";
echo "Web: <input class=\"textbox\" type=\"text\" name=\"web\"><br>";
echo "<input class=\"textbox\" class=\"button\" type=\"Submit\"></form>";
################ END ACTUAL MODULE ###############

?>