I'm working with a client and setting up this form for them. I'm trying to have the user be able to add a new name and email record into the account table. Once they submit it should display the 10 newest records below the form. Appreciate any help.
class account{
function account(){
$this->id = ' ';
$this->name = '';
$this->email = '';
}
function find_account($id){
$sql="select `id` from `account` where `id`='".$id."'";
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
Custom PHP Code - I'm stuck
in PHP Coding Help
Posted
I'm working with a client and setting up this form for them. I'm trying to have the user be able to add a new name and email record into the account table. Once they submit it should display the 10 newest records below the form. Appreciate any help.
class account{
function account(){
$this->id = ' ';
$this->name = '';
$this->email = '';
}
function find_account($id){
$sql="select `id` from `account` where `id`='".$id."'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$row['id']; //int pk auto incerment
$row['name']; //varchar(50)
$row['email']; //varchar(50)
$row['timestamp']; //varchar(15)
}
}
}
<html>
<body>
<div>
<form action='#'>
name: <input type='text' name='account_name'>
email:<input type='text' id='account_email'>
<input type="button" value="submit">
</form>
</div>
<div style="border:solid 1px #F60;">
Last 10 entry:
</div>
<div style="border:solid 1px #000;">
<?php echo "id: ".$account->id;?>
<?php echo "name: ".$account->name;?>
<?php echo "email: ".$account->email;?>
</div>
</body>
</html>