PHP - Adding Javascript To Php Can I Do This?

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

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

I am trying to add foo onto bar inside a loop so I can then echo bar outside the loop and see the sum.
The PHP manual doesn't have anything on addition in the way I need it (adding onto), so I was wondering if anyone can help me?

LOL embrace yourself!

$query = "select * from products where id='{$content['id']}'"; $result = mysql_query($query); $row = mysql_fetch_array($result);
mysql_query ($query);
mysql_close($link);
echo "
<B>Product ID:</B> {$content['id']}
<BR>
<B>Price:</B> $row[price] AUD
<BR>
<BR>
";
+$row[price] -> $total;
}
echo $total;

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?

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?

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.

Ok i have 3 columms right now i have  date  player and points and what i want is for this script to add up each players points and send it to page  as totals decending i have got the page to show them individually but when i do group it only gets one record so i tried to add in the  sum points and it gives me a  ) Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in so i am kind of lost as to where adding the sum(points) would cause this below is the code where the problem is any help would be much appreciated

$r = mysql_query("select  * from player_points Sum(points) as total where date_entered > '$d' Group by player order by  total DESC");

Hi ! please help me . im having a trouble with this im actually new to php. 

Hello,

I'm just learning PHP and I'm trying to have a different image display for each Item in a shop.. My only guess to how this would be possible is to name the IMG after the ID of the Item, like Item #10 has a name of 10.jpg.

My question is, how would I go about doing this? or is there a better way of doing this.. Here is the Code I currently have. Thanks for help.

Code: [Select]
<?php

session_start();

$page = 'index.php';

mysql_connect ('localhost','root','') or die(mysql_error());
mysql_select_db ('buggs') or die (mysql_error());

function products() {
 $get = mysql_query('SELECT id, name, description, price FROM products WHERE quantity > 0 ORDER BY id DESC LIMIT 10');
 if (mysql_num_rows($get)==0) {
   echo "There are no products to display!";
 }
 else {
   while ($get_row = mysql_fetch_assoc($get)) {
       echo '<p>'.$get_row['id'].'<br />'.$get_row['name'].'<br />'.$get_row['description'].'<br />'.number_format($get_row['price'], 2).' <a href="cart.php?add='.$get_row['id'].'">Add</a></p>';
    }
 }
}

?>
and the code to where it displays..

Code: [Select]
<?php require 'cart.php'; ?>

<html>
<head>

</head>
<body>

<?php products();?>

</body>
</html>

Hi all

I am trying to write a piece of code that takes the value from a form and checks it via an SQL table then adds the session value and the value from the SQL table into the rest of the code as a string. It is for a voucher code in a shopping basket:

if(isset($_POST['voucher_code'])) {
   
$vouchercode = $_POST['voucher_code'];

$sqlvoucher_code = mysql_query(" SELECT * FROM `voucher_codes` WHERE name = ".$vouchercode."");
$getvoucher_code = mysql_fetch_array($sqlvoucher_code);

$_SESSION['voucher_code'] = $_POST['voucher_code'];

$voucher_code = $getvoucher_code['value'];

header("Location: basket.php");

exit;

}

Every time I add a value into the form that I know is in the DB it returns a value of 0 even though the value in the DB is 15.95.

Please help!

Thanks
Pete

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

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

?>

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

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