Jump to content
  • 0

[help] php - print on webpage


claww
 Share

Question

anyone can help me at how to print something from data base on webpage

 

Example:

 

currency.png

 

 

so i want to print these dates on webpage     you know what i mean as to TOP PVP / PK... etc

 

i dont know php language...

 

must look smth like that inside php source...

 

Currency: <? print ("currency"); ?> Adena : <? print ("adena") ?> Status : <? print ("status"); ?>

i understand this language but i dont know to write it,,,

i know i didnt write correct the codes but i do that mby u will understand about what i talking...

 

and on web page must lookiong

 

Currency: Festival Adena Adena: 20bilion Status: -

 

i hope u understand what i need and mby someone can help me.....

 

 

 

 

look here i want to add that in ths file

 

"

<?php  include "config/stats.php" ?>

<?php

 

//Online Players

$query = ("SELECT * FROM characters WHERE online=1 and accesslevel>=0");

 

$result = mysql_query($query) or die(mysql_error());

 

$num2=mysql_numrows($result);

$sum=$num2;

 

//Currency

i dont know what to write here

 

?>

Online Players: <?php print ("$num2"); ?><br>

Currency: "  dont know " Adena: "dont know " Status : "dont know" <br> "

Currency: "  dont know " Adena: "dont know " Status : "dont know" <br> "

Link to comment
Share on other sites

7 answers to this question

Recommended Posts

  • 0

He wants to get values from table and put them on website :\

 

I cant understand couse he is giving me an example for greather value..

I mean if the item is more expensive it should be at top or what ?

Link to comment
Share on other sites

  • 0

nop... just print dates from tabel which i post in my 1st post here

 

and i want as all time when dates changes in this table to change on webpage too.... i dont want to print by top which is expensive....  just print the dates from table on webpage

 

look i want to print dates from

 

HERE

 

currency.png

 

TO HERE ON WEBPAGE

 

http://img149.imageshack.us/i/75679269.png/

 

Link to comment
Share on other sites

  • 0

i did it... i will post the code mby someone wanna print information from database on website

 

 

<?php
$db_host = 'localhost';
$db_user = 'root';
$db_pwd = 'database_password';

$database = 'database_name';
$table = 'table_name'; <!-- table name which you wanna print on website.... -->

if (!mysql_connect($db_host, $db_user, $db_pwd))
   die("Can't connect to database");

if (!mysql_select_db($database))
   die("Can't select database");

// trimitere interogare
$result = mysql_query("SELECT * FROM {$table}");
if (!$result) {
   die("Query to show fields from table failed");
}

$fields_num = mysql_num_fields($result);

echo "<h1>Table: {$table}</h1>";
echo "<table border='1'><tr>";
// printeaza titlu tabelului
for($i=0; $i<$fields_num; $i++)
{
   $field = mysql_fetch_field($result);
   echo "<td>{$field->name}</td>";
}
echo "</tr>\n";
// printeaza randurile tabelului
while($row = mysql_fetch_row($result))
{
   echo "<tr>";
    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
   foreach($row as $cell)
       echo "<td>$cell</td>";

   echo "</tr>\n";
}
mysql_free_result($result);
?>

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share



×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disbaled AdBlock