Jump to content
GIGN Forum

Utf-8


Recommended Posts

Sveicināti ,man ir divi jautājumiņi.

Pirmais :

* Es esmu uzlicis teksta failu kā UTF-8 ,bet tikum tā man rāda šādi jaunumus no foruma

untitled.PNG

Teksta fails ir

<!-- jaunumu skripts caur invision power board, veidoja duplets, apmekleejiet http://cs.hackers.lv --> 
<?php

//------------------------------------------------------------------------------------------------ 
// "ipb news to webstite" script by duplets visit http://cs.hackers.lv 
//------------------------------------------------------------------------------------------------ 

$forums = "http://boosts.oo.lv/f"; // noraadam urliiti uz forumu
$limits = "5"; // topiku limits jaunumos
$forumaID = "9"; // forums no kura velkam aaraa jaunumus
$host = "localhost";
$dbname = "boost.lv";
$dbuser = "*********";
$dbpass = "********";
$link = mysql_connect($host, $dbuser, $dbpass)
or die("NEsanaaca piekontektities: " . mysql_error());
mysql_select_db($dbname) or die("Datubaaze neekstistee");
mysql_query("SET NAMES utf8"); // diezgan noziimiigs kveriijs, ja nee sh un zh vietaa buus nesmuki kjeburi

// dabuunam datus no DB
$kverisdivi = mysql_query("SELECT * FROM ibf_topics WHERE forum_id=".$forumaID." ORDER BY start_date DESC LIMIT ".$limits.""); // shito nedriikst aizmirst, ja nee baigiee suudi ar charstetiem iznaaks 

echo "<h1>Jaunumi</h1><br><br>";
// izvadam jaunumus
while($row = mysql_fetch_array( $kverisdivi )) {
  $rowis = mysql_fetch_array( mysql_query("SELECT * FROM ibf_posts WHERE topic_id = ".$row['tid']." ORDER by post_date LIMIT ".$limits.""));


    echo "<h3><a href=\"$forums/index.php?showtopic=".$row['tid']."\">".$row['title']."</a> <br><br><br /></h3>"; 
    echo "<div>".$rowis['post']."</div><br />";
    echo "<div>autors: <a href=\"$forums/index.php?showuser=".$row['starter_id']."\">".$row['starter_name']."</a></div><br><br><hr>"; 


} 

?>

otrs jautājums :

Es uzliku scriptu ,kas parāda visus jaunākos rakstus forumā ,bet rādās šādi

untitled.PNG

Kods

<?php
$platums = "160"; // platums px
$forums = "http://boosts.oo.lv/f"; // foruma url
$limits = "4"; // cik daudz jaunumi uzradisies
$host = "localhost"; // db hosts
$dbname = "*******"; // foruma datubaze
$dbuser = "********"; // foruma db users
$dbpass = "********"; // juusu foruma datubaazes parole
$link = mysql_connect($host, $dbuser, $dbpass)
or die("NEsanaaca piekontektities: " . mysql_error());
mysql_select_db($dbname) or die("Datubaaze neekstistee");
mysql_query("SET NAMES UTF-8"); // lai rada LV alfabetu

// dabuunam datus no DB
$kverisdivi = mysql_query("SELECT posts, last_poster_name, last_poster_id, title, tid, forum_id, last_post FROM ibf_topics ORDER

BY last_post DESC LIMIT ".$limits."");
echo "<div>";
// izvadam jaunumus
while($row = mysql_fetch_array( $kverisdivi )) {

echo "<p><u> <a style='font-size:10pt' href=\"$forums/index.php?showtopic=".$row[tid]."&view=getnewpost\"

title=\"\">".$row[title]."</a><br>
<a style='text-decoration: none' href=\"$forums/index.php?showuser=".$row[last_poster_id]."\"

title=\"\">"."</a></p>";
}
echo "</div>"
;

Lūdzu palīdziet :D

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share

×
×
  • Create New...