File "create_table.php"

Full Path: /home/analogde/www/Outlook/Fusion/Table/create_table.php
File size: 5.28 KB
MIME-type: text/x-php
Charset: utf-8

<?php

	include("calendrier_generation.php"); 

	$site = $_SERVER["SERVER_NAME"];
	if( ($site == "localhost") || ($site == "127.0.0.1") ) 
	{
		echo "Mode local";
		echo "<br>";
		$hostdb = "localhost";  // MySQl host
		$userdb = "root";  // MySQL username
		$passdb = "";  // MySQL password
		$namedb = "task_manager";  // MySQL database name
	}
	else
	{	
		echo "Hebergeur";
		echo "<br>";
		$hostdb = "analogdepat.mysql.db";
		$userdb = "analogdepat";
		$passdb = "Un92pac007";
		$namedb = "analogdepat";
	}
		
	// connexion
	$conn = new mysqli($hostdb, $userdb, $passdb, $namedb);
	// gestion erreur de connexion
	if ($conn->connect_error) 
	{
		die("Connection failed: " . $conn->connect_error);
	}
	
	
	// nom de la table
	$table = "pipo";
	
/*
	$result = $conn->query("SHOW TABLES LIKE '$table'");
	if ($result->num_rows > 0) 
	{
		echo "Table exists!";
		
		//$sql = "INSERT INTO pipo (firstname, lastname, email)
		//VALUES ('John', 'Doe', 'john@example.com')";

		$sql = "INSERT INTO $table (firstname, lastname, email)
		VALUES ('John', 'Doe', 'john@example.com')";
		
		if ($conn->query($sql) === TRUE) 
		{
			echo "New record created successfully";
			echo "<br>";
			echo "--------->>>> " .$sql;
			echo "<br>";
			echo "<br>";
			
			// lire tout le contenu de la table
			$sql = "SELECT * FROM $table";
			$result = $conn->query($sql);

			if ($result->num_rows > 0) 
			{
				// output data of each row
				while($row = $result->fetch_assoc()) 
				{
					echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
				}
			} 
			else 
			{
				echo "0 results";
			}
			
		} 
		else 
		{
			echo "Error: " . $sql . "<br>" . $conn->error;
		}
		
	} 
	else 
	{
		echo "Table pipo does not exist.";
		
		$sql = "CREATE TABLE pipo (
			id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
			firstname VARCHAR(30) NOT NULL,
			lastname VARCHAR(30) NOT NULL,
			email VARCHAR(50)
		)";

		if ($conn->query($sql) === TRUE) 
		{
			echo "Table pipo created successfully";
		} 
		else 
		{
			echo "Error creating table: " . $conn->error;
		}
		
	}
	
	$conn->close();

*/	
	
	
	
	$listing_jours = aaa();
	
	echo " Toute l'annee ";
	echo "<br>";
	echo "<pre>";
	print_r($listing_jours);
	echo "</pre>";
	
	
	// on prends le 3 mois
	echo " On prends le 3ieme mois ";
	echo "<br>";
	echo "<pre>";
	print_r($listing_jours[2]);
	echo "</pre>";
	
	
	//
	
	$nb_elements = count($listing_jours[2]);
	$DateArray = array();
	
	for( $i=0; $i < $nb_elements ; $i++)
	{		
		$pieces = explode("_", $listing_jours[2][$i]);
		
		//echo " ++++ " .gettype($pieces[0]);
		//echo "<br>";
		
		////str_replace("-","_",$pieces[0]);
		
		//$DateArray[] = 
		//$titi = str_replace("-","/", $listing_jours[0][$i]);
		//echo " >>>> " .$titi;
		//echo "<br>";
		$DateArray[] = $pieces[2];
		
		//$startdate = strtotime("03/11/2024");
		
		//str_replace("-","", $listing_jours[0][$i] );
		
		//$DateArray[] = strtotime($pieces[0]);
	}
	
	echo "Liste des dates" ."<br>";
	echo "<pre>";
	print_r($DateArray);
	echo "</pre>";
	
	$RandomNumber = array();
	
	for( $i=0; $i < $nb_elements ; $i++)
	{
		$RandomNumber[] = rand(10,250);
	}
	
	echo "Liste des valeurs (aléatoire)" ."<br>";
	echo "<pre>";
	print_r($RandomNumber);
	echo "</pre>";
	
	$table = "chart_table";
	
	//create_table($conn,$table);
	
	//insertion($conn,$table,$DateArray,$RandomNumber);
	
/**********************************************************/
function aaa()
{
			$liste_annee = array("2024");  
			
			for( $i=0; $i < count($liste_annee) ; $i++)
			{		
				$listing_jours = calendrier($liste_annee[$i]);	
				//echo "<pre>";
				//print_r($listing_jours);
				//echo "</pre>";
			}
			return $listing_jours;
}
/**********************************************************/
function convert_date_to_timestamp()
{

}
/**********************************************************/
function create_table($conn,$table)
{

	$result = $conn->query("SHOW TABLES LIKE '$table'");
	
	if ($result->num_rows > 0) 
	{
		echo ">>>>> Table :  " .$table  ." exists !!!!";
	} 
	else 
	{
		echo "Table does not exist.";
		
		$sql = "CREATE TABLE $table (
			id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
			champ_date VARCHAR(30) NOT NULL,
			champ_valeur VARCHAR(30) NOT NULL
		)";

		if ($conn->query($sql) === TRUE) 
		{
			echo "Table was created successfully";
		} 
		else 
		{
			echo "Error creating table: " . $conn->error;
		}
		
	}
	
	
}

/**********************************************************/

function insertion($conn,$table,$DateArray,$RandomNumber)
{

		for( $i=0; $i < count($DateArray) ; $i++)
		{
			$sql = "INSERT INTO $table (champ_date, champ_valeur)
			VALUES ( $DateArray[$i], $RandomNumber[$i] )";
			
			//echo " ++++ " .$sql;
			//echo "<br>";
			
			if ($conn->query($sql) === TRUE)
			{
				//echo "New record created successfully";
				$ok = True;
				echo "Insert OK : " . $sql . "<br>" ;
			} else
			{
				echo "Error: " . $sql . "<br>" . $conn->error;
			}
			
		}
		//$sql = "INSERT INTO $table (firstname, lastname, email)
		//VALUES ('John', 'Doe', 'john@example.com')";
		
		

}
/**********************************************************/
?>