PHP - Resting Variables?

Hi guys,

I've a developer for a pretty large website and forum, the database is exploding in size and we are now seeing a grow in the slow log. We want to be able to fix this by optimizing query's but the site is so big, we can't locate the query's themselfs as they are dynamically generated.

I want to be able to tail onto the end of the query a comment containing where a function was last called. In the example below, I want the file name and line-number of where add_together() was called.

Here is an example for index.php:

Code: [Select]
$a = 1;
$b = 2;

$c = add_together($a, $b);

function add_together($a, $b)
{
    return $a + $b;
}

Look forward to your assistance with this!

Joe

Hi guys

I have two variables but
$no1=$row[no1];
$no2=$row[no2];

I need to have another variable where i can merge these two as i need to insert them to database with sapce in between each variable like:

$numbers= $no1 $no2;

by doing this i get syntax error, do u know whats the best way to do this?

Hello

I am stuck at a point where I need to call multiple numbers for a given API

 

This is the  code provided by the API company

// Send Message
$my_apikey = "APIKEY";
$destination = "NUMBER";
$message = "hellotest";
$api_url = "http://blahblah.com/send_message.php";
$api_url .= "?apikey=". urlencode ($my_apikey);
$api_url .= "&number=". urlencode ($destination);
$api_url .= "&text=". urlencode ($message);
$my_result_object = json_decode(file_get_contents($api_url, false));

 

Now My html code would be

 

<div class="card-header ch-alt">
        <h2>Test API</h2>
    </div>

    <div class="card-body card-padding">
        API Key: * <br>

         <option value='APIKEY'>APIKEY Value </option>            </select><br>
        
        Destination Number: * <br>
        <input class="form-control" type="text" id="test_number" required><br>

        <br><br>

        Text: * <br>
        <textarea class="form-control" id="test_text" required rows=5></textarea><br>
            </div>

 

 

Now how do I insert multiple numbers on the Destination number...when i give commas, it gives errors but the message goes with single number

 

Need hlp

Hello I need some help please, I've started to teach myself PHP and I'm attempting to set up some matches for a league I run.  I've included the link I'm working on and just cannot seem to fix my problem.  I'm trying to get it so that you can put the team members and have their names come up in the match section.  Any help would be wonderful cause I have to be doing something wrong

I've also now included my PHP that I have...sorry should have put it first time

http://www.4funmembers.com/Pairings.php


Code: [Select]
<?php
if ( !$_POST['submit'] ) {

echo "<table border=\"0\" cellspacing=\"3\" cellpadding=\"3\">\n";
echo "<form method=\"post\" action=\"singles1.php\" target=\"_blank\">\n";

echo "<tr><td>Team 1 Name: <input type=\"text\" name=\"teamone\"/></td></tr>\n";
echo "<tr><td>Player 1: <input type=\"text\" name=\"plyr1a\"/></td></tr>\n";
echo "<tr><td>Player 2: <input type=\"text\" name=\"plyr2a\"/></td></tr>\n";
echo "<tr><td>Player 3: <input type=\"text\" name=\"plyr3a\"/></td></tr>\n";
echo "<tr><td>Player 4: <input type=\"text\" name=\"plyr4a\"/></td></tr>\n";

echo "<tr><td>Team 2 Name: <input type=\"text\" name=\"teamtwo\"/></td></tr>\n";
echo "<tr><td>Player 1: <input type=\"text\" name=\"plyr1b\"/></td></tr>\n";
echo "<tr><td>Player 2: <input type=\"text\" name=\"plyr2b\"/></td></tr>\n";
echo "<tr><td>Player 3: <input type=\"text\" name=\"plyr3b\"/></td></tr>\n";
echo "<tr><td>Player 4: <input type=\"text\" name=\"plyr4b\"/></td></tr>\n";

echo "<tr><td>Team 3 Name: <input type=\"text\" name=\"teamthree\"/></td></tr>\n";
echo "<tr><td>Player 1: <input type=\"text\" name=\"plyr1c\"/></td></tr>\n";
echo "<tr><td>Player 2: <input type=\"text\" name=\"plyr2c\"/></td></tr>\n";
echo "<tr><td>Player 3: <input type=\"text\" name=\"plyr3c\"/></td></tr>\n";
echo "<tr><td>Player 4: <input type=\"text\" name=\"plyr4c\"/></td></tr>\n";

echo "<tr><td>Team 4 Name: <input type=\"text\" name=\"teamfour\"/></td></tr>\n";
echo "<tr><td>Player 1: <input type=\"text\" name=\"plyr1d\"/></td></tr>\n";
echo "<tr><td>Player 2: <input type=\"text\" name=\"plyr2d\"/></td></tr>\n";
echo "<tr><td>Player 3: <input type=\"text\" name=\"plyr3d\"/></td></tr>\n";
echo "<tr><td>Player 4: <input type=\"text\" name=\"plyr4d\"/></td></tr>\n";

echo "<tr><td>Team 5 Name: <input type=\"text\" name=\"teamfive\"/></td></tr>\n";
echo "<tr><td>Player 1: <input type=\"text\" name=\"plyr1e\"/></td></tr>\n";
echo "<tr><td>Player 2: <input type=\"text\" name=\"plyr2e\"/></td></tr>\n";
echo "<tr><td>Player 3: <input type=\"text\" name=\"plyr3e\"/></td></tr>\n";
echo "<tr><td>Player 4: <input type=\"text\" name=\"plyr4e\"/></td></tr>\n";

echo "<tr><td>Team 6 Name: <input type=\"text\" name=\"teamsix\"/></td></tr>\n";
echo "<tr><td>Player 1: <input type=\"text\" name=\"plyr1f\"/></td></tr>\n";
echo "<tr><td>Player 2: <input type=\"text\" name=\"plyr2f\"/></td></tr>\n";
echo "<tr><td>Player 3: <input type=\"text\" name=\"plyr3f\"/></td></tr>\n";
echo "<tr><td>Player 4: <input type=\"text\" name=\"plyr4f\"/></td></tr>\n";

echo "<tr><td>Team 7 Name: <input type=\"text\" name=\"teamseven\"/></td></tr>\n";
echo "<tr><td>Player 1: <input type=\"text\" name=\"plyr1g\"/></td></tr>\n";
echo "<tr><td>Player 2: <input type=\"text\" name=\"plyr2g\"/></td></tr>\n";
echo "<tr><td>Player 3: <input type=\"text\" name=\"plyr3g\"/></td></tr>\n";
echo "<tr><td>Player 4: <input type=\"text\" name=\"plyr4g\"/></td></tr>\n";

echo "<tr><td>Team 8 Name: <input type=\"text\" name=\"teameight\"/></td></tr>\n";
echo "<tr><td>Player 1: <input type=\"text\" name=\"plyr1h\"/></td></tr>\n";
echo "<tr><td>Player 2: <input type=\"text\" name=\"plyr2h\"/></td></tr>\n";
echo "<tr><td>Player 3: <input type=\"text\" name=\"plyr3h\"/></td></tr>\n";
echo "<tr><td>Player 4: <input type=\"text\" name=\"plyr4h\"/></td></tr>\n";




echo "<tr><td>Match #1 <select name=\"teama\"><option value=\"t1\">Team 1</option>\n<option value=\"t2\">Team 2</option>\n<option value=\"t3\">Team 3</option>\n<option value=\"t4\">Team 4</option>\n<option value=\"t5\">Team 5</option>\n<option value=\"t6\">Team 6</option>\n<option value=\"t7\">Team 7</option>\n<option value=\"t8\">Team 8</option></select> vs <select name=\"teamb\"><option value=\"t1\">Team 1</option>\n<option value=\"t2\">Team 2</option>\n<option value=\"t3\">Team 3</option>\n<option value=\"t4\">Team 4</option>\n<option value=\"t5\">Team 5</option>\n<option value=\"t6\">Team 6</option>\n<option value=\"t7\">Team 7</option>\n<option value=\"t8\">Team 8</option></select></td></tr>\n";
echo "<tr><td>Match #2 <select name=\"teamc\"><option value=\"1\">Team 1</option>\n<option value=\"2\">Team 2</option>\n<option value=\"3\">Team 3</option>\n<option value=\"4\">Team 4</option>\n<option value=\"5\">Team 5</option>\n<option value=\"6\">Team 6</option>\n<option value=\"7\">Team 7</option>\n<option value=\"8\">Team 8</option></select> vs <select name=\"teamd\"><option value=\"1\">Team 1</option>\n<option value=\"2\">Team 2</option>\n<option value=\"3\">Team 3</option>\n<option value=\"4\">Team 4</option>\n<option value=\"5\">Team 5</option>\n<option value=\"6\">Team 6</option>\n<option value=\"7\">Team 7</option>\n<option value=\"8\">Team 8</option></select></td></tr>\n";
echo "<tr><td>Match #3 <select name=\"teame\"><option value=\"1\">Team 1</option>\n<option value=\"2\">Team 2</option>\n<option value=\"3\">Team 3</option>\n<option value=\"4\">Team 4</option>\n<option value=\"5\">Team 5</option>\n<option value=\"6\">Team 6</option>\n<option value=\"7\">Team 7</option>\n<option value=\"8\">Team 8</option></select> vs <select name=\"teamf\"><option value=\"1\">Team 1</option>\n<option value=\"2\">Team 2</option>\n<option value=\"3\">Team 3</option>\n<option value=\"4\">Team 4</option>\n<option value=\"5\">Team 5</option>\n<option value=\"6\">Team 6</option>\n<option value=\"7\">Team 7</option>\n<option value=\"8\">Team 8</option></select></td></tr>\n";
echo "<tr><td>Match #4 <select name=\"teamg\"><option value=\"1\">Team 1</option>\n<option value=\"2\">Team 2</option>\n<option value=\"3\">Team 3</option>\n<option value=\"4\">Team 4</option>\n<option value=\"5\">Team 5</option>\n<option value=\"6\">Team 6</option>\n<option value=\"7\">Team 7</option>\n<option value=\"8\">Team 8</option></select> vs <select name=\"teamh\"><option value=\"1\">Team 1</option>\n<option value=\"2\">Team 2</option>\n<option value=\"3\">Team 3</option>\n<option value=\"4\">Team 4</option>\n<option value=\"5\">Team 5</option>\n<option value=\"6\">Team 6</option>\n<option value=\"7\">Team 7</option>\n<option value=\"8\">Team 8</option></select></td></tr>\n";
echo "<tr><td><input type=\"submit\" name=\"submit\" value=\"Get Pairs\"/></td></tr>\n";
echo "</form></table>\n"; 
} else {

$t1 = $_POST['plyr1a'];
$t2 = $_POST['plyr1b'];
$t3 = $_POST['plyr1c'];
$t3 = $_POST['plyr1d'];
$t4 = $_POST['plyr1e'];
$t5 = $_POST['plyr1f'];
$t6 = $_POST['plyr1g'];
$t7 = $_POST['plyr1h'];

$teama = array('1', '2', '3', '4', '5', '6', '7', '8');
$teamb = array('1', '2', '3', '4', '5', '6', '7', '8');
$teamc = array('1', '2', '3', '4', '5', '6', '7', '8');
$teamd = array('1', '2', '3', '4', '5', '6', '7', '8');
$teame = array('1', '2', '3', '4', '5', '6', '7', '8');
$teamf = array('1', '2', '3', '4', '5', '6', '7', '8');
$teamg = array('1', '2', '3', '4', '5', '6', '7', '8');
$teamh = array('1', '2', '3', '4', '5', '6', '7', '8');

if (!$plyr1a) {
$errors[] = "You did not supply a team member";
} else {
if (!$plyr1b) {
$errors[] = "You did not supply a team member";
} else {
if (!$plyr1c) {
$errors[] = "You did not supply a team member";
} else {
if (!$plyr1d) {
$errors[] = "You did not supply a team member";
} else {
if (!$plyr1e) {
$errors[] = "You did not supply a team member";
if (!$plyr1f) {
$errors[] = "You did not supply a team member";
} else {
if (!$plyr1g) {
$errors[] = "You did not supply a team member";
} else {
if (!$plyr1h) {
$errors[] = "You did not supply a team member";
} else {
switch ($teama) {
case '1':
echo $_POST['plyr1a'];
break;
case '2':
$written = $plyr1b;
break;
case '3':
$written = $plyr1c;
break;
case '4':
$written = $plyr1d;
break;
case '5':
$written = $plyr1e;
break;
case '6':
$written = $plyr1f;
break;
case '7':
$written = $plyr1g;
break;
case '8':
$written = $plyr1h;
break;
default :
$written = "";
break;
}

echo $written; 
switch ($teamb) {
case '1':
$written = $plyr1a;
break;
case '2':
$written = $plyr1b;
break;
case '3':
$written = $plyr1c;
break;
case '4':
$written = $plyr1d;
break;
case '5':
$written = $plyr1e;
break;
case '6':
$written = $plyr1f;
break;
case '7':
$written = $plyr1g;
break;
case '8':
$written = $plyr1h;
break;
default :
$written = "";
break;
}

echo $written; 
switch ($teamc) {
case '1':
$written = $plyr1a;
break;
case '2':
$written = $plyr1b;
break;
case '3':
$written = $plyr1c;
break;
case '4':
$written = $plyr1d;
break;
case '5':
$written = $plyr1e;
break;
case '6':
$written = $plyr1f;
break;
case '7':
$written = $plyr1g;
break;
case '8':
$written = $plyr1h;
break;
default :
$written = "";
break;
}

echo $written; 
switch ($teamd) {
case '1':
$written = $plyr1a;
break;
case '2':
$written = $plyr1b;
break;
case '3':
$written = $plyr1c;
break;
case '4':
$written = $plyr1d;
break;
case '5':
$written = $plyr1e;
break;
case '6':
$written = $plyr1f;
break;
case '7':
$written = $plyr1g;
break;
case '8':
$written = $plyr1h;
break;
default :
$written = "";
break;
}

echo $written; 
switch ($teame) {
case '1':
$written = $plyr1a;
break;
case '2':
$written = $plyr1b;
break;
case '3':
$written = $plyr1c;
break;
case '4':
$written = $plyr1d;
break;
case '5':
$written = $plyr1e;
break;
case '6':
$written = $plyr1f;
break;
case '7':
$written = $plyr1g;
break;
case '8':
$written = $plyr1h;
break;
default :
$written = "";
break;
}

echo $written; 
switch ($teamf) {
case '1':
$written = $plyr1a;
break;
case '2':
$written = $plyr1b;
break;
case '3':
$written = $plyr1c;
break;
case '4':
$written = $plyr1d;
break;
case '5':
$written = $plyr1e;
break;
case '6':
$written = $plyr1f;
break;
case '7':
$written = $plyr1g;
break;
case '8':
$written = $plyr1h;
break;
default :
$written = "";
break;
}

echo $written; 
switch ($teamg) {
case '1':
$written = $plyr1a;
break;
case '2':
$written = $plyr1b;
break;
case '3':
$written = $plyr1c;
break;
case '4':
$written = $plyr1d;
break;
case '5':
$written = $plyr1e;
break;
case '6':
$written = $plyr1f;
break;
case '7':
$written = $plyr1g;
break;
case '8':
$written = $plyr1h;
break;
default :
$written = "";
break;
}

echo $written; 
switch ($teamh) {
case '1':
$written = $plyr1a;
break;
case '2':
$written = $plyr1b;
break;
case '3':
$written = $plyr1c;
break;
case '4':
$written = $plyr1d;
break;
case '5':
$written = $plyr1e;
break;
case '6':
$written = $plyr1f;
break;
case '7':
$written = $plyr1g;
break;
case '8':
$written = $plyr1h;
break;
default :
$written = "";
break;
}

echo $written; 
}
}
}
}
}
}
}
}
}
?><br>
Match #1: <?php echo $_POST["teama"]; ?> vs <?php echo $_POST["teamb"]; ?>
<br>
Match #2: <?php echo $_POST["teamc"]; ?> vs <?php echo $_POST["teamd"]; ?>
<br>
Match #3: <?php echo $_POST["teame"]; ?> vs <?php echo $_POST["teamf"]; ?>
<br>
Match #4: <?php echo $_POST["teamg"]; ?> vs <?php echo $_POST["teamh"]; ?>
<br>
<br>

Hello,
Is it possible to use variables that are declared outside or plainly within a class, and if its possible, how?
thanks in advance

It echos that there are to many.. how would I do this

Saying like if I had 100 $Variable[] it would echo that there are to many?

$Variable[] = "";
$Variable[] = "";
$Variable[] = "";
$Variable[] = "";
$Variable[] = "";
$Variable[] = "";

Hi all   I am using the following rewrite rule  

RewriteRule ^news([a-z0-9_-]+)/([a-z0-9_-]+)(/)?$ news.php?id=$1&identifier=$2

  when I use the link generated I get a 404 Not Found but if I go the genuine URL e.g. www.jasondoyle69.com/news.php?id=[id]&identifier=[identifier], then the page is displayed correctly.   My question is, how do I do the rewrite rule for this, where there two php variables?  

Hey,

Quick question on how i should improve my efficientcy....

Currently my site loads all the main variables with a query at the top of the page then the rest of the page does what it needs with the vars.

But lets say when you page refresh - no data has altered from the main variables have been changed - but currently it still queries and assigns all the variables - but i find this inefficient if the data has not changed to keep on loading them every page load with a query.

Is there more efficent way to make php only query and update teh already set variables when "something" has changed... although that also leads to the problem of variables not being set if no chance has happened when the page reloads....any thoughts?

Hey there!
Thanks for taking the time to read my thread.

So basically I have one index page that handles all the redirects of the content etc but the issue is there can be any number of $_GET variables in the URL.

For example:

index.php?v=my-account&action=password&change=true&and=hello&there=yes


But how would I be able to use a rewrite rule to change all vars in the url at once to appear like this:

index.php/my-account/action/password/change/true/and/hello/there/yes

Thanks for your time!

Hi,

Which one is better from performance view (CPU usage and etc)? using too many Variables or a single Associative Array or generally an Array?

This one:

$ld_linkdump_title         = get_option('ld_linkdump_title');
$ld_linkdump_widget_title  = get_option('ld_linkdump_widget_title');
$nw_option                 = get_option('ld_open_nw');
$ld_open_branding          = get_option('ld_open_branding');
$ld_stylesheet_option      = get_option('ld_stylesheet');
$ld_number_of_links        = get_option('ld_number_of_links');
$ld_number_of_links_widget = get_option('ld_number_of_links_widget');
$ld_number_of_rss_links    = get_option('ld_number_of_rss_links');
$ld_number_of_links_be     = get_option('ld_number_of_links_be');
$ld_repeated_link          = get_option('ld_repeated_link');
$ld_linkdump_fd            = get_option('ld_linkdump_fd');
$ld_linkdump_rss_desc      = get_option('ld_linkdump_rss_desc');
$ld_branding_bg            = get_option('ld_branding_bg');
$ld_archive_days           = get_option('ld_archive_days');
$ld_archive_pid            = get_option('ld_archive_pid');
$ld_show_counter           = get_option('ld_show_counter');
$ld_show_description       = get_option('ld_show_description');
$ld_show_description_w     = get_option('ld_show_description_w');
$ld_send_notification      = get_option('ld_send_notification');
$ld_auto_approve           = get_option('ld_auto_approve');
$ld_short_url              = get_option('ld_short_url');


or this:


$options['ld_linkdump_title'] = get_option('ld_linkdump_title');
$options['ld_linkdump_widget_title']  = get_option('ld_linkdump_widget_title');
$options['nw_option']                 = get_option('ld_open_nw');
 .
 .
 .

I am trying to allow users of a web page the ability to create custom Excel exports. I have some code that I use elsewhere that works to make Excel exports. When I moved the code over to my custom report page, the Excel chart contains an error saying that $csv_output is undefined and so is $data (both variables toward the end of the page). I tried declaring the variables ($csv_output = ''; and $data = '' above the Excel code, but that didn't work. Can anybody help me out? Code below...

Code: [Select]
<?php 
//////////////////// INITIATE SESSION ////////////////////
if (!isset($_SESSION)) {
session_start();
}

//////////////////// ALLOW ACCESS ONLY TO ADMINISTRATORS ////////////////////
if ($_SESSION['person_priveleges'] == 0) {
header("location:index.php");
}

//////////////////// CONNECT AND SELECT DATABASE ////////////////////
require_once('connect.php');
mysql_select_db($database, $connect);

//////////////////// APPLY VARIABLES ////////////////////
$state_search = "";
$payment_status = "";
$method_search = "";

//////////////////// GET USER SEARCH RESULTS ////////////////////
if (array_key_exists('search', $_GET)) {

// FILTER USER INPUT //
//       HERE        // 
///////////////////////

// INITIALIZE ERROR ARRAY //
$error = array();
// IF ALL INPUT FIELDS ARE LEFT BLANK THROW AN ERROR //
if ((empty($_GET['state_search'])) && (empty($_GET['payment_status'])) && (empty($_GET['payment_method']))) {
$error['search'] = "Please enter at least one search parameter.";
// IF NO ERRORS START THE QUERY //
} else {
$search = "SELECT * FROM person";
// SET WHERE PART OF QUERY TO FALS SINCE WE DO NOT HAVE ANY WHERE PARAMETERS //
$where = false;
// IF THE PERSON SELECTS A STATE ASSIGN TO A VARIABLE AND ADD TO QUERY //
if (isset($_GET['state_search']) && !empty($_GET['state_search'])) {
$state_search = $_GET['state_search'];
// FOR EACH STATE THAT WAS SELECTED //
foreach ($state_search as $state) {
// IF THERE ALREADY IS A WHERE CLAUSE ADD THE FOLLOWING CODE TO THE QUERY //
if ($where) {
$search .= " AND person_state = '$state'";
// IF THERE IS NO WHERE CLAUSE ADD THE FOLLOWING CODE TO THE QUERY AND SET WHERE TO TRUE SO FUTURE ADDITIONS WILL BE CORRECT //
} else {
$search .= " WHERE person_state = '$state'";
$where = true;
}
}
}
// IF THE PERSON SELECTS A PAYMENT STATUS ASSIGN TO A VARIABLE AND ADD TO QUERY //
if (isset($_GET['payment_status']) && !empty($_GET['payment_status'])) {
$payment_status = $_GET['payment_status'];
foreach ($payment_status as $status) {
if ($where) {
$search .= " AND person_paid = '$status' ";
   } else {
$search .= " WHERE person_paid = '$status' ";
$where = true;
   }
}
}
// IF THE PERSON SELECTS A PAYMENT METHOD ASSIGN TO A VARIABLE AND ADD TO QUERY //
if (isset($_GET['payment_method']) && !empty($_GET['payment_method'])) {
$payment_method = $_GET['payment_method'];
foreach ($payment_method as $method) {
if ($where) {
$search .= " AND person_payment_method = '$method' ";
   } else {
$search .= " WHERE person_payment_method = '$method' ";
$where = true;
   }
}
}
$search .= " AND person_priveleges = 0 ORDER BY person_last_name";
}
$query_search = mysql_query($search, $connect) or die(mysql_error());

// CODE TO GENERATE EXCEL OUTPUT //

// GET THE NUMBER OF FIELDS //
$fields = mysql_num_fields($query_search); 
// FOR EACH RECORD IN THE DATABASE PRODUCE SOME OUTPUT //
for ($i = 0; $i < $fields; $i++) {
$csv_output .= mysql_field_name($query_search, $i) . "\t";
}

while($row = mysql_fetch_row($query_search)) {
foreach($row as $value) {
if ((!isset($value)) OR ($value == "")) {
$value = "\t"; 
} else {
$value = str_replace('"', '""', $value);
$value = '"' . $value . '"' . "\t"; 
}
$line .= $value;
}
$data .= trim($line)."\n";
}
$data = str_replace("\r","",$data);

header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=Registration Report for IDUES 2011 Project Directors Meeting.xls");
header("Pragma: no-cache");
header("Expires: 0");
print $csv_output."\n".$data;
exit;
}
?>

Hi guys

Say for example I have a text field with value 20/10/2011 how do I define it so that $x=20, $y=10 and $z=2011 so that I have three variables

Thanks

I have a database that holds a list of companies. the database includes and ID, and name of each company. Now when an articles gets submitted to my site it can then be related to company. We a relate a company to an article its related through its ID. What I want to do is create a function that would let me easly convert my company ID into company name within having to write out the queries over and over again in my code. Only problem is I can't get it to work.  I have two files, index.php and functions.php.

functions.php
Code: [Select]
function cname($pubid) {
global $db;
$company= $db->query("SELECT * FROM my_database WHERE id='$pubid'") or die(mysql_error());
while($company= $db->fetch_array($company)) {
$cname = $company['name'];
}
return $cname;
}

and within index.php I put
Code: [Select]
echo cname($companyID);
Now, when I first looked at index.php I was getting an error. I know it had something to do with me using my variables within the function and after some searching I ended up getting rid of the error by adding "global $db;" to my code. Please note that I include functions.php at the top of index.php. What am I doing wrong and why wont it work? HELP PLEASE!

also note that my i've rechecked and all the database info is correct and names spelt right. Just dont know what else to do.

Can I use a variable inside an sql query to determine which table to select from? The 2 functions below do exactly the same thing, they're just selecting data from different tables. I'm not sure how I can do it. Maybe put a parameter in the function & use sprinf?


// Output the page data
function showpages()
  {
   db_connect();
$query = ("SELECT * FROM pages");  // can I change pages to a variable somehow?
$result = mysql_query($query);
    $result = result_to_assoc($result);
    return $result;   
   }

// Echo the pricelist data into the pricelist form
function show_pricelist()
  {
db_connect();
$query = ("SELECT * FROM pricelist");  // Again, if pricelist can be a variable, then I need only 1 function
$result = mysql_query($query);
    $result = result_to_assoc($result);
    return $result;   
   }

Hi guys, i have a ipn paypal setup where users can buy items from my custom made shop, however in original ipn code, the logged in users should have the same email with paypal to call on ipn which user has bought what, so I have decided to pass a custome variable as

<input type="hidden" name="custom" value="<?php echo "$username";">


the hard part is in my ipn how im i going to recieve the username variable? what should i put in my ipn. In ipn code I have example code:


$item_name = $_POST['item_name'];
$item_number = $_POST['item_number'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];


but now, can u help me to recieve the username so i can match my mysql query which user has bought what?

thanks in advance