PHP - Extracting Get Variables From 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

$id[] = 12345;
$id[] = 12345;
$id[] = 12345;
$id[] = 12345;
$id[] = 12345;

how would I combine these into a string

"12345,12345,12345,12345,12345"

I have the following code which has deliimiters of |||| and I need to break it apart into three strings and have a variable assigned to each string.

I've tried exploding it but won't dynamically increase the variable.  I know at one point about a year ago I used something like $var.=$foo and the $var would increase $var1, $var2, etc...

Here's the string I need to break.j (And the string will be different every time, and some will have 2 string delimited  some will have 20, and some inbetween.

The rich contemporary style of the "Theo" Counter Height Table combines faux marble and a warm finish to create dining room furniture that adds an exciting style to the decor of any home. The thick polyurethane coated faux marble table top perfectly accentuates the warm brown finish flowing over the straight-lined contemporary design of the apron and legs to help create an exceptional dining experience. With the beautiful stitching and button tufting details of the faux leather upholstered bar stools, the "Theo" Counter Height Table is a refreshing addition to any home.||||Table top made with polyurethane coated print marble. Aprons and legs made from select veneer and solids with a warm brown finish. Chair is upholstered in a brown PVC with accent top stitching. D158-233 bar stool dimension: 18"W x 21"D x 40"H.||||Click here for complete image download listing for series D158.

In a perfect world it would be:
Code: [Select]
$desription1="The rich contemporary style of the "Theo" Counter Height Table combines faux marble and a warm finish to create dining room furniture that adds an exciting style to the decor of any home. The thick polyurethane coated faux marble table top perfectly accentuates the warm brown finish flowing over the straight-lined contemporary design of the apron and legs to help create an exceptional dining experience. With the beautiful stitching and button tufting details of the faux leather upholstered bar stools, the "Theo" Counter Height Table is a refreshing addition to any home.";
$description2="Table top made with polyurethane coated print marble. Aprons and legs made from select veneer and solids with a warm brown finish. Chair is upholstered in a brown PVC with accent top stitching. D158-233 bar stool dimension: 18"W x 21"D x 40"H.":
$description3="Click here for complete image download listing for series D158.";

Hi

I am trying to get all variables passed in a url string and wondered how would i do it?
I dont know what they are yet and i need to set key as value.
Any help?

hello, im wondering how to properly code the following.

Code: [Select]
$stdate = date( 'Ymd', strtotime($pdate) );
$sttime = date( 'His', strtotime($tstart1) );

$dtStart = ".$stdate.'T'.$sttime.'Z'";

echo "$dtStart";

i would like the echo to read 20110309T050000Z

Hi,

I have a string with the value of

{ "success": true, "delivered": true, "contactDetailsRequired": false, "message": "Signed For by: D ANDERSON ", "signature": "https://webservices.thedx.co.uk/PodImage/ImageHandler.ashx?tn=906732192165", "date": "21-07-2020", "serviceLevelName": "Consigned", "time": "13:33:19", "trackedProductName": "DataExchange" }

How do i go about placing the values into variables so for example:

$success = "true";
$delivered = "true";
$message = "Signed for by: D ANDERSON";
etc....

My mind has gone blank and im having one of those days, any help would be greatly appreciated. Thanks

Pretty simple I would think but I'm unsure on the syntax. I have a variable, $ename. It's actually data from a form that I pass to said variable. What I want is to then in turn use this string in a mkdir() function. Something like

Code: [Select]
mkdir("dir/folder/$ename/");
Obviously that doesn't work. I'd imagine I have to use some sort of . syntax.

I need to echo out some string variables in a form. I also want to add some validation for Name, email etc. I think I have the code right or close, but I can an error on the index.php page which is.
"Fatal error:  Call to undefined function  form_row_class() in index.php on line 14"

here is the code for the form


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title>String Tester</title>
    <link rel="stylesheet" type="text/css" href="main.css"/>
</head>

<body>
    <div id="content">
        <h1>String Tester</h1>
        <form action="submit.php" method="post">
  <table>
    <tr class="<?php echo form_row_class("name") ?>" >
      <th><label for="first_name">Name</label></th>
      <td>
        <input name="first_name" id="first_name" type="text" value="<?php echo h($_POST['name']); ?>" />
        <?php echo error_for('name') ?>
      </td>
    </tr>
    
    <tr class="<?php echo form_row_class("email") ?>">
      <th><label for="email">Email Address</label></th>
      <td>
        <input name="email" id="email" type="text" value="<?php echo h($_POST['email']); ?>" />
        <?php echo error_for('email') ?>
      </td>
    </tr>
   
    <tr>
      <th></th>
      <td><input type="submit" value="submit" /></td>
    </tr>
  </table>
</form>

        <h2>Message:</h2>
        <?php 
echo "<table>";
echo "<tr><td>";
echo $name;
echo "</td></tr>";
echo "<tr><td>";
echo $email;
echo "</td></tr>";
echo "<tr><td>";
echo $phone;
echo "</td></tr>";
echo "</table>";
?>

    </div>
</body>
</html>


and the submit portion

<?php

// If request is a form submission
if($_SERVER['REQUEST_METHOD'] == 'POST'){
  // Validation

  // Check first_name is non-blank
  if(0 === preg_match("/\S+/", $_POST['name'])){
    $errors['name'] = "Please enter a name.";
  }
  
  // Check email is valid (enough)
  if(0 === preg_match("/.+@.+\..+/", $_POST['email'])){
    $errors['email'] = "Please enter a valid email address.";
  }
  
  // validate a phone number
if( !preg_match("/^([1]-)?[0-9]{3}-[0-9]{3}-[0-9]{4}$/i", $phone) ) {
echo 'Please enter a valid phone number';
}


 // If no validation errors
  if(0 === count($errors)){
    
    // Sanitize first, last, and email
    $name = mysql_real_escape_string($_POST['name']);
    $email= mysql_real_escape_string($_POST['email']);
    $email= mysql_real_escape_string($_POST['phone']);
  }

// Helpers
function form_row_class($name){
  global $errors;
  return $errors[$name] ? "form_error_row" : "";
}

function error_for($name){
  global $errors;
  if($errors[$name]){
    return "<div class='form_error'>" . $errors[$name] . "</div>";
  }


function h($string){
  return htmlspecialchars($string);
}

?>





probably something simple I am missing.

Hi Guys and Girls,

Long time lurker, first time poster!

I am usually able to read through the forums and find and answer without having to start a new thread but I've tried my best to no avail.

I am having trouble with the following code:
$afname="Gareth";
$alname="B";
$awayoption.="<OPTION VALUE=\"".$afname." \"".$alname."\">".$afname."&nbsp;".$alname;

I would want that to produce the following:

Code: [Select]
<OPTION VALUE=Gareth B">Gareth B
The actual result at the moment is:

Code: [Select]
<OPTION VALUE="Gareth "B">Gareth&nbsp;B
It has an extra " in the middle. Any ides or help would be great!

Cheers

Code: [Select]
$query  = "SELECT content FROM license WHERE serial  = '".$serial."'";

I have an audit trail that record users ids and a copy of the sql string for any updates they make to my application. This is very easy for me to follow to  find exactly where changes happened but do end users it is a bit of a challenge.

Has anyone seen or made a script that can either compare two sql strings to see what fields have different values or a script that takes an SQL string and outputs its field names and values to an array that I can use for comparisons?

Example being the look at a update made by user X, the database pulls the sql for that change then looks for the previous change up any user before (update sql should have a value for all fields) then compares to see what user X changed.

If not im thinking of case statement to divide sql request between inserts and update then writing a script to split the strings based on where the commas were.

Any thoughts?

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

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