Hi all..

This the Section 2 for my previous tutorial about storing values in background using ajax!

Please have a look at here:

Astahost.com/ajax-php-sql-simply-superb-visitor-tracking-t15502.html

Introduction!

We are going to create 2 background script files. One to get values from the main page input field and store all values including visitor details ( IP Address, Input Value, Visitor Agent etc) to database and the 2nd one for retrieving all values from database and display it in the screen! We are going to 2 separate pages first and then going to integrate all those 2 pages to the main user interface page!

So, let us start guys!!

Stage 1: Getting values from the database and displaying the same

We already inserted some values to the database as described here

Now we have to retrieve all values by using query and to display them in screen!!
So, here is the query to retrieve values:

SELECT * FROM ajax ORDER BY slno DESC

This will retrieve all values from the database and will be stored in some buffer! We have to show each and every field values in some table cells!

So, here comes the main code for that!

$query="SELECT * FROM ajax ORDER BY slno DESC";
$result=mysql_query($query);

echo "<table>
<tr>
<th>Sl Num</th>
<th>Text Msg</th>
<th>IP Address</th>
<th>Hostname</th>
<th>Visitor Agent</th>
<th>Time</th>
</tr>\n";
while($row=mysql_fetch_array($result))
{
echo "<tr bgcolor=#2F2F2F>\n";
echo "\n<td align=center>". $row['slno'] . "</td>";
echo "\n<td>". $row['test'] . "</td>";
echo "\n<td>". $row['ipaddr'] . "</td>";
echo "\n<td>". gethostbyaddr($row['ipaddr']) . "</td>";
echo "\n<td>". $row['agent'] . "</td>";
echo "\n<td>". date("D, d M y g:i:s a",$row['timer']+45000) . "</td>";
echo "\n</tr>";
}
echo "\n</table>\n";

Here we already stored the visitor ipaddress. We can get hostname from the ip address by using the function:
gethostbyaddr();

The above while loop will execute for the n number of times (* n = number of records retrieved)
And we can get the timestamp and we can format it using php date() function!
More details about Date function available here

Ok, I think, now the idea is clear! This will display all values in some table format!
Now we have to place some checkbox in each and every row and clicking the delete button should delete the selected values!
( Got this checkbox deletion idea from here )

So we are midifying the script page like this:

if($_POST['perform']) {
foreach($_POST as $id) { // This will loop through the checked checkboxes
mysql_query("DELETE FROM ajax WHERE slno='$id' LIMIT 1"); // Change yourtable and id. This deletes the record from the database
}
}

Thats over in the display part! So finished page will look like this:



And the finished page is available here:

Fun.niranvv.com/test/php_ajax_output.php

Stage 2: Embed the page inside main background script file

We can view the results in separate as seen in the stage 1!
But we have to display the table inside the main page immediately after inserting the values!
So, we can copy and paste the script to the main background script page called by clicking the enter button!
But, That will complicate the pages! So, Im going to include the script file inside the main background script file!

We can include like this:

echo include("php_ajax_integrated_output.php")

here "php_ajax_integrated_output.php" is used to output the values ( created in stage 1 )

So the main Background script file will be like this:



And I'm going to modify the included page like this for easy understanding:



We are dynamically updating the main page with updated database field values!

Now the this is the process flow:

• User enter information and clicking the enter button ( php_ajax_integrated.php)
• Entered values will be send to background script (php_ajax_integrated_script.php) using query string
• The values will be inserted to the database and the background script will call another php page (php_ajax_integrated_output.php) to display updated values using echo include("file path")
• In that php_ajax_integrated_output.php , retrive all values from the database and display the values
• Inrtegrate all files and display output in the main page ( Please have a look at here for more info

So, here is our final integrated page:

Fun.niranvv.com/test/php_ajax_integrated.php

Thats all guys!!
If you have any doubt, Please reply here!
I will try to help you! ( Im a beginner only .. Yes guys!! U have to believe my words!! Just went through some online tutorials about php and ajax, and got some ideas! And tried to integrate all.. This page is the result of that!! And it took only 1-2 days to study all these functions! I Started from a big '0' only!! So, if you dont have any ideas, dont worry!! If you know pragramming concepts, u can also come up with this! all the best )

regards,
Niru

This post has been edited by Niru: Apr 15 2007, 09:54 AM

Hi..
Thanks for approving my small tutorial!!
Let me explain the process flow in this tutorial!

I had created one php page to retrieve database values and display them:
php_ajax_i...ated_output.php

Then One page for sending the values in the database and included/called the above php file inside this page:
http://www.fun.niranvv.com/test/php_ajax_i...ated_script.php
(You can see like this: Hacking Attempt!! or No Input Values )
The code will get values from the query string! If no query string is there, then it wont insert any data to the database!
But You can insert manually like this:
php_ajax_integrated_script.php?word=myWord

Now One new page that is the integration of all the above pages!
http://www.fun.niranvv.com/test/php_ajax_integrated.php

Here, clicking the button will calls the file: php_ajax_integrated_script.php?word=myWord
Thus it will insert the values in the database!
And will display the datas using php_ajax_integrated_output.php

If you have any douts regarding this, please post here! I will try to help you!!

Thanks,

Niru

This post has been edited by Niru: Apr 20 2007, 05:21 PM

I'm updating the code with Reference URL!!

Please check here
I will post the updated code details soon!!
(I'm adding some more functions also! Will post all together later!)



This post has been edited by Niru: Apr 24 2007, 05:35 PM