PHP - Extracting A Web Address To A Variable

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.";
  }
}

?>

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

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?

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

$example "Q: Example? A:"

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

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'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

Hello all,

I have a problem I'm not sure how to tackle.  I have data in a database that looks looks like this:

Field1   |    Field2
AA        |    AA Row 1 Data
AA        |    AA Row 2 Data   
AA        |    AA Row 3 Data   
AB        |    AB Row 4 Data
AB        |    AB Row 5 Data
AB        |    AB Row 6 Data
AC        |    AB Row 7 Data
AC        |    AB Row 8 Data
AC        |    AB Row 9 Data
AC        |    AB Row 10 Data

I would like to grab and output JUST the first AA, AB, AC  and the the row data in field two?  So the loop would catch the first AA then when field1 data has changed it will output the first AB and so on... 

So the output would look like:

Row1:  AA : AA Row 1 Data
Row2:  AB : AA Row 4 Data
Row3:  AC : AA Row 7 Data

Is there a way to accomplish this?  Any help would be great!

Thanks!

Hi guys,
This is my problem:
I have a csv file let's say have these values:

blue,1,2,3,4
red,8,5,6,7

I need to add thes values into a 2d array
to be able to use like this:
colors[1][2]=2
colors[2][4]=7

Where my first number is the row and the second number is the value within that row.

This is what I got so far

<?PHP
$i=0;
$j=0;
$file_handle = fopen("color-list.csv", "r");
while (!feof($file_handle) )
   {
   $colors = fgetcsv($file_handle, 10000);

for ($j=0; $j<=4; $j++)
               {
               $row[$i][$j]=$colors[$j];
                                        print row[$i][$j];
               }
$i++;
?>

For some reason this doesn't work. Maybe I am declaring the arrays wrong.

Thank you!

Folks,

I want to extract the keywords Only form the below Script's output:


<?php
$keywords = file_get_contents('http://suggestqueries.google.com/complete/search?hl=en&gl=us&ds=pr&client=products&hjson=t&jsonp=ac_hr&q=paintball&cp=2');
//$keywords = json_decode($keywords);

print_r($keywords);
?>


Output is:

ac_hr(["paintball",[["paintballs","","0"],["paintball sniper","","1"],["paintball mask","","2"],["paintball vest","","3"],["paintball pants","","4"],["paintball bunkers","","5"],["paintball markers","","6"],["paintball chronograph","","7"],["paintball bow","","8"],["paintball helmets","","9"]],"","","","","",{}])

How to extract the keywords Only in an Array??

Cheers
Natasha T

hey guys im wondering how you would add or takeaway a hour from a timestamp in a database when trying to select it please?   thank you

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>");
?>

Hi - I have an array where one of the values delivers a string. Here is the output from a print_r($pickupdates):

Code: [Select]
Array
(
    [0] => Array
        (
            [location] => Clearwater
            [TheDates] => 1311746700,1321746641,1331668779
        )

    [1] => Array
        (
            [location] => Canmore
            [TheDates] => 1311746700,1321746641,1331746641
        )

    [2] => Array
        (
            [location] => Collingwood
            [TheDates] => 1311746700,1321746641,1331746641
        )

    [3] => Array
        (
            [location] => Varsity
            [TheDates] => 1321746641,1330746700,1331746700
        )

The challenge is to get the location and TheDates  into a nice HTML table which would look like this:

Code: [Select]
LOCATION          DATE 1            DATE 2              DATE 3

Clearwater         April 1              May 1                June 1

Varsity               April 2              May 2                June 2

Collingwood        April 3              May 3                June 3


Canmore        April 4              May 4                June 4


Ok - Now I am stuck, I need to be able to uniquely identify each date that is associated with the location such that I can run a foreach() on then so I can populate the table properly. I tried using list() and explode. List does not separate the dates and explode needs a string not an array.

I'm really stuck - a very big Heartfelt thanks to anyone who can steer me in the right direction.

MANY THANKS !

Hi, not sure if this is posted in the right place (think it should be in the Regex section  ) but hopefully someone can help me out a bit.

I have the following string for example which is stored in a variable called $var.

Quote

This is a reference [ref=17][/ref] number


I wish to extract only the number after the equals sign and store it as a variable. So I am using the following code to do so:

$ref_num = preg_replace("/.*?\[ref\=(.*?)\]\[\/ref\].*?/is", "$1", $var);

The only problem is, I can omit the text before the integer and the tags themselves but I still get the text after the [/ref] section and I cannot get rid of it. It seems my .*? placed after it doesn't work like it does at the beginning.

Can anyone offer any help at all, it will be greatly appreciated - I'm fairly new to using Preg_replace so I still don't know how best to form Regular Expressions.

Thanks, Dan


EDIT-
I have found a workaround which I will post below - however I would still like to solve it the way I planned originally which is the way I posted here. Here's what I did - because I know the integer is never going to be more than 5 characters long, I used the replace from before but added a substring like so.

$ref = substr(preg_replace("/.*?\[ref\=(.*?)\]\[\/ref\]/is", "$1", $var),0,5);

This grabbed the first 5 characters whether it was a number or not, then I used this to strip any non-numerical characters. Finally I added an intval to convert it to an integer rather than a string.

$ref = intval(preg_replace ('/[^\d\s]/', '', $ref));