PHP - Adding Foo Onto Bar (arithmetic)

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

hello.  im trying to get the following to work.  any ideas for me?

Code: [Select]
Text[12]=["Job Description","$description it "]
it is in a .js file.

Hi,

I have a function that pulls a random line from a text file and I would like to change it so it pulls a random line from a text file that contains a certain date, heres the current function :

Code: [Select]

function RandomLine($filename) {
    $lines = file($filename) ;
    return $lines[array_rand($lines)] ;
}


Any ideas on the best way to do this ?

Many thanks.

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?

I created the code below and it outputs the following number output:
1111111773526604115551144611337112281111221111345 6789101121111100352004110051100611007110081100221 1003456789101141111100352004110051100611007110081 1002211003456789101151111100352004110051100611007 1100811002211003456789101123111110035200411005110 06110071100811002211003456789101134
Anyways if you look at the code, I need to be able to add the values on a single colony, idcol, with the same type and subtype, btid/stid, generated as the $prod variable. buildings with the same subtype generate the same resource, in this case, several iron mines and a single copper mine are present, but there are also 9 other types of resource buildings. How do I collect on the prods which go together?
Code: [Select]
<?php
$dbhost = 'localhost:3306';
$dbuser = 'lordofth_aos';
$dbpass = 'flarge';
$dbname = 'lordofth_aos';
$conn = mysql_connect($dbhost,$dbuser,$dbpass)
or die ('Error connecting to mysql');
mysql_select_db($dbname);
$query="SELECT id FROM users";
$result=mysql_query($query);
$num=mysql_num_rows($result);
$i=0;
$idn=1;
while($i<$num){
$queryii="SELECT idcol FROM colony WHERE id=$idn";
$resultii=mysql_query($queryii);
$numt=mysql_num_rows($resultii);
$id=mysql_result($result, $i);
echo $id;
$ii=0;
$ibt=1;
while($ii<$numt){
$querypty="SELECT btid FROM ptypes WHERE btid=$ibt";
$resultpty=mysql_query($querypty);
$numpty=mysql_num_rows($resultpty);
$idcol=mysql_result($resultii, $ii);
echo $idcol;
$bt=0;
$btid=mysql_result($resultpty, $bt);
echo $btid;
$bte=1;
while($bt<$numpty){
$querystid="SELECT stid FROM ptypes WHERE stid=$bte";
$resultstid=mysql_query($querystid);
$numstid=mysql_num_rows($resultstid);
$st=0;
$stid=mysql_result($resultstid, $st);
echo $stid;
$ste=1;
while($st<$numstid){
$bidum=0;
$querybpid="SELECT bpid FROM blueprints WHERE btid=$btid AND stid=$stid";
$resultbpid=mysql_query($querybpid);
$numbpid=mysql_num_rows($resultbpid);
while($bidum<$numbpid){
$bidumb=0;
$bidumbg=mysql_result($resultbpid, $bidum, 'bpid');
echo $bidumbg;
$querybid="SELECT COUNT(bid) AS count, workers, efficiency 
FROM buildings
INNER JOIN blueprints ON buildings.bpid=blueprints.bpid
WHERE blueprints.btid=$btid AND blueprints.stid=$stid AND buildings.bpid=$bidumbg AND buildings.idcol=$idcol";
$resultbid=mysql_query($querybid);
$staff=mysql_result($resultbid, $bidumb, 'workers');
$effic=mysql_result($resultbid, $bidumb, 'efficiency');
$count=mysql_result($resultbid, $bidumb, 'count');
echo $staff;
echo $effic;
echo $count;
$prod=$staff*$effic*$count;
echo $prod;
$bidumb++;
$bidum++;
}
$st++;
$ste++;
}
$bt++;
$bte++;
}
$ii++;
}
$i++;
$idn++;
}
?>

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.

nevermind.

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.

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.

When I try to add 30 days:
Code: [Select]
$date = date("Y-m-d");
$date = strtotime(date("Y-m-d", strtotime($date)) . " +30 days");
echo $date;
and I echo date I get 1330664400

How do I get it to echo out 3/1/2012?

I know the answer lies in the strtotime but I can't figure it out.  I know it's a simple problem for most of you...

what is the propper way to write

Code: [Select]
$payrollweek="10";
date('Y-m-d', strtotime("+($payrollweek - 2) week $payrollend") ), "<br />";
its the ("+($payrollweek - 2)  that isnt working i think

Hi

I currently pass a URL to our website as follows: http://website.com/?nid=10 but want to extend this to include a keyword from google as well. For example http://website.com/?nid=10&kw={keyword}. However it may not always have a keyword so if it does not it needs to just use the nid array.

This is the current script, how do I go about changing it so that if it just contains a nid and no keyword it will do one search of the array and return the result, and if it does have a nid&keywordod it returns something different.

For example if it had nid=1 it would return 0844 000 0300 and if it had nid=1&kw=help it would return 0844 000 0350

Thats what I am looking to achieve. Is this possible and how do I change the array. I have had a little attempt but not sure what I am doing and just got coding errors.


<?php 
$GLOBALS['ct_get_parameter_name'] = 'nid'; 
$GLOBALS['ct_default_number_id'] = 0; 

// source_id => phone number 
$GLOBALS['numbers'] = array( 
    0 => '0844 000 3000', 
    1 => '0844 000 0300', 
    2 => '0844 000 0301', 
    3 => '0844 000 0302', 
); 
session_start(); 

if (array_key_exists($GLOBALS['ct_get_parameter_name'], $_REQUEST)) 
{ 
    $_SESSION['ct_source'] = $_REQUEST[$GLOBALS['ct_get_parameter_name']]; 
} 

function get_phone_number() 
{ 
    $numbers =& $GLOBALS['numbers']; 
    $default_number_id = $GLOBALS['ct_default_number_id']; 
     
    if (isset($_SESSION['ct_source'])) 
    { 
        if (array_key_exists($_SESSION['ct_source'], $numbers)) 
        { 
            return $numbers[$_SESSION['ct_source']]; 
        } 
        else 
        { 
            // otherwise return first number 
            return $numbers[$default_number_id]; 
        } 
    } 
    else 
    { 
        // return first number 
        return $numbers[$default_number_id]; 
    } 
} 
?> 




Many thanks in advance.

Roy

i dont get whats wrong i does not add to the db

Code: [Select]
<?php

if($_POST['submitbtn']){

require "scripts/connect.php";

$title = mysql_real_escape_string($_POST['title']);
$by = mysql_real_escape_string($_POST['by']);
$body = mysql_real_escape_string($_POST['body']);

if ($title && $by && $body){

$query = mysql_query("INSERT INTO news (title, by, body)VALUES('$title', '$by', '$body')");

echo "ADD SUCCESFULLY!";

}else
   $msg = "<font color=red>YOU DID NOT FILL ALL OF THEM IN!</font>";
}

?>

Hello everyone, 
I'm making a site with PHP script and PHPmyadmin database,  i need some help with how to add news and then edit them or delete them on the site, not in the Database(if that is even possible to do it there), so far i can only delete the news,  but when i try to add new stuff i just get the error message of my code, which is not very nice of it but hey, i'm a noob at this PHP so i must be doing something wrong.

this is the code i have for the current situation.
Code: [Select]
<?php
include_once( 'database_functions.php' );


$connectID = 
connectToDatabase( 'login' );  
mysql_set_charset( 'utf8', $connectID );
$categories = mysql_query('SELECT * FROM ref_categories', $connectID);

if( @$_POST && @$_POST['submitted'] && ( !@$_GET[ 'id' ] ) )
{
$title  = ( $_POST[ 'topic_name' ] );
$topic  = ( $_POST[ 'topic_desc' ] );

//write to database
mysql_query ( "INSERT into news (title, topic) 
VALUES ('$title', '$topic')", 
$connectID )
or die ("Unable to insert record into database");
print "Record successfully added";
}
elseif( !$_POST && $_GET && $_GET['id'] )
{
$id = $_GET['id'];
$thisRecord = mysql_query("SELECT * FROM ref_categories WHERE id = $id", 
$connectID )
or die( "Can't Read this record." );

$recordData = mysql_fetch_array( $thisRecord, MYSQL_ASSOC );
}

elseif( $_POST && $_POST['submitted'] && ( $_GET['id'] ) )
{

$title  = ( $_POST[ 'title' ] );
$topic = ( $_POST[ 'topic_desc' ] );
$id  = $_GET['id'];

$success = mysql_query( "SELECT * FROM news", $connectID )
or die( "Can't Update this record" );

if( $success )
{
header( 'Location: links_admin.php?updated=1' );
}

}
else
{

}

?>

Hi.

I have a list of prices in my database - I.E:

NAME ------------  PRICE
-----------------------------
APPLE ------------- 1.00
PEAR --------------- 1.00
BANANA ----------- 1.92
-----------------------------

in php i want to add the tables data together to show a total price for that columns data.

I.E:

Total cost: 3.92

How on earth do I do this? :S!

Many Thanks