[PHP] Onload?

NubPro · Jun 7, 2012

I want the script that can send his details(ip....etc) to database when he's viewing the page instead of pressing the submit button.

EG:
1. Goto google.com
2. Google save your details automatically to their db when you loaded the page.

Mhm bad english....sorry for that...

Hoping anyone can solve my issue

After I ran a quick research on google, it seems that it requires Javascript to execute php script?

WizCoder · Jun 7, 2012

I edited this post because I had no idea what I was saying... I re-wrote something below :3

ThuGie · Jun 7, 2012

Hey,

PHP executes code directly simply put the code after <? and its done..

NubPro · Jun 7, 2012

ThuGie said:
Hey,

PHP executes code directly simply put the code after <? and its done..

I don't understand.....I want the details send directly to the database without pressing the submit button.

Hilroy · Jun 7, 2012

You can put php anywhere in any of your pages and like ThuGie said, PHP executes the code directly so you dont need any submit form for that...

Just put PHP tags in the top of your home page...

Example :

<?php

do stuff here

<?

<html>
<head>
</head>
<body>
</body>
</hmtl>

.....

WizCoder · Jun 7, 2012

LOL, Those guys above got a good point x,x. I have no clue what I was talking about before.

Code:

<html>
<body>

//Anthing you want to automatically execute is below within the <?php <? tags.

<?php

//Code to execute would be placed here

$string = "This line of string is going to be automatically executed once the browser page as loaded.";
echo $string;


?>



</body>
</html>

In other hands if you we're trying to retrieve information from a html script well, then you would need a 'Submit' button for the info to be sent through the PHP script.

Chris · Jun 7, 2012

PHP already does everything "on load". All you need to do is find the details you want in the database, and put the code at the top of the page. (putting it at the top is only for convenience. It can be anywhere on the page.)

If you're wondering how to insert something into a mysql database with php, it's just a simple query.

Code:

<?php
mysql_query("INSERT INTO `table_name`(`online`,`other_column`) VALUES('1','other_value') WHERE `username` = 'user'") or die(mysql_error());

That query will insert '1' in the 'online' column of 'table_name', and 'other_Value' in the 'other_column' column of the same table.

EliteGM · Jun 8, 2012

Are you asking for on-the-fly DB actions? Like submitting a form without the page refreshing? Look into using (S)AJAX.

NubPro · Jun 8, 2012

EliteGM said:
Are you asking for on-the-fly DB actions? Like submitting a form without the page refreshing? Look into using (S)AJAX.

not that....I'll try once my computer is fixed.

Ron · Jun 8, 2012

Initialize a database connection, grab variables, insert to database...

PHP:

$con = mysqli_connect($host, $user, $pass, $db) or die("Failed to connect to database");
$username = $_SESSION['username'];
$ip = $_SERVER['REMOTE_ADDR'];
$sql = "UPDATE users SET ip = '$ip' WHERE username = '$username';";
mysqli_query($con, $sql);

NubPro · Jun 8, 2012

Ron said:

Initialize a database connection, grab variables, insert to database...

PHP:

$con = mysqli_connect($host, $user, $pass, $db) or die("Failed to connect to database");
$username = $_SESSION['username'];
$ip = $_SERVER['REMOTE_ADDR'];
$sql = "UPDATE users SET ip = '$ip' WHERE username = '$username';";
mysqli_query($con, $sql);

Bro thanks but I know the basics

EliteGM · Jun 8, 2012

Well for what you're requesting, those "basics" are all you need.

Foxtrot · Jun 15, 2012

NubPro said:
Bro thanks but I know the basics

You sure could've fooled me.

jMerliN · Jun 15, 2012

PHP is so bad.

[PHP] Onload?

NubPro

Hello!

WizCoder

C:\

ThuGie

ThuGie.NL - Webmaster

NubPro

Hello!

Hilroy

Newbie Spellweaver

WizCoder

C:\

Chris

Developer

EliteGM

The Gamma..?

NubPro

Hello!

Ron

Legend

NubPro

Hello!

EliteGM

The Gamma..?

Foxtrot

Junior Spellweaver

jMerliN

Ginger by design.

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor