PHP, Ligne de commande, MySQL – Utiliser des scripts php en ligne de commande

which php
whereis php
type -a php
php -v

	#!/usr/bin/php

chmod +x /le/chemin/vers/votre/fichier/nom_du_fichier_contenant_votre_script.php

/le/chemin/vers/votre/fichier/nom_du_fichier_contenant_votre_script.php

	#!/usr/bin/php
	<?php 
 
	echo "nnnnnn";
		echo "--- LAUNCH ---";
	echo "nnnnnn";
 
			$username = "root";
			/* Sous MAMP le pwd est root */
			$password = "root";
			/* C'est le moyen de se connceter en mode à la base de données en mode php Cli */
			$hostname = ":/Applications/MAMP/tmp/mysql/mysql.sock"; 
 
 
			//connection to the database
			$dbhandle = mysql_connect($hostname, $username, $password)
			  or die("Unable to connect to MySQL");
			// echo "Connected to MySQL";
				// echo "nn";
 
			//select a database to work with
			$selected = mysql_select_db("db_source",$dbhandle)
			  or die("Could not select db_source");
 
			//execute the SQL query and return records
 
 
 
			$result = mysql_query(" SELECT * FROM posts WHERE user_id = 101 AND status = 'publish' "); // FROM TCMES
			$post_author = '3'; // The id for coming for the wp_users
			$db_name = 'db_destination';
			$file = '/le/chemin/vers/votre/fichier/dump_sql_vers_wordpress.sql';
 
			while ($row = mysql_fetch_array($result)) {
				/* VALUES */
				$output = "";
				$output .= "
				INSERT INTO ".$db_name.".wp_posts (ID, post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_content_filtered, post_parent, guid, menu_order, post_type, post_mime_type, comment_count) VALUES";
				/* ID */
				$output .=  "('".trim($row{'id'})."', ";
				/* post_author */
				$output .=  "'".trim($post_author)."',";
				/* post_date */
				$output .=  "'".trim($row{'created_at'})."',";
				/* post_date_gmt */
				$output .=  "'".trim($row{'created_at'})."',";
				/* post_content */
				$output .=  "'".addslashes(trim($row{'body'}))."',";
				/* post_title */
				$output .=  "'".addslashes(trim($row{'title'}))."',";
				/* post_excerpt */
				$output .=  "'',";
				/* post_status */
				$output .=  "'publish',";
				/* comment_status */
				$output .=  "'open',";
				/* ping_status */
				$output .=  "'open',";
				/* post_password */
				$output .=  "'',";
				/* post_name (slug) */
				$output .=  "'".trim($row{'nicetitle'})."',";
				/* to_ping */
				$output .=  "'',";
				/* pinged */
				$output .=  "'',";
				/* post_modified */
				$output .=  "'".trim($row{'updated_at'})."',";
				/* post_modified_gmt */
				$output .=  "'".trim($row{'updated_at'})."',";
				/* post_content_filtered */
				$output .=  "'',";
				/* post_parent */
				$output .=  "'0',"; 
				/* guid */
				$output .=  "'',";
				/* menu_order */
				$output .=  "'0',";
				/* post_type */
				$output .=  "'post',";
				/* post_mime_type */
				$output .=  "'',";
				/* comment_count */
				$output .=  "'".trim($row{'total_comments'})."'";
				/* END */
				$output .=  ");";
				$output .=  "n";
 
 
				/* INJECT */
				$handle = fopen($file, 'a'); 
				fwrite($handle, $output );
				fclose($handle);
				/* // INJECT */
			}
			echo "nnnnnn";
			echo "--- DONE ---";
			echo "nnnnnn";
 
	?>

 
	CREATE TABLE `posts` (
	  `id` INT(11) NOT NULL AUTO_INCREMENT,
	  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
	  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
	  `title` VARCHAR(255) NOT NULL DEFAULT '',
	  `nicetitle` VARCHAR(255) NOT NULL DEFAULT '',
	  `body` text NOT NULL,
	  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
	  `user_id` INT(11) NOT NULL DEFAULT '0',
	  `status` VARCHAR(11) NOT NULL DEFAULT '0',
	  `last_comment_date` datetime DEFAULT NULL,
	  `total_comments` INT(11) DEFAULT '0',
	  `blocked` tinyint(1) DEFAULT '0',
	  `unique_id` VARCHAR(255) DEFAULT NULL,
	  `imported_feed_id` INT(11) DEFAULT NULL,
	  PRIMARY KEY (`id`),
	  UNIQUE KEY `unique_id` (`unique_id`),
	  UNIQUE KEY `unique_id_2` (`unique_id`),
	  KEY `nicetitle` (`nicetitle`),
	  KEY `user_id` (`user_id`),
	  KEY `date` (`date`),
	  KEY `status` (`status`),
	  FULLTEXT KEY `searching` (`title`,`body`)
	) ENGINE=MyISAM  DEFAULT CHARSET=latin1;