{"id":1434,"date":"2013-05-28T22:50:14","date_gmt":"2013-05-28T20:50:14","guid":{"rendered":"http:\/\/michauko.org\/blog\/?p=1434"},"modified":"2013-05-29T09:28:18","modified_gmt":"2013-05-29T07:28:18","slug":"migrer-du-code-php-de-mysql-a-mysqli","status":"publish","type":"post","link":"https:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/","title":{"rendered":"Migrer du code PHP de mysql \u00e0 mysqli"},"content":{"rendered":"

\"php\"\"mysql\"Ca faisait un moment que je devais le faire. Mais la peur de tout planter pendant trop longtemps m’en emp\u00eachait.
\nFinalement, \u00e7a s’est fait en une heure, en comprenant le temps d’analyse et de compr\u00e9hension de l’outil-qui-va-bien.
\nMais de quoi je parle ?
\nJe parle du fait que tout le monde utilise l’API \u00ab\u00a0mysql\u00a0\u00bb de PHP – historiquement et par habitude – pour taper dans une base MySQL alors que celle-ci est obsol\u00e8te depuis un paquet de temps. Il faut utiliser sa rempla\u00e7ante \u00ab\u00a0mysqli\u00a0\u00bb.
\nC’est d\u00e9crit ici chez PHP.net<\/a><\/p>\n

En tr\u00e8s tr\u00e8s gros, il suffit de remplacer les fonctions mysql_quelque_chose() par mysqli<\/strong>_quelque_chose() et d’indiquer l’identifiant de connexion en premier plut\u00f4t qu’en dernier argument.
\nC’est b\u00eate, mais \u00e7a peut \u00eatre long \u00e0 faire sans faute.<\/p>\n

Il y a donc un outil bien r\u00e9alis\u00e9 pour le faire automatiquement, tout en pouvant simuler les modifs de code. Il est fourni chez Oracle<\/a>.
\nSon interface graphique, pratique en premi\u00e8re approche, ne m’affichait pas le bilan des modifs pour tous les fichiers. Je ne sais pas pourquoi, et j’en suis donc rapidement venu \u00e0 ex\u00e9cuter le mode client texte sur chaque fichier que j’avais besoin de migrer.
\nLes options permettent dans un premier temps de ne voir que les warnings\/erreurs.
\n

\"MySQLConverterTool\"
MySQLConverterTool<\/figcaption><\/figure>
\nDans mon cas, j’ai d\u00fb faire une passe de propre sur mysql_real_escape_string o\u00f9 je n’indiquais aucune connexion (param\u00e8tre optionnel). Du coup l’outil me blindait mon code avec des trucs imbuvables. Conclusion, il vaut mieux parfois v\u00e9rifier la d\u00e9finition de l’ancienne fonction, faire propre, puis tenter une conversion.<\/p>\n

Attention, les permissions sur vos fichiers peuvent s’en trouver modifi\u00e9es, ce qui peut poser des probl\u00e8mes.<\/p>\n","protected":false},"excerpt":{"rendered":"

Ca faisait un moment que je devais le faire. Mais la peur de tout planter pendant trop longtemps m’en emp\u00eachait. Finalement, \u00e7a s’est fait en une heure, en comprenant le temps d’analyse et de compr\u00e9hension …<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[386,82],"tags":[538,430],"class_list":["post-1434","post","type-post","status-publish","format-standard","hentry","category-dev","category-pl","tag-mysqli","tag-php"],"yoast_head":"\nMigrer du code PHP de mysql \u00e0 mysqli - Le blog de Michauko<\/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:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migrer du code PHP de mysql \u00e0 mysqli - Le blog de Michauko\" \/>\n<meta property=\"og:description\" content=\"Ca faisait un moment que je devais le faire. Mais la peur de tout planter pendant trop longtemps m’en emp\u00eachait. Finalement, \u00e7a s’est fait en une heure, en comprenant le temps d’analyse et de compr\u00e9hension …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/\" \/>\n<meta property=\"og:site_name\" content=\"Le blog de Michauko\" \/>\n<meta property=\"article:published_time\" content=\"2013-05-28T20:50:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-05-29T07:28:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2013\/05\/php.png\" \/>\n<meta name=\"author\" content=\"michauko\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"michauko\" \/>\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:\\\/\\\/michauko.org\\\/blog\\\/migrer-du-code-php-de-mysql-a-mysqli-1434\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migrer-du-code-php-de-mysql-a-mysqli-1434\\\/\"},\"author\":{\"name\":\"michauko\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#\\\/schema\\\/person\\\/0cd9f3d9ce4dccc05df81a5b27051ea9\"},\"headline\":\"Migrer du code PHP de mysql \u00e0 mysqli\",\"datePublished\":\"2013-05-28T20:50:14+00:00\",\"dateModified\":\"2013-05-29T07:28:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migrer-du-code-php-de-mysql-a-mysqli-1434\\\/\"},\"wordCount\":324,\"commentCount\":2,\"image\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migrer-du-code-php-de-mysql-a-mysqli-1434\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/michauko.org\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/php.png\",\"keywords\":[\"mysqli\",\"php\"],\"articleSection\":[\"dev\",\"planet-libre.org\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/michauko.org\\\/blog\\\/migrer-du-code-php-de-mysql-a-mysqli-1434\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migrer-du-code-php-de-mysql-a-mysqli-1434\\\/\",\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migrer-du-code-php-de-mysql-a-mysqli-1434\\\/\",\"name\":\"Migrer du code PHP de mysql \u00e0 mysqli - Le blog de Michauko\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migrer-du-code-php-de-mysql-a-mysqli-1434\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migrer-du-code-php-de-mysql-a-mysqli-1434\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/michauko.org\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/php.png\",\"datePublished\":\"2013-05-28T20:50:14+00:00\",\"dateModified\":\"2013-05-29T07:28:18+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#\\\/schema\\\/person\\\/0cd9f3d9ce4dccc05df81a5b27051ea9\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migrer-du-code-php-de-mysql-a-mysqli-1434\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/michauko.org\\\/blog\\\/migrer-du-code-php-de-mysql-a-mysqli-1434\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migrer-du-code-php-de-mysql-a-mysqli-1434\\\/#primaryimage\",\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/php.png\",\"contentUrl\":\"https:\\\/\\\/michauko.org\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/php.png\",\"width\":95,\"height\":51},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migrer-du-code-php-de-mysql-a-mysqli-1434\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/michauko.org\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migrer du code PHP de mysql \u00e0 mysqli\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/\",\"name\":\"Le blog de Michauko\",\"description\":\"Si tu ne comprends pas le titre de l'article, passe ton chemin\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/michauko.org\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#\\\/schema\\\/person\\\/0cd9f3d9ce4dccc05df81a5b27051ea9\",\"name\":\"michauko\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g\",\"caption\":\"michauko\"},\"sameAs\":[\"http:\\\/\\\/michauko.org\\\/\"],\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/author\\\/randomized2\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Migrer du code PHP de mysql \u00e0 mysqli - Le blog de Michauko","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:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/","og_locale":"fr_FR","og_type":"article","og_title":"Migrer du code PHP de mysql \u00e0 mysqli - Le blog de Michauko","og_description":"Ca faisait un moment que je devais le faire. Mais la peur de tout planter pendant trop longtemps m’en emp\u00eachait. Finalement, \u00e7a s’est fait en une heure, en comprenant le temps d’analyse et de compr\u00e9hension …","og_url":"https:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/","og_site_name":"Le blog de Michauko","article_published_time":"2013-05-28T20:50:14+00:00","article_modified_time":"2013-05-29T07:28:18+00:00","og_image":[{"url":"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2013\/05\/php.png","type":"","width":"","height":""}],"author":"michauko","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"michauko","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/#article","isPartOf":{"@id":"https:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/"},"author":{"name":"michauko","@id":"https:\/\/michauko.org\/blog\/#\/schema\/person\/0cd9f3d9ce4dccc05df81a5b27051ea9"},"headline":"Migrer du code PHP de mysql \u00e0 mysqli","datePublished":"2013-05-28T20:50:14+00:00","dateModified":"2013-05-29T07:28:18+00:00","mainEntityOfPage":{"@id":"https:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/"},"wordCount":324,"commentCount":2,"image":{"@id":"https:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/#primaryimage"},"thumbnailUrl":"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2013\/05\/php.png","keywords":["mysqli","php"],"articleSection":["dev","planet-libre.org"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/","url":"https:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/","name":"Migrer du code PHP de mysql \u00e0 mysqli - Le blog de Michauko","isPartOf":{"@id":"https:\/\/michauko.org\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/#primaryimage"},"image":{"@id":"https:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/#primaryimage"},"thumbnailUrl":"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2013\/05\/php.png","datePublished":"2013-05-28T20:50:14+00:00","dateModified":"2013-05-29T07:28:18+00:00","author":{"@id":"https:\/\/michauko.org\/blog\/#\/schema\/person\/0cd9f3d9ce4dccc05df81a5b27051ea9"},"breadcrumb":{"@id":"https:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/#primaryimage","url":"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2013\/05\/php.png","contentUrl":"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2013\/05\/php.png","width":95,"height":51},{"@type":"BreadcrumbList","@id":"https:\/\/michauko.org\/blog\/migrer-du-code-php-de-mysql-a-mysqli-1434\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/michauko.org\/blog\/"},{"@type":"ListItem","position":2,"name":"Migrer du code PHP de mysql \u00e0 mysqli"}]},{"@type":"WebSite","@id":"https:\/\/michauko.org\/blog\/#website","url":"https:\/\/michauko.org\/blog\/","name":"Le blog de Michauko","description":"Si tu ne comprends pas le titre de l'article, passe ton chemin","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/michauko.org\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/michauko.org\/blog\/#\/schema\/person\/0cd9f3d9ce4dccc05df81a5b27051ea9","name":"michauko","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g","caption":"michauko"},"sameAs":["http:\/\/michauko.org\/"],"url":"https:\/\/michauko.org\/blog\/author\/randomized2\/"}]}},"_links":{"self":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts\/1434","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/comments?post=1434"}],"version-history":[{"count":8,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts\/1434\/revisions"}],"predecessor-version":[{"id":1465,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts\/1434\/revisions\/1465"}],"wp:attachment":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/media?parent=1434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/categories?post=1434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/tags?post=1434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}