<?php

	require_once("leerArchivo.php");
	require_once("defaultConfig.php");

	$fdp_database = "";

	function fdp_check_db($db)
	{
		return isset($db) && is_resource($db) && get_resource_type($db) === "mysql link";
	}

	function fdp_connect($config_file = false) 
	{
		global $defaultConfigFile;
		global $fdp_database;

		if(!isset($config_file) || !$config_file) {
			$config_file = $defaultConfigFile;
		}

		if(!fdp_check_db($fdp_database) && isset($config_file))
		{
			$config = fdp_read_config_file($config_file);
		
			$address = $config["address"];
			$user = $config["user"];
			$pass = $config["pass"];
			$database = $config["database"];

			$fdp_database = mysqli_connect($address, $user, $pass, $database);
			if(!$fdp_database) {
				echo "Connection error: " . mysqli_connect_error();
				exit;
			}
		}
		return $fdp_database;
	}

	function fdp_query($db, $sql) {
		$query = mysqli_query($db, $sql);
		if(!$query) {
			echo mysqli_error($db);
			return false;
		}
		return $query;
	}

	function fdp_query_all($db, $sql, $type = MYSQLI_NUM) {
		$query = fdp_query($db, $sql);
		$res = mysqli_fetch_all($query, $type);
		if(!$res) {
			echo mysqli_error($db);
			return false;
		}
		return $res;
	}

	function fdp_query_row($db, $sql, $row, $type = MYSQLI_NUM) {
		$results = fdp_query_all($db, $sql, $type);
		//echo $results[$row];
		//echo var_export($results);
		if(!$results[$row]) {
			return false;
		}
		else {
			return $results[$row];
		}
	}

	function fdp_query_cell($db, $sql, $row, $col, $type = MYSQLI_NUM) {
		$results = fdp_query_row($db, $sql, $row, $type);
		if(!$results[$col]) {
			return false;
		}
		else {
			return $results[$col];
		}
	}

?>