[insert_php]
echo ‚Server date and time is: ‚;
echo date(‚l, F j, Y \a\t G:i:s‘);
[/insert_php]

[insert_php]
$table_name = ‚pracovnici2‘;
$results = $wpdb->get_results( „SELECT * FROM $table_name“); // Query to fetch data from database table and storing in $results
if(!empty($results)) // Checking if $results have some values or not
{
echo „

„; // Adding

and

tag outside foreach loop so that it wont create again and again
echo „

„;
foreach($results as $row){
$id = $row->id; //putting the user_ip field value in variable to use it later in update query
echo „

„; // Adding rows of table inside foreach loop
echo „

“ . „

„;
echo „

„;
echo „

„;
echo „

„;
echo „

“ . „

„; //fetching data from user_ip field
echo „

„;
}
echo „

„;
echo „

ID “ . $row->id . „

Jméno “ . $row->jmeno . „

„;

}

[/insert_php]

[insert_php]
echo ‚Server date and time is: ‚;
echo date(‚l, F j, Y \a\t G:i:s‘);
[/insert_php]

[insert_php]

//connect To Database $hostname=’xxxx‘;
$username= ‚xxxx‘;
$password=’xxxx‘;
$dbname= ‚xxxx‘;
$usertable=’xxxx‘;
mysql_connect($hostname,$username, $password) OR DIE (‚Unable to connect to database! Please try again later.1);
mysql_select_db($dbname);
echo “

„; echo „

„; echo „

“;

echo „

„;

echo „

First Name First Name Last Name Emaik/thx/tr>“;
$query = ‚SELECT FirstName, LastName FROM 1 . $usertable;
$result = mysql_query($query); if($result) {
while($row = mysql_fetch_array($result)){ echo „

“ . $row[‚FirstName‘] . „ “ . $row[‚LastName‘] . „ /td>“;
echo „

„;

[/insert_php]