<?php
    session_start();
	
	$hostName = "localhost";
    $dbName = "areos124_tivuhDB";
    $dbPassword = "1123581321";
    $dbUser = "areos124_arik";
	$options = array( PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8' );
	
	$connectDB = new PDO("mysql:host=$hostName;dbname=$dbName", $dbUser, $dbPassword, $options);
	
	$stmt = $connectDB->prepare("INSERT INTO general_table (data_create, category, city) VALUES (:data, :category, :city)");
    $stmt->bindParam(':data', $create_data);
    $stmt->bindParam(':category', $category);
    $stmt->bindParam(':city', $city);

   	$create_data = date("Y-m-d H:i:s");
	$category = $_POST["category"];
	$city = $_POST["city"];
	
    $stmt->execute();
	
	
	$stmt = $connectDB->prepare("INSERT INTO  texts_table (title_text, main_text) VALUES (:title_text, :main_text)");
    $stmt->bindParam(':title_text', $title_text);
    $stmt->bindParam(':main_text', $main_text);
 
    $title_text = $_POST["title"];
	$main_text = $_POST["bodyText"];
	
    $stmt->execute();
	
	
	$stmt = $connectDB->prepare("INSERT INTO options_table (furniture, space, boiler, mamad, parking, lift, partners, arnona, vaad_bait) VALUES (:furniture, :space, :boiler, :mamad, :parking, :lift, :partners, :arnona, :vaad_bait)");
    $stmt->bindParam(':furniture', $furniture);
    $stmt->bindParam(':space', $space);
	$stmt->bindParam(':boiler', $boiler);
    $stmt->bindParam(':mamad', $mamad);
	$stmt->bindParam(':parking', $parking);
    $stmt->bindParam(':lift', $lift);
	$stmt->bindParam(':partners', $partners);
	$stmt->bindParam(':arnona', $arnona);
	$stmt->bindParam(':vaad_bait', $vaad_bait);
 
    $furniture = $_POST["furniture"];
	$space = $_POST["place"];
	$boiler = $_POST["boiler"];
	$mamad = $_POST["mamad"];
	$parking = $_POST["parking"];
	$lift = $_POST["lift"];
	$partners = $_POST["cammon"];
	$arnona = $_POST["arnona"];
	$vaad_bait = $_POST["vaad_bait"];
	 
    $stmt->execute();
	
	
	$stmt = $connectDB->prepare("INSERT INTO properties_table (rooms, level, total_level, free_time, price, age) VALUES (:rooms, :level, :total_level, :free_time, :price, :age)");
    $stmt->bindParam(':rooms', $rooms);
    $stmt->bindParam(':level', $float);
	$stmt->bindParam(':total_level', $total_float);
    $stmt->bindParam(':free_time', $free_time);
	$stmt->bindParam(':price', $price);
    $stmt->bindParam(':age', $age);
 
    $rooms = $_POST["rooms"];
	$float = $_POST["c_float"];
	$total_float = $_POST["t_float"];
	$free_time = $_POST["free_time"];
	$price = $_POST["price"];
	$age = $_POST["age"];
	 
    $stmt->execute();
?>