PHP - Select 500 Char First

I have the following code:

Code: [Select]
$str = ($stringcontents[$step+38]);
$str1 = ord($str);
$bgcolor = convertchar($str1);
?>
<td bgcolor='<?php echo $bgcolor;?>'>
<span title='<?php echo $fieldname;?>' style='color: <?php echo $fgcolor;?>; font-size: 12pt'><font color="<?php echo $fgcolor;?>"><?php echo $stringcontents[$step];?></font></span>

the convertchar function takes the ord value of the ASCII chr and sets a variable for bgcolor and fgcolor using HTML color codes.  The background sets correctly, but the foreground ASCII chr is always black and does not use the font color code.

What do I need to do to get the ASCII chr to change to a color other than black?


Added:
I am using a default charset:

<META http-equiv="Content-Type" content="text/html; charset=IBM437">

Hi all

I am trying to loop through an array and output as JSON.
What I'm looking to do is create something like:

Code: [Select]
  "something": [
{"title":"Test 1"},
{"title":"Test 2"}
],

Notice that the final row has no comma.

My code is as follows:


<?php foreach($something as $thing): ?>
<?php $something_array = array('title'=>$thingt->getId()); ?>
<?php echo json_encode($something_array).','."\n"; ?>
<?php endforeach; ?>


I had to add a comma to the end of the array, or the JSON rows would not be ended with one.

How can I get it so that, no matter how many items are in the array, the last row, wil not have the comma at the end?

With the comma at the end, my JSON doesn't validate

Thanks


[/code]

I have a list of pictures and I want to control the order.


Here is the picture format:
$pic = http://www.picture.biz/incoming/w_2GTEK13T961240561_1.jpg
$pic = http://www.picture.biz/incoming/w_2GTEK13T961240561_2.jpg
$pic = http://www.picture.biz/incoming/w_2GTEK13T961240561_3.jpg
$pic = http://www.picture.biz/incoming/w_2GTEK13T961240561_4.jpg
$pic = http://www.picture.biz/incoming/w_2GTEK13T961240561_5.jpg

Notice the order 1.jpg, 2.jpg, etc..

Here is where I'm stuck...

// begin stuck :)
$orderPic = explode("_", $pic);

foreach($orderPic as $rank){
     echo "$rank"; // I need $rank to equal 1 then 2 then 3 ...
}


It would be nice actually if I could start the insert with number 2 because number one is always a screwy picture.

I hope this makes sense /  Thank for the help!

This topic has been moved to PHP Regex.

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

I have a text file that contain something like this :

question.txt

------------------------
12/10/2010
Quest : Was a web designer really care about your web security other than thinking so hard to design your web just based on how the web will looks like?.
>>from:sombody@somwhere.com,opinion=not at all,comment:your site are cool
11/10/2010
Quest : Was a web designer really love his girl friend in other side they r almost got no time dating with her?
>>from:sombody@somwhere.net,opinion=he loves computer,comment:your site are waste.
-------------------------

All i need to do is, grabing all informations after the char ">>" and write it to another text file name "output.txt" that will contain :

output.txt
---------------------
from:sombody@somwhere.com,opinion=not at all,comment:your site are cool
from:sombody@somwhere.net,opinion=he loves computer,comment:your site are waste.
---------------------

can some one show me the way?

thanks.

hirealimo.com.au/code1.php

this works as i want it:
Quote

SELECT * FROM price INNER JOIN vehicle USING (vehicleID) WHERE vehicle.passengers >= 1 AND price.townID = 1 AND price.eventID = 1



but apparelty selecting * is not a good thing????

but if I do this:
Quote

SELECT priceID, price FROM price INNER JOIN vehicle....etc


it works but i lose the info from the vehicle table.

but how do i make this work:
Quote

SELECT priceID, price, type, description, passengers FROM price INNER JOIN vehicle....etc


so that i am specifiying which colums from which tables to query??

thanks

I have 2 queries that I want to join together to make one row  

Dear All,

I wish to have 2 drop down boxes, Country Select Box and Locality Select Box. The locality select box will be affected by the value chosen in the country select box.

All is working fine except that the locality select box is not being populated.
I know that the problem is in the sql statement

WHERE country_id='$co'

because i am having an error that $co is an undefined variable.

All the rest works fine because i have replaced the $co variable directly with a number (say 98) for a particular country id and it worked fine. In what way can i define this variable $co so that it is accepted by my sql statement?

Thank you for your help in advance.

MySQL Tables indicated below:

CREATE TABLE countries(
country_id INT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
country_name VARCHAR(30) NOT NULL,
PRIMARY KEY(country_id),
UNIQUE KEY(country_name),
INDEX(country_id),
INDEX(country_name))
ENGINE=MyISAM;

CREATE TABLE localities(
locality_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
country_id INT(3) UNSIGNED NOT NULL,
locality_name VARCHAR(50),
PRIMARY KEY (locality_id),
INDEX (country_id),
INDEX (locality_name))
ENGINE=MyISAM;

Extract PHP script included below:

// connect to database
require_once(MYSQL);

if(isset($_POST['submitted']))

{

// trim the incoming data

/* this line runs every element in $_POST through the trim() function, and assigns the returned result to the new $trimmed array */
$trimmed=array_map('trim',$_POST);

// clean the data

$co=mysqli_real_escape_string($dbc,$trimmed['country']);

$lc=mysqli_real_escape_string($dbc,$trimmed['locality']);

}

?>

<form action="form.php" method="post">

<p>Country
<select name="country">
<option>Select Country</option>

<?php

$q="SELECT country_id, country_name
FROM countries";

$r=mysqli_query($dbc,$q) or
trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

while($row=mysqli_fetch_array($r))

{

$country_id=$row[0];
$country_name=$row[1];
echo '<option value="' . $country_id . '"';
if(isset($trimmed['country']) && ($trimmed['country']==$country_id))
echo 'selected="selected"';
echo '>' . $country_name . '</option>\n';

}

?>

</select>
</p>

<p>Locality
<select name="locality">
<option>Select Locality</option>

<?php

$ql="SELECT locality_id, country_id, locality_name
FROM localities
WHERE country_id='$co'
ORDER BY locality_name";

$rl=mysqli_query($dbc,$ql) or
trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

while($row=mysqli_fetch_array($rl))

{

$locality_id=$row[0];
$country_id=$row[1];
$locality_name=$row[2];
echo '<option value="' . $locality_id . '"';
if(isset($trimmed['locality']) && ($trimmed['locality']==$locality_id))
echo 'selected="selected"';
echo '>' . $locality_name . '</option>\n';

}

// close database connection
mysqli_close($dbc);

?>

</select>
</p>

<p><input type="submit" name="submit" value="Submit" /></p>

<input type="hidden" name="submitted" value="TRUE" />

</form>

I'm trying to run a readout of a db which runs fine as an individual script. When I embed it in PHP inside an html div container, it bails when it encounters the first ">" and simply outputs the PHP characters from there through the "?>". The rest of the html runs fine before and after. For example, this line

echo "<select>";

would output

";

and any other php script up to the ?> end, after which it renders html fine. If I run the script as a separate php file, it runs as expected. Any help would be appreciated. Thanks.

 hi guys ive just finished this task after hours of head scratching

since svg is only really supported good in firefox and opera ive chosen firefox as my browser to view this url

www.deansignori.com/phpsvgpie/index.php

i do need more help with this task but a different problem (creating select box to call different stylesheet and to change from 2d - 3d

i have the code set out so that i can explode any segment or change size of slices or change from 2d-3d but i have to do this manually in the code to render different piecharts im wanting to use 1 but change it using a select box and echo my variable into it

basically im unsure of the syntax for this problem

psuedo code for style maybe something like

if select box value isset onchange stylecolour
echo stylecolour
if select box value isset onchange stylegrey
echo stylegrey

and for 3d-2d

if select box value isset onchnage format3
echo format3
if select box value isset onchange format2
echo format2

this would be on my index page

can anyone advise me please 

regards
Dean

ok here's my problem $Sql1 returns two values: 8 and 10 and these numbers get put into a <select>. So far so good. I assign a onchange to it. When i select 8 it makes the changes but when I select 10 nothing happends. I preciate some help.

Code: [Select]
<?php
require("status.php");
require("id.php");

$Link = mysql_connect($Host, $User, $Password);
mysql_select_db('sportsportal', $Link);

$Sql1 = "select distinct week, (select max(week) from coupons where user='$User') max from coupons where user='$User'";
$Result1 = mysql_query($Sql1, $Link);

print "<tr>";
print "<td align=left valign=top>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>";
print "<td align=left valign=top>";

print "<select name=current_week onchange=window.location='coupon.php?curwk='+this.value>";
while($Row1 = mysql_fetch_array($Result1)){

//if($Row1[week] == $Row1[max]){
//print "<option value='$Row1[week]' selected>Vecka $Row1[week]</option>";
//} else {
//print "<option value='$Row1[week]'>Vecka $Row1[week]</option>";
//}

print "<option value='$Row1[week]'>Vecka $Row1[week]</option>";

}
print "</select>";

print "<p></td>";
print "</tr>";

if(isset($_REQUEST['curwk'])){
$Curwk = $_REQUEST['curwk'];
} else {
$Curwk = 0;
}

$Sql = "select home, away, home_score, away_score, winner from coupons where user='$User' and week='$Curwk'";
$Result = mysql_query($Sql, $Link) or die(mysql_error());

while($Row = mysql_fetch_array($Result)){

if(@$Row[home] == @$Row[winner]){
print "<tr>";
print "<td align=left valign=top>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>";
print "<td align=left valign=top><b>$Row[home]</b> - $Row[away] $Row[home_score]-$Row[away_score]</td>";
print "</tr>";
} else {
print "<tr>";
print "<td align=left valign=top>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>";
print "<td align=left valign=top>$Row[home] - <b>$Row[away]</b> $Row[home_score]-$Row[away_score]</td>";
print "</tr>";
}

}

mysql_close($Link);
?>

Hi everyone! 

I need to know how to write two $what_services variables in so it looks for both "R" AND "B"..

R and B are values within my db table, here's the code:

Code: [Select]
<?php
$what_services = "R";

    $query = "SELECT * FROM companies WHERE what_services = '$what_services' ORDER BY approved DESC, company_name ASC";
$result = mysql_query($query); ?>

iv'e tried the following but have gotten undesired results:

 two what services like so;

$what_services = "R";
$what_services = "B";

separating with comma's;

$what_services = "R, B";

Using AND;

$what_services = "R AND B";

None of which works, what is the correct way to write this?

Thanks

Hi,

I'm not quite sure how to do this, so i thought i'd ask you guys from some assistance.

Basically i am inserting Author's into a table successfully using an array. The reason for this is that i have multiple authors being added and there is no limit as to how many. An example of what i mean can be seen he

http://www.prima.cse.salford.ac.uk:8080/~ibrarhussain/test.html

You can click on "Add author" to add however many necessary..

Anyway, i have got the insert working, however when i edit i want to be able to see all the authors that have been added but obviously i don't know how many there are..

Typically i would like to see something like this:

http://www.prima.cse.salford.ac.uk:8080/~ibrarhussain/edit.jpg

So i would click on an edit link and it would pre populate the text boxes. I don't have a problem with doing this, but how can i show the correct amount of input textboxes based on how many authors exist for that specific record?

Can someone offer some advice please?

The input elements are like so:

Quote

<input type="text" name="author[]" id="author1"/>
<input type="text" name="author[]" id="author2"/>
<input type="text" name="author[]" id="author3"/>
...
...
...
<input type="text" name="author[]" id="author10"/>



Some records may have 1 author some may have 10, so how can i do this?

Thanks again..

Hi, what I want to figure out is for instance a person has registered with their country e.g. England. Now if I echo the country in a select box giving the person an option to change their country and Showing the person which currently they have selected already. The select box shows two England`s to select from. Could some one tell me how can I have one of each country and echo their already selected country from the database. I don't know how to explain any better what I am after but just basically there are two Englands showing one which is already selected (echoing from the mysql database)  and one is already in the select box.  Any help is much appreciated thank you.