Linux, Apache, MySQL, PHP

6-Mar-10 14:15

Hello, my problem is the following: i have a query with 3 results from a database where i store a school timetable datas such as professors, courses etc...I try to put this results in a html tabel dynamic via php.So, for exemple i have courses from 8 to 10, 10 - 12 and 17 - 19.I have "if" conditions in while loop that allow me to verify if i have a course at x hour.If i dont have course at x hour i want to fill the table with empty cell " ".But the real problem is that when i try to do this while loop is displaying the tested conditions plus empty rows cuz of else condition , ofc it is doing like this cuz if the query has x results he will construct x times those empty rows...i dont know if somebody is understanding me and what i need to do.I will attach a piece of code here:

while($linie = mysql_fetch_assoc($rez))
{

if($linie['ziua'] == "Luni")
{

$orastart = $linie['orastart'];
$orafinal = $linie['orafinal'];
$nume_curs = $linie['nume_curs'];
$prof_name = $linie['prof_name'];
$nume_grupa = $linie['nume_grupa'];

if($orastart == "8" && $orafinal <= "10")
{
echo "<tr><td>8 - 9</td><td rowspan = '2'>".$nume_curs."<br />".$prof_name."<br />".$nume_grupa."</td></tr>";
echo "<tr><td>9 - 10</td></tr>";
}

else echo "<tr><td>8 - 9</td><td> </td></tr>
<tr><td>9 - 10</td><td> </td></tr>";

if($orastart >= "10" && $orasfarsit <= "12" )
echo "<tr><td>10 - 11</td><td rowspan = '2'>".$nume_curs."<br />".$prof_name."<br />".$nume_grupa."</td></tr>
<tr><td>11 - 12</td><td> </td></tr>";

else echo "<tr><td>10 - 11</td><td> </td></tr>
<tr><td>11 - 12</td><td> </td></tr>";

}
}

echo "</table>";

Luc Pattyn6-Mar-10 14:38

Luc Pattyn

6-Mar-10 14:38

The trick is to get the cells of the table in the right order. There are many ways to do so.

1.
use a two-dimensional array; fetch the database results (order does not matter); loop over them filling the array; when filled, start creating the table from the array.

2.
use a one-dimensional array representing one day; for each day, fetch the database results for that day only; fill the array; now generate HTML for one row.

3.
fetch all the database results in chronological order (use an ORDER BY clause). Now start reading the results and create your array; start a new row when day does not equal previous day; insert one or more empty cells when time chunks aren't consecutive; etc.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.

pelikan20027-Mar-10 0:53

7-Mar-10 0:53

ty for u'r fast answer i rly aprishiate.I will come back with news :P

pelikan20027-Mar-10 5:22

7-Mar-10 5:22

i tryed u'r first method but i am a little bit confused in creating the array.Here is what i tryed:

$rezultate = array();

while($linie = mysql_fetch_assoc($rez))
{

$rezultate[] = $linie;
}//while
if($rezultate[0]['orastart'] == "8" && $rezultate[0]['orastart'] <= "10")
{
echo "<tr><td>8 - 9</td><td rowspan = '2'>".$nume_curs."<br />".$prof_name."<br />".$nume_grupa."</td></tr>";
echo "<tr><td>9 - 10</td></tr>";
}

else echo "<tr><td>8 - 9</td><td> </td></tr>
<tr><td>10 - 11</td><td> </td></tr>";

u can see how i acces the elements from array but i want to acces different, something like this:

if($rezultate[$i]['orastart'] == "8" && $rezultate[$i]['orastart'] <= "10")

Luc Pattyn7-Mar-10 8:45

Luc Pattyn

7-Mar-10 8:45

pelikan2002 wrote:
$rezultate[] = $linie;

that is completely wrong.

in that scheme you need a 2D array, which you give dimensions according to number of days and number of time periods in a day; then iterate over all database results and fill the corresponding cell of the array.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.

pelikan200211-Mar-10 5:05

11-Mar-10 5:05

ok...i quited first method cuz i have no idea how to do it, but u'r second method sounds better because my sql query is how u told me just for 1 day.My query is :

SELECT classes.day, classes.starthour, classes.finalhour, course.nume_curs, proffessor.prof_name,groups.group_name
                     FROM classes, proffessor, course,groups
                     WHERE classes.profid = proffessor.profid
                     AND course.coursid = classes.courseid
                     AND classes.groupid = groups.groupid
                                         AND classes.day = 'Monday'

.Here is a print with my results What i dont understand is what do u mean by "creating one row" and can u give me an exemple how that array should look?.Thank you

Luc Pattyn11-Mar-10 5:13

Luc Pattyn

11-Mar-10 5:13

I'm not going to give PHP code; what follows is pseudo-code to create one HTML table row between firstHour and lastHour:

0. create an empty array representing the relevant hours (or quarters or whatever time unit you choose) for one day.
1. run your SQL query for that day
2. foreach result from SQL query mark the hour(s) in the array
3. now generate HTML code for one row of your HTML table, starting with TR tag
4. foreach hour between firstHour and lastHour look in your array and create either an empty table cell, or a filled table cell using TD tag, P tag, etc.
5. close table row with /TR tag

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.

pelikan200211-Mar-10 5:19

11-Mar-10 5:19

thank you very much for ur pseudo-code sir.This is very usefull.

Integer conversion for dummies

PHP_Guy19-Mar-10 7:32

PHP_Guy

19-Mar-10 7:32

ok ..

you end with
<pre>
echo "</table>";</pre>

<code>but where is the start "<table>" tag ?</code>

=======================
<pre>echo "<table border=1>";

if($orastart == "8" && $orafinal <= "10")
{
echo "<tr><td>8 - 9</td><td rowspan = '2'>".$nume_curs."<br />".$prof_name."<br />".$nume_grupa."</td></tr>";
echo "<tr><td>9 - 10</td></tr>";
}

else echo "<tr><td>8 - 9</td><td>&nbsp;</td></tr>
<tr><td>9 - 10</td><td>&nbsp;</td></tr>";

if($orastart >= "10" && $orasfarsit <= "12" )
echo "<tr><td>10 - 11</td><td rowspan = '2'>".$nume_curs."<br />".$prof_name."<br />".$nume_grupa."</td></tr>
<tr><td>11 - 12</td><td>&nbsp;</td></tr>";

else echo "<tr><td>10 - 11</td><td>&nbsp;</td></tr>
<tr><td>11 - 12</td><td>&nbsp;</td></tr>";

}
}

echo "</table>";</pre>

Jack Vanderhorst6-Mar-10 4:14

Jack Vanderhorst

6-Mar-10 4:14

I'm successfully calling a mysql stored procedure using PDO with the following line:

$pdoCmd->fetch(PDO::FETCH_OBJ)

It returns an object that I need to get converted into an integer, seems straightforward enough but when the object is say "1000" and I cast to an int I get a value of 1.

How can I convert an object to an integer and keep my zeroes?

Re: Integer conversion for dummies

Jack Vanderhorst6-Mar-10 4:31

Jack Vanderhorst

6-Mar-10 4:31

Think I figured it out:

$objResult = $pdoCmd->fetch(PDO::FETCH_OBJ);
$intValue = (int)$objResult->MyColumnName;

Cheers

Detect when Tomcat Startup

bilal.hobnail5-Mar-10 1:08

bilal.hobnail

5-Mar-10 1:08

Dear all,

any one can help me.....!

Problem: i have window base server where tomcat is installed.i want to detect tomcat when start up. i want to run bat file when tomcat start up.

tell me how i configure Apache tomcat what should be the solution?

behind the reason of this problem is ..i want to call http url when tomcat start.
i will write http url in bat file and i want this bat file will be execute when tomcat start.

How to connect Tata indicom USB modem in fedora 9

Tripathi Sushant S4-Mar-10 5:56

Tripathi Sushant S

4-Mar-10 5:56

due to lack of software they have provided which is not working on fedora
how TO install it Confused | :confused:

Re: How to connect Tata indicom USB modem in fedora 9

HimanshuJoshi18-Mar-10 23:20

HimanshuJoshi

18-Mar-10 23:20

Maybe this[^] can help

"I'm willing to admit that I may not always be right, but I am never wrong." - Samuel Goldwyn

Mysql connectivity with C program in fedora 9

Tripathi Sushant S4-Mar-10 5:50

Tripathi Sushant S

4-Mar-10 5:50

there is an error that ~lmysqlclient not found
HELP with sample Coding example
and compiling procedure Cry | :((

Re: Mysql connectivity with C program in fedora 9

Graham Breach4-Mar-10 8:11

Graham Breach

4-Mar-10 8:11

Make sure you have the mysql-devel RPM installed.

Embed php forms or flash into facebook, step by step

sharkbc3-Mar-10 23:21

sharkbc

3-Mar-10 23:21

Hi friends !

We have already html forms or flash file(.swf).
How can we do to "Embed html forms or flash into facebook".

Any ideas or link to do it step by step!

Thanks !

Newbie to PHP

offroaderdan2-Mar-10 22:53

offroaderdan

2-Mar-10 22:53

Hi,

I have a vb program which communicates with PHP but cut long story short it works Smile | :)

What i want to know is if i develop this PH further can i create a login screen on the internet and allow the user to amend records?

e.g if a teacher did a register of a class and messed it up could they login online and edit the absent and present column?

Please note i am new to PHP!

Thanks

Dan

Graham Breach3-Mar-10 0:33

Graham Breach

3-Mar-10 0:33

The answer is "maybe"...

If the records you want to amend are stored in a database that you have access to using PHP, then you can do whatever you like with them, assuming you have the required permissions.

Sorry the answer is a bit vague, but you asked quite a vague question.

chevu3-Mar-10 1:11

chevu

3-Mar-10 1:11

Ya you can do it.
But you need to store userid and password.
If you want to use database then you can refer these links:
http://php.thedemosite.co.uk/login.php[^]
http://www.phpeasystep.com/phptu/6.html[^]
http://www.devshed.com/c/a/PHP/Creating-a-Secure-PHP-Login-Script/[^]

If you dont want to use any database then you can do one thing(Try not to use this method). Make a text file at server side and read it to check id and password. But make sure that you set appropriate permission for that text file.

offroaderdan3-Mar-10 3:01

offroaderdan

3-Mar-10 3:01

Awesome thanks,

So how would I go about allowing one of the columns to be edited? How do i allow the permissions?

Thanks again

Dan

Eddy Vluggen3-Mar-10 7:00

Eddy Vluggen

3-Mar-10 7:00

offroaderdan wrote:
So how would I go about allowing one of the columns to be edited? How do i allow the permissions?

You'll also need a webserver. Think IIS if you're on Windows, Apache if you're on Linux. Next, you'd need to test if PHP is configured correctly to work with your database-setup.

W3Schools would be a good place to start, they've got examples on interacting with a database to get you started[^] Smile | :)

I are Troll Suspicious | :suss: