Linux, Apache, MySQL, PHP

11-Mar-10 5:19

Hello everyone, I am a newbie to php. I have been learning it and it is going well.
I have a php webpage, where there are textforms, dropdown list and stuff. There is Activity field in the database. Whatever activities that i do on the webpage, like modifying the text in the textbox, or changing a value for a dropdown list, these need to be automatically entered into the activity text in the database. Like this it happens only for one page.

Like for example, if i change a project name field and change status to 'Important' from 'Normal', then it needs to make an entry into the Activity field like:

On date:yyyy/mm/dd Project name has been changed to 'New Project' and status has been changed to 'Important'.

I think this can be achieved with stored procedures or i might be wrong.
I would really appreciate if someone could write down a sample code for me regarding this.

PHP_Guy19-Mar-10 7:46

19-Mar-10 7:46

you can make a form from HTML for Edit name and state ..

anyway put a hidden value for time .. and use that time to query the database and inject the new value Smile | :)

scorpio2222-Mar-10 4:25

22-Mar-10 4:25

I want it to be doing automatically, like there are many other textboxes and dropdown lists in the page and i do not which one the user will be modifying so i cannot right one query for all of them. That is why i thought a stored procedure will be useful.

PHP_Guy22-Mar-10 10:44

22-Mar-10 10:44

hmmm ..

in this case u need [AJAX] just a little code scripted with javascript Smile | :)

scorpio2222-Mar-10 10:56

22-Mar-10 10:56

could you help me with some sample code for a webpage with a textbox and a dropdown list???
It would be very helpful.

PHP_Guy22-Mar-10 11:21

22-Mar-10 11:21

ok
look at this code

<script src="yourpage.js"></script>
<form>
<select name="c" onchange="showchange(this.value)">
<option value = "c1"> C1
<option value = "c2"> C2
<option value = "c3"> C3
<option value = "c4"> C4
</select>
</form>

an at yourpage.js

type

var xmlHttp

function showchange(str) {
xmlHttp = GetXmlHttpObject();
if (xmlHttp==null)
{
alert("your browser deosn't support AJAX");
return;
}
var url = "url" <- your link
url=url+"?q="+str;
url=url+"&sid="+Math.random();
xmlHttp.onreadystatechange=statechanged;
xmlHttp.OPEN("GET",url,true);
xmlHttp.send(null);
}

function statechanged()
{
if (xmlHttp.readystate==4"number of chooses")
{
document.getElementById("txtHint").innerHTML=xmlHttp.responsetext;
}
}
function GetXmlHttpObject()
{
var xmlHttp=null;
try
{
xmlHttp = new XMLHttprequest();
}
catch(e) {
try
{
xmlHttp = new ActiveXObject("Msxm12.XMLHTTP");
}
catch (e)
{
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}

scorpio2223-Mar-10 3:44

23-Mar-10 3:44

Thank you for the code and the effort.
I have tried it but it does not seem to be doing anything.
Moreover i need a procedure where it will enter the changes into the databases and also re-directing me to a new page when a submit button is clicked.

php - include_once

thes3cr3t16-Mar-10 22:39

thes3cr3t1

6-Mar-10 22:39

hi, i am trying to include functions from a php review script in my original web layout, to do this i changed my pages from .htlm to .php and i'am using the include_once function to call the script.

for some reason when i include the script all code execution halts after it has been callled and focus does not return to the anti-insect.php page so the footer for my site is not shown. im not sure if i need to change a return value for the script or not.

this is also preventing me from using multiple include_once to import two or more functions and display them in different area's on my website.

this is very frustrating if any one could help me out i would be really happy, i have also included a link to the site that i am testing using the xampp server.

http://92.8.199.227/Anti-Insect.php

thankyou

chris

Re: php - include_once

chevu7-Mar-10 22:37

chevu

7-Mar-10 22:37

Hi,
First of all, link given by you is not working.. Another thing is include_once can be used once check this php manual page.
http://php.net/manual/en/function.include-once.php[^]

Either explain your problem in detail or give sample code you are trying... So we can help you properly...

Re: php - include_once

PHP_Guy19-Mar-10 7:51

Organize mysql results in html table with PHP

19-Mar-10 7:51

i think i got ur problem

that's because the HTML code at ur included script

pelikan20026-Mar-10 14:15

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.

PHP_Guy19-Mar-10 7:32