I need help

[gudfry]

hi all;

 

      I have a class function to perform the insertion of data into database, but this not work. please help.

 

      here is my code that I found in the internet. this not working, i try already.

       

     

require_once('connect.php');

 

class email {

 

        var $mail_id;   // hotel id in emailRecord Auto_increment.

var $name;   // hotel name in emailRecord.

var $email;      // hotel email id.

var $phone;   // hotel contact number in emailRecord.

var $senderName;  // Guest name.

var $guestPhone;  // Guest Phone number.

var $guestEmail;  // Guest email id.

var $subject;    // Guest title.

var $message;    // Guest message.

 

    function setName($name) {

 

        $this->name = $name;

    }

    function setEmail($email) {

 

        $this->email = $email;

    }

    function setPhone($phone) {

 

        $this->phone = $phone;

    }

    function setsenderName($senderName) {

 

        $this->senderName = $senderName;

    }

function setguestPhone($guestPhone) {

 

        $this->guestPhone = $guestPhone;

    }

function setguestEmail($guestEmail) {

 

        $this->guestEmail = $guestEmail;

    }

function setsubject($subject) {

 

        $this->subject = $subject;

    }

   

function setmessage($message) {

 

        $this->message = $message;

    }

}

class stored {

 

function storedRecord($data) {

 

$sql = "insert into emailrecord (name, phone, senderName, guestEmail, guestPhone, subject, message) values

($data->name, $data->phone, $data->senderName, $data->guestEmail, $data->guestPhone, $data->subject, $data->message)";

 

echo $sql;

     

    }

}

?>

 

Thanks to all

[waynew]

Do you have a connect.php file?

What are the errors?

[gudfry]

yes i ahve, there is no error display,

[JasonLewis]

Where do you define the classes? Where do you call the functions inside the classes? All I can see is the actual classes, with no call to them.

[gudfry]

this is i defined my classes nad call my function;

 

here is the whole code;

 

$name = $_POST['name'];

$phone = $_POST['phone'];

$email = $_POST['email'];

$senderName = $_POST['senderName'];

$guestEmail = $_POST['guestEmail'];

$guestPhone = $_POST['guestPhone'];

$subject = $_POST['subject'];

$message = $_POST['message'];

 

require_once('classEmail.php');

include('connect.php');

 

 

$input = new request();

$input->setName($name);

$input->setEmail($email);

$input->setPhone($phone);

$input->setsenderName($senderName);

$input->setguestPhone($guestPhone);

$input->setguestEmail($guestEmail);

$input->setsubject($subject);

$input->setmessage($message);

 

 

$stored = new stored();

$stored->storedRecord($input);

 

 

        var $mail_id;   // hotel id in emailRecord Auto_increment.

var $name;   // hotel name in emailRecord.

var $email;      // hotel email id.

var $phone;   // hotel contact number in emailRecord.

var $senderName;  // Guest name.

var $guestPhone;  // Guest Phone number.

var $guestEmail;  // Guest email id.

var $subject;    // Guest title.

var $message;    // Guest message.

 

    function setName($name) {

 

        $this->name = $name;

    }

    function setEmail($email) {

 

        $this->email = $email;

    }

    function setPhone($phone) {

 

        $this->phone = $phone;

    }

    function setsenderName($senderName) {

 

        $this->senderName = $senderName;

    }

function setguestPhone($guestPhone) {

 

        $this->guestPhone = $guestPhone;

    }

function setguestEmail($guestEmail) {

 

        $this->guestEmail = $guestEmail;

    }

function setsubject($subject) {

 

        $this->subject = $subject;

    }

function setmessage($message) {

 

        $this->message = $message;

    }

}

class stored {

 

function storedRecord($data) {

 

$sql = "insert into emailrecord (name, phone, senderName, guestEmail, guestPhone, subject, message)

values

('$data->name', '$data->phone', '$data->senderName', '$data->guestEmail', '.$data->guestPhone', '$data->subject', '$data->message')" or die("Query failed : " . mysql_error());

 

echo $sql;

     

    }

}

 

hope everybody get the point

[JasonLewis]

Well your not actually calling mysql_query() anywhere. And I don't see why you need two classes for this. You could easily make it one.