PHP - Moved: Deleting Numbers Between Parenthesis

This topic has been moved to JavaScript Help.

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

This topic has been moved to JavaScript Help.

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

Hi,
I need to sort variables in groups of up to 15 and put it in an array. For example:
$exstract['center_tabOpBody_0'] =5
$exstract['center_tabOpBody_1'] =6
$exstract['center_tabOpBody_2'] =8
$exstract['center_tabOpBody_3'] =1


Should yield:
ARRAY(
          = center_tabOpBody_1,center_tabOpBody_2,center_tabOpBody_3 // <-----15 [1] = center_tabOpBody_0 //<----5
)

Is there some simple function do do the "efficiency" sort?

Thanks,
Vadim

Could anyone tell me why this is not deleting the userip and post id from the database at all.

Thanks


Code: [Select]
<?php
include('dbcon.php');

if($_REQUEST['postId'])
{
$userip = $_SERVER['REMOTE_ADDR'];

mysql_query("update collapsed_likes set likes=likes-1 where post_id= ".$_REQUEST['postId']);

mysql_query("delete from collapsed_ip where userip=".$userip." AND post_id = ".$_REQUEST['postId']);

$total_likes = mysql_query("SELECT * FROM collapsed_likes where post_id = ".$_REQUEST['postId']." ");
$likes = mysql_fetch_array($total_likes);
$likes = $likes['likes'];
}
echo $likes;
?>

Hi.

What am I doing wrong he

Code: [Select]
mysql_query("DELETE FROM availability WHERE id = '$_POST['id']'");
I am able to echo the id but I must be entering the post item incorrectly into the delete string.

Can anyone show me my mistake?

Thanks

Does anyone have a code that will automatically delete stuff out of the database after 30 days of being in there...?

Hi, this is the first time I've asked for some help from a forum. I guess this code has sort of got me stumped.

So, I have a system where a user can enter a number. The number goes into a mysql database. A random number is also generated and it is added into another column.

So, I want users to be able to delete the number using the random number. I've shown it to them, and I need help working my delete script.
Code: [Select]
<?php
$con = mysql_connect("localhost","","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("a8784hos_adopts", $con);
$adopt = $_POST['adoptid'];
$uniquecode = $_POST['uniquecode'];
$result = mysql_query("SELECT uniquecode, id FROM id WHERE id='$adopt'");
mysql_fetch_array($result);
if (($adopt == $row['id']) || ($uniquecode == $row['uniquecode'])){
mysql_query("DELETE FROM id WHERE id='$adopt'");
echo 'Done! <br/><br/><a href="tester.php">Go back....</a>';
}
else {
echo 'Bad unique code. <br/><br/><a href="tester.php">Go back....</a>';
}
?>

So, the random number is uniquecode in the database, and the number is id. However, when I try this code, it always tell me I have a bad unique code. What am I doing wrong?

Thanks.

I am sorry even i didn't say hello to forum but i need this snippet very urgently. i have Zero knowledge of PHP but unfortunately i need a small code as follow.

Hi, When i launch my code i get the following php error:
Warning: unlink(../files/"yCUuH0223e3d6d046acb58678fbb54042e0fe.pdf") [function.unlink]: Invalid argument in C:\xampp\htdocs\intra\VVS\admin\fakture-edit.php on line 74

But in the dir: C:\xampp\htdocs\intra\VVS\files\

The file exists..

here's my php code:

Code: [Select]
$id = mysql_real_escape_string($_GET['id']);
$fil = mysql_real_escape_string($_GET['fil']);


$result2 = mysql_query("SELECT * FROM fakture WHERE id=('$id')  LIMIT 1");
$row2 = mysql_fetch_array($result2);

if ($_GET["op"] == "process")
{

if (!unlink('../files/"'.$fil.'"'))

Hi, I gave the following php script:

#!/usr/bin/php -f
<?php
require_once(dirname(dirname(__FILE__))."/modules/common/common.config.inc.php");
$path = $conf["root"]."/media/images/tricouri/tmp/";
$command = "rm -Rf".$path."*";
if(exec($command))
{
    echo "Folder cleared\n";
}
else
{
    echo "Folder clear failed\n";
}
?>


I want to delete some .png files from the ./tmp folder and I receive a rm error:
Quote

rm: invalid option -- /
Try `rm --help' for more information.
Folder clear failed



The rm -rf command sintax is ok on the linux bash, but from php i receive the error.
Php safe mode is off. Can someone help, please ?

I'm trying to delete the <identifier> node of some XML, using the following code; unsuccessfully.   Can someone help me identify where I'm going wrong? TIA

$newXML = "";
$xmlString = Fedora_API::callGetDatastreamContents($this->pid, 'MODS', true);
$doc = DOMDocument::loadXML($xmlString);
$xpath = new DOMXPath($doc);

$fieldNodeList = $xpath->query("/identifier");

foreach ($fieldNodeList as $node) {  
	$fieldNodeList->removeChild($node);
}
$newXML = $doc->SaveXML();  

I'm just trying to get suggestions on what people think would be the best way to go with this. With the bottom part of this card where it s tarts working with the foreach loop its taking what was a UL and for each of each LI's and updating a table with its new data however this way isn't going to work as this is editing a user. Because there could be 5 in the database but the new edit user has only 4 lis so I'm sure you could all see the issue here. What I'm thinking would be best is to have it DELETE the existing characterIDs that have WHERE handler_ID = $handlerID and then just do a new INSERT statement. Anyone else think this would be the best way to go about this?


Code: [Select]
if (mysqli_num_rows($Qresult) == 0) {
        $query = "UPDATE `handlers`
            SET `userName` = '".$userName."', `password`='".$password."', `firstName`='".$firstName."', `lastName`='".$lastName."', `statusID`='".$statusID."', `isAdmin`='".$admin."', `defaultCharID`='".$defaultCharID."', `email`='".$email."' WHERE `ID` = '".$handlerID."'"; 
        mysqli_query($dbc, $query);
        foreach ($characterIDs as $cID) {
               $query2 = "UPDATE `handler_characters`
               SET `handler_id` = '".$handlerID."', `characterID` = '".$cID."'";
               mysqli_query($dbc, $query2);
        }
        $result = "good";
    }

I'm trying to delete rows in the database, based on what checkboxes are left empty by the user...

What i have is small application in which a user can add an item to the database and give it tags...

for example there is "apple" and it has the tags of "fruit, red, round"

What i want is for the user to be able to edit those tags, so the user can remove "fruit" and add "sweet" instead or just remove "fruit" all at the same time.

The code i have, somewhat works...

This code below loops through the checkboxes and should remove the items that are no longer checked, by going through the database and grabbing all the tags and them checking it against those that are still checked and remove the ones that it didn't find checked...??

However whats happening is when i unchecked say "red" it removes all the other items..so if i had "red, fruit, round' and i want to remove "red" it leaves red but removes the rest.

foreach($_POST['tag'] as $r=>$n){
$t = mysql_real_escape_string($_POST['tag'][$r]);

$get_tag2 = mysql_query("SELECT * FROM file_cats WHERE fileID='$fileID'") or die(mysql_error());
while($t2 = mysql_fetch_assoc($get_tag2)){
$tmp_tag1 = $t2['category'];

if($t==$tmp_tag1){
$remove_tag = mysql_query("DELETE FROM file_cats WHERE fileID='$fileID' AND category='$t' LIMIT 1") or die(mysql_error());
}
}
}


This following piece of code just adds a new tag...however i want it to check to see if that tags already exist in the database, if it does then don't add it just add the new ones..


foreach($_POST['tag'] as $k=>$l){
$tag = mysql_real_escape_string($_POST['tag'][$k]);

$add_tag = mysql_query("INSERT into file_cats (fileID, category) VALUES('$fileID', '$tag')") or die(mysql_error());

}


My final problem is that i can't remove items if the second snippet of code is there, i have to remove those lines of code in order to remove items, however i can add items with both loops there.

I'm basically stuck and hope that someone here can shed some light on what i'm doing wrong, because i know i'm doing something wrong i just can't find it

Anyway thank you in advanced

How would I make a script that would delete any row in a MySQL table that was more than 7 days old?

I have a string containing long text, which contains urls in the form of example.com or www.domain.com (simple plain text, not html links). How I can delete all of them. I need a php regex to delete all terms containing ".com"