PHP - If More Than 100 Variables...

I've got a select statement that looks like this in php.
Code: [Select]
$sql = "Select * from inventory where ".$fields."".$operator."".$criteria;
Everything posts correctly, everything is dereferenced correctly.    My only question is how do I get $criteria have single quotes around it?

So that when I actually run the query it says

select * from inventory where field = 'value';


I've tried
Code: [Select]
$sql = "Select * from inventory where ".$fields."".$operator.""'.$criteria';

$sql = "Select * from inventory where ".$fields."".$operator.""'$criteria';
and a bunch of variations like that. 

Thanks for you help.

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

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>

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

Ok- I have seen it go both ways on this forum and I was wondering which is correct- or more secure.

I have a script that receives $_POST variables from a form.  Which is better- to change the name of the $_POST variable to do script manipulations or to simple do them with the $_POST['whatever']

$whatever  = $_POST['var_from_form'];

or simply utilize $_POST['var_from_form']

I know it would be less typing changing it to $whatever, but does it really matter?

And yes- register_globals is off.

Cheers-

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');
 .
 .
 .

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 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?  

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.

How can i put returned values from an sql query, into variables.
If the returned values from a query were; email1@com, email2@com, email3@com
how would i go about puting them into variables?

$value1 = (1st returned value from my sql query, in this case it would be email1@com)
$value2 = (2nd returned value from my sql query, in this case it would be email2@com)
$value3 = (3rd returned value from my sql query, in this case it would be email3@com)


$code = $_GET['postcode'];
$message = $_GET['message'];
$emailad = "email@email.comuk";
$shortcode = substr($code,0,2);
$result = mysql_query("SELECT email FROM treesurgeons WHERE postcode like '%" . $shortcode . "%' ORDER BY companyName LIMIT 3")
or die(mysql_error());  
echo "<h2>Business Names:</h2>";                     
while ($row = mysql_fetch_array( $result )) 
{
$message .= "\r\n". $row['email'] ;
}
echo nl2br ($message); 
mail( "$emailad", "Header","$message" );
echo "<br>" . "Thank you for using our mail form.";
?>
</body>
</html>


Thankyou for any ideas, or suggestions.

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;
}
?>

Hello All,

In below script, I'm using another script called "SimpleImage.php" to upload and resize photos for a news site. The problem comes with renaming the photos. I need to name the photo based off of the story id. I have everything right to get the story id, but saving it as the variable is what's confusing me.

Here's what I have:

<?php include ("newsconnection.php");?>
<?php
$picturename = $_POST['newstoryid'];

      include('SimpleImage.php');
      $image = new SimpleImage();
      $image->load($_FILES['uploaded_image']['tmp_name']);
      $image->resizeToWidth(300);
      $image->save('$picturename');

?>

It's the $image->save('$picturename'); line that's messing me up. Any help would be great!!

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