PHP - Using A New Connection Inside The Function Of A Function

Hi,
I'm an novice/intermediate PHP prgogrammer, so excuse me if this is a stupid question.

I have one php program that consist of a few functions. Inside the function taht is the starting point I pickup a few entries from a MYSQL database, and display those in my html page.

I wish to dynamically put a link on those entries that makes it possible for the users to click those entries an get directed to other functions inside this very same PHP program WITH a parameter. The parameters that should accompany the url/link into the selected function to be able to select apropriate records from the mysql tables.

Any hints and tips for this would be highly appreciated!

Kind Regsrds,

Terje Hvidsten.

I dont know why I'm having so many problems with this. I need to get a variable that defined in an included file inside of a function I've got this

Inside file.php I've got the $variable1 and $variable2 defined (they're dynamic/different to each user)

include('file.php');

function foo() {
GLOBAL $variable1, $variable2;

echo $variable1;
echo $variable2;
}

foo();

Yet it outputs nothing?

If I Include file.php right inside of the function it works however. Any idea?

Hey

Before I start playing around with some code I want to know if it is possible to call a function inside a while loop that will call echo a some stuff then return to the loop it got called by?

thanks 

I have included language file and function file in my index.php

include 'includes/functions.php';
include 'languages/english.php';

english.php contains

<?php
$lang['success']['a'] = 'Settings have been updated.';
$lang['error']['b'] = 'Database error. Please try again later!';

.................................
?>

functions.php

<?php
function testFunction($id, $settings, $db){
	
	$query = 'UPDATE table_name SET a = a + :a WHERE id = :id';
	$update = $db->prepare($query);
	$update->bindParam(':a', $settings['a'], PDO::PARAM_INT); 
	$update->bindParam(':id', $id, PDO::PARAM_INT);  
	$success = $update->execute();
	
	if($success){
		print $lang['success']['a'];
	}else{
		print $lang['error']['b'];
	}
	
}

.................................................

?>

Now if i print testFunction(); i got Undefined variable: lang in .............  If i include 'languages/english.php'; in testFunction() then everything works. Any other way to make $lang working without including language file in testFunction(). (Sorry for my  bad english)

print testfunction(2, $settings, $db);

Hi Everyone.

I'm working on a form, that allows the user to select the country / county / area where they are from.
I am doing this using:

 - mysql database store the locations in
 - PHP OOP, to pull this information from the database
 - AJAX/Javascript to only show the next dropdown, once the first dropdown has been selected.

Example:
select country then the county dropdown will appear, select county then the area/town will appear.


However, the first drop down for country is placed directly on to the page. So the javascript works fine.
but the second dropdown is placed in to a PHP function, and the javascript seems to no longer want to work.

CODE:
Code: [Select]
   //////////////// CODE FOR COUNTRY ///////////
   if(isset($_REQUEST['country'])) {
  echo '
<div class="labelleft">County / State:</div>
  <div class="fieldleft">
<div >
  <select name="county" id="county" onchange="javascript:AJAXQuery("lib/search.php?town="+this.value, "tw", "")">
  <option value="0">Select County</option>
  <option value="0">-------</option>';
  $countyList = Area_county::find_country_id($_REQUEST['country']);
  foreach($countyList as $countyLists){
  $county_id = $countyLists->id;
  $county_list = $countyLists->county;
 
  echo '<option value="'.$county_id.'">'.ucwords($county_list).'</option>';
  }
  echo '
      </select>
    </div>
    </div>
    <div class="clear"></div>';  
}


Any ideas?

Thanks

I'm using this line a lot on my site.  It would be nice if I didn't have to change it 10 times over when I decide to change something.  Can I wrap that into a Function and use it in a While loop?

echo '<div><a href="/tag/'. strtolower($nameFirst) . '-' . strtolower($nameLast) .'">'. $nameFirst . ' ' . $nameLast .'</a>, ';

I have this above it in the While loop.  

$nameFirst = $row['nameFirst'];
$nameLast = $row['nameLast'];

 

My function predictably looks like this...

function player_name () {

echo '<div><a href="/tag/'. strtolower($nameFirst) . '-' . strtolower($nameLast) .'">'. $nameFirst . ' ' . $nameLast .'</a>, ';

}

 

Hi

I am trying to use the nl2br function like this

while ($row = mysqli_fetch_array($query)) {
//May need this later to output pictures   
//     $imageURL = 'upload/'.rawurlencode($row["filename"]);
  echo
  
   "  <div class='divTableRow'>
<div class='divTableCell'>{$row['User']} ;</div>
<div class='divTableCell'>nl2br({$row['CommentText']});</div>
</div>


    \n";
}

However the output just looks like the attached picture.

When I check in the sql db I can see the line breaks when doing a select * from Table ;

 

hello.

i have two functions that are not working because i cant seem to input the php and java correctly.. could someone help please.

how do i put these lines into a function:

1 -

Code: [Select]
function applyBox() {

echo '
<div id="apply">
<h3><b><span class="arial18_GRN">Apply NOW</span> to become a<br>BusinessMobiles.com Affiliate</b></h3>
<p class="applyText">Drive quality traffic to one of our<br>partners and get paid for it.</p>
<a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Apply','','image/callsToAction/applyButton2.jpg',1)">
<img src="image/callsToAction/applyButton1.jpg" class="applyButton" alt="Apply" name="Apply" width="137" height="36" border="0"></a>
</div>
';
}

this part is not working: onMouseOver="MM_swapImage('Apply','','image/callsToAction/applyButton2.jpg',1)">

i can see that the ' is breaking it. i tried putting .'s but it didn't work : onMouseOver="MM_swapImage('.Apply.','..','.image/callsToAction/applyButton2.jpg.',1)">





2 - this form:

Code: [Select]
   <div class="form">
                   <form name="Form" method="post" action="<?PHP echo $_SERVER['PHP_SELF']; ?>">
                    <input name="submit" type="hidden" value="submit" /></input>
                    <input type="text" class="inputField" name="Uname" id="Uname"  value="'.$Uname.'" onfocus="clearUname()"></input>
                    <input type="text" class="inputField" name="PW" id="PW" value="'.$PW.'" onfocus="clearPW()"></input>
                      <input type="image" class="submit" src="image/wrapper/submit.jpg"  value="Submit" alt="login" width="36" height="20" border="0" /></input>
</form>

this part is not working : <form name="Form" method="post" action="<?PHP echo $_SERVER['PHP_SELF']; ?>">

i tried:

<form name="Form" method="post" action="'.echo $_SERVER['PHP_SELF'].'">

but no luck.


any suggestions ????

thanks
ricky

I thought this would be fairly straightforward but for some reason isn't working.

I have an array built from some MySQL data: -

Code: [Select]
$all_products[1] = array(
"title"=>"widget",
"product_code"=>"wid-123",
"colour"=>"blue"); 

$all_products[2] = array(
"title"=>"thingy",
"product_code"=>"thi-345",
"colour"=>"red");
This works fine when used like: -

echo 'Product #1 is a ' . $all_products[1]['colour'] . $all_products[1]['title'] . ', code: ' . $all_products[1]['code'];

Gives: "Product #1 is a blue widget, code: wid-123"

However, if I do this: -

function showproductinfo($thisproduct)
{

echo 'Product #' . $thisproduct . ' is a ' . $all_products[$thisproduct]['colour'] . $all_products[$thisproduct]['title'] . ', code: ' . $all_products[$thisproduct]['code'];
}

showproductinfo(1);

It gives nothing

Can I use a variable passed via a function as the array key in this way? If so, how? And if not, what's the best way to do what I, trying to do?

I have the array defined and print_r (outside the function is show what I need...)
However, I need to somewhay pass those three arguments - name, price, shipping (keys & values) into the "all_products" function and assign (inside the function) each element to a variable {name, price, shipping}.

Code: [Select]
function all_products($key,$value) {

# This is where I'm lost - I know the values are passed to the function but how to I assign them to below variable?
echo "$name";
echo "$price";
echo "$shipping";


// Products array defined to send values into "all_products" function & loop to display item name & individual pricing (using WHILE LOOP)
$products = array('Product1' =>
                                    array   (   'name'  =>  'item one',
                                                'price' => '30.00',
                            'shipping' => '0.00'),
             'Product2' =>                       
                        array (   'item two',
                                                'price' => '19.50',
                            'shipping' => '0.10'),
             'Product3' =>
                        array (   'item three',
                                                'price' => '21.99',
                            'shipping' => '0.10')
                                                );


while (list($keys, $values) = each($products)) {
             while (list($k, $v) = each($values))
   echo "Checking Looped Data Outside Function: <strong>$k: </strong> $v<br/>";

#   echo "<pre>";
#   print_r($value);
#   echo "</pre>";

# Trying to send array elements into "all_products" function & echo (name, price, shipping) keys and values inside that function
all_products($k,$v);

}

I need $row['con_id'] outside the function so I can put it into a query, but simply putting global in front of it won't work. What would be the right way to do?

This portion of code is INSIDE a function:

//Loop through the array of data

while ($row = mysqli_fetch_array ($data)) 

{

echo "<table padding='0' margin='0' class='knuffixTable'>";

echo "<input type='hidden' name='con_id' value='<?php echo " . $row['con_id'] . "; ?>' />";

echo "<tr><td width='65px' height='64px' class='avatar_bg' rowspan='2' colpan='2'><img src='$avatar_path' alt='avatar' /></td><td class='knuffix_username'><strong>" . $user_name;

echo "</strong><br />" . $row['category'] .  " | " . date('M d, Y', strtotime($row['contributed_date'])) . "</td></tr><tr><td>";

echo "<form action='' method='post'>

<input type='submit' name='plusVote' value='Y' />

<input type='submit' name='minusVote' value='N' />

</form></td><td class='votes'>Y[ - ] | N[ - ]</td></tr>";

echo "<tr><td class='knuffix_name' colspan='3'><strong>" . htmlentities($row['name']) . "</strong><br /></td></tr>";

echo "<tr><td colspan='2' class='knuffix_contribution'><pre>" . $row['contribution'] . "</pre><br /></td></tr>";

echo "</table>";



The PHP documentation does not show any examples how to GLOBALIZE a mysqli function. I'd need a way to use $row['con_id'] outside the function for the voting script I'm writing.

Thanks for the suggestions.

Cant get it to work!!


here is the code , how do i fix this?

Code: [Select]
<script type="text/javascript">

function popup(var) {
alert(var);
}

</script>



<?php $calendar.= "<td class='calendar-day'><div style='position:relative;height:100px;' onclick='popup('hello')'>"; ?>

I am trying to pass a variable from inside of a function in a file that is included

eg
include.php
Code: [Select]
<?
function noms(){
$foobar = "apples";
}
?>

main.php
Code: [Select]
<?
include("include.php");
noms();
echo "these ". $foobar. " are most delicious... OM NOM NOM";
?>

I am essentially using a include file for a mysql connection and based on the connection outcome i am either setting a value to true or false.  It prints  "Connected succesfully" and what not just fine, but, after that it wont pass on the variables data.  I know its the function because, it passes the data if i put the variable before the function... i just dont get it.. any help would be great.

Thanks.

Ansel

I'm trying to call a function inside an iFrame inside Wordpress, and I'm getting this error message:

Code: [Select]
Fatal error: Call to a member function get_results() on a non-object in

What is this supposed to mean?

By the way the function DOES work when it's NOT called inside the iFrame, but as soon as I call it inside the iFrame I get the error message. Why is that?

Hello all,

I have a 14 column csv that I load into an array, retrieving only the required fields, load the array into columns and perform a sort:
Code: [Select]
foreach ($array as $key => $row) {
$firstname[$key] = $row["firstn"];
    $lastname[$key] = $row["lastn"];
    $address1[$key] = $row["addr1"];
    $address2[$key] = $row["addr2"];
    $address3[$key] = $row["addr3"];
$city[$key] = $row["cit"];
$stateprov[$key] = $row["state"];
$country[$key] = $row["cntry"];
$membernumber[$key] = $row["num"];}
array_multisort($membernumber,$lastname,$firstname,$address1,$address2,$address3,$city,$stateprov,$country,$array);When I pass say the first three letters of a last name ($find = "smi"), all records matching the search criteria are returned:
Code: [Select]
foreach ($array as $key => $row) {
if (strncasecmp($find, $lastname[$key], strlen($find)) == 0) {
echo "<tr><td>" . $firstname[$key] . "</td>";
echo "<td>" . $lastname[$key] . "</td>";
echo "<td>" . $address1[$key] . "</td>";
echo "<td>" . $address2[$key] . "</td>";
echo "<td>" . $address3[$key] . "</td>";
echo "<td>" . $city[$key] . "</td>";
echo "<td>" . $stateprov[$key] . "</td>";
echo "<td>" . $country[$key] . "</td>";
echo "<td>" . $membernumber[$key] . "</td></tr>" . chr(13);
}}}So far so good. However, I'd like to put the search part into a function so I can call it a number of times without having to reload the entire csv:
Code: [Select]
function FindMember() {
foreach ($array as $key => $row) {
if (strncasecmp($find, $membernumber[$key], strlen($find)) == 0) {
echo "<tr><td>" . $firstname[$key] . "</td>";
echo "<td>" . $lastname[$key] . "</td>";
echo "<td>" . $address1[$key] . "</td>";
echo "<td>" . $address2[$key] . "</td>";
echo "<td>" . $address3[$key] . "</td>";
echo "<td>" . $city[$key] . "</td>";
echo "<td>" . $stateprov[$key] . "</td>";
echo "<td>" . $country[$key] . "</td>";
echo "<td align='right'>" . $membernumber[$key] . "</td></tr>" . chr(13);
}}}}The search criteria would come from a second txt file with every line containing 2 numbers, separated by a comma:
Code: [Select]
foreach ($lines as $member => $numbers) {
$exploded = explode(",", $numbers);
$find = $exploded[1];
FindMember();here $exploded[1] corresponds to $membernumber[$key], so this is where I would call the function, but this is where I run into trouble, nothing gets returned.

Does this have something to do with the scope of variables inside a user-defined function?

I'd appreciate it if someone could point me in the right direction.

TIA