zal direct wat meer code doorsturen.
Toevoeging op 06/03/2012 02:07:43:
dit is wat ik heb.
de like.php code
<?php
function article_exists($article_id) {
$article_id = (int)$article_id;
return (mysql_result(mysql_query("SELECT COUNT(`article_id`) FROM `articles` WHERE `article_id` = $article_id"), 0) == 0) ? false : true;
}
function previously_liked($article_id) {
$article_id = (int)$article_id;
return (mysql_result(mysql_query("SELECT COUNT(`like_id`) FROM `likes` WHERE `user_id` = ".$_SESSION['user_id']." AND `article_id` = $article_id"), 0) == 0) ? false : true;
}
function like_count($article_id) {
$article_id = (int)$article_id;
return (int)mysql_result(mysql_query("SELECT `article_likes` FROM `articles` WHERE `article_id` = $article_id"), 0, 'article_likes');
}
function add_like($article_id) {
$article_id = (int)$article_id;
mysql_query("UPDATE `articles` SET `article_likes` = `article_likes` + 1 WHERE `article_id` = $article_id");
mysql_query("INSERT INTO `likes` (`user_id`, `article_id`) VALUES (".$_SESSION['user_id'].", $article_id)");
}
?>
dit is de articles.php code.
<?php
function get_articles() {
$articles = array();
$query = mysql_query("SELECT `article_id`, `article_title`, `article_likes` FROM `articles`");
while (($row = mysql_fetch_assoc($query)) !== false) {
$articles[] = array(
'article_id' => $row['article_id'],
'article_title'=> $row['article_title'],
'article_likes'=> $row['article_likes']
);
}
return $articles;
}
?>
de index-klik.php code
<?php
include 'core/initmap.php';
?>
<!doctype html>
<head>
<title>articles</title>
<link rel="stylesheet" href="cssmap/style.css" />
</head>
<body>
<?php
$articles = get_articles();
if (count($articles) == 0) {
echo 'sorry no articles there';
} else {
echo '<ul>';
foreach ($articles as $article) {
echo '<li><p>', $article['article_title'], '</p><p><a class="like" href="#" onclick="like_add(', $article['article_id'], ');">like</a> <span id="article_', $article['article_id'], '_likes">', $article['article_likes'], '</span> like this </p></li>';
}
echo '</ul>';
}
?>
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/like.js"></script>
</body>
</html>
en de like.js code
function like_add(article_id) {
$.post('ajax/like_add.php', {article_id:article_id}, function(data) {
if (data == 'success') {
like_get(article_id);
} else {
alert(data);
}
});
}
function like_get(article_id) {
$.post('ajax/like_get.php', {article_id:article_id}, function(data) {
$('#article_'+article_id+'_likes').text(data);
});
}
like_add.php code
<?php
include '../core/initmap.php';
if (isset($_POST['article_id'], $_SESSION['user_id']) && article_exists($_POST['article_id'])) {
$article_id = $_POST['article_id'];
if (previously_liked($article_id) === true) {
echo 'je hebt al meegedaan met deze enquete.';
} else {
add_like($article_id);
echo 'success';
}
}
?>
like_get.php code
<?php
include '../core/initmap.php';
if (isset($_POST['article_id'], $_SESSION['user_id']) && article_exists($_POST['article_id'])) {
echo like_count($_POST['article_id']);
}
?>
mocht er meer nodig zijn hoor ik het heel graag.mvg
Toevoeging op 06/03/2012 02:12:16:
ik heb ook nog de user.func.php code voor u.
<?php
function logged_in() {
return isset($_SESSION['user_id']);
}
function login_check($email, $password) {
$email = mysql_real_escape_string($email);
$login_query = mysql_query("SELECT COUNT(`user_id`) as `count`, `user_id` FROM `users` WHERE `email`='$email' AND `password`='".md5($password)."'");
return (mysql_result($login_query, 0) == 1) ? mysql_result($login_query, 0, 'user_id') : false;
}
function user_data() {
$args = func_get_args();
$fields = '`'.implode('`, `', $args).'`';
$query = mysql_query("SELECT $fields FROM `users` WHERE `user_id`=".$_SESSION['user_id']);
$query_result = mysql_fetch_assoc($query);
foreach ($args as $field) {
$args[$field] = $query_result[$field];
}
return $args;
}
function user_register($email, $name, $password) {
$email = mysql_real_escape_string($email);
$name = mysql_real_escape_string($name);
mysql_query("INSERT INTO `users` VALUES ('', '$email', '$name', '".md5($password)."')");
return mysql_insert_id();
}
function user_exists($email) {
$email = mysql_real_escape_string($email);
$query = mysql_query("SELECT COUNT(`user_id`) FROM `users` WHERE `email`='$email'");
return (mysql_result($query, 0) == 1) ? true : false;
}
?>
