Mysql without Pear DB

[daralthus]

Hello!
I would like to ask your help, i have founded a great code here: http://www.jamescaws.c o.uk/2008/07/dynamically-count-exit-link-clicks-throughs-using-javascript-php/

but it uses Pear DB for the database connection. the problem is that it don't works, actually the php don't writes anything in the table and i don't get any error when i add the

if (PEAR::isError($db)) {
die($db->getMessage());}

code, so not the connection...

Then i tried a simple insert (a Pear DB one, from the pear manual... )
it looks like this:

$res =& $db->query("INSERT INTO ct_Links (hash, url) VALUES (v, something)");

there's no succes so, maybe somebody can help to rewrite the code to use only simple mysql and php without the pear package... please:D

the connect is simple. but there are some code i don't really no how to transform:

$db->setFetchMode(DB_FETCHMODE_ASSOC);
 
function local_getLinkID($db, $debugObj, $sHash) {
    $sql = sprintf('SELECT linkID FROM ct_Links WHERE hash = %s', $db->quoteSmart($sHash));
 
    $debugObj->output("local_getLinkID($db, $debugObj, $sHash) : $sql");
 
    $iID = $db->getOne($sql);
 
function local_logNewLink($db, $debugObj, $sHash, $sURL) {
    $sql = sprintf('INSERT INTO ct_Links (hash, url) VALUES (%s, %s)',
        $db->quoteSmart($sHash),
        $db->quoteSmart($sURL)
    );
 
    $debugObj->output("local_logNewLink($db, $debugObj, $sHash, $sURL) : $sql");
 
    $db->query($sql);
 
    return $db->getOne('SELECT LAST_INSERT_ID()');
}
 
 
function local_logLinkClick($db, $debugObj, $iLinkID, $sIP, $sUserAgent) {
    $sql = sprintf('INSERT INTO ct_Log (linkID, ip, useragent) VALUES (%d, INET_ATON(%s), %s)',
        $iLinkID,
        $db->quoteSmart($sIP),
        $db->quoteSmart($sUserAgent)
    );
 
    $debugObj->output("local_logLinkClick($db, $debugObj, $iLinkID, $sIP, $sUserAgent) : $sql");
 
    $db->query($sql);

thanks for any help!!

[Atli]

Hi.

You shouldn't have any trouble changing your code to use the MySQLI extension.
Any decent host should support it.

There are excellent examples of how to use it in the mysqli_query section of the manual.

[daralthus]

ok thank you very much i will try