Ubuntu.pl 🇺🇦️ - Forum Ubuntu

Kod: Zaznacz cały

<?php
require_once("config.php"); /* Configuration File */

class DB{
	
	private $link;
	
	public function __construct(){
		$this->link = mysqli_connect(DB_SERVER, DB_USER, DB_PASS,DB_NAME);
		if (mysqli_connect_errno())
		    exit();
	}
	
	public function __destruct() {
		mysqli_close($this->link);
	}
	
	public function dbNewMessage($email,$name,$telefon,$website,$message){
		$email 	 	= mysqli_real_escape_string($this->link,$email);
		$name 		= mysqli_real_escape_string($this->link,$name);
		$telefon 	= mysqli_real_escape_string($this->link,$telefon);
		$website 	= mysqli_real_escape_string($this->link,$website);
		$message 	= mysqli_real_escape_string($this->link,$message);
		
		mysqli_autocommit($this->link,FALSE);
		
		$query = "INSERT INTO CONTACT(pk_contact,name,email,telefon,website,message) 
				  VALUES('NULL','$name','$email','$telefon','$website','$message')";
		mysqli_query($this->link,$query);
		
		if(mysqli_errno($this->link))
			return -1;
		else{
			mysqli_commit($this->link);
			return 1;
		}
	}   
};
?>

Kod: Zaznacz cały

	public function __construct(){
		$this->link = mysqli_connect(DB_SERVER, DB_USER, DB_PASS,DB_NAME);
		if (mysqli_connect_errno()){
		    exit();
                }
                else{
                 mysql_query ($this->link,'SET character_set_connection=utf8');
                 mysql_query ($this->link,'SET character_set_client=utf8');
                 mysql_query ($this->link,'SET character_set_results=utf8'); 
                }

	}