more search findings

[edwin]

Jan or Nicky, is it possible to see on what kind of keywords my visitor search.
And how do i get more results in my controlpanel, so not the 5 best but the 25 best visited pictures and were should i change it

regards edwin

[Jan]

Jan or Nicky, is it possible to see on what kind of keywords my visitor search.

At the moment no. If you want to log the searches, just create a new table in your database "4images_searchlog":

Code: [Select]

CREATE TABLE 4images_searchlog (
user_id MEDIUMINT NOT NULL,
search_keywords VARCHAR(255) NOT NULL
);
and paste in "search.php" just before

Code: [Select]

$search_keywords = strip_tags(strtolower(stripslashes($search_keywords)));
this code

Code: [Select]

$sql = "INSERT INTO 4images_searchlog (user_id , search_keywords)
        VALUES (".$user_info['user_id'].", '$search_keywords')";
$site_db->query($sql);

And how do i get more results in my controlpanel, so not the 5 best but the 25 best visited pictures and were should i change it

Just change in the firstline of "admin/home.php"

Code: [Select]

$stats_limit = 5;
Jan

[edwin]

Jan, i did it but i get the next error, do you have any idea what it is

regards

Parse error: parse error, unexpected T_STRING in /home/ejanssen/public_html/images/search.php on line 105

[Jan]

Check your code, maybe you did some faults while pasting the code. I tested it, for me it works.

Jan

[edwin]

Can you show me like above how it would look like, mayby i don't understand u correctly

regards edwin

[Jan]

Code: [Select]

if ($search_keywords != "" && $show_result == 1) {
  $sql = "INSERT INTO 4images_searchlog (user_id, search_keywords)
          VALUES (".$user_info['user_id'].", '$search_keywords')";
  $site_db->query($sql);
  $search_keywords = strip_tags(strtolower(stripslashes($search_keywords)));
With 1 line around the part.

Jan

[edwin]

Great, that works only now i have to make a table in my database, can you help me with that to or do i have to contact my provider for that

DB Error: Bad SQL Query: INSERT INTO 4images_searchlog (user_id , search_keywords) VALUES (1, 'alexander')
Table 'ejanssen.4images_searchlog' doesn't exist

[Jan]

Try phpMyAdmin. With that tool you can manage mySQL databases.

Jan

[bernd]

Jan,

This sounds really interesting so I immediatley tried it
Really cool - now all I need is a nice page that creates some cool statistics ... but I guess I have to try that myself  

thnx so far!
Bernd

[edwin]

Mayby the stuppiest question of all but how do i get into my Mysql database ??
i'm a complete newbie to this.

Can i get there from by example; http://janssen.xs4fun.net/database.php or something else.

[Nicky]

ok

make an new file with a name new_table.php
put ONLY this as content:

Code: [Select]


<?php 
define&#40;'ROOT_PATH', './'&#41;;

include&#40;ROOT_PATH.'config.php'&#41;;
include&#40;ROOT_PATH.'includes/db_mysql.php'&#41;;

$site_db = new Db&#40;$db_host, $db_user, $db_password, $db_name&#41;;
$sql="CREATE TABLE 4images_searchlog 
      &#40;user_id MEDIUMINT NOT NULL, 
      search_keywords VARCHAR&#40;255&#41; NOT NULL&#41;";
$result = $site_db->query&#40;$sql&#41;;

echo "table <b>4images_searchlog</b> created !<br>have fun !";
?>

save. upload new_table.php into your 4images folder (where config.php reside) now point your webbrowser to:
http://your_url_to/4images/new_table.php .

done.. delete new_table.php from your server.

[edwin]

great and need, i'm very humble to you because i need and us your program evendo i don't knw anything of mysql.

one last question, how can i see this log

again thanks for your quick and sharp help

[Jan]

You can use phpMyAdmin. I posted the link above:
http://www.4homepages.de/forum/viewtopic.php?p=8056#8056

Jan