{"id":54,"date":"2017-07-24T09:30:39","date_gmt":"2017-07-24T07:30:39","guid":{"rendered":"https:\/\/numa-bord.com\/miniblog\/?p=54"},"modified":"2017-07-24T09:32:06","modified_gmt":"2017-07-24T07:32:06","slug":"php-importer-donnees-base-fichiers-sql","status":"publish","type":"post","link":"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/","title":{"rendered":"PHP : Importer les donn\u00e9es dans une base depuis un fichiers .sql"},"content":{"rendered":"

Ci-dessous un script PHP permettant d’importer dans une base les donn\u00e9es d’un fichier \u00ab\u00a0export.sql\u00a0\u00bb. Cela permet de cr\u00e9er les tables et d’ins\u00e9rer les donn\u00e9es dans la base directement en PHP sans passer par l’import du fichier via le PhpMyAdmin<\/p>\n

\u00c7a peut \u00eatre utile par exemple dans un \u00ab\u00a0installeur\u00a0\u00bb de site, dans la m\u00eame id\u00e9e de l’article pr\u00e9c\u00e9dent qui permettait de Cr\u00e9er une fichier de configuration en PHP<\/p>\n

\/\/effectuer la connexion \u00e0 la base de donn\u00e9es<\/span>
\n$mysqli<\/span> =<\/span> new<\/span> mysqli(<\/span>DB_SERVER,<\/span> DB_USERNAME,<\/span> DB_PASSWORD,<\/span> DB_NAME)<\/span>;<\/span>
\n\/\/fichier contenant le sql<\/span>
\n$lines<\/span> =<\/span> 'export.sql'<\/span>;<\/span>
\n\/\/initialisation des variables<\/span>
\n$req<\/span> =<\/span> ""<\/span>;<\/span>
\n$finRequete<\/span> =<\/span> false<\/span>;<\/span>
\n\/\/pour chaque ligne du fichier<\/span>
\nforeach<\/span> (<\/span>$lines<\/span> as<\/span> $line<\/span>)<\/span> {<\/span>
\n    \/\/on saute les commentaires<\/span>
\n    if<\/span> (<\/span>substr<\/span><\/a>(<\/span>$line<\/span>,<\/span> 0<\/span>,<\/span> 2<\/span>)<\/span> ==<\/span> '--'<\/span> ||<\/span> $line<\/span> ==<\/span> ''<\/span>)<\/span> {<\/span>
\n        continue<\/span>;<\/span>
\n    }<\/span>
\n    \/\/on ajoute la ligne \u00e0 la requ\u00eate<\/span>
\n    $req<\/span> .=<\/span> $line<\/span>;<\/span>
\n    \/\/Permet de rep\u00e9rer quand il faut envoyer l'ordre SQL...<\/span>
\n    if<\/span> (<\/span>substr<\/span><\/a>(<\/span>trim<\/span><\/a>(<\/span>$line<\/span>)<\/span>,<\/span> -<\/span>1<\/span>,<\/span> 1<\/span>)<\/span> ==<\/span> ';'<\/span>)<\/span> {<\/span>
\n        $finRequete<\/span> =<\/span> true<\/span>;<\/span>
\n    }<\/span>
\n    \/\/si requ\u00eate termin\u00e9, on l'ex\u00e9cute et on recommence le traitement \u00e0 partir de la ligne suivante<\/span>
\n    if<\/span> (<\/span>$finRequete<\/span>)<\/span> {<\/span>
\n        if<\/span> (<\/span>!<\/span>$mysqli<\/span>-><\/span>query<\/span>(<\/span>$req<\/span>)<\/span>)<\/span> {<\/span>
\n            echo<\/span> "<div class='alert alert-danger'>Erreur : "<\/span> .<\/span> $mysqli<\/span>-><\/span>error<\/span> .<\/span> "<br>"<\/span> .<\/span> $req<\/span> .<\/span> "<\/div>"<\/span>;<\/span>
\n        }<\/span>
\n        $req<\/span> =<\/span> ""<\/span>;<\/span>
\n        $finRequete<\/span> =<\/span> false<\/span>;<\/span>
\n    }<\/span>
\n}<\/span><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

Ci-dessous un script PHP permettant d’importer dans une base les donn\u00e9es d’un fichier \u00ab\u00a0export.sql\u00a0\u00bb. Cela permet de cr\u00e9er les tables et d’ins\u00e9rer les donn\u00e9es dans la base directement en PHP sans passer par l’import du fichier via le PhpMyAdmin \u00c7a peut \u00eatre utile par exemple dans un \u00ab\u00a0installeur\u00a0\u00bb de site, dans la m\u00eame id\u00e9e de […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2,7],"tags":[],"class_list":["post-54","post","type-post","status-publish","format-standard","hentry","category-developpement","category-php"],"acf":[],"yoast_head":"\nPHP : Importer les donn\u00e9es dans une base depuis un fichiers .sql - Pense b\u00eate d'un d\u00e9veloppeur web<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PHP : Importer les donn\u00e9es dans une base depuis un fichiers .sql - Pense b\u00eate d'un d\u00e9veloppeur web\" \/>\n<meta property=\"og:description\" content=\"Ci-dessous un script PHP permettant d’importer dans une base les donn\u00e9es d’un fichier \u00ab\u00a0export.sql\u00a0\u00bb. Cela permet de cr\u00e9er les tables et d’ins\u00e9rer les donn\u00e9es dans la base directement en PHP sans passer par l’import du fichier via le PhpMyAdmin \u00c7a peut \u00eatre utile par exemple dans un \u00ab\u00a0installeur\u00a0\u00bb de site, dans la m\u00eame id\u00e9e de […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Pense b\u00eate d'un d\u00e9veloppeur web\" \/>\n<meta property=\"article:published_time\" content=\"2017-07-24T07:30:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-07-24T07:32:06+00:00\" \/>\n<meta name=\"author\" content=\"Numa\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Numa\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/\"},\"author\":{\"name\":\"Numa\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e\"},\"headline\":\"PHP : Importer les donn\u00e9es dans une base depuis un fichiers .sql\",\"datePublished\":\"2017-07-24T07:30:39+00:00\",\"dateModified\":\"2017-07-24T07:32:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/\"},\"wordCount\":208,\"commentCount\":1,\"articleSection\":[\"D\u00e9veloppement\",\"PHP\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/\",\"url\":\"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/\",\"name\":\"PHP : Importer les donn\u00e9es dans une base depuis un fichiers .sql - Pense b\u00eate d'un d\u00e9veloppeur web\",\"isPartOf\":{\"@id\":\"https:\/\/numa-bord.com\/miniblog\/#website\"},\"datePublished\":\"2017-07-24T07:30:39+00:00\",\"dateModified\":\"2017-07-24T07:32:06+00:00\",\"author\":{\"@id\":\"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e\"},\"breadcrumb\":{\"@id\":\"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/numa-bord.com\/miniblog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHP : Importer les donn\u00e9es dans une base depuis un fichiers .sql\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/#website\",\"url\":\"https:\/\/numa-bord.com\/miniblog\/\",\"name\":\"Pense b\u00eate d'un d\u00e9veloppeur web\",\"description\":\"(php, javascript, Symfony, Wordpress....)\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/numa-bord.com\/miniblog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e\",\"name\":\"Numa\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g\",\"caption\":\"Numa\"},\"url\":\"https:\/\/numa-bord.com\/miniblog\/author\/negonner\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PHP : Importer les donn\u00e9es dans une base depuis un fichiers .sql - Pense b\u00eate d'un d\u00e9veloppeur web","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/","og_locale":"fr_FR","og_type":"article","og_title":"PHP : Importer les donn\u00e9es dans une base depuis un fichiers .sql - Pense b\u00eate d'un d\u00e9veloppeur web","og_description":"Ci-dessous un script PHP permettant d’importer dans une base les donn\u00e9es d’un fichier \u00ab\u00a0export.sql\u00a0\u00bb. Cela permet de cr\u00e9er les tables et d’ins\u00e9rer les donn\u00e9es dans la base directement en PHP sans passer par l’import du fichier via le PhpMyAdmin \u00c7a peut \u00eatre utile par exemple dans un \u00ab\u00a0installeur\u00a0\u00bb de site, dans la m\u00eame id\u00e9e de […]","og_url":"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/","og_site_name":"Pense b\u00eate d'un d\u00e9veloppeur web","article_published_time":"2017-07-24T07:30:39+00:00","article_modified_time":"2017-07-24T07:32:06+00:00","author":"Numa","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Numa","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/#article","isPartOf":{"@id":"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/"},"author":{"name":"Numa","@id":"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e"},"headline":"PHP : Importer les donn\u00e9es dans une base depuis un fichiers .sql","datePublished":"2017-07-24T07:30:39+00:00","dateModified":"2017-07-24T07:32:06+00:00","mainEntityOfPage":{"@id":"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/"},"wordCount":208,"commentCount":1,"articleSection":["D\u00e9veloppement","PHP"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/","url":"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/","name":"PHP : Importer les donn\u00e9es dans une base depuis un fichiers .sql - Pense b\u00eate d'un d\u00e9veloppeur web","isPartOf":{"@id":"https:\/\/numa-bord.com\/miniblog\/#website"},"datePublished":"2017-07-24T07:30:39+00:00","dateModified":"2017-07-24T07:32:06+00:00","author":{"@id":"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e"},"breadcrumb":{"@id":"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/numa-bord.com\/miniblog\/php-importer-donnees-base-fichiers-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/numa-bord.com\/miniblog\/"},{"@type":"ListItem","position":2,"name":"PHP : Importer les donn\u00e9es dans une base depuis un fichiers .sql"}]},{"@type":"WebSite","@id":"https:\/\/numa-bord.com\/miniblog\/#website","url":"https:\/\/numa-bord.com\/miniblog\/","name":"Pense b\u00eate d'un d\u00e9veloppeur web","description":"(php, javascript, Symfony, Wordpress....)","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/numa-bord.com\/miniblog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e","name":"Numa","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g","caption":"Numa"},"url":"https:\/\/numa-bord.com\/miniblog\/author\/negonner\/"}]}},"_links":{"self":[{"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/posts\/54","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/comments?post=54"}],"version-history":[{"count":6,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/posts\/54\/revisions"}],"predecessor-version":[{"id":90,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/posts\/54\/revisions\/90"}],"wp:attachment":[{"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/media?parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/categories?post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/tags?post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}