PHP - < > These Exist In Php?

hello, i am having an issue with tables using incorrect data.

i have 2 columns, first is employee name, second is location

if the employee doesnt have a location for the current day, it is telling me he is at the same location as the guy in the row above him.  i need this to be blank.  is this possible?

hi,

im having trouble adding a get variable to a url if one already exists.

eg

current url = http://www.example.com/index.php?var1=something

i want to be able to change this to

new url = http://www.example.com/index.php?var1=something&var2=another

even so i can have a few get variable there.

I can add the first var through a form or link, but how would i add more through a link or through the header function?

I am positivly stuck.

Thanks

Gud pm!!
So i made this script to check if a username and password exist but it kinda fails me.
It gives me a database connection error from my confirm_query() which means it returned false?
so here's my code:

Code: [Select]
  function check_if_exist($username, $password)
{
global $connection;
$query = "SELECT username, hashed_password";
$query .= "FROM users ";
$query .= "WHERE username = '$username' ";
    $query .= "AND hashed_password = '$password' ";
$query .= " LIMIT 1";
$result_set = mysql_query($query, $connection);
confirm_query($result_set);
if(mysql_num_rows($result_set) == 1)
{
return true;
}
else
{
return false;
}
}

my confirm_query():

Code: [Select]
function confirm_query($result)
{
if(!$result)
{
die("Database connection failure ". mysql_error());
}
}

I have a another script to check if the email exist and it works perfectly, i dunno why this won't work properly.. 
maybe another simple mistake..
Any ideas or Violent reaction? 
Thanks!

Does the concept of a "Namespace" exist in PHP?

If so, how do you use them?

This is a snippet from ASP.NET that made me ask this question...

Quote

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>



TomTees

hi, i have a select which gets todays schedule for each user.  sometimes that user doesnt have anything for todays date and it will display the info from the user above him.  how can i make it so it stays blank if there is no record?

I have an array like so


Array (14)
(
|    ['0'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['1'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['2'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['3'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['4'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['5'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['6'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['7'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['8'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['9'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['10'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['11'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['12'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['13'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
)


what i want to do is add the details to a new multi dimensional array but only add one each like so

array(
    ['units'] = array(
          ['name'] => 'Pikemen',
          ['lost']    => 14
     )
)
basically where the HP is 0 in the first array i need to add them to the second if the name is unique. I have tried array unique but it didnt seem to work. Any ideas? All i get it a loop of each Pikemen

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=357281.0

Working with authorize.net script that is included in my php.  Trying to figure out how to use a variable beyond the 'case' I can do just about anything... inside the case... But I need to use the variable outside of there.

Code: [Select]
//several cases above
case 5:
$this->approval_code = $pstr_trimmed;
break;

// case 7 is the authorize.net transaction ID - This is the one I want to work with
case 7:
echo "Transaction ID: ";
echo $pstr_trimmed;
$trans_id_test = $pstr_trimmed;

break;
// but this below won't work. I can't use the variable anywhere outside of the case.
echo "the new variable is now...".$trans_id_test;

I have a field in a table named flights
I hope to find a 1 line statement to bypass inserting a new row if $flight_no is already in the field flight_no
btw flight_no is the primary key and won't  allow a duplicate anyway but I want to avoid the error message

this is what I tried but doesn't work
if(SELECT * FROM flights WHERE flight_no !LIKE  %$flight_no%) {

I need to insert data into a table if it doesn't exist or update if it does.

Can someone give me an example of this code.

im using mySQL 5.1.42
im using phpMyAdmin 3.1.o

I'm writing a dropdown menu of countries states/regions, that pulls from an xml file... but some countries don't have a specific state/region (IE Antarctica).  If they don't, then the XML file isn't formatted in the same way
There is more to this, but the relevant part is he

echo "<select name=\"statename\">\n";

echo "<option value=\"\">Select a state</option>\n";

$statexml = simplexml_load_file($state);

foreach ($statexml->geoname as $statelink)  {

if($statelink) {

echo "<option value='{$statelink->name}'>{$statelink->name}</option>\n";

} else {

echo "<option value='none'>none</option>\n";

}

}
echo "</select>";


A state xml with results looks like this:
Code: [Select]
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<geonames style="MEDIUM">
<totalResultsCount>51</totalResultsCount>
<geoname>
<name>Alabama</name>
...etc, etc
</geoname>
<geoname>
<name>Alaska</name>
...etc, etc
</geoname>
</geonames>

And an xml with no results looks like this:
Code: [Select]
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<geonames>
<status message="no children for Antarctica 6697173" value="15"/>
</geonames>

Saying the if($statelink) isn't working, as any country without a state simply doesn't display the 'none' selection.
Code: [Select]
<select name="statename">
<option value="">Select a state</option>
</select>

Any help?? 

Hello,

i want to check whether image exist or not, but i can't get any data about it. I have tried everything: getimagesize, file_exist, filesize, etc.

<?

$info = @getimagesize('http://jargames.eu/ic.php?lf=files/All phone/240x320/007-quantum_of_solace_240x320.jar');
if(isset($info['mime'])){echo 'Image exist';}
else{echo 'Image doesnt exist';}

?>
Ty, for your help.

Is it possible to check if multiple rows exist at the same time.  For example, if a row with the id "1" and another row with id "2" exists, and return something like true then false if only the first exists?   I have a file that provides tens of thousands to check and it takes forever.  I know this sounds bad off the start, but it's not something that is run normally.  Only to update my database with new additions.   Is there any good way to check a lot at once?  I know you can insert many at a time and save a lot of time.

hi,

im getting the error

Quote

Fatal error: Call to undefined function notification() in C:\xampp\htdocs\xampp\index.php on line 21


after including the functions.php file i wrote. It does include it but the data isnt being recognised from it. If i copy/paste the notification() function into index.php it works.

Can someone tell me why so i can fix it?

Here is my code so far (I say it's PDO but it pretty much isn't. What is the object here? The database connection? LOL!);
 

$sql = 
	"
	SELECT 
	SUM(IF(`sent` != 'N' , 1 , 0 )) as 'Emails Sent',	
	SUM(IF(`completed` NOT IN('N','paper') , 1 , 0 )) as 'Completed Electronically', 	
	SUM(IF(`completed` = 'paper' , 1 , 0 )) as 'Completed Manually', 
	SUM(IF(`completed` != 'N' , 1 , 0 )) as 'Total Number Completed',
	SUM(IF(`remindercount` = '1' , 1 , 0 )) as 'Reminder Sent Once',
	SUM(IF(`remindercount` = '2' , 1 , 0 )) as 'Reminder Sent Twice',
	SUM(IF(`remindercount` = '3' , 1 , 0 )) as 'Reminder Sent Thrice'
	FROM `tokens_$survey_id`
	";
				
$statement = $dbh->prepare($sql);
$statement->execute();

$result = $statement->fetch(PDO::FETCH_OBJ);
				
foreach($result as $key => $value) {
	 echo "<tr>
		<td>$key</td>
		<td>$value</td>
	       </tr>";
}

This is all well and good if the tokens_$survey_id table is actually there. Sometimes, for a genuine reason, there won't be a tokens table for that particular survey. How do I account for this? At the moment I get an error..
 

Warning: Invalid argument supplied for foreach() in /var/www/html/index.php on line 149 

I tried this but I am not satisfied this is correct;
 

if(!$result) {
die();
}

I don't want the code to die! If I take out the die() statement then this if is ignored for some reason I don't understand.