insert function

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
gautamz07
Forum Contributor
Posts: 331
Joined: Wed May 14, 2014 12:18 pm

insert function

Post by gautamz07 »

I donot understand this insert function at all , can somebody really please explain this to me ??

Code: Select all

	public function insert($data, $table) {
		
		$columns = "";
		$values = "";
		
		foreach ($data as $column => $value) {
			$columns .= ($columns == "") ? "" : ", ";
			$columns .= $column;
			$values .= ($values == "") ? "" : ", ";
			$values .= $value;
		}
		
		$sql = "insert into $table ($columns) values ($values)";
				
		mysql_query($sql) or die(mysql_error());
		
		//return the ID of the user in the database.
		return mysql_insert_id();
		
	}
:banghead: .

Thanks .
pbs
Forum Contributor
Posts: 230
Joined: Fri Nov 07, 2008 5:31 am
Location: Nashik, India
Contact:

Re: insert function

Post by pbs »

this insert function is used to insert data in database table, it accepts two parameters,
first the data, in array format with array key as table column name and value as column value and
second parameter is table name to which you want to insert data
Post Reply