Please click here to login.
prepare($sql);
$success = $sth->execute($prepared_array);
$row = $sth->fetch (PDO::FETCH_NUM);
echo "Enjoying pineapples since " . $row[0] . "!";
// Customer information
print "Personal Information
";
$sql = "SELECT fullname, country, phone_num FROM pontech_pineapplepnp.user WHERE email = ? limit 1 ";
$prepared_array = array($email);
db_edit_row($db, $sql, $prepared_array, "pineapple_personal_information_edit_action.php",
array("country" => "select country_code, country from phone_num_country_code order by country asc")
);
echo "Please enter your phone number without any special characters or a country code. Ex: 1234567890";
// Addresses
$sql = "SELECT address_label, street, city, state, zip, country FROM user_address WHERE email = ?";
$prepared_array = array($email);
$sth = $db->prepare($sql);
$success = $sth->execute($prepared_array);
$row_count = $sth->rowCount();
if ($row_count == 0)
{
print "No addresss found, please add a shipping address
";
$sql = "SELECT address_label, street, city, state, zip, country FROM user_address WHERE email = ? limit 1 ";
$prepared_array = array($email);
db_edit_row($db, $sql, $prepared_array, "pineapple_address_edit_action.php",
array()
);
goto exit_page;
}
else
{
if ($row_count > 1)
{
print "Found $row_count addresses in our database
";
}
else
{
print "Found $row_count address in our database
";
}
while ($row = $sth->fetch (PDO::FETCH_NUM))
{
$sql = "SELECT address_label, street, city, state, zip, country FROM user_address WHERE email = ? AND address_label = ?";
$prepared_array = array($email, $row[0]);
db_edit_row($db, $sql, $prepared_array, "pineapple_address_edit_action.php",
array()
);
print "
";
}
}
?>
fetchColumn(3);
?>