PHP - Exploding Arrays?

Heres the code of the line im trying to trim

$r = mysql_query("insert into points values ('','${v[0]}', ${v[1]}, '$At')")or die (mysql_error());
mysql_query("insert ignore into toc values ('','$p1', '$At'),('','$p2', '$At'), ('','$p3', '$At'), ('','$p23', '$At')") or die (mysql_error());
if (!$r) die (mysql_error());

the line pertaining to the question is the  insert into points . what that part of the code does is
takes this preformatted text START POINTS
MrsSpacely 1
nanatravels 1
Trust_Me_honey 2
moratala 3
xxBIGDAVExx 3
Spring_Chicken 5
tomrarose 5
sitdownnplay 7
_Antoinette_ 11
Melyn 25
mokan40 30
dj_lia 10
STOP POINTS And inserts it into the points table. Which works fine but if you put a space after Stop points or before any name it comes back with an error about check spaces, and doesnt post the whole thing   what i need to do is trim all the spaces from the text before it tries to go into the  table

Hi,

I've been asked to modify a section on a site for a local club.

Basically, I've been asked to improve the name input section (a user may have to input up 15 names in one visit to the site).

At the moment the site works like this:
The user enters one members first name in one form box, then the surname in another, then presses "add name" which adds it to the list.

What i want to be able to do (and i'm sure i've seen it somewhere), is have the user enter the list of names into one big text area: Type in the first name then the surname, hit enter for a new line in the text area then type the next name....etc. When the list is complete press "add names" button.

Is there a name for this type of input? And does it work on the following principle:
1. The entire text sent from the text area can be exploded into an array using the line break as the delimiter
2. Each value in the array is then the first name and second name.
3. I can then explode each value further now using the space as the delimiter.
4. I am left with a bunch of arrays containing the first name in one value and the surname in the second

Any help or pointers here would be class

Cheers,

John

Using curl_multi, I have loaded up 3 url's and then printed the array.

1) How can I also set a timestamp on output to let me know when each url was run?

2) How can I explode the array to only display the data and timestamp, excluding the text "Array ( =>", "[1] =>", "[2] =>" and " )"? Code

<?php

function multiRequest($data, $options = array()) {

  // array of curl handles
  $curly = array();
  // data to be returned
  $result = array();

  // multi handle
  $mh = curl_multi_init();

  // loop through $data and create curl handles
  // then add them to the multi-handle
  foreach ($data as $id => $d) {

    $curly[$id] = curl_init();

    $url = (is_array($d) && !empty($d['url'])) ? $d['url'] : $d;
    curl_setopt($curly[$id], CURLOPT_URL,            $url);
    curl_setopt($curly[$id], CURLOPT_HEADER,         0);
    curl_setopt($curly[$id], CURLOPT_RETURNTRANSFER, 1);

    // post?
    if (is_array($d)) {
      if (!empty($d['post'])) {
        curl_setopt($curly[$id], CURLOPT_POST,       1);
        curl_setopt($curly[$id], CURLOPT_POSTFIELDS, $d['post']);
      }
    }

    // extra options?
    if (!empty($options)) {
      curl_setopt_array($curly[$id], $options);
    }

    curl_multi_add_handle($mh, $curly[$id]);
  }

  // execute the handles
  $running = null;
  do {
    curl_multi_exec($mh, $running);
  } while($running > 0);

  // get content and remove handles
  foreach($curly as $id => $c) {
    $result[$id] = curl_multi_getcontent($c);
    curl_multi_remove_handle($mh, $c);
  }

  // all done
  curl_multi_close($mh);

  return $result;
}



$data = array(array(),array());

$data[0]['url']  = 'http://search.yahooapis.com/VideoSearchService/V1/videoSearch?appid=YahooDemo&query=Pearl+Jam&output=json';
$data[1]['url']  = 'http://search.yahooapis.com/VideoSearchService/V1/videoSearch?appid=YahooDemo&query=Black+Eyed+Peas&output=json';
$data[2]['url']  = 'http://search.yahooapis.com/VideoSearchService/V1/videoSearch?appid=YahooDemo&query=Nirvana&output=json';

$r = multiRequest($data);

print_r($r);

?>

Output

Array ( => Pearl Jam [1] => Black Eyed Peas
        [2] => Nirvana )

Preferred Output

01:00:01 Pearl Jam
01:00:02 Black Eyed Peas
01:00:03 Nirvana

I'm having troubling with trying to create a function to spit out a single array with the following array. I can write it in a away that looks through the arrays manually. 

the results i am trying to generate is that each item in generated array.

Array to convert

array(
    "account" => array(
        "login",
        "register",
        "logout",
        "edit",
    ),
    "p" => array( 
        "report",
    ),
    "array1.0" => array( 
        "array2.0" => array(
            "array3.0",
            "array3.1
        ),
        "array2.1",
    ),

generating the array will look like this

 

Array ( 
[0] => account 
[1] => account/login 
[2] => account/register 
[3] => account/logout 
[4] => account/edit 
[5] => p 
[6] => p/report 
[7] => array1.0 
[8] => array1.0/array2.0
[9] => array1.0/array2.0/array3.0
[10] => array1.0/array2.0/array3.1
[11] => array1.0/array2.1

)

The idea is that id generates a single array with combined labels and arrays inside, etc. I just can't figure out how to create a script that will create this array even If I add a new value or array. 

 

I have this thing that i am trying to make but i cant get it to work.. can anyone help?

Code: [Select]
function sql_read( $dbname,$dbusername,$dbpassword )
{
$names = array();
$password = array();


$connect = @mysql_connect("mysql11.000webhost.com",$dbusername,$dbpassword) or die("Could Not Connect");
@mysql_select_db ($dbname) or die("Could not find DataBase");


$query = mysql_query("select * from users");
$numrows = mysql_num_rows($query);

if ($numrows > 0){

while($row = mysql_fetch_assoc($query)){

$names[] = $row["uname"];
$password[] = $row["password"];
$id = $row["id"];

}
$return = array($names,$password,$id);

}else{
$return = array();
}


return $return[];
}



$names = array();

$names = sql_read("XXXXXX","XXXXXX","XXXXXXX")[0];


The error i get is
Code: [Select]
Parse error: syntax error, unexpected '[' in /home/a5480952/public_html/sql/index.php on line 28
Line 28 is "$names = sql_read("XXXXXX","XXXXXX","XXXXXXX")[0];"

Please help... i REALLLLD need help with this.. ask questions if you want to know more about what i am trying to do... thanks!

I have two arrays, both with the same key values. I'd like to combine them. So for instance...

Code: [Select]
<?php
$array1['abcd'] = array( 'value1' => "blah", 'value2' => "blahblah");
$array1['efgh'] = array( 'value1' => "ha", 'value2' => "haha", 'valuex' => "xyz");

$array2['abcd'] = array('value3' => "three", 'value4' => "four");
$array2['efgh'] = array( 'value3' => "hohoho", 'value6' => "six6");

function combine_arrays($array1,$array2)
{

//*combining*
return $single_array;
}

echo "<pre>";
print_r(combine_arrays($array1,$array2));
echo "</pre>";

/*
would produce 

['abcd'] = ( 'value1'  => "blah",
                 'value2'  => "blahblah",
                 'value3'  => "three",
                 'value4'  => "four" )

['efgh'] = ( 'value1' => "ha",
                 'value2' => "haha",
                'valuex'  => "xyz",
                'value3' => "hohoho",
                'value6' => "six6" )
*/
?>
What's the easiest way to do this?

Okay so here is a very simplified version of my code in order to try and illustrate what I am trying to do:


$C1 = array (174,30);
$C2 = array (165,80);
$S = array($C1, $C2);

foreach ($S as $cluster)
{
$number = '5000';
$another_number = '4565';
$cluster[0] = $number;
}



I feel like this should be really simple but its not working.  So basically I'm trying to change the first value of the array select (e.g. C1 or C2) to whatever is in the variable $number.  Any help would be greatly appreciated.  Thanks

Ok i am trying to create a simple program that will allow mwe to use an array with 8 numbers, the output form should show the numbers in their original order that the user inputs them, in numerical order, Highest number, lowest number and then the average number. I am confused on what logic i would use to do this. If anyone could help me get started it would be much appreciated. here's waht i have so far.
Code: [Select]
<?php
$Num1 = $_POST['fielda'];
$Num2 = $_POST['fieldb'];
$Num3= $_POST['fieldc'];
$Num4 = $_POST['fieldd'];
$Num5 = $_POST['fielde'];
$Num6 = $_POST['fieldf'];
$Num7 = $_POST['fieldg'];
$Num8 = $_POST['fieldh'];
$Numbers = array(1,2,3,4,5,6,7,8);
$big = max($Numbers);
$small = min($Numbers);
$average = array_sum($Numbers) / 8; 
?>

Hello,

I have 2 array questions that I'm hoping someone can help me with.

1) First, I'm trying to add elements to a previously existing array.  I start with:

$data = array('text' => $_POST['text'],

   'question_type' => $_POST['question_type'],

  'solution' => $_POST['solution'],

  'filename' => $filename,

   'author_id' => $_POST['author']);
Then, under certain circumstances, I'm going to want to add the following to the array $data:

      'incorrect_solution1' => $_POST['incorrect_solution1'],

'incorrect_solution2' => $_POST['incorrect_solution2'],

'incorrect_solution3' => $_POST['incorrect_solution3'])

I tried the concatenation function, combined with an if statement but then PHP thinks that I have a string.

2) Once I have the array, I want to shuffle the solution and 3 incorrect solution indices.  I'm not sure how to shuffle just a portion of an array.

Any help with either or both questions would be appreciated.

Thank you.

Ok so this link returns HTML

$hitlist = file_get_contents($iMobLink."get_hit_list?user_id=".$iStore[2]."&level=10&auth_key=".$iStore[3]);

now to parse it out I have this

$entry = explode('<entry>', $hitlist);
$hitlist = file_get_contents($iMobLink."get_hit_list?user_id=".$iStore[2]."&level=10&auth_key=".$iStore[3]);
    $user_id = explode('<user_id>', $hitlist);
$user_id = explode('</user_id>', $user_id[1]);
$mobname = explode('<mob_name>', $hitlist);
$mobname = explode('</mob_name>', $mobname[1]);
$paiduser = explode('<paid_user>', $hitlist);
$paiduser = explode('</paid_user>', $paid_user[1]);
    $amount = explode('<amount>', $hitlist);
$amount = explode('</amount>', $amount[1]);
$paid_time = explode('<placed_time_ago>', $hitlist);
$paid_time = explode('</placed_time_ago>', $paid_time[1]);
$level = explode('<level>', $hitlist);
$level = explode('</level>', $level[1]);
$entry = explode('</entry>', $entry[1]);
echo $user_id[0]."\n";
echo urldecode($mobname[0])."\n";
echo $amount[0]."\n";
echo $paid_time[0]."\n";
echo $level[0]."\n";
echo $entry[0];}

Ok now.... this only returns one entry of the xml when there are more than 10. I need it to return all ten+ of the entrys

here is what the xml looks like

<outer>
−
<xml>
−
<entry>
−
<target_user>
<user_id>512433892</user_id>
<mob_name>MR%2025TATT00S%2C%20Level%2015</mob_name>
</target_user>
−
<paid_user>
<user_id>554190549</user_id>
<mob_name>PRINCE%20OF%20NEW</mob_name>
</paid_user>
<amount>48000000000</amount>
<is_npc>false</is_npc>
<placed_time_ago>3 days ago</placed_time_ago>
<level>15</level>
</entry>
−
<entry>
−
<target_user>
<user_id>530120192</user_id>
<mob_name>EVILNESS%20SIMPLIFIED%2C%20Level%2013</mob_name>
</target_user>
−
<paid_user>
<user_id>539494114</user_id>
<mob_name>StompinDatAzz</mob_name>
</paid_user>
<amount>1478608800</amount>
<is_npc>false</is_npc>
<placed_time_ago>1 day ago</placed_time_ago>
<level>13</level>
</entry>
−
<entry>
−
<target_user>
<user_id>526183645</user_id>
<mob_name>snatch%20rider%2C%20Level%20112</mob_name>
</target_user>
−
<paid_user>
<user_id>450207248</user_id>
<mob_name>ShiftyShellShock</mob_name>
</paid_user>
<amount>999999999</amount>
<is_npc>false</is_npc>
<placed_time_ago>22 hours ago</placed_time_ago>
<level>112</level>
</entry>
−
<entry>
−
<target_user>
<user_id>542145086</user_id>
<mob_name>Riding%20Raider%2C%20Level%2043</mob_name>
</target_user>
−
<paid_user>
<user_id>513441119</user_id>
<mob_name>Level%20U%20uP</mob_name>
</paid_user>
<amount>334616000</amount>
<is_npc>false</is_npc>
<placed_time_ago>18 hours ago</placed_time_ago>
<level>43</level>
</entry>
−
<entry>
−
<target_user>
<user_id>554043828</user_id>
<mob_name>klaibers%20limited%2C%20Level%2011</mob_name>
</target_user>
−
<paid_user>
<user_id>522432052</user_id>
<mob_name>Sloppy%20Seconds</mob_name>
</paid_user>
<amount>39344504405</amount>
<is_npc>false</is_npc>
<placed_time_ago>17 hours ago</placed_time_ago>
<level>11</level>
</entry>
−
<entry>
−
<target_user>
<user_id>496266215</user_id>
<mob_name>Geheim%20Abwher%2C%20Level%207</mob_name>
</target_user>
−
<paid_user>
<user_id>216904061</user_id>
<mob_name>yve1</mob_name>
</paid_user>
<amount>2499912800</amount>
<is_npc>false</is_npc>
<placed_time_ago>16 hours ago</placed_time_ago>
<level>7</level>
</entry>
−
<entry>
−
<target_user>
<user_id>524874924</user_id>
<mob_name>MYLILFRIEND%2C%20Level%20104</mob_name>
</target_user>
−
<paid_user>
<user_id>536745842</user_id>
<mob_name>SUC%20MY%20GLOCK</mob_name>
</paid_user>
<amount>1615247200</amount>
<is_npc>false</is_npc>
<placed_time_ago>15 hours ago</placed_time_ago>
<level>104</level>
</entry>
−
<entry>
−
<target_user>
<user_id>531185082</user_id>
<mob_name>THE%20RAGE%20WITHIN%2C%20Level%2031</mob_name>
</target_user>
−
<paid_user>
<user_id>512862859</user_id>
<mob_name>The%20Kozmik%20Slop</mob_name>
</paid_user>
<amount>16536800</amount>
<is_npc>false</is_npc>
<placed_time_ago>14 hours ago</placed_time_ago>
<level>31</level>
</entry>
−
<entry>
−
<target_user>
<user_id>494326270</user_id>
<mob_name>RIDE%20HIS%20CUCUMBER%2C%20Level%2016</mob_name>
</target_user>
−
<paid_user>
<user_id>554794332</user_id>
<mob_name>STDS%20R%20BAD%20MMKAY</mob_name>
</paid_user>
<amount>337825600</amount>
<is_npc>false</is_npc>
<placed_time_ago>14 hours ago</placed_time_ago>
<level>16</level>
</entry>
−
<entry>
−
<target_user>
<user_id>558355598</user_id>
<mob_name>DEATH%20TO%20HITLIST%2C%20Level%2011</mob_name>
</target_user>
−
<paid_user>
<user_id>558349535</user_id>
<mob_name>Gangsta%20Love</mob_name>
</paid_user>
<amount>181600000</amount>
<is_npc>false</is_npc>
<placed_time_ago>10 hours ago</placed_time_ago>
<level>11</level>
</entry>
−
<entry>
−
<target_user>
<user_id>545114043</user_id>
<mob_name>Ridin%20Dirty%2C%20Level%20130</mob_name>
</target_user>
−
<paid_user>
<user_id>510805692</user_id>
<mob_name>iced%20baby</mob_name>
</paid_user>
<amount>481680800</amount>
<is_npc>false</is_npc>
<placed_time_ago>10 hours ago</placed_time_ago>
<level>130</level>
</entry>

Notice there is more than one energy.. now how to I parse it out to where I can define each entry by a variable or something... any help is appreciated.. Thanks

Hello,

I have an array, $solutions, and a separate indexing array, $solution_order.  From the $solution_order array (developed from the $order variable, where each $order variable looks like '0321' or '3021'), I'd like to create a new array $ordered_solutions, which indexes on the values picked from the $solution_order array.  For example, if my $solutions array is (Big, Small, Fat, Skinny) and my $solution_order array is (2,3,1,0), then the final results should be (Fat, Skinny, Small, Big).  I've written down what I have so far.  Any thoughts about how to move this forward would be appreciated.

Thanks!
function GetOrder($solution, $wrong1, $wrong2, $wrong3, $order) {

$solutions = array( $solution,

               $wrong1,

$wrong2,

               $wrong3);

$solution_order = array(substr($order,0,1),

       substr($order,1,1),

       substr($order,2,1),

      substr($order,3,1));
$ordered_solutions = array();

//what do to here??

return $ordered_solutions;
}

Hello! i want to store data in a array (as seen in the code). Im trying to make it so that a php code search through the arrays and find the correct one. once it does it tells me. I dont know if im close, How ever this is what i have.


$carrier = $_POST['carrier'];

$carriers = array(
array("verizon","tmobile","sprint","att","virgin","textnow","metro","unknown"),
array("@vtext.com","@tomomail.net","@messaging.sprintpcs.com","@txt.att.net","@vmobl.com","@textnow.me","@mymetropcs.com","@teleflip.com")
            );

If ($carrier = 

I'm not sure if this can be done, but I would like to get the sum for each $.row[''] result ex: if $row['robotics'] had values of 100,150,300 I would like to be able to show a total of 550

Code: [Select]
<?php
echo "<Table border=1>";
echo "<tr><td></td><td>Robotics</td><td>Chiral Stuctors</td><td>Enriched Uranium</td><td>Mechanical Parts</td><td>Coolant</td><td>Consumer Electronics</td><td>Precious Metals</td><td>Reactive Metals</td><td>Oxygen</td><td>Toxic Metals</td></tr>";
$result = mysql_query("select * from `pi`");
while ($row = mysql_fetch_array($result)) {

echo "<tr><td>".$row['pilot']."</td>";
echo "<td>".$row['robotics']."</td>";
echo "<td>".$row['chiralstuctors']."</td>";
echo "<td>".$row['enricheduranium']."</td>";
echo "<td>".$row['mechanicalparts']."</td>";
echo "<td>".$row['collant']."</td>";
echo "<td>".$row['consumerelectronics']."</td>";
echo "<td>".$row['preciousmetals']."</td>";
echo "<td>".$row['reactivemetals']."</td>";
echo "<td>".$row['oxygen']."</td>";
echo "<td>".$row['toxicmetals']."</td></tr>";

}
echo "</table>";
?>

Hi, I am trying to specify a new variable that points to two columns from a table, I think I need to use an array but not sure how to code it. The reason I want one variable instead of two is because it will be used as a dynamic link for home teams and away teams to link to the team page, hope that makes sense. Here is the code I currently have:

Code: [Select]
<?php
$query = "SELECT tr.competition, tr.date, tr.htp, tr.hts, tr.ats, tr.atp, tr.et, tr.htpts, tr.atpts, tth.team as hometeam, tta.team as awayteam
FROM test_selections ts 
LEFT JOIN (test_results tr, test_teams tth, test_teams tta) 
ON (tth.teamid = tr.hometeam AND tta.teamid = tr.awayteam)
WHERE ts.userid = '{$_SESSION['userid']}' AND (tr.hometeam = ts.teamid OR tr.awayteam = ts.teamid)
GROUP BY tr.resultid
ORDER BY tr.resultid DESC";
        $result = mysql_query($query) or die(mysql_error());
        
        while($row = mysql_fetch_assoc($result))
{
$team = array($row['hometeam'], $row['awayteam']);
?>
Any help would be very much appreciated.

Hi i'am try to insert multiple data on a single submit, but i'm a total noob to Arrays, can any one help me out here... one of the members send me this out, but still i can figure it out how to insert the fields onto my database. it inserts but doesnt get the valuee.. Please help!

if(isset($_POST['save']))
   {
   unset($_POST['save']);
   $i = count($_POST['id']); $x = 0;
   for($x=0; $x <$i;$x++){
      foreach($_POST as $data =>$d){
      echo $data.'-'.$d[$x].'<br/>';
      $insert = mysql_query("insert into tbl_grades");
//sql statement here (example): insert into table name (value of $data) values( value of$d[$x]) --

can anyone help me with this , how can i query to get the value of  this,
//HOW DO I MAKE MY SQL QUERY TO SAVE THIS OUT, I KNOW THIS IS MY PROBLEM IN THE QUERY....

here's my HTML

 <input name="id[]" type="hidden" value="<?php echo $row['id'];?>" />
 1st<input name="fg[]" type="text" id="fg[]" size="1" value="<?php  $g_sub['sub_id'];?>"/>
 2nd<input name="sg[]" type="text" id="sg[]" size="1" value="<?php  $g_sub['sub_id'];?>"/>
 3rd<input name="tg[]" type="text" id="tg[]" size="1" value="<?php  $g_sub['sub_id'];?>"/>
4th <input name="forg[]" type="text" id="forg[]" size="1" value="<?php  $g_sub['sub_id'];?>"/> ---- sub_id stands for subject id