to integrate this code on HTML?

[hostingames]

hi,

 

need help thank you

 

to integrate this code on HTML?

 

$counter3 = mysql_query("SELECT COUNT(*) AS id FROM tblhosting WHERE domainstatus='Active'");
$num3 = mysql_fetch_array($counter3);
$count3 = $num3["id"];
$this->assign('hostingtotal',$count3); 

 

 

on my page header.tpl the code works well.

index.html fontionne not

[hostingames]

hi,

I need to integrate this code on, html?

 

thank you

[foka]

There would be two ways to do that.

 

1. To execute php code in html, you will need to put this code in your .htaccess file.

AddType application/x-httpd-php .html .htm

 

or

 

2. You can execute the code in php file and include it in html via iframe.

[hostingames]

hi,

could you give me code, please thank you

[sentq]

@hostingames, simply create activeClients.php inside your WHMCS main directory and place this code inside it:

<?php
require("init.php");
$counter3 = mysql_query("SELECT COUNT(*) AS id FROM tblhosting WHERE domainstatus='Active'");
$num3 = mysql_fetch_array($counter3);
$count3 = $num3["id"];
echo "document.write('{$count3}');";
?>

 

in index.html you use the following code to display the result from activeClients.php file:

<script type="text/javascript" src="http://yourwebsite.com/whmcs/activeClients.php"></script>

 

this will do what you need

[hostingames]

hi,

 

solved thank you