Jump to content
php.lv forumi

Recommended Posts

  • Replies 53
  • Created
  • Last Reply

Top Posters In This Topic

Posted

neticu, ja pat mysql neko neatgrieztu, jabut divam izvaditam View->Page Source (Ctrl+U). Sourca divs ir?

Posted (edited)

Luk ko rada Source koda

<div id="userlist"></div>

un ka man ir tas vis uzrakstic

<?
	define('WWW','www');
       if (!defined('WWW')) { header('Location: http://'.$_SERVER['HTTP_HOST'].''); die(); }

       $link = mysql_connect($INFO['sql_host'],$INFO['sql_user'],$INFO['sql_pass']);
       mysql_query('use '.$INFO['sql_database'].';');

       $page = '<div id="userlist">';
       $result = mysql_query('select t1.id,t1.members_display_name,t2.avatar_location from '.$INFO['sql_tbl_prefix'].'members t1 join '.$INFO['sql_tbl_prefix'].'member_extra t2 on (t1.id = t2.id) limit 10;');
       if (!empty($result)) {
               while ($r = mysql_fetch_array($result)) {
                        $page .='<p>
                                       <a href="'.WWW.'forum/index.php?showuser='.$r[0].'">
                                       <img class="avatar" src="'.WWW.'forum/uploads/'.$r[2].'" alt="'.$r[1].'" />
                                       '.$r[1].'</a>
                               </p>';
               }
       }
$page .='</div>';
echo $page;
mysql_close($link); 
error_reporting(E_ALL);
ini_set('display_errors', 1);
?>

Edited by GeRik
Posted (edited)

gan jau mysql pieprasijuma kluda, vai pat konekciju neveido.

 

ps. tas bus ilgi

Edited by cucumber
Posted (edited)

Luk nu kas man sanaca tagad

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
$sql_host = "localhost";
$sql_user = "root";
$sql_pass = "";
$sql_database = "forum";
	define('WWW','www');
       if (!defined('WWW')) { header('Location: http://'.$_SERVER['HTTP_HOST'].''); die(); }

       $link = mysql_connect($INFO['sql_host'],$INFO['sql_user'],$INFO['sql_pass']);
       mysql_query('use '.$INFO['sql_database'].';');

       $page = '<div id="userlist">';
       $result = mysql_query('select t1.id,t1.members_display_name,t2.avatar_location from '.$INFO['sql_tbl_prefix'].'members t1 join '.$INFO['sql_tbl_prefix'].'member_extra t2 on (t1.id = t2.id) limit 10;');
       if (!empty($result)) {
               while ($r = mysql_fetch_array($result)) {
                        $page .='<p>
                                       <a href="'.WWW.'forum/index.php?showuser='.$r[0].'">
                                       <img class="avatar" src="'.WWW.'forum/uploads/'.$r[2].'" alt="'.$r[1].'" />
                                       '.$r[1].'</a>
                               </p>';
               }
       }
$page .='</div>';
echo $page;
mysql_close($link); 
?>

un lapa rada tagad


Notice: Undefined variable: INFO in C:\AppServ\www\lietotaji.php on line 11

Notice: Undefined variable: INFO in C:\AppServ\www\lietotaji.php on line 11

Notice: Undefined variable: INFO in C:\AppServ\www\lietotaji.php on line 11

Notice: Undefined variable: INFO in C:\AppServ\www\lietotaji.php on line 12

Notice: Undefined variable: INFO in C:\AppServ\www\lietotaji.php on line 15

Notice: Undefined variable: INFO in C:\AppServ\www\lietotaji.php on line 15

Edited by GeRik
Posted

nu ja tu esi uztaisijis vienkarhsu skriptu lietotaji.php, un neesi vinu sasaistisjis ar foruma globaliem mainigiem.

Posted

GeRik, lūdzu parādi to vietu, kur esi definējis tādu $INFO masīvu un kur esi piešķīris dažādiem tā elementiem (kā, piemēram $INFO['sql_host']) vērtības.

Posted (edited)

GeRik, lūdzu parādi to vietu, kur esi definējis tādu $INFO masīvu un kur esi piešķīris dažādiem tā elementiem (kā, piemēram $INFO['sql_host']) vērtības.

 

Tur jau ir tas joks, ka vinsh to skriptu laiz ka single failu. Nemak failus includet ari, isak sakot nodarbojas ar kombinatoriku.

Edited by cucumber
Posted

Nodefineju itka vis aizgaja bet neuzrada visus memberus un ka vinjus varetu sadalit pa lapam ?

Posted

LIMIT 10 - rūpējas par visu memberu neparādīšanu.

Attiecībā par sadalīšanu vairākās lapās... Ir tēma ar nosaukumu: Neliels foruma tēmu apkopojums no arhīva sadaļas - tajā ir norādes uz šīs vajadzības atrisināšanu.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...