Skrypt Do Podziału Na Strony.

traktor · 26 Listopada 2008

Witam,

Mam taki skrypt do podziału na strony, ale jak widzę jest on oparty o bazę danych. Problem polega na tym, że nie ma w nim chyba miejsc na wpisanie usera, nazwy bazy, hosta i hasla.

Podejrzewam, ze w require trzeba podac strone ktora ma byc dzielona.

Oto skrypt:

<?php // start database processrequire "my_global.php";// variables needed for this script// you will not need to change this variables$num = 0;$page_number = 1;$number_of_pages = 1;// The only variable you will need to change is to// set the total number of rows you want to display on a single Web page$total_num_rows_to_show = 25;// retreive the number of rows in the database table$result = mysql_query("SELECT applicant_pid FROM $tablename_21");$number_of_rows = mysql_num_rows($result);// divide the number of rows in the table with the total number of rows to show$number_of_pages = $number_of_rows / $total_num_rows_to_show;// if there is any remaining data to show// add one page to the total number of pages$remaining_number_of_data = $number_of_rows % $total_num_rows_to_show;if ($remaining_number_of_data <= "1") {	$number_of_pages = $number_of_pages + 1;} // end if ($remaining_number_of_data <= "1")// set the minimum number receive data for each pageif ($page <= "1") {	$page = 1;	$min_num = 0;} else {	$min_num = $total_num_rows_to_show * $page;} // end if ($page <= "1")// set the maximum number to stop data for each page$max_num = $total_num_rows_to_show * $page;// set up the display for the page links that will show at the bottom // of the page.if ($number_of_pages <= "1") {	$option_block_2 .= "";} else {	for ($i = 0; $i < $number_of_pages; $i++) {		if (($i == "0") && ($page <= "$number_of_pages")) {			$next_page = $page_number + 1;			if ($page != "$number_of_rows") {			$option_block_2 .= "			<a href=\"./consultant_list_short.php?page=$next_page\">[ NEXT ] </a>";			}			$option_block_2 .= "			<a href=\"./consultant_list_short.php?page=$page_number\">$page_number</a>";		} else  {			if ($page <= "$number_of_pages") {			$page_number = $page_number + 1;			$option_block_2 .= "			<a href=\"./consultant_list_short.php?page=$page_number\">			$page_number</a>";			} // end if ($page <= "$number_of_pages")		} // end if (($i == "0") && ($page <= "$number_of_pages")))	} // end for ($i = 0; $i <= $number_of_pages; $i++)	if ($number_of_rows >= "2") {		if ($page <= "1") {			$prev_number = $page_number - 1;		} else {			$prev_number = $page - 1;		} // end if ($page <= "1")		$option_block_2 .= "		<a href=\"./consultant_list_short.php?page=$prev_number\"> [ PREV ]</a>";	} // end if ($number_of_rows >= "2")} // end if ($number_of_rows <= "$total_num_rows_to_show")// start retreiving data form the database$sql_0 = mysql_query("SELECT data FROM $tablename_21 ORDER BY LAST, FIRST ");if(!$sql_0) {   print mysql_errno(). ": ".mysql_error(). "<br />Can't execute sql_0 query.";exit();} // end if(!$sql_0)while (list($business_name, $FIRST, $MID_INT, $LAST, $JRSRETC,            $job_description) = mysql_fetch_row($sql_0)) {$num++;$option_block_1 .= "<tr><td width=\"60%\" valign=\"top\">					<b class=\"smablue\">Company Name:</b>					$business_name</a></td>					<td width=\"40%\" valign=\"top\">					<b class=\"smablue\">Name:</b> 					$FIRST $MID_INT $LAST $JRSRETC</td></tr>					<tr><td colspan=\"2\" valign=\"top\">					$job_description					<p><hr width=\"100%\"></p></td>";} // end while (list() = mysql_fetch_row($sql_0))if ($num == "0") {$option_block_1 .= "<br><b class=\"smablue\">Ther are no Consultants to list at this point in time.<br><br> Please check back.</b>";} // end if ($num == "0")$display_block_1 = "<table align=\"center\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\"><tr><td colspan=\"2\" valign=\"top\"><b class=\"medred\">Click on the company name to view more information.</b></td></tr><tr><td colspan=\"2\" align=\"center\"><p><hr width=\"100%\"></p></td></tr>$option_block_1</tr></table><br>$option_block_2"; // end Display_block?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head>	<title>Script Template</title></head><body><table align="center" width="95%" cellspacing="0" cellpadding="0" border="0"><tr>    <td align="center" valign="top">	<table align="center" width="100%" cellspacing="0" cellpadding="10" border="2" frame="box" rules="all" bgcolor="#87cefa">	<tr>	    <td align="center" valign="middle"><h1>Consultant List</h1></td>	</tr>	</table></td></tr><tr>	<td align="center" valign="top">	<br>	<?php echo ("$display_block_1"); ?></td></tr></table></body></html></body></html>

A oto strona której wyrzuca błędy:

SKRYPT

m4r · 26 Listopada 2008

konfig do bazy masz zapewne tutaj:

require "my_global.php";

tudzież w jakimś pliku includowanym wewnątrz my_global.php- szukaj.

Żadnej strony raczej się nie podaje do podziału (chyba że ktoś się uprze). Include spowoduje ci jedynie wyświetlenie pliku który podasz, ale będzie on wyświeltony w całości.

Tutaj masz dane z bazy i tylko takie będą podzielone.

Zaloguj się

Skrypt Do Podziału Na Strony.

Rekomendowane odpowiedzi

traktor

Udostępnij tę odpowiedź

Odnośnik do odpowiedzi

Udostępnij na innych stronach

m4r

Udostępnij tę odpowiedź

Odnośnik do odpowiedzi

Udostępnij na innych stronach

Dołącz do dyskusji

Przeglądaj

Cała aktywność