PHP - Edit Mysql Table From Bowser Problem

I'm not sure if my problem is with the PHP, MySQL, HTML, or all of the above, but I've used a tutorial from ScriptPlayground (http://scriptplayground.com/tutorials/php/Printing-a-MySQL-table-to-a-dynamic-HTML-table-with-PHP/) to print a table to HTML.

My problem isn't that I couldn't get it to work, as you can see from my site, http://dollapal.com/offerlist.php

I've used the code on my site,  trying to display a list of offers, with links to each, but I actually have two questions:

Is there a way to EXCLUDE columns of the table?  I would rather not show the 'id' or 'points' columns, since they don't offer any worth to the user.  I would also need to hopefully add a dollar sign before the 'pay' quantities if possible.

I would also like use the 'title' field as a hyperlink to the URL listed in the 'URL' field, instead of simply printing the URL. 

Are there any simple ways to do this and not have it look terrible?  I have included a copy of the script that I'm working with so far.

Thank you in advance!

I made a table that gets the rows from a mysql table and lists them with the information on each row. What i need is an edit button at the end of the row so i can click it to change the data. What i want it to do is pop up a new window (child) that i can easily change the data by a text box, drop down menu, etc. and click submit to update it on the table. What i also need is a second button that will completely remove the data from that row in the table. I am still learning php and html and have no knowledge of javascript so any help would be appreciated!

Gang,

I'm trying to create a form that allows me to edit table data within a MySQL database. I've been able to display the data, no problem. I want to be able to edit the fields in the database tables but have had no luck. I'm using session variables to connect and gather the information I need.

Here's the code for collecting the table data:

<?php
mysql_select_db($database);
if(empty($database)) {

echo "<p>You must be connected to a database in order to view any table data.</p>";
}else{

// Show table data start
$sql = "SHOW TABLES FROM $database";
$result = mysql_query($sql);
$table = array();

while ($row = mysql_fetch_row($result)) 
{

$table[] = $row[0];
}
if (count($table) == 0)
{

echo "<p>The database '" . $database . "' contains no tables.</p>\n";
}
else
{
foreach($table AS $aTable)

{

echo "<p style='text-align:left;float:left;width:100%;margin-top:15px;'>Table: <font color='green'>$aTable</font>";

if (!mysql_connect($hostname, $user, $passwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

// sending query
$result = mysql_query("SELECT * FROM {$aTable}");
if (!$result) {
    die("Query to show fields from table failed");
}

$fields_num = mysql_num_fields($result);

echo "<div style='text-align:left;width:100%;'><table border='0'><tr><td></td>";
// printing table headers
for($i=0; $i<$fields_num; $i++)
{
    $field = mysql_fetch_field($result);
    echo "<td style='text-align:left;padding:3px;font-size:11px;color:green;'>{$field->name}</td>";
}
echo "</tr>\n";
// printing table rows
while($row = mysql_fetch_row($result))
{
    echo "<tr><td style='text-align:center;padding:3px;font-size:10px;border:1px solid #888;background:#fff;'><a href='edit_data.php?=$row[0]' style='color:red;text-decoration:none;'>edit</a></td>";

    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
    foreach($row as $cell)
        echo "<td style='text-align:left;padding:3px;font-size:10px;border:1px solid #888;background:#fff;clear:both;float:left;'>$cell</td>";

    echo "</tr>\n";
}
mysql_free_result($result);
echo "</table></div>";

}

    }
} //end show table data

include("includes/footer.php");
?>


I'm not sure how to create a form using the session variables in order to be able to edit the correct information since I want to edit numerous databases.

Any help would be great! Thanks

This topic has been moved to Other Libraries and Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=346821.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=346771.0

Hi all.
I built an online finance tracking thingy for myself and I got it to work using the following database table and PHP code. I didn't write the PHP code, rather, I edited it to suit my needs.
It works great for my needs. I have a way to enter records and view the last 180 records in a table. The thing is, while viewing the table, I would lke to be able to edit and delete records. I don't know enough to be able to do this.
Can it be done? I realize my PHP code would probably, for the most part, be totally different.
Thanks for any help with this.

Here is my DB table structu
Code: [Select]
DROP TABLE IF EXISTS `money`;
CREATE TABLE IF NOT EXISTS `money` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`date` date NOT NULL,
`type` varchar(18) NOT NULL,
`checking` decimal(5,2) NOT NULL DEFAULT '0.00',
`cash` decimal(5,2) NOT NULL DEFAULT '0.00',
`description` varchar(25) NOT NULL,
`who` varchar(25) NOT NULL,
`note` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
And here is the PHP:
Code: [Select]
<?php


$result = mysql_query ('SELECT date, type, checking, cash, who, description, note'
        . ' FROM money'
        . ' ORDER BY date DESC LIMIT 0,180')
or die(mysql_error());  

echo "<table border='1' cellpadding='5'>";


echo "<tr><th>Date</th><th>Type</th><th>Checking</th><th>Cash</th><th>Who?</th><th>Description</th><th>Note</th></tr>";

while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>"; 
echo $row['date'];
echo "</td><td>";
        echo $row['type'];
echo "</td><td>";  
echo $row['checking'];
echo "</td><td>"; 
        echo $row['cash'];
echo "</td><td>"; 
echo $row['who'];
echo "</td><td>"; 
        echo $row['description'];
        echo "</td><td>"; 
        echo $row['note'];
echo "</td></tr>";
} 

echo "</table>";
?>

Hi friends. I want to php code on how i can modify my retrieved database values from a particular table before echoing out. Please could you help me correct the code. Or if there is any better way of editing loop datas before printing out, please kindly drop the code for me. Thanks

<?php    

$q = "SELECT * FROM threads WHERE catid='2'";

  $get = $database->query($q) or die(mysql_error());

 $row=mysql_fetch_row($get);


$value=$row['0']['title'];

$one='first value'; 

echo $value.$one;


$value=$row['1']['name'];

$two='second value'; 

echo $value.$two;


$value=$row['2']['category'];

$three='third value'; 

echo $value.$three;

?>

please if there is any better way of editing loop values from mysql database before printing out, please kindly drop the code for me. Thanks

My validation

Code: [Select]
<?php 

if(!isset($_POST['submit']))
{
if(!isset($_GET["id"]))
{
me_redirect_to("staff.php");
}
}
?>


is redirecting me even if my $_POST['submit'] is set


here's the full code


Code: [Select]
<?php require_once("includes/connection.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php require("includes/header.php"); ?>
<?php require("includes/navbar.php"); ?>
<?php require("staff_sidebar.php"); ?>




<?php 

if(!isset($_POST['submit']))
{
if(!isset($_GET["id"]))
{
me_redirect_to("staff.php");
}
}
?>


<?php 

if(!isset($_POST['submit']))
{
if(!is_numeric($_GET["id"]))
{
me_redirect_to("staff.php");
}
}
?>



<?php

if(isset($_GET['id']));
{

$i = 0;

$edit_proj_id = $_GET['id'];


$edit_query = "Select proj_name, content from rec_projects where proj_id = {$edit_proj_id}";

$edit_result = mysql_query($edit_query, $connection);

$num = mysql_num_rows($edit_result);

if($num != 1)
{
me_redirect_to("staff.php");
}


$edit_proj_name = mysql_result($edit_result,$i,"proj_name");
$edit_content = mysql_result($edit_result,$i,"content");


}
?>






<div id="content">
<h1>Edit Subject</h1><br>



<?php


if(isset($_POST['submit']))
{


$proj_name = me_mysql_prep(trim($_POST['proj_name']));
$proj_content = me_mysql_prep($_POST['proj_content']);



if(empty($_POST['proj_name']))
{
$empty_name = array('Project Name Cannot Be Empty');
}

if(empty($_POST['proj_content']))
{
$empty_content = array('Content Cannot Be Empty');
}




if(isset($empty_name) && isset($empty_content))
{
$error_merge = array_merge($empty_name, $empty_content);
}
else if(isset($empty_name))
{
$error_merge = array_merge($empty_name);
}
else if(isset($empty_content))
{
$error_merge = array_merge($empty_content);
}
else
{
$error_merge = array();
}






if(!empty($error_merge))
  {
  foreach($error_merge as $error)
  {
  echo "<span class=\"error_validation\">*". $error . "<br></span>";
  }
  }
  else
  {

$query = "UPDATE rec_projects SET proj_name='{$proj_name}', content='{$proj_content}' where proj_id = {$edit_proj_id}";

if($result = mysql_query($query,$connection))
{
me_redirect_to("edited_project.php?edited=1");
}
else
{
echo "Can\'t edit the project: ". mysql_error() . "";
}

  }
  
  echo "<br><br>";

}


?>



<table>
<tr><td>


</td></tr>
   
</table>





<table>

<form action="edit_project.php" method="post" name="add_subject">
<tr>
<td>Project Name:</td>
    <td><input type="text" size="50" name="proj_name" value="<?php echo $edit_proj_name; ?>"></td>
</tr>


<tr>
<td>Content:</td>
<td><textarea cols="70" rows="20" name="proj_content"><?php echo $edit_content; ?></textarea></td>
</tr>


<tr>
<td></td>
<td><input type="submit" value="Edit Project" name="submit" id="submit" size="30"></td>
</tr>


</form>

</table>

</div>



<?php require("includes/footer.php"); ?>


It's suppose to be executing the mysql edit query but it's bypassing my validation. I wonder what the problem is..

Hello, I will try to explain this in as much detail as I can. I am probably making a simple mistake but I have gone through the code multiple times and can't figure it out.

I have 3 HTML Site tables, pending, accepted and denied applications. I have accept, deny, and delete buttons on all the tables for each row. I could probably do with out the accept and deny buttons on the last two HTML Site tables, but in the case an admin making a mistake and clicking the wrong button. I don't want the admin to have to delete the app and have the user fill out a new one. User experience and all that.

My problem: The last two HTML Site tables, Accept and Denied, the three buttons do not function but in Pending they do. I don't remember assigning those functions to one table and looked thought the code and didn't see any place I did it is only looking for id at the displayed row. Enough of my jabbering. Here is what I am working with.

 

    

Here is the code, I have done for the deletes and edits to the application status.

//DELETE APPLICATION

if(isset($_POST['delete'])) {

    $to_change = mysqli_real_escape_string($conn, $_POST['to_change']);



    $sql = "DELETE FROM apps WHERE id = $to_change";



    if(mysqli_query($conn, $sql)) {

        $feedback['delete'] = '<div class="green white-text alert-box">Success the user deleted from list.</div>';

        header('Location: admin.php');

    } else {

        $feedback['ui_feedback'] = '<div class="red white-text alert-box">Connection Error</div>';

    }

} else {

    $feedback['ui_feedback'] = '<div class="red white-text alert-box">Connection Error</div>';

}



//UPDATE APPLICATION STATUS TO ACCEPT

if(isset($_POST['accept'])) {

    $to_change = mysqli_real_escape_string($conn, $_POST['to_change']);

    //QUERY DB

    mysqli_query($conn, "UPDATE apps SET app_status='Accepted' WHERE id = $to_change");

    $feedback['accept'] = '<div class="green white-text alert-box">Success, the user was accepted.</div>';

    header('Location: admin.php');

} else {

    $feedback['ui_feedback'] = '<div class="red white-text alert-box">Connection Error</div>';

}



//UPDATE APPLICATION STATUS TO DENIED

if(isset($_POST['denied'])) {

    $to_change = mysqli_real_escape_string($conn, $_POST['to_change']);

    //QUERY DB

    mysqli_query($conn, "UPDATE apps SET app_status='Denied' WHERE id = $to_change");

    $feedback['denied'] = '<div class="green white-text alert-box">Success, the user was denied.</div>';

    header('Location: admin.php');

} else {

    $feedback['ui_feedback'] = '<div class="red white-text alert-box">Connection Error</div>';

}

I know the $feedback doesn't work I wanted to see it worked and it didn't I will research that later.

<!-- NEW APPLICATIONS -->
            <div id="new_apps" class="container white container-style">
                <h4 class="blue-text text-darken-3">New Applications</h4>
                <div class="table-responsive">
                <table class="highlight centered row">
                    <thead>
                        <tr class="">
                            <th class="blue-text text-darken-3">ID</th>
                            <th class="blue-text text-darken-3">Name</th>
                            <th class="blue-text text-darken-3">Email</th>
                            <th class="blue-text text-darken-3">Discord</th>
                            <th class="blue-text text-darken-3">Steam Hex ID</th>
                            <th class="blue-text text-darken-3">DOB</th>
                            <th class="blue-text text-darken-3">Department</th>
                            <th class="blue-text text-darken-3">Date Applied</th>
                            <th class="blue-text text-darken-3">Status</th>
                            <th class="blue-text text-darken-3">Actions</th>
                        </tr>
                        <tbody class="">
<?php if($pending): ?>
<?php foreach($pending as $pend): ?>
                                    <tr>
                                        <td><?php echo $pend['id']; ?></td>
                                        <td><?php echo $pend['first_name'] . " " . $pend['last_name']; ?></td>
                                        <td><?php echo $pend['email']; ?></td>
                                        <td><?php echo $pend['discord_name']; ?></td>
                                        <td><?php echo $pend['steam_hex']; ?></td>
                                        <td><?php echo $pend['dob']; ?></td>
                                        <td><?php echo $pend['dept_select']; ?></td>
                                        <td><?php echo $pend['created_at']; ?></td>
                                        <td><?php echo $pend['app_status']; ?></td>
                                        <td>
                                            <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="POST">
                                                <input type="hidden" name="to_change"  value="<?php echo $pend['id']; ?>">
                                                <button type="submit" name="accept" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Accept"><i class="material-icons green-text text-darken-3">check_circle</i></button>
                                                <button type="submit" name="denied" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Deny"><i class="material-icons yellow-text text-darken-3">not_interested</i></button>
                                                <button type="submit" name="delete" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Delete"><i class="material-icons red-text text-darken-3">delete</i></button>
                                            </form>
                                        </td>
                                    </tr>
                            </tbody>
<?php endforeach; ?>
<?php else: ?>
                <div class="blue darken-3 white-text table-empty-box">There are no applications</div>
<?php endif; ?>
                        </thead>
                    </table>
            </div>
        </div>
<!-- ACCEPTED APPLICATIONS-->
                <div id="accepted_apps" class="container white container-style">
                    <h4 class="blue-text text-darken-3">Accepted Applications</h4>
                    <div class="table-responsive">
                    <table class="highlight centered row">
                        <thead>
                        <tr class="">
                            <th class="blue-text text-darken-3">ID</th>
                            <th class="blue-text text-darken-3">Name</th>
                            <th class="blue-text text-darken-3">Email</th>
                            <th class="blue-text text-darken-3">Discord</th>
                            <th class="blue-text text-darken-3">Steam Hex ID</th>
                            <th class="blue-text text-darken-3">DOB</th>
                            <th class="blue-text text-darken-3">Department</th>
                            <th class="blue-text text-darken-3">Date Applied</th>
                            <th class="blue-text text-darken-3">Status</th>
                            <th class="blue-text text-darken-3">Actions</th>
                        </tr>
                            <tbody class="">
<?php if($accepted): ?>
<?php foreach($accepted as $accept): ?>
                                    <tr>
                                        <td><?php echo $accept['id']; ?></td>
                                        <td><?php echo $accept['first_name'] ." " . $accept['last_name']; ?></td>
                                        <td><?php echo $accept['email']; ?></td>
                                        <td><?php echo $accept['discord_name']; ?></td>
                                        <td><?php echo $accept['steam_hex']; ?></td>
                                        <td><?php echo $accept['dob']; ?></td>
                                        <td><?php echo $accept['dept_select']; ?></td>
                                        <td><?php echo $accept['created_at']; ?></td>
                                        <td><?php echo $accept['app_status']; ?></td>
                                        <td>
                                            <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="POST">
                                                <input type="hidden" name="to_change"  value="<?php echo $accept['id']; ?>">
                                                <a type="submit" name="accept" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Accept"><i class="material-icons green-text text-darken-3">check_circle</i></a>
                                                <a type="submit" name="denied" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Deny"><i class="material-icons yellow-text text-darken-3">not_interested</i></a>
                                                <a type="submit" name="delete" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Delete"><i class="material-icons red-text text-darken-3">delete</i></a>
                                            </form>
                                        </td>
                                    </tr>
<?php endforeach; ?>
<?php else: ?>
                                <div class="blue darken-3 white-text table-empty-box">There are no applications</div>
<?php endif; ?>
                            </tbody>
                        </thead>
                    </table>
                    </div>
                </div>
<!-- deniedED APPLICATIONS -->
            <div id="denieded_apps" class="container white container-style">
                <h4 class="blue-text text-darken-3">Denied Applications</h4>
                <div class="table-responsive">
                <table class="highlight centered row">
                    <thead>
                    <tr class="">
                            <th class="blue-text text-darken-3">ID</th>
                            <th class="blue-text text-darken-3">Name</th>
                            <th class="blue-text text-darken-3">Email</th>
                            <th class="blue-text text-darken-3">Discord</th>
                            <th class="blue-text text-darken-3">Steam Hex ID</th>
                            <th class="blue-text text-darken-3">DOB</th>
                            <th class="blue-text text-darken-3">Department</th>
                            <th class="blue-text text-darken-3">Date Applied</th>
                            <th class="blue-text text-darken-3">Status</th>
                            <th class="blue-text text-darken-3">Actions</th>
                        </tr>
                        <tbody class="">
<?php if($denied): ?>
<?php foreach($denied as $deny): ?>
                                <tr>
                                    <td><?php echo $deny['id']; ?></td>
                                    <td><?php echo $deny['first_name'] ." " . $deny['last_name']; ?></td>
                                    <td><?php echo $deny['email']; ?></td>
                                    <td><?php echo $deny['discord_name']; ?></td>
                                    <td><?php echo $deny['steam_hex']; ?></td>
                                    <td><?php echo $deny['dob']; ?></td>
                                    <td><?php echo $deny['dept_select']; ?></td>
                                    <td><?php echo $deny['created_at']; ?></td>
                                    <td><?php echo $deny['app_status']; ?></td>
                                    <td>
                                        <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="POST">
                                            <input type="hidden" name="to_change"  value="<?php echo $deny['id']; ?>">
                                            <a type="submit" name="accept" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Accept"><i class="material-icons green-text text-darken-3">check_circle</i></a>
                                            <a type="submit" name="denied" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Deny"><i class="material-icons yellow-text text-darken-3">not_interested</i></a>
                                            <a type="submit" name="delete" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Delete"><i class="material-icons red-text text-darken-3">delete</i></a>
                                        </form>
                                    </td>
                                </tr>
<?php endforeach; ?>
<?php else: ?>
                                <div class="blue darken-3 white-text table-empty-box">There are no applications</div>
<?php endif; ?>
                        </tbody>
                    </thead>
                </table>
                </div>
            </div>

 

Any help would be amazing even if you tell me to look at a line lol

I am getting back into php after only doing it for a few weeks after switching to firebase,  just coming back to what works and not having limits. 

Thank you for taking the time to read this!

Hi There

I am trying to create a page that edit mysql database from a php page. I can get the edit page to show the orginal information but it wont update the data in the mysql database.

I am sure I have entered everything right. If anyone could help with this I would greatly appreciated

<?php

include("dbconnect.php");

     if(isset($_POST['submit']))

  {


      // Set global variables to easier names
     // and prevent sql injection and apostrophe to break the db.
    
      $ProductName = mysql_escape_string($_POST['ProductName']);
      $ProductText = mysql_escape_string($_POST['ProductText']);
      $ProductImage = mysql_escape_string($_POST['ProductImage']);
      $ProductPrice = mysql_escape_string($_POST['ProductPrice']);


         $result = mysql_query("UPDATE Product SET ProductName='$ProductName', ProductText='$ProductText', ProductImage='$ProductImage', ProductPrice='$ProductPrice' WHERE ID='$ID' ",$dbconnect);

          echo "<b>Thank you! Product UPDATED Successfully!<br>You'll be redirected to View Page after (2) Seconds";

          echo "<meta http-equiv=Refresh content=2;url=view.php>";
         
          echo "$ProductName <br> $ProductText <br> $ProductImage <br> $ProductPrice";

}

elseif(isset($_GET['ID']))

{

 

        $result = mysql_query("SELECT * FROM Product WHERE ID='$_GET[ID]' ",$dbconnect);

        while($myrow = mysql_fetch_assoc($result))

             {

                $ProductName = $myrow["ProductName"];
                $ProductText= $myrow["ProductText"];
                $ProductImage = $myrow["ProductImage"];
                $ProductPrice = $myrow["ProductPrice"];



?>

<br>

<h3>::Edit Product</h3>

   <form method="post" action="<?php echo $PHP_SELF ?>">
   
      <input type="hidden" name="ID" value="<? echo $myrow['ID']?>">            
      Product Name: <input name="ProductName" size="40" maxlength="255" value="<? echo $ProductName; ?>"><br>
      Product Text: <textarea name="ProductText"  rows="7" cols="30"><? echo $ProductText; ?></textarea><br>
      Product Image: <textarea name="ProductImage"  rows="7" cols="30"><? echo $ProductImage; ?></textarea><br>
      Product Price: <textarea name="ProductPrice" rows="7" cols="30"><? echo $ProductPrice; ?></textarea><br>
      <input type="submit" name="submit" value="Update Product">
   
   </form>

<?

              }//end of while loop

 

  }//end else

?>

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=322008.0

I am realy doing my best , but i am bad at php , when i click update bottum on edit_profil.php page it put me over to update.php, but update.php is blank , and cant see any errors. and it has not updated mysql.

Files:
// form page.
edit_profil.php

// Data from edit_profil to mysql
update.php
___________________________

edit_profil.php
Code: [Select]
<?php
// Check if user is logged in
session_start();
if ($_SESSION['s_logged_n'] == 'true'){
$username = $_SESSION['s_username'];
$usermail = $_SESSION['s_usermail'];
// Get the id
if (isset($_GET['id'])){
// Include config file
include "config.php";
// Define id
$id = $_GET['id'];
// Query table
$query = "SELECT * FROM users WHERE user_id = '$id' AND username = '$username' LIMIT 1";
$result = mysql_query($query);
$check = mysql_num_rows($result);
// If user try to edit someone's else profile it will say it can't
if (!$check == 1){
echo "You can edit your profile only";
// Else if everything is ok display form
} else {
?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>

<link href="css/test.css" rel="stylesheet" type="text/css" />


</head>

<body>


<div class="bodyContentCenter">
<h1>My Profile</h1>
<div class="solidThickLine"></div>
<div class="breakLine"><!-- --></div>




<div class="loginColumnBorder" style="width:100%;">
<form action="update.php?id=<?php echo "$id" ?>" method="post">
    <table border="0" width="100%" cellspacing="10" cellpadding="0">
<tbody><tr>
<td>
    <div style="font-size:16px;font-weight:bold;">Edit Profile</div>
    <div class="breakLine"><!-- --></div>
    <div>Personal information obtained are used solely for the purpose of enhancing the functionality and level of service.</div>
    <div class="breakLine" style="height:20px;"><!-- --></div>
   
<table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tbody><tr><td colspan="3" style="font-weight:bold">LOGIN E-MAIL &amp; PASSWORD</td></tr>
          <tr><td colspan="3"><div class="breakLine"></div></td></tr>
          <tr style="height:45px;" valign="top">
          <td style="width:120px;">E-mail Address:</td>
          <td style="width:220px;">
                            <label for="e_mail_address"></label>
  <input type="text" name="e_mail_address" value="<?php echo "$usermail"; ?>" id="e_mail_address">&nbsp;*</td>
         
                           
          </tr>
       
          <tr style="height:45px;" valign="top">
          <td style="width:120px;">New Password:</td>
          <td style="width:220px;">
                           <label for="password"></label>
      <input type="password" name="password" id="password">&nbsp;*</td>
          </tr>
          <tr style="height:45px;" valign="top">
          <td style="width:120px;">Confirm New Password:</td>
          <td style="width:220px;"><label for="password_confirm"></label>
      <input type="password" name="password_confirm" id="password_confirm">&nbsp;*</td>
                           
          <td style="width:380px;"><div id="confirm_password_message"></div>&nbsp;</td>
          </tr>
  <tr><td colspan="3"><div class="dottedLine" style="lin-height: 2px;">&nbsp;</div></td></tr>
  <!--tr><td colspan="3"><div class="breakLine"></div></td></tr-->
 
  <tr><td colspan="3" style="font-weight:bold" valign="top">PERSONAL DETAILS</td></tr>
  <tr><td colspan="3"><div class="breakLine"></div></td></tr>
          <tr style="height:45px;" valign="top">
          <td style="width:120px;">First Name:</td>
          <td style="width:220px;"><input type="text" name="edit_profile_firstname" value="lasse" id="firstname">&nbsp;*</td>

          </tr>
          <tr style="height:45px;" valign="top">
          <td style="width:120px;">Last Name:</td>
          <td style="width:220px;"><input type="text" name="edit_profile_lastname" id="lastname">&nbsp;*</td>
         
          </tr>
          <tr style="height:45px;" valign="top">
          <td style="width:120px;">Country Code:&nbsp;</td>
          <td style="width:220px;"><select name="edit_profile_country_code" style="width:150px;" id="country"><option value="1">Afghanistan +93</option><option value="2">Albania +355</option><option value="3">Algeria +213</option><option value="4">American Samoa +684</option><option value="5">Andorra +376</option><option value="6">Angola +244</option><option value="7">Anguilla +1264</option><option value="8">Antarctica +672</option><option value="9">Antigua and Barbuda +1268</option><option value="10">Argentina +54</option><option value="11">Armenia +374</option><option value="12">Aruba +297</option><option value="13">Australia +61</option><option value="14">Austria +43</option><option value="15">Azerbaijan +994</option><option value="16">Bahamas +1242</option><option value="17">Bahrain +973</option><option value="18">Bangladesh +880</option><option value="19">Barbados +1246</option><option value="20">Belarus +375</option><option value="21">Belgium +32</option><option value="22">Belize +501</option><option value="23">Benin +229</option><option value="24">Bermuda +1441</option><option value="25">Bhutan +975</option><option value="26">Bolivia +591</option><option value="27">Bosnia and Herzegovina +387</option><option value="28">Botswana +267</option><option value="29">Bouvet Island +47</option><option value="30">Brazil +55</option><option value="31">British Indian Ocean Territory +246</option><option value="32">Brunei Darussalam +673</option><option value="33">Bulgaria +359</option><option value="34">Burkina Faso +226</option><option value="35">Burundi +257</option><option value="36">Cambodia +855</option><option value="37">Cameroon +237</option><option value="38">Canada +1</option><option value="39">Cape Verde +238</option><option value="40">Cayman Islands +1345</option><option value="41">Central African Republic +236</option><option value="42">Chad +235</option><option value="43">Chile +56</option><option value="44">China +86</option><option value="45">Christmas Island +61</option><option value="46">Cocos (Keeling) Islands +61</option><option value="47">Colombia +57</option><option value="48">Comoros +269</option><option value="49">Congo +242</option><option value="50">Cook Islands +682</option><option value="51">Costa Rica +506</option><option value="52">Cote D'Ivoire +225</option><option value="53">Croatia +385</option><option value="54">Cuba +53</option><option value="55">Cyprus +357</option><option value="56">Czech Republic +420</option><option value="57" selected="">Denmark +45</option><option value="58">Djibouti +253</option><option value="59">Dominica +1767</option><option value="60">Dominican Republic +1809</option><option value="61">East Timor +670</option><option value="62">Ecuador +593</option><option value="63">Egypt +20</option><option value="64">El Salvador +503</option><option value="65">Equatorial Guinea +240</option><option value="66">Eritrea +291</option><option value="67">Estonia +372</option><option value="68">Ethiopia +251</option><option value="69">Falkland Islands (Malvinas) +500</option><option value="70">Faroe Islands +298</option><option value="71">Fiji +679</option><option value="72">Finland +358</option><option value="73">France +33</option><option value="74">France, Metropolitan +33</option><option value="75">French Guiana +594</option><option value="76">French Polynesia +689</option><option value="77">French Southern Territories +</option><option value="78">Gabon +241</option><option value="79">Gambia +220</option><option value="80">Georgia +995</option><option value="81">Germany +49</option><option value="82">Ghana +233</option><option value="83">Gibraltar +350</option><option value="84">Greece +30</option><option value="85">Greenland +299</option><option value="86">Grenada +1473</option><option value="87">Guadeloupe +590</option><option value="88">Guam +1671</option><option value="89">Guatemala +502</option><option value="242">Guernsey +44</option><option value="90">Guinea +224</option><option value="91">Guinea-bissau +245</option><option value="92">Guyana +592</option><option value="93">Haiti +509</option><option value="94">Heard and Mc Donald Islands +672</option><option value="95">Honduras +504</option><option value="96">Hong Kong +852</option><option value="97">Hungary +36</option><option value="98">Iceland +354</option><option value="99">India +91</option><option value="100">Indonesia +62</option><option value="101">Iran (Islamic Republic of) +98</option><option value="102">Iraq +964</option><option value="103">Ireland +353</option><option value="104">Israel +972</option><option value="105">Italy +39</option><option value="106">Jamaica +1876</option><option value="107">Japan +81</option><option value="108">Jordan +962</option><option value="109">Kazakhstan +7</option><option value="110">Kenya +254</option><option value="111">Kiribati +686</option><option value="112">Korea, Democratic People's Republic of +850</option><option value="113">Korea, Republic of +82</option><option value="114">Kuwait +965</option><option value="115">Kyrgyzstan +996</option><option value="116">Lao People's Democratic Republic +856</option><option value="117">Latvia +371</option><option value="118">Lebanon +961</option><option value="119">Lesotho +266</option><option value="120">Liberia +231</option><option value="121">Libyan Arab Jamahiriya +218</option><option value="122">Liechtenstein +423</option><option value="123">Lithuania +370</option><option value="124">Luxembourg +352</option><option value="125">Macau +853</option><option value="126">Macedonia, The Former Yugoslav Republic of +389</option><option value="127">Madagascar +261</option><option value="128">Malawi +265</option><option value="129">Malaysia +60</option><option value="130">Maldives +960</option><option value="131">Mali +223</option><option value="132">Malta +356</option><option value="133">Marshall Islands +692</option><option value="134">Martinique +596</option><option value="135">Mauritania +222</option><option value="136">Mauritius +230</option><option value="137">Mayotte +269</option><option value="138">Mexico +52</option><option value="139">Micronesia, Federated States of +591</option><option value="140">Moldova, Republic of +373</option><option value="141">Monaco +377</option><option value="142">Mongolia +976</option><option value="241">Montenegro +382</option><option value="143">Montserrat +1664</option><option value="144">Morocco +212</option><option value="145">Mozambique +258</option><option value="146">Myanmar +95</option><option value="147">Namibia +264</option><option value="148">Nauru +674</option><option value="149">Nepal +977</option><option value="150">Netherlands +31</option><option value="151">Netherlands Antilles +599</option><option value="152">New Caledonia +687</option><option value="153">New Zealand +64</option><option value="154">Nicaragua +505</option><option value="155">Niger +227</option><option value="156">Nigeria +234</option><option value="157">Niue +683</option><option value="158">Norfolk Island +672</option><option value="159">Northern Mariana Islands +1670</option><option value="160">Norway +47</option><option value="161">Oman +968</option><option value="162">Pakistan +92</option><option value="163">Palau +680</option><option value="164">Panama +507</option><option value="165">Papua New Guinea +675</option><option value="166">Paraguay +595</option><option value="167">Peru +51</option><option value="168">Philippines +63</option><option value="169">Pitcairn +872</option><option value="170">Poland +48</option><option value="171">Portugal +351</option><option value="172">Puerto Rico +1787</option><option value="173">Qatar +974</option><option value="174">Reunion +262</option><option value="175">Romania +40</option><option value="176">Russian Federation +7</option><option value="177">Rwanda +250</option><option value="178">Saint Kitts and Nevis +1869</option><option value="179">Saint Lucia +1758</option><option value="180">Saint Vincent and the Grenadines +1784</option><option value="181">Samoa +685</option><option value="182">San Marino +378</option><option value="183">Sao Tome and Principe +239</option><option value="184">Saudi Arabia +966</option><option value="185">Senegal +221</option><option value="240">Serbia +381</option><option value="186">Seychelles +248</option><option value="187">Sierra Leone +232</option><option value="188">Singapore +65</option><option value="189">Slovakia (Slovak Republic) +421</option><option value="190">Slovenia +386</option><option value="191">Solomon Islands +677</option><option value="192">Somalia +252</option><option value="193">South Africa +27</option><option value="194">South Georgia and the South Sandwich Islands +</option><option value="195">Spain +34</option><option value="196">Sri Lanka +94</option><option value="197">St. Helena +290</option><option value="198">St. Pierre and Miquelon +508</option><option value="199">Sudan +249</option><option value="200">Suriname +597</option><option value="201">Svalbard and Jan Mayen Islands +79</option><option value="202">Swaziland +268</option><option value="203">Sweden +46</option><option value="204">Switzerland +41</option><option value="205">Syrian Arab Republic +963</option><option value="206">Taiwan +886</option><option value="207">Tajikistan +992</option><option value="208">Tanzania, United Republic of +255</option><option value="209">Thailand +66</option><option value="210">Togo +228</option><option value="211">Tokelau +690</option><option value="212">Tonga +676</option><option value="213">Trinidad and Tobago +1868</option><option value="214">Tunisia +216</option><option value="215">Turkey +90</option><option value="216">Turkmenistan +993</option><option value="217">Turks and Caicos Islands +1649</option><option value="218">Tuvalu +688</option><option value="219">Uganda +256</option><option value="220">Ukraine +380</option><option value="221">United Arab Emirates +971</option><option value="222">United Kingdom +44</option><option value="223">United States +1</option><option value="224">United States Minor Outlying Islands +1</option><option value="225">Uruguay +598</option><option value="226">Uzbekistan +998</option><option value="227">Vanuatu +678</option><option value="228">Vatican City State (Holy See) +39</option><option value="229">Venezuela +58</option><option value="230">Vietnam +84</option><option value="231">Virgin Islands (British) +284</option><option value="232">Virgin Islands (U.S.) +1340</option><option value="233">Wallis and Futuna Islands +681</option><option value="234">Western Sahara +212</option><option value="235">Yemen +967</option><option value="237">Zaire +243</option><option value="238">Zambia +260</option><option value="239">Zimbabwe +263</option></select>&nbsp;*</td>
         
          </tr>
                    <tr style="height:60px;" valign="top">
          <td style="width:120px;">Contact Number:&nbsp;</td>
          <td style="width:220px;"><input type="text" name="edit_profile_contact_number" autocomplete="off" id="contact_number">&nbsp;*</td>
         
          </tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">Gender:</td>
<td style="width:220px;">
                              <select name="edit_profile_gender" id="edit_profile_gender"><option>Female</option><option>Male</option>  </select> </td>
<td style="width:380px;">&nbsp;</td>
</tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">Date of Birth:</td>
<td style="width:220px;"><select name="dob_month" id="month"><option value="01">January</option><option value="02">February</option><option value="03">March</option><option value="04">April</option><option value="05">May</option><option value="06">June</option><option value="07" selected="">July</option><option value="08">August</option><option value="09">September</option><option value="10">October</option><option value="11">November</option><option value="12">December</option></select>&nbsp;&nbsp;<select name="dob_day" id="day"><option value="01">01</option><option value="02">02</option><option value="03">03</option><option value="04">04</option><option value="05">05</option><option value="06">06</option><option value="07">07</option><option value="08">08</option><option value="09">09</option><option value="10">10</option><option value="11">11</option><option value="12">12</option><option value="13">13</option><option value="14">14</option><option value="15">15</option><option value="16">16</option><option value="17">17</option><option value="18">18</option><option value="19">19</option><option value="20">20</option><option value="21">21</option><option value="22">22</option><option value="23" selected="">23</option><option value="24">24</option><option value="25">25</option><option value="26">26</option><option value="27">27</option><option value="28">28</option><option value="29">29</option><option value="30">30</option><option value="31">31</option></select>&nbsp;&nbsp;<select name="dob_year" id="year"><option value="1900">1900</option><option value="1901">1901</option><option value="1902">1902</option><option value="1903">1903</option><option value="1904">1904</option><option value="1905">1905</option><option value="1906">1906</option><option value="1907">1907</option><option value="1908">1908</option><option value="1909">1909</option><option value="1910">1910</option><option value="1911">1911</option><option value="1912">1912</option><option value="1913">1913</option><option value="1914">1914</option><option value="1915">1915</option><option value="1916">1916</option><option value="1917">1917</option><option value="1918">1918</option><option value="1919">1919</option><option value="1920">1920</option><option value="1921">1921</option><option value="1922">1922</option><option value="1923">1923</option><option value="1924">1924</option><option value="1925">1925</option><option value="1926">1926</option><option value="1927">1927</option><option value="1928">1928</option><option value="1929">1929</option><option value="1930">1930</option><option value="1931">1931</option><option value="1932">1932</option><option value="1933">1933</option><option value="1934">1934</option><option value="1935">1935</option><option value="1936">1936</option><option value="1937">1937</option><option value="1938">1938</option><option value="1939">1939</option><option value="1940">1940</option><option value="1941">1941</option><option value="1942">1942</option><option value="1943">1943</option><option value="1944">1944</option><option value="1945">1945</option><option value="1946">1946</option><option value="1947">1947</option><option value="1948">1948</option><option value="1949">1949</option><option value="1950">1950</option><option value="1951">1951</option><option value="1952">1952</option><option value="1953">1953</option><option value="1954">1954</option><option value="1955">1955</option><option value="1956">1956</option><option value="1957">1957</option><option value="1958">1958</option><option value="1959">1959</option><option value="1960">1960</option><option value="1961">1961</option><option value="1962">1962</option><option value="1963">1963</option><option value="1964">1964</option><option value="1965">1965</option><option value="1966">1966</option><option value="1967">1967</option><option value="1968">1968</option><option value="1969">1969</option><option value="1970">1970</option><option value="1971">1971</option><option value="1972">1972</option><option value="1973">1973</option><option value="1974">1974</option><option value="1975">1975</option><option value="1976">1976</option><option value="1977">1977</option><option value="1978">1978</option><option value="1979">1979</option><option value="1980">1980</option><option value="1981">1981</option><option value="1982">1982</option><option value="1983">1983</option><option value="1984">1984</option><option value="1985">1985</option><option value="1986">1986</option><option value="1987">1987</option><option value="1988">1988</option><option value="1989" selected="">1989</option><option value="1990">1990</option><option value="1991">1991</option><option value="1992">1992</option><option value="1993">1993</option><option value="1994">1994</option><option value="1995">1995</option><option value="1996">1996</option><option value="1997">1997</option><option value="1998">1998</option><option value="1999">1999</option><option value="2000">2000</option><option value="2001">2001</option><option value="2002">2002</option><option value="2003">2003</option><option value="2004">2004</option><option value="2005">2005</option><option value="2006">2006</option><option value="2007">2007</option><option value="2008">2008</option><option value="2009">2009</option><option value="2010">2010</option></select></td>
<td style="width:380px;"><div id="dob_message"></div>&nbsp;</td>
</tr>
<tr style="height:45px;" valign="top">
</tr>
  <tr><td colspan="3"><a name="ba"></a><div class="breakLine"></div></td></tr>
 
<tr>
  <td colspan="3" style="font-weight:bold">ADDRESS</td></tr>
          <tr><td colspan="3"><div class="breakLine"></div></td></tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">Address1:&nbsp;</td>
<td style="width:220px;">
<input type="text" name="edit_profile_billing_address1" id="billing_address1">&nbsp;*</td>
</tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">Address2:&nbsp;</td>
<td style="width:220px;">
<input type="text" name="edit_profile_billing_address2" id="billing_address2">&nbsp;*</td>
</tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">City:</td>
<td style="width:220px;">
<input type="text" name="edit_profile_billing_city" id="billing_city">&nbsp;*</td>
</tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">Zip/Post Code:</td>
<td style="width:220px;">
<input type="text" name="edit_profile_billing_postcode" id="billing_postcode">&nbsp;*</td>
</tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">Country:</td>
<td style="width:220px;">
<select name="edit_profile_billing_country" style="width:150px;" id="billing_country"><option value="1">Afghanistan</option><option value="2">Albania</option><option value="3">Algeria</option><option value="4">American Samoa</option><option value="5">Andorra</option><option value="6">Angola</option><option value="7">Anguilla</option><option value="8">Antarctica</option><option value="9">Antigua and Barbuda</option><option value="10">Argentina</option><option value="11">Armenia</option><option value="12">Aruba</option><option value="13">Australia</option><option value="14">Austria</option><option value="15">Azerbaijan</option><option value="16">Bahamas</option><option value="17">Bahrain</option><option value="18">Bangladesh</option><option value="19">Barbados</option><option value="20">Belarus</option><option value="21">Belgium</option><option value="22">Belize</option><option value="23">Benin</option><option value="24">Bermuda</option><option value="25">Bhutan</option><option value="26">Bolivia</option><option value="27">Bosnia and Herzegovina</option><option value="28">Botswana</option><option value="29">Bouvet Island</option><option value="30">Brazil</option><option value="31">British Indian Ocean Territory</option><option value="32">Brunei Darussalam</option><option value="33">Bulgaria</option><option value="34">Burkina Faso</option><option value="35">Burundi</option><option value="36">Cambodia</option><option value="37">Cameroon</option><option value="38">Canada</option><option value="39">Cape Verde</option><option value="40">Cayman Islands</option><option value="41">Central African Republic</option><option value="42">Chad</option><option value="43">Chile</option><option value="44">China</option><option value="45">Christmas Island</option><option value="46">Cocos (Keeling) Islands</option><option value="47">Colombia</option><option value="48">Comoros</option><option value="49">Congo</option><option value="50">Cook Islands</option><option value="51">Costa Rica</option><option value="52">Cote D'Ivoire</option><option value="53">Croatia</option><option value="54">Cuba</option><option value="55">Cyprus</option><option value="56">Czech Republic</option><option value="57" selected="">Denmark</option><option value="58">Djibouti</option><option value="59">Dominica</option><option value="60">Dominican Republic</option><option value="61">East Timor</option><option value="62">Ecuador</option><option value="63">Egypt</option><option value="64">El Salvador</option><option value="65">Equatorial Guinea</option><option value="66">Eritrea</option><option value="67">Estonia</option><option value="68">Ethiopia</option><option value="69">Falkland Islands (Malvinas)</option><option value="70">Faroe Islands</option><option value="71">Fiji</option><option value="72">Finland</option><option value="73">France</option><option value="74">France, Metropolitan</option><option value="75">French Guiana</option><option value="76">French Polynesia</option><option value="77">French Southern Territories</option><option value="78">Gabon</option><option value="79">Gambia</option><option value="80">Georgia</option><option value="81">Germany</option><option value="82">Ghana</option><option value="83">Gibraltar</option><option value="84">Greece</option><option value="85">Greenland</option><option value="86">Grenada</option><option value="87">Guadeloupe</option><option value="88">Guam</option><option value="89">Guatemala</option><option value="242">Guernsey</option><option value="90">Guinea</option><option value="91">Guinea-bissau</option><option value="92">Guyana</option><option value="93">Haiti</option><option value="94">Heard and Mc Donald Islands</option><option value="95">Honduras</option><option value="96">Hong Kong</option><option value="97">Hungary</option><option value="98">Iceland</option><option value="99">India</option><option value="100">Indonesia</option><option value="101">Iran (Islamic Republic of)</option><option value="102">Iraq</option><option value="103">Ireland</option><option value="104">Israel</option><option value="105">Italy</option><option value="106">Jamaica</option><option value="107">Japan</option><option value="108">Jordan</option><option value="109">Kazakhstan</option><option value="110">Kenya</option><option value="111">Kiribati</option><option value="112">Korea, Democratic People's Republic of</option><option value="113">Korea, Republic of</option><option value="114">Kuwait</option><option value="115">Kyrgyzstan</option><option value="116">Lao People's Democratic Republic</option><option value="117">Latvia</option><option value="118">Lebanon</option><option value="119">Lesotho</option><option value="120">Liberia</option><option value="121">Libyan Arab Jamahiriya</option><option value="122">Liechtenstein</option><option value="123">Lithuania</option><option value="124">Luxembourg</option><option value="125">Macau</option><option value="126">Macedonia, The Former Yugoslav Republic of</option><option value="127">Madagascar</option><option value="128">Malawi</option><option value="129">Malaysia</option><option value="130">Maldives</option><option value="131">Mali</option><option value="132">Malta</option><option value="133">Marshall Islands</option><option value="134">Martinique</option><option value="135">Mauritania</option><option value="136">Mauritius</option><option value="137">Mayotte</option><option value="138">Mexico</option><option value="139">Micronesia, Federated States of</option><option value="140">Moldova, Republic of</option><option value="141">Monaco</option><option value="142">Mongolia</option><option value="241">Montenegro</option><option value="143">Montserrat</option><option value="144">Morocco</option><option value="145">Mozambique</option><option value="146">Myanmar</option><option value="147">Namibia</option><option value="148">Nauru</option><option value="149">Nepal</option><option value="150">Netherlands</option><option value="151">Netherlands Antilles</option><option value="152">New Caledonia</option><option value="153">New Zealand</option><option value="154">Nicaragua</option><option value="155">Niger</option><option value="156">Nigeria</option><option value="157">Niue</option><option value="158">Norfolk Island</option><option value="159">Northern Mariana Islands</option><option value="160">Norway</option><option value="161">Oman</option><option value="162">Pakistan</option><option value="163">Palau</option><option value="164">Panama</option><option value="165">Papua New Guinea</option><option value="166">Paraguay</option><option value="167">Peru</option><option value="168">Philippines</option><option value="169">Pitcairn</option><option value="170">Poland</option><option value="171">Portugal</option><option value="172">Puerto Rico</option><option value="173">Qatar</option><option value="174">Reunion</option><option value="175">Romania</option><option value="176">Russian Federation</option><option value="177">Rwanda</option><option value="178">Saint Kitts and Nevis</option><option value="179">Saint Lucia</option><option value="180">Saint Vincent and the Grenadines</option><option value="181">Samoa</option><option value="182">San Marino</option><option value="183">Sao Tome and Principe</option><option value="184">Saudi Arabia</option><option value="185">Senegal</option><option value="240">Serbia</option><option value="186">Seychelles</option><option value="187">Sierra Leone</option><option value="188">Singapore</option><option value="189">Slovakia (Slovak Republic)</option><option value="190">Slovenia</option><option value="191">Solomon Islands</option><option value="192">Somalia</option><option value="193">South Africa</option><option value="194">South Georgia and the South Sandwich Islands</option><option value="195">Spain</option><option value="196">Sri Lanka</option><option value="197">St. Helena</option><option value="198">St. Pierre and Miquelon</option><option value="199">Sudan</option><option value="200">Suriname</option><option value="201">Svalbard and Jan Mayen Islands</option><option value="202">Swaziland</option><option value="203">Sweden</option><option value="204">Switzerland</option><option value="205">Syrian Arab Republic</option><option value="206">Taiwan</option><option value="207">Tajikistan</option><option value="208">Tanzania, United Republic of</option><option value="209">Thailand</option><option value="210">Togo</option><option value="211">Tokelau</option><option value="212">Tonga</option><option value="213">Trinidad and Tobago</option><option value="214">Tunisia</option><option value="215">Turkey</option><option value="216">Turkmenistan</option><option value="217">Turks and Caicos Islands</option><option value="218">Tuvalu</option><option value="219">Uganda</option><option value="220">Ukraine</option><option value="221">United Arab Emirates</option><option value="222">United Kingdom</option><option value="223">United States</option><option value="224">United States Minor Outlying Islands</option><option value="225">Uruguay</option><option value="226">Uzbekistan</option><option value="227">Vanuatu</option><option value="228">Vatican City State (Holy See)</option><option value="229">Venezuela</option><option value="230">Vietnam</option><option value="231">Virgin Islands (British)</option><option value="232">Virgin Islands (U.S.)</option><option value="233">Wallis and Futuna Islands</option><option value="234">Western Sahara</option><option value="235">Yemen</option><option value="237">Zaire</option><option value="238">Zambia</option><option value="239">Zimbabwe</option></select> </td>
<td style="width:380px;"><div id="billing_country_message"></div>&nbsp;</td>
</tr>
<tr style="height:45px;" valign="top">
<td style="width:120px;">State/Province:</td>
<td style="width:220px;">
<span id="state_div" style="float:left;">
<label for="state_province"></label>
  <input type="text" name="state_province" id="state_province">&nbsp;*</span></td>


</tr>
   
<tr valign="top">
<td colspan="3" style="width:100%;">
<div class="breakLine"><!-- --></div>
<div class="dottedLine"><!-- --></div>
<div class="breakLine"><!-- --></div>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>


</tbody></table>
<div class="breakLine"><!-- --></div>
  </td>
</tr>
  <tr><td colspan="3"><div class="dottedLine">&nbsp;</div></td></tr>
  <!--tr><td colspan="3"><div class="breakLine"></div></td></tr-->
 
  <tr>
  <td colspan="3">
<div style="height:66px; display: block;">
<div style="float:left; width:50px; display: inline-block;">

<div class="loginBoxLink"<a href="#"><a href="index.php"><img src="images/buttoms/button_back.gif" border="0" width="51" height="17" longdesc="index.php" /></a></div>
</div>
<div style="float:right;">
        <INPUT TYPE="image" SRC="images/buttoms/button_update.gif" HEIGHT="17" WIDTH="66" BORDER="0" ALT="Submit Form">
        </div>
        </div>
</td>
</tr>
  </tbody></table>
  </td>
  </tr>
</tbody></table>
</form>
</div>
<div class="break_line"></div>


</div>
     <?php
}
}
} else {
// If user is not logged in and opens edit page output that he must be logged in
echo "You must be logged in to edit profile";
}
?>               
                   


</body>
</html>


update.php
Code: [Select]
<?php
// Start session
session_start();
if($_SESSION['s_logged_n'] == 'true'){
// Define $username
$username = $_SESSION['s_username'];
$new_user_mail = $_POST["e_mail_address"];
$year = $_POST["year"];
$day = $_POST["day"];
$month = $_POST["month"];
$state_province = $_POST["state_province"];
$billing_postcode = $_POST["billing_postcode"];
$billing_country = $_POST["billing_country"];
$billing_city = $_POST["billing_city"];
$billing_address2 = $_POST["billing_address2"];
$billing_address1 = $_POST["billing_address1"];
$edit_profile_gender = $_POST["edit_profile_gender"];
$lastname = $_POST["lastname"];
$contact_number = $_POST["contact_number"];
$country = $_POST["country"];
$firstname = $_POST["firstname"];
// Check if form button update has been pressed
if(isset($_POST['update'])){
// Get the id
$id = $_GET['id'];
// Include config file
include "config.php";
// Add slashes and trim password
$password = addslashes(trim($password));
$password_confirm = addslashes(trim($password_confirm));
// Check if passwords match each other
if ($password == $password_confirm){
// If they do then do md5 hash on it
$password = md5($password);
// Query users table
$query = "UPDATE users SET password = '$password', email = '$new_user_mail', dateofbirth = '$month$day$year', first_name = '$firstname', last_name = '$lastname', country_code = '$billing_postcode', contact_cumber = '$contact_number', gender = '$edit_profile_gender', address_1 = '$billing_address1', address_2 = '$billing_address2', city = '$country', zip_post_code = '$billing_postcode', country = '$country', state_province = '$state_province' WHERE user_id = '$id' AND username = '$username' LIMIT 1";
$result = mysql_query($query);
// If it was successfull change of pass then output it
if($result){
echo "You have successfully edited your password";
} else {
// Else output error
echo "There was an error editing your password";
}
} else {
// If passwords don't match each other say so
echo "Your passwords don't match each other";
}
}
} else {
// If someone just try to open file then stop them
echo "You must be logged in to access this area";
}
?>

mysql database

table: users
Code: [Select]

username email password date ip actkey activated user_id points first_name last_name country_code contact_cumber gender dateofbirth address_1 address_2 city zip_post_code country state_province


so if some one please give me a hit or help to get it done thanks

create table mimi (mimiId int(11) not null, mimiBody varchar(255) );
<?php
//connecting to database
include_once ('conn.php');
$sql ="SELECT mimiId, mimiBody FROM mimi";

$result = mysqli_query($conn, $sql );

$mimi = mysqli_fetch_assoc($result);

$mimiId ='<span>No: '.$mimi['mimiId'].'</span>';

$mimiBody ='<p class="leading text-justify">'.$mimi['mimiBody'].'</p>';
?>
//what is next?

i want to download pdf or text document after clicking button or link how to do that

Hello,

I need some help. Say that I have a list in my MySQL database that contains elements "A", "S", "C", "D" etc... Now, I want to generate an html table where these elements should be distributed in a random and unique way while leaving some entries of the table empty, see the picture below. But, I have no clue how to do this... Any hints?



Thanks in advance,
Vero

Hello everyone,

Sorry if this has been answered but if it has I can't find it anywhere. So, from the begining then.  Lets say I had a member table and in it I wanted to store what their top 3 interests are.  Their$ row has all the usual things to identify them userID and password etc.. and I had a further 3 columns which were labled top3_1 top3_2 & top3_3 to put each of their interests in from a post form.

If instead I wanted to store this data as a PHP Array instead (using 1 column instead of 3) is there a way to store it as readable data when you open the PHPmyadmin?

At the moment all it says is array and when I call it back to the browser (say on a page where they could review and update their interests) it displays 'a' as top3_01 'r' as top3_02 and 'r' as top3_03 (in each putting what would be 'array' as it appears in the table if there were 5 results. Does anyone know what I mean?

For example -

If we had a form which collected the top 3 interests to put in a table called users,

Code: [Select]
<form action="back_to_same_page_for_processing.php" method="post" enctype="multipart/form-data">
   
    <input name="top3_01" type="text" value="enter interest number 1 here" />
    <input name="top3_02" type="text" value="enter interest number 2 here" />
    <input name="top3_03" type="text" value="enter interest number 3 here" />
    <input type="submit" name="update_button" value=" Save and Update! " />

   
    </form> // If my quick code example for this form is not correct dont worry its not the point im getting at :)
And they put 'bowling' in top3_01, 'running' in top3_02 and 'diving' in top3_03 and we catch that on the same page with some PHP at the top -->

Code: [Select]
        if (isset($_POST)['update_button']) {
   
    $top3_01 = $_POST['top3_01']; // i.e, 'bowling' changing POST vars to local vars
    $top3_02 = $_POST['top3_02']; // i.e, 'running'
    $top3_03 = $_POST['top3_03']; // i.e, 'diving'

With me so far? If I had a table which had 3 columns (1 for each interest) I could put something like -

  Code: [Select]
   include('connect_msql.php');
   
    mysql_query("Select * FROM users WHERE id='$id' AND blah blah blah");
   
    mysql_query("UPDATE users SET top3_01='$top3_01', top3_02='$top3_02', top3_03='$top3_03' WHERE id='$id'");


And hopefully if ive got it right, it will put them each in their own little column. Easy enough huh? But heres the thing, I want to put all these into an array to be stored in the 1 column (say called 'top3') and whats more have them clearly readable in PHPmyadmin and editable from there yet still be able to be called back an rendered on page when requested.

Continuing the example then, assuming ive changed the table for the 'top3' column instead of individual colums,  I could put something like this -


Code: [Select]
            if (isset($_POST)['update_button']) {
       
        $top3_01 = $_POST['top3_01']; // i.e, 'bowling' changing POST vars to local vars
        $top3_02 = $_POST['top3_02']; // i.e, 'running'
        $top3_03 = $_POST['top3_03']; // i.e, 'diving'
   
    $top3_array = array($top3_01,$top3_02,$top3_03);
   
    include('connect_msql.php');
   
    mysql_query("UPDATE members SET top3='$top3_array' WHERE id='$id' AND blah blah blah");
But it will appear in the column as 'Array' and when its called for using a query it will render the literal string. a r r in each field instead.  Now I know you can use the 'serialize()' & 'unserialize()' funtcions but it makes the entry in the database practically unreadable. Is there a way to make it readable and editable without having to create a content management system?

If so please let me know and I'll be your friend forever, lol, ok maybe not but I'd really appreciate the help anyways.  The other thing is, If you can do this or something like it, how am I to add entries to that array to go back into the data base?

I hope ive explained myself enough here, but if not say so and I'll have another go.  Thanks very much people,  L-PLate (P.s if I sort this out on my own ill post it all here)