PHP - Without Using Extract Function,how Can This Be Possible ?

So I make a colum in my table called "friends"

Is there a way to update using mysql that colum for each user, so let's say friend 1 adds friends 2 with the id of 25

so the query puts the id "25" into the friends column, then if friend 1 adds friend 5 with the id of 26 it puts "26" into the friends column and so on...

So it would have like commas in the colum, 25,26,30,31,31 and all those represent the id's of the person who is wanting to add people to his friends list!


If so how do I accomplish that, and then what If I want to use mysql to list all those id's and Code: [Select]
SELECT name,avatar,etc from userstable WHERE id = "25,26,3,31,31"
Is this even possible or am i thinking to harD?

What is the difference between EXTR_PREFIX_SAME and EXTR_PREFIX_IF_EXISTS?

Hi, how do I extract a substring? I just want to store "car" in a variable for other uses:

Here is the original string:
car/red/blue/gun/hit

Any help much appreciated!

http://www.abc.com/sports/more/others/Younger-people/show/7321382.xml

http://www.abc.com/news/head/Elder-people/show/7321302.xml

In the above string,please tell me how to extract the portion, and store "sports/more/others" and "news/head" in another string.

Hi i have a string which contains some text and 2 links for example. 

How could i extract all the string minus one of the links

eg  $textstring = "some text before <a href="testpage.php"> <img src="image1.jpg" /></a> <a href="testpage2.php"> <img src="image2.jpg" /></a> some text after "


i would like to make a create a new string which contains all this text minus the first link

$newstring = "some text before <a href="testpage2.php"> <img src="image2.jpg" /></a> some text after "


any ideas?

I draw contents from a database. Some of the texts contain a footnote, which is formatted using a div class. Following the HTML of this:

<div class=""footnotes"">
<br>
<hr align=""left"" noshade=""noshade"" size=""1"" width=""150"" />
      <blockquote> <a href=""#f1"" name=""fn1""> <span class=""superscript""> * </span>

        </a>Some footnotetext</blockquote></div>

Since my bibliography uses data from the database as well, the footnote now appears before the references, but I would like it at the very bottom of the page. I was thinking of using preg_replace in order to separate the textfield into two variables, one for the text itself, the other one for the footnote (it is always just one) and integrate after the bibliography is compiled.    Unfortunately, it seems that the preg_replace does not work. It always displays the whole content of the textfield. Here's the PHP:

$text = preg_replace('/(.*)(\div class=\"footnotes\"\>.*?\<\/div\>)/s', '$1', $result['text']);$footnote = preg_replace('/(.*)(\div class=\"footnotes\"\>.+?\<\/div\>)/s', '$2', $result['text']);

echo '<div align="justify"><span style="font-family:Georgia;font-size:16px;">' . $text;

***BIBLIOGRAPHY***

...

echo $footnote; 

Maybe someone has an idea how to deal with that. I tried it on phpliveregex. There search string works fine. Many thanks for any help.

I am new to coding and I am trying to write a simple business registration app.
a foreach loop populates a select list and a nested loop checks to see if something new is being added.
If so write to the DB. Great.
Only part of it is working, I am getting the correct businessId but the categoryId is an array:

        188    Array
    189    Array
   190    Array
   191    Array
   192    Array
    195    Array
    196    Array

Here is the code:
Code: [Select]

<form method="post" action="?">
<table>
<tr><td class="picklist"><?php echo $pickMessage; ?>
<select name="bizCatSelect[]" size="4" multiple>
<?php
$sql = "SELECT categoryId FROM categories";
$sth = $dbh->prepare($sql);
$sth-> execute();
$result = $sth->fetchAll(PDO::FETCH_COLUMN, 0);

foreach($result as $value)
{
if($addRecord == 1)
{
$selected = false;
if(in_array($value, $bizCatSelect)) // $row[1]
{

$sql = "INSERT INTO businessCat(businessId,categoryId) VALUES(:bizId, :bizCatSelect)";
$sth = $dbh->prepare($sql);
$sth->bindValue(':bizId', $bizId, PDO::PARAM_STR);
$sth->bindValue(':bizCatSelect', $bizCatSelect, PDO::PARAM_STR);
$query = $sth->execute();

$params = array($bizId, $bizCatSelect);  // $row[0] $value
print_r($params);
//$resp = $sth->execute($query, $params);

echo "<option selected=\"$value\">$value</option>\n"; // $row[1]
$selected = true;
}
if($selected == false){echo "<option value=\"$value\">$value</option>\n";}
}

else{ echo "<option value=\"$value\">$value</option>\n";}
//echo "<option value=\"$value\">$value</option>\n";
}
?>
</select>
</td>
<td class="addlist">
<table>
<tr><td class="formLable">Business Name:</td>
<td><input type="text" name="bizName" size="40" maxlength="255" value="<?php echo $bizName; ?>"></td>
</tr>
<tr><td class="formLable">Address:</td>
<td><input type="text" name="bizAddress" size="40" maxlength="255" value="<?php echo $bizAddress; ?>" ></td>
</tr>
<tr><td class="formLable">City:</td>
<td><input type="text" name="bizCity" size="40" maxlength="128" value="<?php echo $bizCity; ?>" ></td>
</tr>
<tr><td class="formLable">Telephone:</td>
<td><input type="text" name="bizTele" size="40" maxlength="64" value="<?php echo $bizTele; ?>" ></td>
</tr>
<tr><td class="formLable">URL:</td>
<td><input type="text" name="bizUrl" size="40" maxlength="255" value="<?php echo $bizUrl; ?>" ></td>
</tr>
</table>
</td>
</tr>
</table>

<p><input type="hidden" name="addRecord" value="1">
<?php
if($addRecord == 1)
{echo "<p><a href=\"?\">Add another business</a></p>";}
else
{echo "<INPUT TYPE=\"submit\" NAME=\"submit\" VALUE=\"Add Business\">";}
?>
</p>

</form>


I just can't seem to get this last part, any suggestions?
AL

Okay I now have a working extract ZIP archive script.
What I am now looking to do is have a loop which checks the percentage complete the extraction is and at 100% (with no erros) carry out a PHP function.

The code so far is (and includes comments on how the new function would be placed):
$dir = opendir('temp');
while(false !==($file=readdir($dir))){
if(strpos($file, '.zip',1)){
extractupdate($file);
}
}

function extractupdate($file){
$zip=new ZipArchive;
if($zip->open('temp/'.$file) == TRUE){
$update=rtrim($file, ".zip");
$zip->extractTo($_SERVER['DOCUMENT_ROOT']."/update/temp/$update");
$zip->close();
echo "Extraction started.";
// Place loop here to run untill 100% extraction completed and then run function "intsallupdate($update);"
} else {
echo "Failed to start extraction.";
}
}

function installupdate($update){
// installupdate() will now shift the files around as necessary.
// NB to PHPFREAKS, no assistance with code for installupdate() is required, only the loop. Cheers.
}

Many thanks in advance.

How to extract the last row a query and store it in a variable  ?
Thanks for helping.
Noob apppreciate.

Hello,

I seem to be having a problem.  I am trying to extract the year from a date

Code: [Select]
2012-03-01
echo "2012";

I have tried this and it only displays 1969

$dateorig = "2012-03-01";
$new_year = date("Y", strtotime($dateorig));
echo $new_year;

I need to extract "C:\Documents and Settings" from the last line of this data every time it appears. It is always between DirectoryName REG_SZ and HKEY.

DirectoryName  REG_SZ         C:\Documents and Settings   HKEY


How can I extract "C:\Documents and Settings" or whatever the value is multiple times using PHP?

Folks,

Quote

http://natty.com/p/bh-fitness-class-indoor-magnetic-exercise-bike-2-years-parts-/detail/b004r2wuak/fitness-spinning.html


From this url String, i want to extract the last part of string which is, "fitness spinning".

This URL is dynamic an can have any value in that last bit, so how to extract anything btween Two Forward slashes just before .html?

Note: It can not be extracted with GET as its not how its designed.

Thanks
Natasha

 

I can t seem to get this. I need to extract some data from the following xml file. http://api.twitter.com/1/users/show/seobpo.xml   I just want to get seobpo's tweet count. The data will be used in a wordpress blog.

Thank you

Hello,

I am creating zip file of multiple files using PHP and downloading it.

Problem is that: zip file is getting extracted by only WinRAR, its not getti ng extracted by default windows extracter or other software.

Here is code which I have written -

            $file_folder = 'referral-resume/';
            if(extension_loaded('zip'))
            { 
                if(isset($_POST['files']) and count($_POST['files']) > 0)
                {     
                    $zip = new ZipArchive();
                    $zip_name = "referralresumes".time().".zip";
                    if($zip->open($zip_name, ZIPARCHIVE::CREATE)!==TRUE)
                    { 
                        $error .= "* Sorry ZIP creation failed at this time";
                    }
                    foreach($_POST['files'] as $file){ 
                        $zip->addFromString(basename($file_folder.$file),  file_get_contents($file_folder.$file));  
 
                    }
                    $zip->close();
                    if(file_exists($zip_name)){
                        header('Content-type: application/zip');
                        header('Content-Disposition: attachment; filename="'.$zip_name.'"');
                        readfile($zip_name);
                        unlink($zip_name);
                    }
 
                }
                else{
                    $error .= "* Please select file to zip ";
                }    
            }
            else{
                $error .= "* You dont have ZIP extension";
            }
 

Hi, I got 1 warning form the server, It said:   Warning: extract() expects parameter 1 to be array, null given in /home/tz005/public_html/COMP1687/edit.php on line 113   extract($row);   how to fix the warning,should I replace it with extract($array);?