Bonjour à vous tous,
désoler de mon ignorance j 'essaye d'apprendre MySQL et j'ai encore un problème, rien ne veut s'enregistrer dans ma BDD.
demo.html
<!DOCTYPE html PUBLIC>
<html lang="fr">
<head>
<meta http-equiv="Content_Type" content="text/html; charset-utf-8">
<title>TEST</title>
<script src="http://cdn.jquerytools.org/1.2.7/full/jquery.tools.min.js"></script>
<style type="text/css" media="screen">
body {margin:40px;}
</style>
<script language="javascript" type="text/javascript">
$(document).ready(function(){
$("#log a").click(function(){
var logURL = $(this).attr('href');
var logClick = "clicked.php?url=" + logURL;
$(this).load(logClick, goURL());
return false;
function goURL() {
$(location).attr('href', logURL);
}
});
});
</script>
</head>
<body>
<div id="log">
<a href="http://google.com">Google</a> <br />
<a href="http://yahoo.com">Yahoo</a> <br />
<a href="http://grafikart.fr">Grafikart</a>
</div>
</body>
</html>
clicked.php
<?
mysql_connect("localhost","root","passwrd");
mysql_select_db("database") or die(mysql_error());
$url = $_GET'url'];
$check = mysql_query("SELECT * FROM tutoclic WHERE url = '$url' LIMIT 1");
while($row = mysql_fetch_array($check)){
$currentClicks = $row'clicks'];
$newClicks = $currentClicks + 1;
}
$ifExists = mysql_num_rows($check);
if($ifExists == "0"){
mysql_query("INSERT INTO tutoclic (url, clicks) VALUES('$url', '1')") or die(mysql_error());
} else {
mysql_query("UPDATE tutoclic SET clicks='$newClicks' WHERE url='$url'") or die(mysql_error());
}
?>
Si cela peut aider je passe la config de la bdd
"CREATE TABLE tutoclic (id INT(255) NOT NULL AUTO_INCREMENT,url TEXT NULL, clicks VARCHAR(255) NULL, PRIMARY KEY (id)) ENGINE = MyISAM;"
merci à vous tous pour votre aide.
boulou-astuces