PHP - Extract Text Between Curly Braces - Why Doesn't My Code Work?

I am using this PHP code with a MySQL query.
PHP parses the PHP fine, but the MySQL query is not having any effect on the database. Can anyone see an error in my code? I can't.

$query = "UPDATE `products` set `id` = '".$_POST['id']."' where `id` = '".$_POST['id']."'";

MOD EDIT: Changed PHP manual link tags to [php] . . . [/php] tags.

I'm not sure if this is the right section, if not, please move it on proper one, i'm still newbie.

However, here's my problem, i'm using jquery to replace standard check boxes with images, and here's the code:


<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.0/jquery.min.js"></script>
<script type="text/javascript">

$(document).ready(function() {

/* see if anything is previously checked and reflect that in the view*/
$(".checklist input:checked").parent().addClass("selected");

/* handle the user selections */
$(".checklist .checkbox-select").click(
function(event) {
event.preventDefault();
$(this).parent().addClass("selected");
$(this).parent().find(":checkbox").attr("checked","checked");
}
);

$(".checklist .checkbox-deselect").click(
function(event) {
event.preventDefault();
$(this).parent().removeClass("selected");
$(this).parent().find(":checkbox").removeAttr("checked");
}
);

});

</script>

Here's the css:

<style type="text/css">

body {
font: 12px/1.3 "Lucida Grande","Lucida","Arial",Sans-serif;
}

form {
margin: 0 0 30px 0;
}

legend {
font-size: 17px;
}

fieldset {
border: 1;
}

.checklist {
list-style: none;
margin: 0;
padding: 0;
}

.checklist li {
float: left;
margin-right: 10px;
background: url(i/checkboxbg.gif) no-repeat 0 0;
width: 105px;
height: 80px;
position: relative;
font: normal 11px/1.3 "Lucida Grande","Lucida","Arial",Sans-serif;
}

.checklist li.selected {
background-position: -105px 0;
}

.checklist li.selected .checkbox-select {
display: none;
}

.checkbox-select {
display: block;
float: left;
position: absolute;
top: 55px;
left: 10px;
width: 85px;
height: 23px;
background: url(i/select.gif) no-repeat 0 0;
text-indent: -9999px;
}

.checklist li input {
display: none;
}

a.checkbox-deselect {
display: none;
color: white;
font-weight: bold;
text-decoration: none;
position: absolute;
top: 55px;
right: 10px;
}

.checklist li.selected a.checkbox-deselect {
display: block;
}

.checklist li label {
display: block;
text-align: center;
padding: 8px;
}

.sendit {
display: block;
float: left;
top: 118px;
left: 10px;
width: 115px;
height: 34px;
border: 0;
cursor: pointer;
background: url(i/sendit.gif) no-repeat 0 0;
text-indent: -9999px;
margin: 20px 0;
}

</style>

And finally the form thing

<ul class="checklist"><li><input name="jqdemo" value="value5" type="checkbox" id="choice_c"/><label for="choice_c">Some Text Here to be checked - clicked</label><a class="checkbox-select" href="#">Click</a><a class="checkbox-deselect" href="#">Cancel</a></li></ul>


I would like that my text on top of checkboxes become clickable.

Hello everyone,

I'm having this problem which is really annoying, tried to solve it but couldn't, I write that code in PHPMyAdmin and it works great, but it doesn't work in the website it self

ok long story short, there are three tables, hotels, cities, countries
hotels include in addition to hotel info, 2 columns (city_id) and (country_id)
Cities include id and name and also countries include id and name

what I was trying to do, that when a person inputs a city or country name in the search form, it should get the hotels that exists in this city or country, but unfortunately it shows all the hotels in all cities and countries, although the pagination code for number of pages works just fine, it count the number of hotels in that city or country and show the number of pages correctly

so here is the code for both

for hotel search

Code: [Select]
class hotelManager
{


public function getHotel($where)
{
$where = isset($_POST['where']) ? $_POST['where'] : "";
$dbObj = new DB();
$sql = "select * from hotels where city_id = (select id from cities where name = '$where' ) or country_id = (select id from countries where name = '$where' )";
$result = MYSQL_QUERY($sql);
$arr = array();
echo "<table>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td valign=\"top\" width=\"120px\">";
$rowid = $row['id'];
$imageqry=mysql_query("SELECT * FROM `hotelphotos` where hotel_id='$rowid' LIMIT 1");
$image=mysql_fetch_array($imageqry);
$imagename=$image['attachmentName'];
echo "<img src=\"foxmaincms/webroot/files/small/$imagename\"/>";
echo "</td>";
echo "<td valign=\"top\">";

echo "<table>
<tr>
<td valign=\"top\">
<a href=\"hotels.php?id=".$row['id']."\" class=\"titleslink\">".$row['name']."</a>
</td>
</tr>
<tr>
<td class=\"text\" valign=\"top\">
".$row['location']."
</td>
</tr>
</table>";

echo "</td>";
echo "</tr>";
}
echo "</table>";

for hotel pagination

Code: [Select]
<?php
  include("includes/hotelsManager.php");
  $hotelObj = new hotelManager();
  $where = isset($_POST['where']) ? $_POST['where'] : "";
  if(isset($_POST['where']))
  {
    
$hotelObj -> getHotel($where);


$per_page = 9;

//Calculating no of pages
$sql = "select * from hotels where city_id = (select id from cities where name = '$where' ) or country_id = (select id from countries where name = '$where' )";
$result = MYSQL_QUERY($sql) or die("<br />No Hotels found in this city, please check the city name and try again");
$count = mysql_num_rows($result);
$pages = ceil($count/$per_page)
?>


<div id="loading" ></div>
<div id="maincontent" ></div>
<ul id="pagination">
thank you in advance

This topic has been moved to Other Programming Languages.

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

if ($count==1){
				
						
				header("Location:store.php");				
				
								}

very simple I have issolated it and it doesn't redirect maybe u can see where my mistake is

Hey folks, I am trying to create a small script that will retrieve content from a site, strip it of everything but human readable words, then remove numbers, single letters, and words that I specify. I have the following code which is live on
http://salesleadhq.com/tools/crawler/meta.php?url=http://www.cooking.com.

My problem is that it is not removing all of the the words I specify, only some... ??
I think i would rather an external word list as well... if anyone can assist me with that.

Thank you!

Code: [Select]
<?php
$url = (isset($_GET['url']) ?$_GET['url'] : 0);
$str = file_get_contents($url);
####################################################################3
function get_url_contents($url){
        $crl = curl_init();
        $timeout = 5;
        curl_setopt ($crl, CURLOPT_URL,$url);
        curl_setopt ($crl, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt ($crl, CURLOPT_CONNECTTIMEOUT, $timeout);
        $ret = curl_exec($crl);
        curl_close($crl);
        return $ret;
}
#--------------------------------------Strip html tag----------------------------------------------------
function StripHtmlTags( $text )
{
  // PHP's strip_tags() function will remove tags, but it
  // doesn't remove scripts, styles, and other unwanted
  // invisible text between tags.  Also, as a prelude to
  // tokenizing the text, we need to insure that when
  // block-level tags (such as <p> or <div>) are removed,
  // neighboring words aren't joined.
  $text = preg_replace(
    array(
      // Remove invisible content
      '@<head[^>]*?>.*?</head>@siu',
      '@<style[^>]*?>.*?</style>@siu',
      '@<script[^>]*?.*?</script>@siu',
      '@<object[^>]*?.*?</object>@siu',
      '@<embed[^>]*?.*?</embed>@siu',
      '@<applet[^>]*?.*?</applet>@siu',
      '@<noframes[^>]*?.*?</noframes>@siu',
      '@<noscript[^>]*?.*?</noscript>@siu',
      '@<noembed[^>]*?.*?</noembed>@siu',

      // Add line breaks before & after blocks
      '@<((br)|(hr))@iu',
      '@</?((address)|(blockquote)|(center)|(del))@iu',
      '@</?((div)|(h[1-9])|(ins)|(isindex)|(p)|(pre))@iu',
      '@</?((dir)|(dl)|(dt)|(dd)|(li)|(menu)|(ol)|(ul))@iu',
      '@</?((table)|(th)|(td)|(caption))@iu',
      '@</?((form)|(button)|(fieldset)|(legend)|(input))@iu',
      '@</?((label)|(select)|(optgroup)|(option)|(textarea))@iu',
      '@</?((frameset)|(frame)|(iframe))@iu',
    ),
    array(' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', "\n\$0", "\n\$0", "\n\$0", "\n\$0", "\n\$0", "\n\$0", "\n\$0", "\n\$0",),$text );

  // Remove all remaining tags and comments and return.
  return strtolower( $text );
}

function RemoveComments( & $string )
{
  $string = preg_replace("%(#|;|(//)).*%","",$string);
  $string = preg_replace("%/\*(?:(?!\*/).)*\*/%s","",$string); // google for negative lookahead
  return $string;
}


$html = StripHtmlTags($str);

###Remove number in html################
$html  = preg_replace("/[0-9]/", " ", $html);

#replace &nbsp; by ' '
$html = str_replace("&nbsp;", " ", $html);

######remove any words################
$remove_word = array("amp","carry","serious","for","re","looking","accessories","you","used","wright","none","selection","come","second","you","new","a","able","about","across","after","all","almost","also","am","among","an","and","any","are","as","at","be","because","been","but","by","can","cannot","could","dear","did","do","does","either","else","ever","every","for","from","get","got","had","has","have","he","her","hers","him","his","how","however","i","if","in","into","is","it","its","just","least","let","like","likely","may","me","might","most","must","my","neither","no","nor","not","of","off","often","on","only","or","other","our","own","rather","said","say","says","she","should","since","so","some","than","that","the","their","them","then","there","these","they","this","tis","to","too","twas","us","wants","was","we","were","what","when","where","which","while","who","whom","why","will","with","would","yet","you","your");
foreach($remove_word as $word) {
$html = preg_replace("/\s". $word ."\s/", " ", $html);
}

######remove space
$html =  preg_replace ('/<[^>]*>/', '', $html);

$html =  preg_replace('/\s\s+/', ', ', $html);
$html =  preg_replace('/[\s\W]+/',', ',$html);   // Strip off spaces and non-alpha-numeric

#remove white space, Keep : . ( ) : &
//$html = preg_replace('/\s+/', ', ', $html);


###process#########################################################################
$array_loop = explode(",", $html);
$array_loop1 = $array_loop;
$arr_tem = array();

foreach($array_loop as $key=>$val) {
if(in_array($val, $array_loop1)) {
if(!$arr_tem[$val]) $arr_tem[$val] = 0;
$arr_tem[$val] += 1;

if ( ($k = array_search($val, $array_loop1) ) !== false )
unset($array_loop1[$k]);
}
}

arsort($arr_tem);

###echo top 20 words############################################################
echo "<h3>Top 20 words used most</h3>";
$i = 1;
foreach($arr_tem as $key=>$val) {
if($i<=20) {
echo $i.":&nbsp;&nbsp;".$key." (".$val." words)<br />";
$i++;
}else break;
}
echo "<hr />";
###print array#####################################################################
echo (implode(", ", array_keys($arr_tem)));

?>

Hi All,

Bit of a strange one but i would like to be able to supply a URL to a page.

This page will always contain an image and the copyright that goes with it for example

http://www.geograph.org.uk/photo/693325

The copyright lies undearneath

I would like to get some php code that would automatically grab the image and copy this to a directory on mt site and also take the creative commons copyright notice as a string ( which i will then display along side the image when i add it to  my site)

How can i do this through php

I know that the word "copyright" only ever appears once on the page ( as part of the bit im trying to grab) so can i use this somehow to grab the whole string?


Basically im being lazy and would like to automate the process of grabbing the image and copywrite without having to download it to my computer first and reload to my server ( as i will be doing this quite a lot)

Any ideas much appreciated
Thanks

For example:

I am using this code:

Code: [Select]
$myFile = "newuser.txt";
$fh = fopen($myFile, 'r');
$theData = fread($fh, 5);
fclose($fh);
echo $theData;
and it displays:

Code: [Select]
Bob 2 Which I am reading from my newuser.txt file!

Which corresponds to the username bob, and he has the ID of 2.

Now I want to make that linkable like this:

Code: [Select]
<a href=.?act=Profile&id=$IDFROMTEXTFILE(2)>$NAMEFROMTEXTFILE(BOB)</a>

this is possible? If so, Thanks!

Hello. I have one programming problem. I have this log, from witch i have to read specific area of text:
webtopay.log

OK 123.456.7.89 [2012-03-15 09:09:59 -0400] v1.5: MIKRO to:"1398", from:"865458961", id:"13525948", sms:"MCLADM thing"

So i need the script to extract word "thing" from that log. Also that script has to check if there is new entries in the log, and extract text from the last one.
(Explaining in other words, that script should extract word AFTER MCLADM. Every time its a different word)

p.s. I need that script to be integrated here (this has to send command to server "/manuadd (text from log)" :
Code: [Select]
<?php
try{
     $HOST = "178.16.35.196"; //the ip of the bukkit server
     $password = "MCLietuva";
     //Can't touch this:
     $sock = socket_create(AF_INET, SOCK_STREAM, 0)
     or die("error: could not create socket\n");
     $succ = socket_connect($sock, $HOST, 4445) 
     or die("error: could not connect to host\n");
     //Authentification
     socket_write($sock, $command = md5($password)."<Password>", strlen($command) + 1)
     or die("error: failed to write to socket\n");
     //Begin custom code here.
     socket_write($sock, $command = "/Command/ExecuteConsoleCommandAndReturn-SimpleBroadCast:broadcast lol;", strlen($command) + 1) //Writing text/command we want to send to the server
     or die("error: failed to write to socket\n");
     sleep(2); // This is example code and here has to be that script i want to make.
     //while(($returnedString = socket_read($sock,50000))!= ""){
        $returnedString = socket_read($sock,50000,PHP_NORMAL_READ);
        print($returnedString)
     //}
     print("End of script");
     socket_close($sock);
}catch(Exception $e){
    echo $e->getMessage();
}
?>

I hope i made things clear and you will help me
Thanks

Geek Friends,

I have list of URLs in an array called '$domains'

1- I want to run through each and every element of $domains in an API call.

API: Quote

http://lightapi.majesticseo.com/api_command.php?app_api_key=API_KEY&cmd=GetIndexItemInfo&items=1&item0=http://www.majesticseo.com


(Note: In this API "http://www.majesticseo.com" will be replaced with each element of $domain array in a loop)


2- The resulting output is XML:
<?xml version="1.0" encoding="utf-8"?>
<Result Code="OK" ErrorMessage="" FullError="">


<GlobalVars IndexBuildDate="17/04/2010 16:43:46" MostRecentBackLinkDate="2010-03-25"/>

<DataTables Count="1">

<DataTable Name="Results" RowsCount="1" Headers="ItemNum|Item|ResultCode|Status|ExtBackLinks|RefDomains|AnalysisResUnitsCost|ACRank|ItemType|IndexedURLs|GetTopBackLinksAnalysisResUnitsCost|RefIPs|RefSubNets|RefDomainsEDU|ExtBackLinksEDU|RefDomainsGOV|ExtBackLinksGOV|RefDomainsEDU_Exact|ExtBackLinksEDU_Exact|RefDomainsGOV_Exact|ExtBackLinksGOV_Exact">


<Row>0|majesticseo.com|OK|Found|28381|1229|28381|-1|1|4774|28381|1074|954|1|5|0|0|0|0|0|0</Row>

</DataTable>



</DataTables>
</Result>



I want to extract the below Elements out of this XML Output for each element of $domains in loop:

Quote

ACRank
ExtBackLinks
RefDomains
AnalysisResUnitsCost
RefIPs
RefSubNets
RefDomainsEDU
ExtBackLinksEDU
RefDomainsGOV
ExtBackLinksGOV
RefDomainsEDU_Exact
ExtBackLinksEDU_Exact
RefDomainsGOV_Exact
ExtBackLinksGOV_Exact
LastCrawlDate
Title




How can i achieve this with PHP?

P.S.: I have a scrapper code, that will scrape data for the array $domains, it best if we can merge this code with that code, so all run in one code only.

Please Letme know and i will PM you that scrapper Code, as i do not want to share that Publically.

Cheers & Enjoy the Snow  ,
Natasha T

Hi, I need to extract the integers from the source code:

<span class=CatLevel1><a onclick="Javascript:ShowMeu('21');">Arts</a>&nbsp;(9768)</span>
<span class=CatLevel1><a onclick="Javascript:ShowMeu('271');">Industrial Products</a>&nbsp;(9321)</span>
<span class=CatLevel1><a onclick="Javascript:ShowMeu('1273');">Baby</a>&nbsp;(11407)</span>

What are the pattern that I can use to retrieve all the integer in the bracket (9768, 9321, 11407)?    This is my php code: 

<!DOCTYPE html>
<html>
<body>


<?php
$file_string = file_get_contents('http://www.lelong.com.my/');
preg_match('/<title>(.*)<\/title>/i', $file_string, $title);     //pattern
$title_out = $title[1];
echo $title_out;
?>
 

</body>
</html>

Thanks
Edited by Raex, 22 August 2014 - 12:49 AM.

This topic has been moved to Third Party PHP Scripts.

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

I've joined querys because I'm making my own forums. However, when it gets to the echoin out part, it shows the category and only ONE of the sub categorys.

Code: [Select]
<div id="forumContainer">
<?php
$lastboard = '';

$forumQ = mysql_query("SELECT

   f1.cat_name as catName,
   f1.cat_id as catID,
   f2.cat_id as subCatID,
   f2.sub_id as subID,
   f2.sub_name as subName,
   f2.sub_desc as subDesc
   
   FROM `forum_cats` as f1
    LEFT JOIN `forum_sub` as f2
    ON f1.cat_id = f2.cat_id
   GROUP BY f2.cat_id
   ");
  
while($forumF = mysql_fetch_assoc($forumQ))
{
if($forumF['catName'] != $lastboard)
{
echo '<div class="forumCat">'.$forumF['catName'].'</div>';
$lastboard = $forumF['catName'];
}
echo '<div class="forumSub">'.$forumF['subName'].'</div>';
}
?>
</div>

$Row[2] doesn't work but if I use $Row["linkcat"] than it works fine.
Is there somewhere to activate in the php.ini file ?


Code: [Select]
// I got 9 fields to in the table tbl_link !  $Row[2] should give me a number.

$Verbinding = mysql_connect($db_host, $db_user, $db_passw);
mysql_select_db($db_name);
$sql = "Select * from tbl_link where userid=1";
$ResultShow = mysql_query($sql);

while ($Row = mysql_fetch_assoc($ResultShow)){
 
    echo $Row[2];

}

I just started with php and made an image. But when I try to open it in my browser, it shows a broken image icon. I have put the font in the same folder as the .php file, but it doesn't work. Can somebody help me solve this problem?

Here is the code:
Code: [Select]
<?php
$font_path = "nakedchick.TTF";
$font_size = 30;

$img_number = imagecreate(300,50);
$backcolor = imagecolorallocate($img_number,0,162,255);
$textcolor = imagecolorallocate($img_number,255,255,255);

imagefill($img_number,0,0,$backcolor);
$number = " So your ip is $_SERVER[REMOTE_ADDR]? ";

ImageTTFText($img_number, $font_size,10,5,5,$number,$font_path,$textcolor);

header("Content-type: image/png");
imagepng($img_number);
?>

And also the files: (.php in attachment)
http://falcogerritsjans.nl/u/signature2.php
http://falcogerritsjans.nl/u/nakedchick.ttf