PHP - Array Keys And Values, Extracting And Forming A String.

Say I have this array:

Code: [Select]
<?php
$array = array('one' => array(), 'two' => array(), '_three' => array());
?>
How could I sort that array so it ends up like so:

Code: [Select]
Array
(
    [_three] => Array
        (
        )

    [one] => Array
        (
        )

    [two] => Array
        (
        )
)
Thanks!!

This topic has been moved to PHP Regex.

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

Hey there...

I'm so stuck on this problem I was hoping someone could help...

I need to query a MySQL Database using array values...

Here is my array ... $query_keywords = Array ( [7] => business [10] => home [11] => depo )
 
Here is my php ...$query = "SELECT * FROM product WHERE product_name, product_comment IN ($query_keywords)";
$result=mysql_query($query);

if(mysql_num_rows($result) > 0)
{
   echo "results";
}
else
{
   echo "no results";
}


Unfortunately, I get this ...
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in blah\blah\results.php on line 99

Please help me
All comments greatly appreciated...

Hi everyone,

I'm new to this group and new to php. I have created a multi-part form that allows the user the option to add multiple input fields to a form to upload images. Here is the form structu

Code: [Select]
<form action="Scripts/processreports2.php" method="post" enctype="multipart/form-data" name="report_form" target="uploader" class="reportfrm">
<fieldset>
        <legend>Upload your images</legend>
        <ol id="add_images">
          <li>
        <input type="file" class="input" name="files[]" />
          </li>
  <li>
        <input type="file" class="input" name="files[]" />
          </li>
  <li>
        <input type="file" class="input" name="files[]" />
          </li>
        </ol>
        <input type="button" name="addFile"  id="addFile" value="Add Another Image" onclick="window.addFile(this);"/>
</fieldset>
        <p>* indicates a required field.</p>
        <input name="submit" type="submit" id="submit" value="Send Info!" />
</form>

Through php a maximum of three input fields are fed into an array that checks to make sure that the uploaded files are images and not some other type of file. The uploading porition of this script works.

Now I am trying to get the values of the input fields as a string and insert them into the database as one record.

Let's say the user has three files they want to upload. I have managed to get the files as a string ie; file1.jpg, file2.jpg, file3.jpg but what is happening is that I am getting three separate records with  file1.jpg, file2.jpg, file3.jpg in them. If the user has only two files to upload then I get two separate records with file1.jpg and file2.jpg in them. (Hope that makes sense). I want one record.

I have been struggling with this since Monnday and while every day I get closer, this is as close as I can get. Below is the php code.

#connect to the database

mysql_connect("localhost", "root", "");

mysql_select_db("masscic");

//Upload Handler to check image types

function is_image($file) {

$file_types = array('jpeg', 'gif', 'bmp'); //acceptable file types

if ($img = getimagesize($file)){

//echo '<pre>';

//print_r($_FILES); used for testing

//print_r($img); used for testing

if(in_array(str_replace('image/', '', $img['mime']), $file_types))

return $img;

}

return false;
}

//form submission handling

if(isset($_POST['submit'])) {

//file variables

$fname = $_FILES['files']['name'];

$ftype = $_FILES['files']['type'];

$fsize = $_FILES['files']['size'];

$tname = $_FILES['files']['tmp_name'];

$ferror = $_FILES['files']['error'];

$newDir = '../uploads/'; //relative to where this script file resides

for($i = 0; $i < count($fname); $i++) {
    //echo 'File name ' . $fname[$i] . ' has size ' . $fsize[$i]; used for testing

if ($ferror[$i] =='UPLOAD ERR OK' || $ferror[$i] ==0) 

{

if(is_image($tname[$i]))

{

//append the tmp_name($tname) to the file name ($fname) and upload to the server

move_uploaded_file($tname[$i], ($newDir.time().$fname[$i])); 

echo '<li><span class="success">'.$fname[$i].' -- image has been accepted<br></span></li>';

}else 

echo '<li><span class="error">'.$fname[$i].' -- is not an accepted file type<br></span></li>';

}

if (is_array($fname))

$files = implode(', ',$fname);

//else $files = $fname;

$sqlInsert = mysql_query("INSERT INTO files (file_names) VALUES('$files')") or die (mysql_error());

}
}

atm i have this in a function:

Code: [Select]
$returnInfo = array();

$returnInfo["totalWords"] = $totalWords;
$returnInfo["uniqueWords"] = count($uniqueWords);
$returnInfo["positiveWords"] = $positiveWords;
$returnInfo["negativeWords"] = $negativeWords;
$returnInfo["rating"] = $mappedrating;

return $returnInfo;

If i recursive print it it says Array instand of my expected values.

p.s., i have found examples where the array get's created in 1 line with all there values but i prefer not to do that since it will be a very long line.

how to connect juice and 1 and milk and 3 and cola and 2? and then sort it by the numbers from high to low?

$a=array('juice','milk','cola');
$a2=array('1','3','2');

This:
Code: [Select]
echo "<pre>";
print_r($torrent->content());
echo "</pre>";
Returns:
Code: [Select]
Array
(
    [Eureka.S05E01.HDTV.XviD-ASAP\Eureka.S05E01.HDTV.XviD-ASAP.avi] => 367011826
    [Eureka.S05E01.HDTV.XviD-ASAP\eureka.s05e01.hdtv.xvid-asap.nfo] => 4798
    [Eureka.S05E01.HDTV.XviD-ASAP\Sample\eureka.s05e01.hdtv.xvid-asap.sample.avi] => 7883092
)
Needs to be inserted to MySQL like:


In other words, the array $torrent->content() needs to be inserted to MySQL as new lines at columns "filename" and "size".

Please help me..

hey guys i need to extract all the IP's of a string and loop them for more operations but for some reason i only get the first one

<?php

$string = '80.37.14.13 80.37.14.14 80.37.14.15';
preg_match("/\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}/", $string, $matches);

foreach ($matches as $ip){
    echo "$ip<br>";
}

?>

The string is not really seperated by spaces ... it can actualy be messy and have ips rapped arround a lot of code. The regex works because i do get the first one ...

What did i miss?

I have a string

Code: [Select]
<p>Bollywood romcom: a pair of wouldbe suicides choose the same bridge at the same time.</p><p><a href="http://www.dailyinfo.co.uk/reviews/venue/1320/Vue_Cinema">Vue Cinema</a> (<a href="http://www.myvue.com/cinemas/index.asp?SessionID=0D86903A19334C93A7491563A77862A3&cn=1&ln=1&ci=66" target="_blank">www.myvue.com/cinemas/index.asp?SessionID=0D86903A19334C93A7491563A77862A3&cn=1&ln=1&ci=66</a>), Ozone Leisure Park, Grenoble Road (next Kassam Stadium), Oxford OX4 4XP; Tel. 08712 240 240 (10p per min from BT).<br /> </p>
Using php i want to extract

Code: [Select]
http://www.myvue.com/cinemas/index.asp?SessionID=0D86903A19334C93A7491563A77862A3&cn=1&ln=1&ci=66
from the <a> tag.

I have already tried using

    
<?php

$pattern = "/<a href=\"([^\"]*)\">(.*)<\/a>/iU";
preg_match_all($pattern, $link, $matches);
var_dump($matches);
?> 

The output I get is

array
  0 =>
    array
      0 => string '<a href="http://www.dailyinfo.co.uk/reviews/venue/1320/Vue_Cinema">Vue Cinema</a>' (length=81)
  1 =>
    array
      0 => string 'http://www.dailyinfo.co.uk/reviews/venue/1320/Vue_Cinema' (length=56)
  2 =>
    array
      0 => string 'Vue Cinema' (length=10)

I have a string that looks like /index.php?g1=111&g2=222&g3=333.  How can I obtain the value of g1 (i.e. 111)?  It does not represent the current state of the server thus I cannot just use $_GET.  It also is not necessarily the first item.

The script below appears to work, however, http://php.net/manua...n.parse-url.php states
  This function is intended specifically for the purpose of parsing URLs and not URIs. However, to comply with PHP's backwards compatibility requirements it makes an exception for the file:// scheme where triple slashes (file:///...) are allowed. For any other scheme this is invalid.  
It appears that my string is a URI and not a URL, but I might be wrong.

How should this be accomplished

<?php
$str='/index.php?g1=111&g2=222&g3=333';

$array=parse_url($str);
parse_str($array['query'],$get);
echo("<p>{$get['g1']}</p>");
?>

I have managed to get this to work but it seems like it is a very long and messy solution. I was wondering if anyone had an idea of how this can be done better. I am new to php and don't know a lot.

It shows the text between the tags <h1> and </h1> from the content of a different file
Basically I had to start the substr() from the fourth position so it would actually skip the "<h1>" being included, and because I started on the fourth postion I then had to finish four places back to skip the "</h1>" being included. 

Code: [Select]
<?php
$id = $_GET['id'];
$homepage = file_get_contents("./".$id.".php");
$title = stristr($homepage,"<h1>");
$titlepos = strpos($homepage,"</h1>");
$endpos = $titlepos - 4;
echo "Title " . substr($title,4,$endpos);

?>

so I'm working on this system which requires me to inject anime show names into a DB for an index.

I get them in this form:
[Kira-Fansub]_HIGHSCHOOL_OF_THE_DEAD_-_04_(BD_1920x1080_x264_AAC) [F0E73009].mkv

I need to get it in this form: Highschool Of The Dead

sometimes the words are space seperated.
the main part is to extract the text in between the ] and ( and with that i mean [stuff]extract this(other stuff) and sometimes it looks like this: [stuff]extract[stuff]

I have NO CLUE how to do this preg_match_all doesn't get me any further.. maybe in stages?

I am trying to extract field data from a specific row,

Here is my code:

    $query = "SELECT * FROM music WHERE title = '%$selected%'";

     $musicresult = mysql_query($query) or die ("Couldn't execute query.");

     $row = mysql_fetch_array($musicresult);
 
      /* extract the contents of the row */
      Line 98 extract($row);
     
   echo $title." "."<BR>";
    echo $select."<BR>";
     /* set contents of selected to 1  */
    $selectval = $select;
    ++$selectval ;
   
     echo $selectval."<BR>";
/* Put the data into the database */
//$query= "UPDATE music SET select=$selectval WHERE title=$selected";
//$result = mysql_query($query) or die ("could not save new data!");

 


Here is the error message:


Warning: extract() [function.extract]: First argument should be an array in /home/content/a/c/k/acksfaq/html/theackshow/THANKYOU.PHP on line 98

The two echo statements that follow line 98 do not generate an output

About the only thing that is different with is table compared with a table that this code works with is the fact that this table (music) is not indexed.

What the heck am I doing wrong??

Thanks,

Ack

hi there - hello dear PHP-Friends,

good evening!  - i want to extract some data ouf of a large html-file.

i have - a very very large amount of data:  approx 5000 x the following line-sheme!:

Quote


67003 Cato Bontjes Vice Versum House 1    28832 Achim     
62042 Cato Bontjes Vice Versum House 2 28832 Achim       
41798 Cato Bontjes Vice Versum House 3 37139 Adelebsen    
40034 Cato Bontjes Vice Versum House 4 21365 Adendorf    
46218 Cato Bontjes Vice Versum House 5    31855 Aerzen    
42481Cato Bontjes Vice Versum House 6  21702 Ahlerstedt    
49761 Cato Bontjes Vice Versum House 7    26197 Ahlhorn
   


   

Question: how can i  extract the first 5 first digits...!?

I have allready some solutions here -


i need a very very robuste solution 

diblertone1

Is it possible to create a PHP array that contains only keys?

	array
	1
	3
	5
	6
	7
	

 

I have a query that returns row ID's that I want to put into an array to do some work.  There is no real concept of a "value" - I just need to store a list of the database table rows that i want and that's it!

 

Edited February 16 by SaranacLake