PHP - Php-documentor Help -- Keeps Adding Namespaces

This might be more of a mySQL question or a PHP question, I'm not exactly sure.  I have a field in my table (Deals) called "Price".  All I want is the sum of that field.

I tried using something like:

$price += $row['Price'];

This ended up as one long string, even though the database is set as a decimal number field.

Then I tried doing it from mySQL like this (from what I read), but I don't think I have the full answer:

foreach($stmt->query('SELECT SUM(Price) 
        FROM Deals') as $row) {
            echo "<tr>";
            echo "<td>Total</td>";
            echo "<td> ->".$row['SUM(Price)']."</td>";
            echo "</tr>";
        }

Anyway, if someone could just show me how to get that sum, I would greatly appreciate it because I am missing something here.

hi
i been working on this code witch will add what ever text i want to my database all is working great but what i am having problems with is inserting a url in the same  field  as vidID it will look like this in the database hxxp://xxx.mysitehere.com/index.php?vid=vidID  hope you guys know what im talking about im having a hard time explaining it sorry. Code: [Select]
<?php
$host="xxxxx";
$username="xxxxxxx";
$password="xxxxxxx";
$db_name="xxxxxxx";
$tbl_name="xxxxxxx";
$message =  strtoupper(trim($_REQUEST['message']));
$sender = strtoupper(trim($_REQUEST['sender']));
$email = strtolower(trim($_REQUEST['email']));
$vidID =$_REQUEST['vidID'];
mysql_connect("$host", "$username", "$password")or die("cannot connect server ");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="INSERT INTO $tbl_name(message,sender,email,vidID)VALUES('$message','$sender', '$email', '$vidID')";
$result=mysql_query($sql);
?>

Hi  can someone please show me how I should include a Code: [Select]
<div id="css"></div> in this line
Code: [Select]
echo $AB_LANGS['CalendarInstructions'];
I have tried several attempts with no joy.

Many thanks

nevermind.

Hi,

This is probably very easy for someone who knows how but I cant seem to get it working.

Can someone please tell me how I can alter this query to select a 'WHERE gender = female' so instead of picking a random user it picks a random female user ?

Code: [Select]
$offset_result = mysql_query( " SELECT FLOOR(RAND() * COUNT(*)) AS `offset` FROM `users` ");
$offset_row = mysql_fetch_object( $offset_result );
$offset = $offset_row->offset;
$user1b = mysql_query( " SELECT * FROM `users` LIMIT $offset, 1 " );
$user1= mysql_fetch_array($user1b);

Also, would it be easy to modify it so it picks a second random user that isnt the same as the first user ? so I end up with 2 random females ( $user1 and $user2 )

Many thanks,

Scott

I have seen somewhere that you can add to a string like so

$var = "text";


or


$string ="var";
&$var = "text";

it is the latter that I am wanting to know more about.

I'm trying to get code to work along the following logic (or something similar if this logic isn't PHP-friendly).

If a user inputs a URL with the http, I want the url left alone.
If the user inputs the URL starting with www, I want http:// added to the beginning.
If the user does anything else (in other words uses a relative link), I want the beginning of my url to be added on (because then I later check for it to open the website in a new window or not).

Code: [Select]
if (strpos($url, "http") == 0) { $url = $url; }
else if (strpos($url, "www") == 0) { $url = "http://".$url; }
else { $url = "http://www.mywebsite.com/".$url; };
Any suggestions?

How can i keep adding value to a session???

I need to somehow keep storing more values into an array.
session_start();

// store session data
$_SESSION['tune_name']=$_GET['tune_name'];
$_SESSION['tune']=$_GET['tune'];

print_r($_SESSION);

So this is what i get from the print_r();
Array ( [attach] => Array ( ) [backups-2] => true [dnb] => true [house] => true [tech-house] => true [uk-garage] => true [uk-grime] => true [uk-hip-hop] => true [uncategorized] => true [warehouse] => true [views] => Music/dnb/Gold Dust (Vocal VIP Mix)_DJ Fresh_192.mp3 [tune_name] => Music/dnb/Dj Ss - We Came To Entertain (Sub Zero Remix).mp3 [tune] => Array ( ) )

ok what i need to do is everytime i click it saves that value above but just appends another value to the array so the session can keep getting larger and larger???

Any help please.

i need help with adding an integer into an array

something like this

$Loaded[count($Loaded)+1] = $To;

hello, i have created a table that desplays perticulars, price per person and number of people. the fees is then calculated by multiplying price per person with number of people. till now everything is good. but the problem is when i try to calculate the total fees.
here is an example to explain you better:
Perticulars Price Per Person Number of people Amount something 10 100 1000 something else 20 100 2000 Total 3000

Code: [Select]
$pert_query = mysql_query ("SELECT * FROM `perticulars` WHERE `invoice` =$invoice") or die(mysql_error());
$i = 1;
$sum = 0 + $_SESSION['sum'];
while($perticulars = mysql_fetch_array($pert_query, MYSQL_ASSOC)) {
?>
<tr>
      <td style="border-collapse: collapse"><div align="center"><?php echo $i;
  $i++; 
   ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['perticulars']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['ppc']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['nop']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center">
        <?php $amount = $perticulars['ppc'] * $perticulars['nop']; echo $amount; $_SESSION['sum'] = $sum+$amount;?>
      </div></td>
    </tr><?php 
} ?>
    <tr>
      <td colspan="4" style="border-collapse: collapse"><div align="center">Total</div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $sum; ?></div></td>
    </tr>
  </table>
From the above code you can see that i am getting the amount form $amount = $perticulars['ppc'] * $perticulars['nop'];
by this each row has its own amount which i got by multiplying the data from mysql.
the problem is how do i find out the Total. i know i am suppose to add up $amount but how?
i even tired using sessions to store the amount and add the new amount to get total but the problem in using sessions is it messes up my next page, no using session is a very bad idea.

Hi again guys,

Right, I have two times being output from a database... The first time is the time something is booked in for (eg: 16:30:00) and the second time is the duration that thing is booked in for (eg an hour and a half - 01:30:00)

Now, I want to figure out when that thing will be finished, so using the two examples above, it will be finished at 18:00:00, I've tried a few things with no success

Please help

Cheers

This is my current script
<?php
$iFile = "accounts.txt"; //Put your list lagger's info in this txt file in the same directory as this script. Format is UserID(space)AuthKey

$login = file($iFile, FILE_SKIP_EMPTY_LINES);

if(!is_file($iFile)) echo "The logins file couldn't be found...".sleep(999999);

foreach($login as $line_num => $line)
{
$login = explode(" ", htmlspecialchars(str_replace("    "," ",$line)));
////////////////
//////////////
///////////
/////////
 if(stristr($login[1], "\n")) $login[1] = substr($login[1], 0, strlen($login[1])-2);

$MobLink = "http://mobsters-fb-apache-dynamic-lb.playdom.com/mob_fb/";
$RefreshStat = file_get_contents($MobLink."refresh_stat?user_id=".$login[1]."&auth_key=".$login[0]);


$Mob_Name = explode("<mob_name>", $RefreshStat);
$Mob_Name = explode("<", $Mob_Name[1]);
$Name = $Mob_Name[0];
$Cash = explode("<cash>", $RefreshStat);
$Cash = explode("<", $Cash[1]);
$CurrentCash = $Cash[0];
echo $Name."-$".number_format($CurrentCash)." - ".$login[1]."\n";
}







sleep(99999);






?>



The Script runs through for 100 different accounts, is it possible to add all the Cash values that get echo'd?

Is it possible to add onto the value of a $_SESSION, rather replacing it?


$_SESSION['order']['cartcontenttext'] += echo 'Small: "'.$content['sizes'].'"';
$_SESSION['order']['cartcontenttext'] += echo 'Medium: "'.$content['sizem'].'"';
$_SESSION['order']['cartcontenttext'] += echo 'Large: "'.$content['sizel'].'"';


... so the result would be something like this:
echo $_SESSION['order']['cartcontenttext'];
Quote

Small: 1Medium: 3Large: 2

Right now I have a search option on my site that searches the database for whatever the user puts in. Well then they can click on a record and they can edit it. What I am trying to accomplish is whenever a user clicks to edit but then decides that was the wrong record they can hit a back button and it will show them their results with what they typed in earlier. If they just click the back button on top they get a "Do you want to resubmit the form".
 I tried the <a href="#" onclick="history.go(-1);return false;" class="mtn">
Find out that only works on Safari and that isn't good code.
Then I tried this...
<input type="hidden" name="qry" value="<?=$qry_str?>">

$qry_str is my "SELECT" statement and I am just sending it to my update page as a variable with the POST.

On my update page I pull the variable, save it in another one and send it back to the search page if the user clicks the back link. However it keeps adding a '' on both sides of the criteria everytime I send it to a page.

For instance, I have: SELECT * FROM tasks WHERE 1 and Owner='cnj'. Then I echo on my update page and its SELECT * FROM tasks WHERE 1 and Owner=''cnj'', then I click the back link and get this: SELECT * FROM tasks WHERE 1 and Owner=''''cnj''''. It is doubling them up everytime.

Code on the update page looks like this if you wanted to see
<?php $search=$_POST['qry'];?>
<FORM name="form1" action="searchtasks.php" method="post">
<input type="hidden" name="return" value="<?=$search?>"></FORM>
<a href="javascript: submitform()">Back</a>

I had this working before, but my coding structure has changed a bit and need help with syntax.

My function I have down ok.


function cssfrommvp($mvp) {
 $class = array('MVP' => 'MVP');
 return $class[$mvp];
}


this is how I would add the class to a <td> with $row.

Code: [Select]
echo "<td class=\"".cssfrommvp($row['mvp'])."\">".$row['mvp']."</td>\n";

now using $array


<td> . $MVP .</td>\n</tr>


how would I do the same thing as done before with $row?