PHP - Php On A Wamp-system On My Opensuse 11.4 System - Permissions-question

well good moring dear folks - hope you are all right and everythings is fine across the atlantic

today i have a  question regarding server-paths - and the absolute and relative in a linux-[opensuse 11.4] lampp-system
well i just installed something in to my Lampp on openSuse  11.4

while setting up  this application - (it is a joomla 1.7.3 ) i wonder how i name the paths


   public $unicodeslugs = '0';
   public $feed_limit = '10';
   public $log_path = 'D:\\Xammp\\xampp\\htdocs\\pre1/logs';
   public $tmp_path = 'D:\\Xammp\\xampp\\htdocs\\pre1/tmp';
   public $lifetime = '15';
   public $session_handler = 'database';



what cou you thinks how shoud i name the paths
well you see above this was a windows box where the pahts originally were taken from

love to hear from you

I have just a general question about a friends system here with regards to the database design.......

lets say you have a website where users can rent books.  The database design would be


MEMBER                                    BOOK                                                              LINk
memberid                                  isbn                                                                 memberid
name                                         name                                                              isbn
                                               
Or something to that extent

Now with a friends system like facebook has that "LINK" table would be absolutley huge and I cant see it being good design practise.  I mean how do you suppose facebook does this. Do they have ......

FRIENDS
myID
friendID


and just millions upon millions of repeated data?

 The only way I can see would be in the member table have a field called friends and then the ID's of each friend like so


Friends
001, 002, 003, 004, 005, 006, 007,

Now is my logic correct here or am I thinking of this totally the wrong way?  Would the other way be a better option or would it take the system too long to get to the 1000,000 th record in the database?

I believe the first option would be correct but I cant see how the server would handle the request if say you had 1000,000 users.  It just seems to me that you would create too many records. 

In my website people can sign up to mulitple events but if every user had 100 events the link table would just be massive!!!!!!!!!!!!!!!!!!!!!!

Im just after peoples input really on the situation.

Thank you

Hello everyone!

I'm completely new to PHP and Databases. I've managed to do some nice work by reading, but now I've encountered a problem I can't solve.

I made a site with trailers and got tierd of adding them manually. So I created a form which sends the trailer info to my database.

There's now trailers in specific organized genres. But the list is beginning to get really big so I wanted to show just 10 trailers per page. And so I found out I could use a paging system which I ALMOST got working. Just one last thing that needs to be fixed and that is when I click on next page "http://www.xxxxxxxx.com/test.php&page=2" it doesn't show the content. While "http://www.xxxxxxxx.com/test.php" does.

So I just need that next button to work, I don't know if theres something missing or what it is...

Note: I'm new to all this so please excuse my very very bad coding.

Here is my code:

test.php
<link rel="stylesheet" type="text/css" media="all" href="http://www.xxxxxxxxxxxxx.n.nu/createdfiles/trailers/style-twentyten.css" />
<link rel="stylesheet" type="text/css" media="all" href="http://www.xxxxxxxxxxxxx.com/paginate.css" />

<?php

$rpp = 10; // results per page
$adjacents = 4;

$page = intval($_GET["page"]);
if(!$page) $page = 1;

$reload = $_SERVER['PHP_SELF'];

// connect to your DB:
$link_id = mysql_connect("server","username","my password");
mysql_select_db("database");

// select appropriate results from DB:
$sql = "SELECT * FROM blablabla WHERE Genre LIKE '%Drama%' ORDER BY `blablabla`.`sort` DESC LIMIT 0, 9999";
$result = mysql_query($sql, $link_id);

// count total number of appropriate listings:
$tcount = mysql_num_rows($result);

// count number of pages:
$tpages = ($tcount) ? ceil($tcount/$rpp) : 1; // total pages, last page number

$count = 0;
$i = ($page-1)*$rpp;
while(($count<$rpp) && ($i<$tcount)) {
    mysql_data_seek($result,$i);
    $query = mysql_fetch_array($result);

    // output each row:
    echo "<br />--------------------------------------------------------------------------------------------------------<br /><br />";
?><strong> <img src=" <?php echo $query['Poster'];?>" /><?php
  echo "<br /> <br />";

//////////////////////////////
//SHOW TITLE, YEAR AND GENRE//
//////////////////////////////

  echo "<H1>";
  echo $query['Title'];
  echo "<br /> <br />";
  echo "</h1>";
?></strong> <?php
  echo "<H2>";
  echo $query['Year'];
  echo "</H2>";
  echo "<br />";
  echo "<H3>";
  echo $query['Genre'];
  echo "</H3>";
?>
<a href="
<?php

//////////////////////////////
//SHOW IMDB, ACTORS AND PLOT//
//////////////////////////////

  echo $query['IMDB'];
?>
" target="_self">Link to IMDb</a>
<?php
  echo "<br /> <br />";
  echo "<H2>Stars:</H2>";
  echo "<br />";
  echo "<H3>";
  echo $query['Actors'];
  echo "</H3>";
  echo "<br />";
  echo "<H2>Plot:</H2>";
  echo "<br />";
  echo "<H3>";
  echo $query['Plot'];
  echo "</H3>";
  echo "<br /> <br />";
  echo "<H2>";

////////////////
//SHOW TRAILER//
////////////////

?>
<div id="<?php echo $query['ID'];?>" style="display: none;">
<?php
  echo $query['Youtube'];
  echo "</div>";
?>
<a href="javascript:ReverseDisplay('<?php echo $query['ID'];?>')">Click to show/hide trailer.</a>
<?php
  echo "</H2>";
  echo "<br /> <br />";

    $i++;
    $count++;
}

// call pagination function:
include("paginate_one.php");
echo paginate_one($reload, $page, $tpages);
?>

<?php
////////////////////////////////
//SCRIPT FOR SHOW/HIDE TRAILER//
////////////////////////////////
?>

<script type="text/javascript" language="JavaScript"><!--
function HideContent(d) {
document.getElementById(d).style.display = "none";
}
function ShowContent(d) {
document.getElementById(d).style.display = "block";
}
function ReverseDisplay(d) {
if(document.getElementById(d).style.display == "none") { document.getElementById(d).style.display = "block"; }
else { document.getElementById(d).style.display = "none"; }
}
//--></script>

paginate_one.php
<?php
/*************************************************************************
php easy :: pagination scripts set - Version One
==========================================================================
Author:      php easy code, www.phpeasycode.com
Web Site:    http://www.phpeasycode.com
Contact:     webmaster@phpeasycode.com
*************************************************************************/
function paginate_one($reload, $page, $tpages) {

$firstlabel = "First";
$prevlabel  = "Prev";
$nextlabel  = "Next";
$lastlabel  = "Last";

$out = "<div class=\"pagin\">\n";

// first
if($page>1) {
$out.= "<a href=\"" . $reload . "\">" . $firstlabel . "</a>\n";
}
else {
$out.= "<span>" . $firstlabel . "</span>\n";
}

// previous
if($page==1) {
$out.= "<span>" . $prevlabel . "</span>\n";
}
elseif($page==2) {
$out.= "<a href=\"" . $reload . "\">" . $prevlabel . "</a>\n";
}
else {
$out.= "<a href=\"" . $reload . "&amp;page=" . ($page-1) . "\">" . $prevlabel . "</a>\n";
}

// current
$out.= "<span class=\"current\">Page " . $page . " of " . $tpages . "</span>\n";

// next
if($page<$tpages) {
$out.= "<a href=\"" . $reload . "&amp;page=" .($page+1) . "\">" . $nextlabel . "</a>\n";
}
else {
$out.= "<span>" . $nextlabel . "</span>\n";
}

// last
if($page<$tpages) {
$out.= "<a href=\"" . $reload . "&amp;page=" . $tpages . "\">" . $lastlabel . "</a>\n";
}
else {
$out.= "<span>" . $lastlabel . "</span>\n";
}

$out.= "</div>";

return $out;
}
?>

Here you can view a test of it all in action: http://www.mansgullberg.com/test.php please dont hack my site

I'm thankfull for all of your answers! Really nice forum this! 

/kvickan

i am trying to add a like system to my forum similar to facebook where it shows how many people like a post.

this is my code so far:

$like_list = "";
            
            $likes = explode("|", $post_info['post_likes']);
            $amount_likes = count($likes);
            $ac_likes = ($amount_likes / 2);
            $slice = array_slice($likes, 0, 4, true);
            $remain = array_slice($likes, 4, $ac_likes, true);
            $remain_num = count($remain);
            
            if ($ac_likes >= 4)
            {
                for($i=0; $i<$ac_likes; $i+=2)
                {
                    $like_list .= $likes[$i].", ";
                }
                $like_list .= " and $remain_num others like this";
            }
            elseif ($amount_likes == 1    )
            {
                $like_list .= "0 people like this";
            }
            elseif ($ac_likes == 1)
            {
                $like_list = implode(", ", $likes);
                $like_list .= " likes this";
            }
            else
            {
                $like_list = implode(", ", $likes);
                $like_list .= " like this";
            }

$post_info['post_likes'] contains data like:

Code: [Select]
user1|123456789|user2|123456789
where the number is the timestamp.

unfortunatly $like_list prints the username and the timestamp when i would like it to only display the username. This means
printing every 2nd element in the array starting from 0. I have seen this done with for loops but i am not using one therefore i am stuck. Any ideas? and is this the best database setup for likes? the post_likes column is added on to the end of the post table.

  Hi this is my login script i do have the html if you need to see it please ask & i was wondering if anyone would be kind enough to tell me how i can get my ban system to work Thanks

<?php

require 'connect.php';

if(isset($_POST['submit'])) {

	$username = $_POST['username'];
	$password = $_POST['password'];

	//Prevent hackers from using SQL Injection
	$username = stripslashes($username);
	$password = stripslashes($password);
	$username = mysql_real_escape_string($username);
	$password = mysql_real_escape_string($password);

	$sql = "SELECT * FROM $tbl_name WHERE username='$username' AND password='$password'";
	$result = mysql_query($sql);
	$count = mysql_num_rows($result);

	$user_level = $_GET['user_level'];

	$_SESSION['user_level'] = $user_level;

	if($count == 1) {

		$_SESSION['username'];
		$_SESSION['password'];
		header("Location: index.php");
	} else {

		echo "Please check the username and password you entered is correct.";
	} if($_SESSION['user_level'] == 0) {
		$_SESSION['username'];
		$_SESSION['password'];
		header("Location: index.php");
		
	} else if($_SESSION['user_level'] == -1) {

		die();
		header("Location: banned.php");

	} else if($_SESSION['user_level'] < -1) {
		die();
		echo "An error has occurred please contact your administrator.";

	} else if($_SESSION['user_level'] == 1) {
		$_SESSION['username'];
		$_SESSION['password'];
		header("Location: admin.php");

	}


}

?>

Edited by Tom8001, 23 November 2014 - 12:18 PM.