function.. [RESOLVED]

Printable View

Sep 8th, 2005, 12:18 AM
titan7262

function.. [RESOLVED]

i am trying to create a function.. but i don't know how to use it.. a procedure(as in VB) but how?

I don't want it to be in a different file...

PHP Code:

<html> <head>sample</head> <body> *********** how will i use dbconnect in here ********** </body> </html> <?php function dbconnect($host,$user,$password) $conn = mysql_connect($host, $user, $password) or die ("Could Not Connect to DB"); ?>

a sample of function and procedure and how to use it will be excellent.. sorry just started PHP yesterday.. hope you guys can help me..
Sep 8th, 2005, 01:55 AM
Dnereb

Re: function..

My experience is limited with PHP but shouldn't it be like this:

PHP Code:

Code:

<html> <head>sample <?php function dbconnect($host,$user,$password) ; $conn = mysql_connect($host, $user, $password) ; or die ("Could Not Connect to DB"); ?> </head> <body> *********** how will i use dbconnect in here ********** <?php dbconnect($host,$user,$password); ?> </body> </html>

PHP/HTML reads a file from top to bottom I suspect so function definitions should be made before they are used. and I'm not sure about the orange semicolon
Sep 8th, 2005, 02:04 AM
titan7262

Re: function..

ok... i have solved most of my problems now.. umm how can i add items to a list on my form using the records from my database? <- got this working.. but the problem is.. the results are shown on a diffrent page.. i am wondering how can i expose all results on the same page.. i will post the code..

PHP Code:

<html> <head> </body> <form> <p> <select name="mGrid" id="mGrid"> <option value="NONE">----- SELECT GRID -----</option> <option value="NORTH">NORTH</option> <option value="EAST">EAST</option> <option value="SOUTH">SOUTH</option> <option value="WEST">WEST</option> </select> <input type="button" name="Button" value="Button" onClick="show()"> ** how can i call show after clicking the button?? ** <br> <br> <select name="select" size="10"> <option>--------------- LIST OF BRANCHES ---------------</option> </select> </form> </html> <? function show(){ $host = 'localhost'; $user = 'root'; $password = 'admin'; $conn = mysql_connect($host, $user, $password) or die ("Could Not Connect to DB"); $mooo = '$mGrid'; $sd = mysql_select_db("ifl-sales", $conn) or die ("Could Not Select DB" . mysql_error()); $tableaccess = "select branch_name from branch where grid = '$mooo'"; $sb = mysql_query($tableaccess, $conn); while ($row = mysql_fetch_array ($sb)) { echo("<option>"); echo($row['branch_name']); } } ?>

everytime ic click the button nothing happens.. :(
Sep 8th, 2005, 08:12 AM
john tindell

Re: function..

You are trying to call the PHP function from the client side, this wont work. All the PHP gets processed before it gets to the client. So they will never see your PHP code. Try using a form eg

PHP Code:

<form method="POST"> <input type="submit" name="submit1" value="Get Values"/> <input type="hidden" name="action" value="getvalues" /> </form> <? if($_GET['action']=="getvalues") { show(); // <--- calling your function here; } ?>

That will basicaly do what you want, but the page will be reloaded, which really cant be helped.

There is a way to get the data as you click the button, but that uses javascript as well and is a little complex, ill just find the link for you.
Sep 8th, 2005, 08:17 AM
john tindell

Re: function..

http://www.sitepoint.com/blogs/2004/...-hidden-php-1/
Sep 8th, 2005, 07:02 PM
titan7262

Re: function..

Quote:

<form method="POST">
<input type="submit" name="submit1" value="Get Values"/>
<input type="hidden" name="action" value="getvalues" />
</form>
<?
if($_GET['action']=="getvalues")
{
show(); // <--- calling your function here;
}
?>

for what is the <input type="hidden" name="action" value="getvalues" /> for? and how will my page be loaded i can't seem to find how it is reloaded..

so i need to learn javascript for me to be able to call php functions?
Sep 8th, 2005, 07:10 PM
john tindell

Re: function..

Use use a form to submit the data to the php script. The <input type="hidden" name="action" value="getvalues" /> is so that the part of your script you want to run only happens after you press the button.
Sep 8th, 2005, 09:29 PM
titan7262

Re: function..

sorry.. but i can't get it to work..

Quote:

<html>
<head>
</body>
<?php include("show.php")?>
<form method="post">
<p>
<select name="mGrid" id="mGrid">
<option value="NONE">----- SELECT GRID -----</option>
<option value="NORTH">NORTH</option>
<option value="EAST">EAST</option>
<option value="SOUTH">SOUTH</option>
<option value="WEST">WEST</option>
</select>
<input type="button" name="Button" value="Button">
<input type="hidden" name="action" value="Button">
<br>
<br>
<select name="select" size="10">
<option>--------------- LIST OF BRANCHES ---------------</option>
</select>
</form>
<?
if($_GET['action']=="button")
{
show();
}
?>
</html>

what's wrong with this.. it says error on line 23 which is if($_GET['action']=="button") <-- that's the line
Sep 8th, 2005, 09:36 PM
john tindell

Re: function..

You need to change two things, one PHP is case sensative, and secondly you are not using a submit button on your form, you are using a normal button try

Code:

<html> <head> </body> <?php include("show.php")?> <form method="post"> <p> <select name="mGrid" id="mGrid"> <option value="NONE">----- SELECT GRID -----</option> <option value="NORTH">NORTH</option> <option value="EAST">EAST</option> <option value="SOUTH">SOUTH</option> <option value="WEST">WEST</option> </select> <input type="submit" name="Button" value="Button"> <input type="hidden" name="action" value="button"> <br> <br> <select name="select" size="10"> <option>--------------- LIST OF BRANCHES ---------------</option> </select> </form> <? if($_GET['action']=="button") { show(); } ?> </html>

That should work now
Sep 8th, 2005, 09:44 PM
titan7262

Re: function..

i am getting this error..

Notice: Undefined index: action in D:\PHPWEB\HTMLKIT\temp.php on line 24

line 24 is: if($_GET['action']=="button")
Sep 8th, 2005, 09:52 PM
john tindell

Re: function..

ahhh im half asleep try using

PHP Code:

<? if(isset($_POST['action'])) { if($_POST['action']=="button") { show(); } } ?>
Sep 8th, 2005, 10:02 PM
titan7262

Re: function..

ok that did the trick.. and a new error has occured.. sorry if i am bugging you this much.. :(

this is the whole code..

PHP Code:

<html> <head> </body> <?php include("show.php")?> <form method="post"> <p> <select name="mGrid" id="mGrid"> <option value="NONE">----- SELECT GRID -----</option> <option value="NORTH">NORTH</option> <option value="EAST">EAST</option> <option value="SOUTH">SOUTH</option> <option value="WEST">WEST</option> </select> <input type="submit" name="Button" value="Button"> <input type="hidden" name="action" value="button"> <br> <br> <select name="select" size="10"> <option>--------------- LIST OF BRANCHES ---------------</option> </select> </form> <? if(isset($_POST['action'])) { if($_POST['action']=="button") { mshow() } } ?> </html> <? function mshow(){ $host = 'localhost'; $user = 'root'; $password = 'admin'; $conn = mysql_connect($host, $user, $password) or die ("Could Not Connect to DB"); $mooo = '$mGrid'; $sd = mysql_select_db("ifl-sales", $conn) or die ("Could Not Select DB" . mysql_error()); $tableaccess = "select branch_name from branch where grid = '$mooo'"; $sb = mysql_query($tableaccess, $conn); while ($row = mysql_fetch_array ($sb)) { echo("<option>"); echo($row['branch_name']); } } ?>

nothing happens.. it just redraw the page but did not show the results..
Sep 11th, 2005, 10:08 AM
john tindell

Re: function..

You don't have superglobals turned on so change

PHP Code:

$mooo = '$mGrid';

to

PHP Code:

$mooo = $_POST['mGrid'];

It *should* work now.....hopefuly. :lol:
Sep 12th, 2005, 02:15 AM
titan7262

Re: function..

just found some samples on other websites.. ;) Thanks to all that helped!!!

CHEERS! :wave: