kanikase
Préstamo
Ómicron
Programador
Verificación en dos pasos activada
Verificado por Whatsapp
¡Ha verificado su Paypal!
- Desde
- 22 Feb 2014
- Mensajes
- 4.716
Necesito ayuda con un codigo php, es para un contador de visitas por entradas, ya lo tengo configurado, pero al subirlo a mi host, y abrir el archivo me sale "Warning: mysql_close() expects parameter 1 to be resource, null given in /home/u292154245/public_html/counter.php on line 69" que esta fallando, este es el codigo que utilizo:
Lo que me dice que esta mal es esto: mysql_close($link);
Y aqui esta el archivo: http://toddescargas.com/counter.php
PHP:
<?php
//Created by Anuj Pathania --- anujpathania#gmail.com. Please Feel Free to mail me if you want any help, script has a bug or just wanna say Hi. :D
//This code is released under GPL (General Public License).
/*
You need to create a database and table to store data first, please do so by executing this command in phpmyadmin first but make sure you change database and table name --
CREATE TABLE `YOUR-COUNTER-DATABASE`.`YOUR-COUNTER-TABLE` (
`SN` BIGINT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 1000 ) NOT NULL ,
`hit` BIGINT NOT NULL DEFAULT '1',
PRIMARY KEY ( `SN` )
) ENGINE = MYISAM
*/
Header("content-type: application/x-javascript");
$url = getenv("HTTP_REFERER");
$url = str_replace ("http://",'',$url);
$url = str_replace ("www.",'',$url);
if ($url != "")
{
$username = "xxxxxxxx_xxxxx"; // Enter Your Username and Password Here
$password = 'xxxxxxxxx'; // Enter Your Username and Password Here
$database = 'xxxxxxxxx_xxxxx'; //Enter Your Database Name Here
$table = "counter"; //Enter Your Counter Table Name Here
$link = mysql_connect('localhost', $username, $password);
if (!$link)
{
die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db($database, $link);
if (!$db_selected)
{
die ('Cann\'t select database : ' . mysql_error());
}
$query = "Select hit from $table where name = '$url'";
$result = mysql_query($query);
if (!$result)
{
die('Invalid query: ' . mysql_error());
}
if (mysql_affected_rows()==0)
{
$query = "Insert into counter (name) values ('$url')";
$result = mysql_query($query);
echo "document.write('1');";
if (!$result)
{
die('Invalid query: ' . mysql_error());
}
}
else
{
$hitcount = mysql_result($result, 0);
$hitcount++;
echo "document.write('$hitcount');";
$query = "Update counter set hit = $hitcount where name = '$url'";
$result = mysql_query($query);
if (!$result)
{
die('Invalid query: ' . mysql_error());
}
}
}
mysql_close($link);
?>Lo que me dice que esta mal es esto: mysql_close($link);
Y aqui esta el archivo: http://toddescargas.com/counter.php
