{"id":232435,"date":"2023-01-19T12:44:00","date_gmt":"2023-01-19T09:44:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232435"},"modified":"2023-02-04T17:19:33","modified_gmt":"2023-02-04T14:19:33","slug":"le-calculateur-hypothecaire-simple-implemente-en-c-c-javascript-et-mysql","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/fr\/le-calculateur-hypothecaire-simple-implemente-en-c-c-javascript-et-mysql\/","title":{"rendered":"Le calculateur hypoth\u00e9caire simple impl\u00e9ment\u00e9 en C\/C++, Javascript et MySQL"},"content":{"rendered":"<p>Bien qu&rsquo;il existe de nombreuses calculatrices <a href=\"https:\/\/helloacm.com\/how-to-calculate-mortgage-monthly-payment-using-excel-with-formula\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">hypoth\u00e9caires<\/a> disponibles, le principe d&rsquo;une calculatrice hypoth\u00e9caire simple est tr\u00e8s simple et repose sur la formule math\u00e9matique suivante.<\/p>\n<p><a href=\"https:\/\/wordpress.mediadoma.com\/wp-content\/uploads\/2022\/01\/post-156659-61e5c2d32c6ed.png\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/wordpress.mediadoma.com\/wp-content\/uploads\/2022\/01\/post-156659-61e5c2d32c6ed.png\" alt=\"Le calculateur hypoth\u00e9caire simple impl\u00e9ment\u00e9 en C\/C++, Javascript et MySQL\"><\/a><\/p>\n<p>o\u00f9, le c est le remboursement mensuel, r est les int\u00e9r\u00eats mensuels (qui est le douzi\u00e8me des int\u00e9r\u00eats annuels). P est le montant total emprunt\u00e9. N est le nombre total de remboursements (par exemple le nombre de mois).<\/p>\n<h3>Calculatrice hypoth\u00e9caire simple impl\u00e9ment\u00e9e dans MySQL<\/h3>\n<p>Par exemple, j&rsquo;ai emprunt\u00e9 170\u00a0000 \u00e0 la banque HSBC, le taux d&rsquo;int\u00e9r\u00eat (annuel) est de 2,49\u00a0% et je dois rembourser le capital + les int\u00e9r\u00eats en 25\u00a0ans. Le montant du remboursement chaque mois (en supposant qu&rsquo;il s&rsquo;agisse d&rsquo;un taux fixe) peut \u00eatre calcul\u00e9 via la commande suivante dans la <a href=\"https:\/\/helloacm.com\/php-script-to-execute-mysql-statements-in-a-text-file\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">console MySQL<\/a>\u00a0:<\/p>\n<pre><code>mysql&gt; select 0.0249\/12*170000*power(1+0.0249\/12,25*12)\/(power(1+0.0249\/12,25*12)-1);\n+------------------------------------------------------------------------+\n| 0.0249\/12*170000*power(1+0.0249\/12,25*12)\/(power(1+0.0249\/12,25*12)-1) |\n+------------------------------------------------------------------------+\n| \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 761.792586559163 |\n+------------------------------------------------------------------------+\n1 row in set (0.00 sec)<\/code><\/pre>\n<h3>Calculatrice hypoth\u00e9caire simple impl\u00e9ment\u00e9e en C\/C++<\/h3>\n<p>Avec la fonction pow de math.h, la fonction de paiement est d\u00e9finie comme suit\u00a0:<\/p>\n<pre><code>#include &lt;math.h&gt;\n\u00a0\n\/\/ r - monthly interest rate\n\/\/ p - principle\n\/\/ n - number of repayments\ndouble payment(r, p, n) {\n\u00a0 \u00a0 var x = pow(1 + r, n);\n\u00a0 \u00a0 return r * p * x \/ (x - 1);\n}<\/code><\/pre>\n<h3>Calculatrice hypoth\u00e9caire simple en ligne impl\u00e9ment\u00e9e en Javascript<\/h3>\n<p>De m\u00eame, la fonction d\u00e9finie en <a href=\"https:\/\/wordpress.mediadoma.com\/fr\/comment-completer-automatiquement-le-formulaire-de-commentaire-en-utilisant-javascript\/\" title=\"Javascript\">Javascript<\/a> est d\u00e9finie comme\u00a0:<\/p>\n<pre><code>\/\/ r - monthly interest rate\n\/\/ p - principle\n\/\/ n - number of repayments\nfunction payment(r, p, n) {\n\u00a0 \u00a0 var x = Math.pow(1 + r, n);\n\u00a0 \u00a0 return r * p * x \/ (x - 1);\n}<\/code><\/pre>\n<p>Remplissez les valeurs de r, P et N et le <a href=\"https:\/\/helloacm.com\/the-simple-mortgage-calculator-implemented-in-cc-javascript-and-mysql\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">calculateur hypoth\u00e9caire en ligne suivant (open in new window)<\/a> calculera le remboursement mensuel et les int\u00e9r\u00eats (non disponible si vous visualisez la version <a href=\"https:\/\/wordpress.mediadoma.com\/fr\/comment-activer-amp-avec-wordpress-techniques-doptimisation-amp-avec-wordpress\/\" title=\"Accelerated Mobile Page\">Accelerated Mobile Page<\/a> )\u00a0:<\/p>\n<p><a href=\"https:\/\/wordpress.mediadoma.com\/wp-content\/uploads\/2022\/01\/post-156659-61e5c2d428cbc.jpg\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/wordpress.mediadoma.com\/wp-content\/uploads\/2022\/01\/post-156659-61e5c2d428cbc.jpg\" alt=\"Le calculateur hypoth\u00e9caire simple impl\u00e9ment\u00e9 en C\/C++, Javascript et MySQL\"><\/a><\/p>\n<p>calculatrice hypoth\u00e9caire avec formule<\/p>\n<p>La version alternative de <a href=\"https:\/\/justyy.com\/archives\/3454\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">cette calculatrice hypoth\u00e9caire peut \u00eatre trouv\u00e9e ici<\/a>.<\/p>\n<p><div id=\"PostUnique_PostSource\" style=\"padding-top: 50px\">Source d&rsquo;enregistrement:  <a target=\"_blank\" rel=\"noopener nofollow\" href=\"\/\/helloacm.com\" class=\"external external_icon\">helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Le calculateur hypoth\u00e9caire simple impl\u00e9ment\u00e9 en C\/C++, Javascript et MySQL<\/p>\n","protected":false},"author":1,"featured_media":224427,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[915,893,717],"tags":[1167],"class_list":["post-232435","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-autre","category-code-2","category-developpeur","tag-affiai-fr"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/posts\/232435","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/comments?post=232435"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/posts\/232435\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/media\/224427"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/media?parent=232435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/categories?post=232435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/tags?post=232435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}