PHP - Cannot Get "foreach" To Work From An Array??

Can someone please help me with an array problem i can not figure out.

I need the array to be numbered from 1 to how ever many fields that are needed in the form and have a mysql field name and the title of the field also in the array.

1, "mysql_field_name", "Title of form field"
2, "", ""

and so on

then the form will be shown based on the array.

I have the following draft code which I am working with.

any suggestions on how i may do this array ?

Code: [Select]
<?php
$options = array(
'1'=> array('fieldtext'=>'option1', 'mysqlfield'=>'option1'),
'2'=> array('fieldtext'=>'option2', 'mysqlfield'=>'option2'),
'3'=> array('fieldtext'=>'option3', 'mysqlfield'=>'option3'),
'4'=> array('fieldtext'=>'option4', 'mysqlfield'=>'option4'),
);


// $options = array(1 => "option1", "option2", "option3", "option4");

// the line above works but i want to include the name of the mysql field as well.

$userid = 1;

?>
<div style="align: center; margin: 12px; font-family:Tahoma;">
<br><br><?php
if ($_POST['Update'] != "Update") { // check if form submitted yet, if not get data from mysql.
$res = db_query("SELECT * FROM `users` WHERE `userid` = '" . $userid . "'");
foreach($options as $key => $value) { $_POST[$key] = mysql_result($res, 0, $value); }
$ok_to_update = "no";
} elseif ($_POST['Update'] == "Update") { // check if form submitted yet, if so get POST data.
// error checking
// foreach($options as $key => $value) {
// $_POST[$i] = "";
// }
$ok_to_update = "yes";
}

if ($_POST['Update'] == "Update" && $ok_to_update == "yes") {
// $res = db_query("INSERT INTO `users` () VALUES ()"); // add user details to database.
?><p><br><br><br>Thank you for updating</p><?php
} else {
?><form name="form1" method="post" action="">
<?php foreach($options as $key => $value) {
?><p><?php echo($value); ?>:&nbsp;<input type="text" name="<?php echo($key); ?>" value="<?php echo($_POST[$key]);?>"></p>
<?php } ?>
<input name="Update" type="submit" value="Update">
</form>
<?php } ?>
</div>

Hi guys

I'm struggling a bit, I need to replace a word that occurs multiple times in text with an array("up","down","forward","backwards") of words.


$find = "left";
$replace = array("up","down","forward","backwards");
$text = "left left left left";

echo str_replace($find,$replace,$text);


The Output is: array array array array

Did try this with a foreach statement as well, but no luck. Is there a better way of doing this? 

Thanks

Hi,

bit stuck on how to find and replace "<" and ">" with "&lt;" and  "&gt;". I basically have a database record that outputs to screen and I need the code in the <code> tags to be rendered to the screen. I therefore need it to go through the whole array variable from the db and change the symbols just inside the code tags. Please be aware that the code tags might happen more than once

here's an example below

Code: [Select]
<p>blah blah blah</p>
<p>blah blah blah</p>
<p>blah blah blah</p>
<code>
<h1>hello</h1>
</code>
<p>blah blah blah</p>
<p>blah blah blah</p>
<p>blah blah blah</p>
<code>
<h1>hello</h1>
</code>

the desired output would be:

<p>blah blah blah</p>
<p>blah blah blah</p>
<p>blah blah blah</p>
<code>
&lt;h1&gt;hello&lt;/h1
</code>
<p>blah blah blah</p>
<p>blah blah blah</p>
<p>blah blah blah</p>
<code>
&lt;h1&gt;hello&lt;/h1
</code>

help on this would be great

Cheers

Rob

hello

how do i pass a foreach loop through "Passing by Reference"

say i have a foreach loop in a function like this:

Code: [Select]

function findText(&$output){
  $word = Text::find_all(); 
  foreach ($word as $words){
  $output = $words->text;
  }
}

then one the page i put

Code: [Select]

findText($output);
echo $output;


that will just give me the last word in the database.

so how do i get it to echo out the array on the page ?

thanks

Greetings to all!

I am very new to this so I may not be on the right track.  I am providing some code I have because I think this is the best way to explain what I am trying to do.  I have a database and php pages that generate a pedigree when one selects any particular dog from the search page.  If anyway has a tip on how to simplify this, I would sure appreciate it!!

First, I request an array for the dog selected:


Code: [Select]
$sql = "SELECT RegName, SireID, DamID FROM pedigrees WHERE ID=";

$thisDogQ = $sql . $values["ID"];
$thisDogR = db_query($thisDogQ,$conn);


$thisDogRow_value = mysql_fetch_assoc($thisDogR);
    $thisDogRow_value = array (
'RegName' => $thisDogRow_value['RegName'],
'SireID' => $thisDogRow_value['SireID'],
'DamID' => $thisDogRow_value['DamID']);
</code>

//Next I request the same information for his sire

<code>
if (is_numeric($thisDogRow_value['SireID'])) {
 
$query_SireQ = $sql . $thisDogRow_value['SireID']; 
$SireR = mysql_query($query_SireQ, $conn) or die(mysql_error());

  $SireRow_value = mysql_fetch_assoc ($SireR);         
$SireRow_value = array (
'RegName' => $SireRow_value['RegName'],           
'SireID' => $SireRow_value['SireID'],           
'DamID' => $SireRow_value['DamID']);
</code>

//and then his dam

<code>
if (is_numeric($thisDogRow_value['DamID'])) {
 
$query_DamQ = $sql . $thisDogRow_value['DamID'];   
$DamR = mysql_query($query_DamQ, $conn) or die(mysql_error());

  $DamRow_value = mysql_fetch_assoc ($DamR);         
$DamRow_value = array (
'RegName' => $DamRow_value['RegName'],           
'SireID' => $DamRow_value['SireID'],           
'DamID' => $DamRow_value['DamID']);

</code>

Now, here's the rub:  Now I need the sire and the dam for those 2 [described above] so this time through, I will need the same information for FOUR dogs.  The next time will be for EIGHT, then SIXTEEN - and so on until there are a total of 256 dogs.

<code>
//Get PatGrandSire 2

if (is_numeric($SireRow_value['SireID'])) {

$PatGrandSireQ = $sql . $SireRow_value['SireID'];
$PatGrandSireR = mysql_query ($PatGrandSireQ, $conn) or die(mysql_error());
    $PatGrandSireRow_value = mysql_fetch_assoc ($PatGrandSireR);         

$PatGrandSireRow_value = array (
'RegName' => $PatGrandSireRow_value['RegName'],           
'SireID' => $PatGrandSireRow_value['SireID'],           
'DamID' => $PatGrandSireRow_value['DamID']);

//GetPatGrandDam 17
if (is_numeric($SireRow_value['DamID'])) {
$PatGrandDamQ = $sql . $SireRow_value['DamID'];
$PatGrandDamR = mysql_query ($PatGrandDamQ, $conn) or die(mysql_error());
$PatGrandDamRow_value = mysql_fetch_assoc ($PatGrandDamR);

$PatGrandDamRow_value = array (
'RegName' => $PatGrandDamRow_value['RegName'],
'SireID' => $PatGrandDamRow_value['SireID'],
'DamID' => $PatGrandDamRow_value['DamID']);
//Get Pat1GGrandSire-3

if (is_numeric($PatGrandSireRow_value['SireID'])) {
$Pat1GGrandSireQ = $sql . $PatGrandSireRow_value['SireID'];
$Pat1GGrandSireR = mysql_query ($Pat1GGrandSireQ, $conn) or die(mysql_error());
     
$Pat1GGrandSireRow_value = mysql_fetch_assoc ($Pat1GGrandSireR);         
$Pat1GGrandSireRow_value = array (
'RegName' => $Pat1GGrandSireRow_value['RegName'],           
'SireID' => $Pat1GGrandSireRow_value['SireID'],
'DamID' => $Pat1GGrandSireRow_value['DamID']);


if (is_numeric($PatGrandSireRow_value['DamID'])) {
$Pat1GGrandDamQ = $sql . $PatGrandSireRow_value['DamID'];
$Pat1GGrandDamR = mysql_query ($Pat1GGrandDamQ, $conn) or die(mysql_error());
     
$Pat1GGrandDamRow_value = mysql_fetch_assoc ($Pat1GGrandDamR);         
$Pat1GGrandDamRow_value = array (
'RegName' => $Pat1GGrandDamRow_value['RegName'],           
'SireID' => $Pat1GGrandDamRow_value['SireID'],           
'DamID' => $Pat1GGrandDamRow_value['DamID'],
'Title' => $Pat1GGrandDamRow_value['Title'],
'Title2' => $Pat1GGrandDamRow_value['Title2'],
'Title3' => $Pat1GGrandDamRow_value['Title3'],
'Title4' =>$Pat1GGrandDamRow_value['Title4'],
'Title5' => $Pat1GGrandDamRow_value['Title5'],
'Title6' =>$Pat1GGrandDamRow_value['Title6'],
'Title7' => $Pat1GGrandDamRow_value['Title7'],
'Title8' =>$Pat1GGrandDamRow_value['Title8'],
'Title9' => $Pat1GGrandDamRow_value['Title9'],
'Addl_Titles' => $Pat1GGrandDamRow_value['Addl_Titles']);
//Get Pat2GGrandSire-18

if (is_numeric($PatGrandDamRow_value['SireID'])) {
$Pat2GGrandSireQ = $sql . $PatGrandDamRow_value['SireID'];
$Pat2GGrandSireR = mysql_query ($Pat2GGrandSireQ, $conn) or die(mysql_error());
     
$Pat2GGrandSireRow_value = mysql_fetch_assoc ($Pat2GGrandSireR);         
$Pat2GGrandSireRow_value = array (
'RegName' => $Pat2GGrandSireRow_value['RegName'],           
'SireID' => $Pat2GGrandSireRow_value['SireID'],
'DamID' => $Pat2GGrandSireRow_value['DamID'],
'Title' => $Pat2GGrandSireRow_value['Title'],
'Title2' => $Pat2GGrandSireRow_value['Title2'],
'Title3' => $Pat2GGrandSireRow_value['Title3'],
'Title4' => $Pat2GGrandSireRow_value['Title4'],
'Title5' => $Pat2GGrandSireRow_value['Title5'],
'Title6' => $Pat2GGrandSireRow_value['Title6'],
'Title7' => $Pat2GGrandSireRow_value['Title7'],
'Title8' => $Pat2GGrandSireRow_value['Title8'],
'Title9' => $Pat2GGrandSireRow_value['Title9'],

'Addl_Titles' => $Pat2GGrandSireRow_value['Addl_Titles']);

//Get Pat2GGrandDaminfo-25

if (is_numeric($PatGrandDamRow_value['DamID'])) {
$Pat2GGrandDamQ = $sql . $PatGrandDamRow_value['DamID'];
$Pat2GGrandDamR = mysql_query ($Pat2GGrandDamQ, $conn) or die(mysql_error());
     
$Pat2GGrandDamRow_value = mysql_fetch_assoc ($Pat2GGrandDamR);         
$Pat2GGrandDamRow_value = array (
'RegName' => $Pat2GGrandDamRow_value['RegName'],           
'SireID' => $Pat2GGrandDamRow_value['SireID'],           
'DamID' => $Pat2GGrandDamRow_value['DamID']);