I have a birthdays.php running on a seperate webserver and just get xibo to view that webpage :-) Just a basic LAMP server nothing special, runs several websites, including wordpress, but the birthdays.php just sits in its own folder and works :-)
Hope this helps
We get Xibo to display an external webpage running on a webserver. Nothing embedded.Originally Posted by cleverleyson
Ahhh Cheers for the advice, I still get get it to work tho! been trying to find out why i get the error message
"
"Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\birthdays\Birthdays.php on line 48
No birthday's today!"
I think it might be the way ive setup the tables? I think its something simple. Losing alot of time to this already!
"
what is your host setup? thats looking for an absolute path - is that written in the code (i've not seen it)
Im using the code posted from above.
<?php
include('config.php');
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-image: url(Background.png);
background-repeat: no-repeat;
}
body,td,th {
font-family: "Segoe UI Light";
color: #000;
font-size: large;
}
</style>
</head>
<body>
<p><br />
</p>
<p> </p>
<p> </p>
<p> </p>
<p><br />
<br />
</p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5%" height="303"> </td>
<td width="62%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="265" valign="top"><h1>
<br />
<?php
$myDate = date('d/m');
$badgesql = mysql_query("SELECT * FROM birthdays.students WHERE `Date` LIKE '%$myDate%'"); // birthdays is the DB, the table is called students - you can change these
$badgecheck = mysql_num_rows($badgesql);
$check = $badgecheck;
if($check==0)
echo('No birthday\'s today!');
else
if($badgecheck!=0)
{
while($badge = mysql_fetch_array($badgesql))
{
echo(''.$badge[Firstname].' '.$badge[Surname].'<br>');
}
}The database is on the same server as xibo server, hence localhost. could it be the the tables need to be a type (its text atm) Also Would i need to move the year from date?<?
$host = "localhost"; // if the database is locally installed
$dbuser = "'Birthdays";
$dbpwd = "XXXX";
$db = "birthdays."; // this is the database name
$connect = mysql_pconnect($host, $dbuser, $dbpwd);
if(!$connect)
echo("Could not connect to database...");
else
$select = mysql_select_db($db);
?>
Last edited by cleverleyson; 1st March 2013 at 12:04 PM.
@cleverleyson I had this error. In the table, is the column with the dates in called dob? I had mine called "Date of Birth" but once renamed to "Date" to match the code it worked. I set my First/Last name columns to VARCHAR and the DOB to Date.
Last edited by MHUK; 4th March 2013 at 08:48 AM.
Just as a FYI you could have also changed the SQL query to match the database column name...
From:
To:Code:$badgesql = mysql_query("SELECT * FROM birthdays.students WHERE `Date` LIKE '%$myDate%'")
This may make it easier to work out in the future if you ever come back to it as the DB column name will be what your expecting it to be (i.e a DOB).Code:$badgesql = mysql_query("SELECT * FROM birthdays.students WHERE `Date of Birth` LIKE '%$myDate%'")
The reason for the error is that your code is expecting a result of some number of rows but you had an error in the query which the mysql_num_rows() couldn't interpret. You could prevent this with something like:
Code:$badgesql = "SELECT * FROM birthdays.students WHERE `Date of Birth` LIKE '%$myDate%'" if (mysql_query($badgesql)){ echo "This Worked - Continue Code Here"; }else{ echo "This Failed - Exit Code Here: " . mysql_error(); exit(); }
Last edited by jaminben; 5th March 2013 at 07:50 PM.
MHUK (6th March 2013)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks