DaniWeb Forum Index > Web Development > PHP

insert into database problem

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jul 2008

Posts: 39

Reputation: god_1896 is an unknown quantity at this point

Solved Threads: 0

god_1896

Offline

Light Poster

insert into database problem

Aug 11th, 2008

hi all;

I create a php classes to insert my data into database, but it doest work, please help me with this. here is my whole code.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
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 email() {
 
			$this->mail_id = $mail_id;
			$this->name = $name;
			$this->phone = $phone;
			$this->senderName = $senderName;
			$this->guestPhone = $guestPhone;
			$this->guestEmail = $guestEmail;
			$this->subject = $subject;
			$this->message = $message;
	}
	function storedRecord($mail_id, $name, $phone, $senderName, $guestEmail, $guestPhone, $subject, $message) {
 
			$sql="INSERT INTO emailrecord (name, phone, senderName, guestEmail, guestPhone, subject, message) 
				  VALUES ('$name', '$phone', '$senderName', '$guestEmail', '$guestPhone', '$subject', '$message')";
			echo $sql;
		}
	}
?>
<?php
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 email() {
		
			$this->mail_id = $mail_id;
			$this->name = $name;
			$this->phone = $phone;
			$this->senderName = $senderName;
			$this->guestPhone = $guestPhone;
			$this->guestEmail = $guestEmail;
			$this->subject = $subject;
			$this->message = $message;
	}
	function storedRecord($mail_id, $name, $phone, $senderName, $guestEmail, $guestPhone, $subject, $message) {
			
			$sql="INSERT INTO emailrecord (name, phone, senderName, guestEmail, guestPhone, subject, message) 
				  VALUES ('$name', '$phone', '$senderName', '$guestEmail', '$guestPhone', '$subject', '$message')";
			echo $sql;
		}
	}
?>

•

Join Date: Aug 2007

Posts: 791

Reputation: darkagn has a spectacular aura about

Solved Threads: 109

darkagn

Offline

Master Poster

Re: insert into database problem

Aug 11th, 2008

The only thing I can see wrong with your sql statement is that you don't need single quotes around your variables. But I wouldn't think that would cause an error. What happens when you call the storedRecord function? (It should just print the sql statement to the screen, but what is being printed?)

There are no stupid questions, only those too stupid to ask for help.
echo is a web developer's best friend.

•

Join Date: Mar 2008

Posts: 145

Reputation: queenc is an unknown quantity at this point

Solved Threads: 4

queenc

Offline

Junior Poster

Re: insert into database problem

Aug 11th, 2008

Help with Code Tags

(Toggle Plain Text)

	 mysql_query("INSERT INTO emailrecord (name, phone, senderName, guestEmail, guestPhone, subject, message) 
	VALUES ('$name', '$phone', '$senderName', '$guestEmail', '$guestPhone', '$subject', '$message')") or die("ERROR:".mysql_error());

•

Join Date: Aug 2008

Posts: 48

Reputation: Demiloy is an unknown quantity at this point

Solved Threads: 4

Demiloy

Offline

Light Poster

Re: insert into database problem

Aug 11th, 2008

Ok...

1. When you do "$this->mail_id = $mail_id;", you're referencing the same thing. $this->mail_id is used inside functions to reference the variables in the parent class. So, basically, your email() function is unneeded.

2. Also, if all you're doing is echoing your query, and not using mysql_query, then obviously you're not going to be doing any action is your database.

I think a much simpler way to do this, without classes, is:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
function storedRecord($mail_id, $name, $phone, $senderName, $guestEmail, $guestPhone, $subject, $message) {
 
			$sql="INSERT INTO emailrecord (name, phone, senderName, guestEmail, guestPhone, subject, message) 
				  VALUES ('$name', '$phone', '$senderName', '$guestEmail', '$guestPhone', '$subject', '$message')";
			$result = mysql_query($sql) or die(mysql_error());
 
return $result;
		}
function storedRecord($mail_id, $name, $phone, $senderName, $guestEmail, $guestPhone, $subject, $message) {
			
			$sql="INSERT INTO emailrecord (name, phone, senderName, guestEmail, guestPhone, subject, message) 
				  VALUES ('$name', '$phone', '$senderName', '$guestEmail', '$guestPhone', '$subject', '$message')";
			$result = mysql_query($sql) or die(mysql_error());

return $result;
		}

Last edited by Demiloy; Aug 11th, 2008 at 6:31 am.

•

Join Date: Jul 2008

Posts: 39

Reputation: god_1896 is an unknown quantity at this point

Solved Threads: 0

god_1896

Offline

Light Poster

Re: insert into database problem

Aug 11th, 2008

well thanks, but the requirement that i need to fullfil is must be a classes, thank any i try code.

•

Join Date: Jul 2008

Posts: 39

Reputation: god_1896 is an unknown quantity at this point

Solved Threads: 0

god_1896

Offline

Light Poster

Re: insert into database problem

Aug 11th, 2008

hi, well, there is no error after i click the submmit button;

•

Join Date: Jul 2008

Posts: 39

Reputation: god_1896 is an unknown quantity at this point

Solved Threads: 0

god_1896

Offline

Light Poster

Re: insert into database problem

Aug 12th, 2008

hi all;

thanks alot for all the replies, I finnaly solve ny problem, here is the whole code, actually I made a changes and add the line of code. hope this code will be more perfect as challenge.

class request {

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.

// this get the data

function store($input) {

// this will perform an insertion

$sql = "insert into emailrecord (name, phone, senderName, guestEmail, guestPhone, subject, message)
values
('$input->name', '$input->phone', '$input->senderName', '$input->guestEmail', '$input->guestPhone', '$input->subject', '$input->message')";

$result = mysql_query($sql);

}
}