Beste leden,
Ik had eens een scriptje laten maken voor WHMCS en nu ik mijn VPS heb geupdated naar nieuwe versies van PHP en MySQL krijg ik de melding:
Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in/home/admin/domains/starohosting.nl/public_html/domeinprijzen.php on line 40
Hoe kan ik dit oplossen want ik connect nog op de oude manier dus zo:
PHP
<?php
$link = mysql_connect("localhost", "user", "wachtwoord") or die("MySQL Error: ".mysql_error());
mysql_select_db("database", $link) or die("MySQL Error: ".mysql_error());
$result = mysql_query("SELECT
tblpricing.currency,
tblpricing.msetupfee,
(SELECT tblcurrencies.prefix FROM tblcurrencies WHERE id = tblpricing.currency) AS curprefix,
(SELECT tblcurrencies.suffix FROM tblcurrencies WHERE id = tblpricing.currency) AS cursuffix,
(SELECT tbldomainpricing.extension FROM tbldomainpricing WHERE id = tblpricing.relid) AS extension
FROM
tblpricing
WHERE
tblpricing.type= 'domainregister'
AND
!(SELECT tbldomainpricing.extension FROM tbldomainpricing WHERE id = tblpricing.relid)");
echo "
<table class='TabelTarief' border='0' cellspacing='0' cellpadding='0'>
<tbody>
<tr class='TabelHeader'>
<td class='First'>Domein Extensies</td>
<td>Duur v Registratie</td>
<td>Prijs v Domein</td>
<td>Domeincheck</td>
</tr>
";
while($row = mysql_fetch_array($result))
echo "
<tr class='TabelOdd'>
<td>".$row['extension']."</td>
<td>1 jaar</td>
<td>€ ".$row['msetupfee']." ".$row['cursuffix']."</td>
<td><a href='https://mijn.starohosting.nl/domainchecker.php' target='_blank'>Kijk of uw domein vrij is</a></td>
</tr>
";
mysql_close($link);
?>
Toon Meer