PHP - Extracting All Ip's Of A String

What I'm trying to do is take two arrays and combine them using array_combine. After they are combined I want to take each key and value pair and use them in a string to build a MySQL query. See below for some pseudo-code  =D


<?php
$fields = array('first_name', 'last_name'); //the fields that will be set with an UPDATE query.
$newvals = array('Joe', 'Blow');//The values that will go into $fields

$arr = array_combine($fields, $newvals);//Each value now has a key of the field it will update.

/**
This is where I want to return my SET string with something like 'SET ' . $arr['first_name']  ' = ' . $arr['first_name_value'] ', etc etc.
*/


There it is, I suppose. Are there any easier ways of doing what I'm trying to accomplish, that is, am I on the right track or just making things harder for myself?
Both arrays will have dynamic values throughout my application, so I need to be able to get both each field and value for each query. Any links to some constructs, etc, etc? That's all I really need and I can post the solution when I've figured it out.

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

Folks,

I want to extract certain portion form URL.

Exmaple:
Quote

http://abc.com/this-is-test.html


Output should be
Quote

this-is-test


Another Example
Quote

http://abc.com/this-is-yet-another-test.html

Output should be
Quote

this-is-yet-another-test


I am not sure how it can be done with preg_match() and regex or something like that...

Can someone help me with this please?

Cheers
Natasha

I have an RSS feed, with alot of data of lottery numbers.

the feed itself is : http://www.alllotto.com/rss/NY/latest.rss

The item i am interested in is:

Quote

<item>
                   <title>Take 5</title>
                 <description>2011-08-27: 4, 10, 16, 17, 31</description>
                   <guid isPermaLink="false">USA-New-York-Take-5-2011-08-27</guid>
                 </item>



How could I output those to varibles?

thanks

Joe

$example "Q: Example? A:"

Let's assume that I'd like to display $example but exclude "Q:" and "A:", how would I do that?

I'm *attempting* to write a script that will take a paste of data from a user and when it's submitted it will drop certain parts of the data into databases and be available for recall later. I have the MySQL sorta out I think but I can't test until I get this part done.

Basically people will paste a copied paste (CTRL A, CTRL C and go to my form and just hit CTRL V). It will contain a bunch of data I want to drop in the database but in different areas, like the following example the items in bold are the items I want to grab.

First Name: Lincoln
Last Name: Coe
Address: 1234 Easy St, Perfectville, PV 00000
Telephone: 0000000000

Hi there

I need to extract data from some XML. I have found a few sites that explain that part to me, however there is a section of the data which I need to extract and am not sure how to go about it. Below is an extract of the XML, the section I am trying to extract is highlighted in red (it is essentially a text message being sent I am trying to get the contents of the sms/text message):

 <usa_smpp_host>THTTP</usa_smpp_host>
 <short_message>id:660352946 sub:001 dlvrd:001 submit date:1102081032 done date:1102081035 stat:DELIVRD err:000 text:Test SMS message</short_message>
 <dest_addr_npi>1</dest_addr_npi>

Any assistance would be appreciated. Have played around quite a bit but have not managed to figure it out yet.

thanks

Hey guys i have a array i made and im wanting to grab a random value out of the array.
The only way i can see to do this looking at the list of array functions is i need to random a key first?
and then return the value assigned to the random key i just generated?
I only see a function that lets me do the opposite. array_search()

so now that i have generated a random key how do I grab just the value from the array using the random key. or is there a function i can just random value?

$explode_names = explode(" ", $planet_names);

$random_key_name = (array_rand($explode_names, 1));


echo $random_key_name;

I usually only do design work, but a client wanted a log in system to his website, so I decided to do it.

I set everything up correctly, and users can sign up, login, and log out. However, he wants to be informed when a user logs into his site.

So say (user x) wants logs in, my client wants to receive an email with all of (user x)'s account information. How do I pull a row from mysql based on the login information provided?

My database is has 7 columns: user, pass, name, address, state, phone, email

HI guys,

I'm quite new to php, and I'm really struggling to get this right. I just cant get it to work properly.

Im trying to extract email from a list of URLS. I have currently got it to work with 1 URL at a time, but I am needing to as to how I can pass multiple URLS at once, either from a csv or just pasting them into the input.
any help would be much appriciated. here is my current code:

Quote

<?php



$the_url = isset($_REQUEST['url']) ? htmlspecialchars($_REQUEST['url']) : '';
?>

<form method="post">
  Please enter full URL of the page to parse (including http://):<br />
  <textarea name="url" cols="100" rows="10"><?php echo $the_url;  ?></textarea>
  <br />

  <input type="submit" value="Get Emails" />
</form>

<?php
if (isset($_REQUEST['url']) && !empty($_REQUEST['url'])) {
  // fetch data from specified url
  $text = file_get_contents($_REQUEST['url']);
}
elseif (isset($_REQUEST['text']) && !empty($_REQUEST['text'])) {
  // get text from text area
  $text = $_REQUEST['text'];
}

// parse emails
if (!empty($text)) {
  $res = preg_match_all(
    "/[a-z0-9]+([_\\.-][a-z0-9]+)*@([a-z0-9]+([\.-][a-z0-9]+)*)+\\.[a-z]{2,}/i",
    $text,
    $matches
  );

  if ($res) {
    foreach(array_unique($matches[0]) as $email) {
      echo $email . "<br />";
    }
  }
  else {
    echo "No emails found.";
  }
}

?>

Hi

Ive been trying to solve this problem for a few hours but am having no luck so would appreciate any help

Im looking for a function/way of extracting info from a dropdown list when a form is submitted. The form field has a name and email address i.e John (john@smith.com) and i just need the email address part to submit into a mysql database.

I tried using the explode() function but this didnt work.

Any ideas?

Cheers
Andy

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

I have 2 sites.  1 site is a store the other is a blog.
The homepage of the store shows random product images.  Each image links to it's product page.

I'm using the code below to get data from the store homepage into a variable:
Code: [Select]
<?php
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, "http://www.somesite.com");
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    $output = curl_exec($ch);
curl_close($ch);
?>
I can echo $output and see the page displayed on my page.  So that part is working.

On the blog, I want to display random products and link them back to the store.

How can I extract just the images & their page links from the $output variable?

Folks,

I tired all my PHP skills to extract domain name strings from a RSS Feed and put each domain name as an Array element, but all in vain:

Here is the RSS:

http://bulliesatwork.co.uk/master/dev/domp/expdom/domains.php()

What i want to extract:
Quote

Do you see a list of domain names, which are Anchored, all i need is to extract these domain names llik "abc.co uk"   (observe there is a space between .co and uk, which can be removed with str_replace())


Here is my first try: (Using SimpleHTMLDomParser)
Code: [Select]
require_once('simple_html_dom.php');

$html = file_get_html('http://bulliesatwork.co.uk/master/dev/domp/expdom/domains.php');

$domains = $html->find('div[class="entry"] a', 0);

foreach($domains as $dom)
{
   
   
    echo str_replace(' ', '.', $dom->plaintext);
}

$html->clear();
unset($html);



Here is my another try with DOM Document:
Code: [Select]
$scrapeurl = 'http://bulliesatwork.co.uk/master/dev/domp/expdom/domains.php';         

$keywords = file_get_contents($scrapeurl);

$keywords = json_decode($keywords);

foreach( $keywords->responseData->results as $keyword)
{   
    echo str_replace("...",".",$keyword->title).'<br/>';
   
    }




In both the cases, DOM document is created but it seems the Document has all information except the Domain names i want to extract.

Please help me out to extract the doamin names.

Cheers