Help in PHP Function Calling............?

Question

hello, I have Two saprate hyper link with saprate ID, and on the click event of thees hyperlink i calls a php function. This function has a parameter which depends on the Number of Hyperlink.

Suppose the Link 1. sends the Parameter "Rose" and link 2. sends the parameter "Mango". now whats going on, when i click on link 2. it works fine the Mango goes as a parameter and value got saved, but when i click on the First link then it also sends the parameter "Mango" while it should send the "Rose", now it doesn't matter what link i click, it just sends only one parameter and that is "Mango". Can anybody pls tell me what i m doing wrong.
Pls help me in this i wasted a long time................... on this puzzle.

The Code is shown below-
--------------------------------------------------

PHP FUNCTION---->

function ChangeSaveDefaultView($NewView)
{
$con = mysql_connect("localhost","root");
mysql_select_db("filehost", $con);
$users = $_SESSION['MM_Username'];
$sql = "update useraccounts set useraccounts.DefaultView ='$NewView' where useraccounts.Email='$users'";
if (!mysql_query($sql,$con)){
die('Error: ' . mysql_error());}
mysql_close($con);

}

--------------------------------------------------------------------------------------------------------------
Hyper Link 1.
-------------------------------------

">



Hyper Link 2.
-------------------------------------

">

Answer 1

You don't understand how Php works...

1. Php reads the script on the server.

2. It sees a function (Change...), stores it but does nothing

3. It sees the first link and outputs
4. It sees the first
5. It sees the second
6. It finishes the script.

7. ALL that has reached the user's machine is the HTML part:





and the browser shows it. There is NOTHING on the browser to click, and the DB has been set to "mango"...



Let's review the code...

"main.php"




session_start(); // I assume you are using $_SESSIONS

// Take the habit of putting your functions in the head: it makes the code more readable

function ChangeSaveDefaultView($NewView)

{

$con = mysql_connect("localhost","root");

mysql_select_db("filehost", $con);

$users = $_SESSION['MM_Username'];

$sql = "update `useraccounts` set `DefaultView` = '" . $NewView. "' where `Email` = '" . $users . "' ";

//note the corrected syntax

mysql_query($sql,$con) or die("Error: " . mysql_error());

mysql_close($con);

}

?>






if ( !isset ($_GET['colr']) ) // first time around. There is no parameter.

{

echo ("Rose");

echo ("Mango");

// Note the way the anchor is formed: we pass the colour parameter as a GET request

// Note that the id are DIFFERENT. Do not have elements with the same ID on a page: it confuses the browsers!

}

else // the user has clicked a colour, and "main.php" is called for the SECOND time, where $_GET is now set

{

ChangeSaveDefaultView($_GET['colr']);

}

?>

Answer 2

The PHP will not work in the way you want it to, check the outputted code and you get something like



Notice the blank space between the onClick quotes!

What your code does is run some PHP the second the page is loaded calling your function and passing parameters, when you echo a function the function has to have a return type of some kind or the result will be blank! To do what you want to do, do the following!



main.php

if(isset($_GET['id'])){

ChangeSaveDefaultView($_GET['id']);

}

function ChangeSaveDefaultView($NewView)

{

$con = mysql_connect("localhost","root");

mysql_select_db("filehost", $con);

$users = $_SESSION['MM_Username'];

$sql = "update useraccounts set useraccounts.DefaultView ='$NewView' where useraccounts.Email='$users'";

if (!mysql_query($sql,$con)){

die('Error: ' . mysql_error());}

mysql_close($con);

}



html.html









Now when you run html.html and click a link you open main.php and send it the id variable as a GET variable, this then holds the value rose or mango depending and sends it to the function!

Answer 3

own domicile page applications in basic terms artwork via own domicile page records. however if that's a own domicile page record then basically upload that code anyplace you choose for it to artwork its stuff. you do no longer would desire to do any particular HTML tags to call a own domicile page tag - own domicile page tags are introduced into action as quickly because of the fact the server notices it.

Answer 4

The only thing I believe it could be is that you're not closing off you tags and one is within the other. From what I see it should work perfectly if the tags are closed off.... and the links DON'T have separate IDs.