Re: [PHP] Passing var from one page to itself
hello,
you can use session to store your variables between pages.
Aslan a écrit :
Hey there,
I have a problem where I have a simple -script that I am wanting to
pass back to itself three times
1) Symptoms - > 2) Troubleshooting questions 3) Answer to problem
The page is passing the vars from the first page to the second, but
the first pages vars are not passed to the third (but the second page is)
I am using includes for each sectional "page" and passing it back to
itself
if($submitted == "")
{
include 'inc/tshoot2-input.php';
}
if($submitted == "symptoms")
{
include 'inc/tshoot2-symptoms.php'; }
if($submitted == "submitted")
{
include 'inc/answers.php'; }
The tool will ultimately be on www.adslgeek.com/troubleshooter/
I have it currently all on one page, but it isn't quite what I was after
..
Any help would be appreciated!
Cheers
ADSL Geek
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Image Resizing
This one time, at band camp, Stephen Alistoun wrote: > I want all the images to resize to 100px width but the height adjusts > automatically. Two ways, GD or Imagick http://www.phpro.org/examples/GD-Thumbnail-Based-On-Image-Type.html http://www.phpro.org/tutorials/Imagick.html#4 Kevin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Image Resizing
i use imageMagick:
http://www.imagemagick.org/Magick++/Geometry.html
$command_line = "convert -geometry $width" . "x" . "$height $image_path
$thumb_path";
system($command_line, $return_var);
if ($return_var == 1) {
echo "Thumbnail creation failed! :(";
} else {
echo "Thumbnail created. :) View
Thumbnail FFS";
}
?>
if you run into problems, and assuming imageMagick was successfully
installed:
- make sure you have write permission for where you want the thumbnail to be
created
- try replacing convert with the full path to the convert app.
e.g.
$command_line = "/usr/bin/convert -geometry etc";
- run the script from the command line. ssh in to your script's directory
and try typing this:
php thumbscript.php
you'll see verbose messages to help you pinpoint the problem. depending
on your setup, you might have to put in the full path to php
- if you're still stuck, try putting in this line:
wrote:
> This one time, at band camp, Stephen Alistoun
> wrote:
>
>
> > I want all the images to resize to 100px width but the height adjusts
> > automatically.
>
>
> Two ways, GD or Imagick
>
> http://www.phpro.org/examples/GD-Thumbnail-Based-On-Image-Type.html
>
> http://www.phpro.org/tutorials/Imagick.html#4
>
> Kevin
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Crunchmutt Studios
Latest News Headlines: http://www.rssvideonews.com
http://www.imagepoop.com
http://www.crunchmutt.com
http://www.deadjoe.com
http://www.dailymedication.com
http://www.extremesportclips.com
http://www.coolanimalclips.com
http://www.robotclips.com
http://www.newsfinger.com
http://www.postyourimage.com
http://www.nakedalarmclock.com
Re: [PHP] Passing var from one page to itself
also, you can store info in hidden form fields. on the 2nd page, populate
the hidden fields with the data from the first page. when that form is
submitted, the hidden field values will get submitted as well.
that's not ideal, tho. if you have validation in place between the first
and second pages, that could be obviated if someone who knew some stuff
changed the hidden field values before it gets sent to the 3rd page.
you could do the session vars as the previous person suggested, but if you
have a lot of data to store, you might want to consider putting it into a
database using the session_id as the identifier.
On Sun, Dec 21, 2008 at 3:10 AM, kspal wrote:
> hello,
> you can use session to store your variables between pages.
>
>
>
> Aslan a écrit :
>
> Hey there,
>>
>> I have a problem where I have a simple -script that I am wanting to pass
>> back to itself three times
>> 1) Symptoms - > 2) Troubleshooting questions 3) Answer to problem
>>
>> The page is passing the vars from the first page to the second, but the
>> first pages vars are not passed to the third (but the second page is)
>>
>> I am using includes for each sectional "page" and passing it back to
>> itself
>>
>> if($submitted == "")
>> {
>>include 'inc/tshoot2-input.php';
>> }
>> if($submitted == "symptoms")
>> {
>>include 'inc/tshoot2-symptoms.php'; }
>> if($submitted == "submitted")
>> {
>>include 'inc/answers.php'; }
>>
>> The tool will ultimately be on www.adslgeek.com/troubleshooter/
>>
>> I have it currently all on one page, but it isn't quite what I was after
>> ..
>> Any help would be appreciated!
>>
>> Cheers
>> ADSL Geek
>>
>>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Crunchmutt Studios
Latest News Headlines: http://www.rssvideonews.com
http://www.imagepoop.com
http://www.crunchmutt.com
http://www.deadjoe.com
http://www.dailymedication.com
http://www.extremesportclips.com
http://www.coolanimalclips.com
http://www.robotclips.com
http://www.newsfinger.com
http://www.postyourimage.com
http://www.nakedalarmclock.com
[PHP] Repeat Region Error
Hi All,
I am getting the following error - Warning: mysql_fetch_assoc(): 3 is not a
valid MySQL result resource in
I think it has something to do with my Dreamweaver created code for a repeat
region. The head code is:
function GetSQLValueString($theValue, $theType, $theDefinedValue = "",
$theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ?
mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" :
"NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue :
$theNotDefinedValue;
break;
}
return $theValue;
}
}
$colname_rsSearch = "-1";
if (isset($_GET['product_name'])) {
$colname_rsSearch = $_GET['product_name'];
}
mysql_select_db($database_sondia_lighting, $sondia_lighting);
$query_rsSearch = sprintf("SELECT * FROM products WHERE product_name LIKE
%s", GetSQLValueString("%" . $colname_rsSearch . "%", "text"));
$rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
die(mysql_error());
$row_rsSearch = mysql_fetch_assoc($rsSearch);
$totalRows_rsSearch = mysql_num_rows($rsSearch);
?>
... and the code in the page to generate my region is:
?>
View Product
If anyone can assist I would really appreciate it
- Gary
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Repeat Region Error
Sorry guys .. resolved it doh!
I was freeing the recordset in
-Gary
""Gary Maddock-Greene"" wrote in message
news:5a.42.33998.4b83e...@pb1.pair.com...
Hi All,
I am getting the following error - Warning: mysql_fetch_assoc(): 3 is not
a valid MySQL result resource in
I think it has something to do with my Dreamweaver created code for a
repeat region. The head code is:
function GetSQLValueString($theValue, $theType, $theDefinedValue = "",
$theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ?
mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" :
"NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue :
$theNotDefinedValue;
break;
}
return $theValue;
}
}
$colname_rsSearch = "-1";
if (isset($_GET['product_name'])) {
$colname_rsSearch = $_GET['product_name'];
}
mysql_select_db($database_sondia_lighting, $sondia_lighting);
$query_rsSearch = sprintf("SELECT * FROM products WHERE product_name LIKE
%s", GetSQLValueString("%" . $colname_rsSearch . "%", "text"));
$rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
die(mysql_error());
$row_rsSearch = mysql_fetch_assoc($rsSearch);
$totalRows_rsSearch = mysql_num_rows($rsSearch);
?>
... and the code in the page to generate my region is:
?>
View Product
If anyone can assist I would really appreciate it
- Gary
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: imap_rfc822_parse_adrlist problem
Hi, On 21 dec 2008, at 03:41, Manuel Lemos wrote: on 12/20/2008 09:34 PM Ben Stuyts said the following: Hi, Since upgrading to php 5.2.8 I have a problem with imap_rfc822_parse_adrlist. When I run the example given on the manual page at http://nl3.php.net/imap_rfc822_parse_adrlist: ... So the host part isn't filled in correctly. I have verified this on two FreeBSD 7 machines. On an older FreeBSD 5 machine with php4 this works fine. Before the update, I was running php 5.2.6 and there was no problem either. Any ideas? Sometime ago I decided to not use IMAP library functions to parse e- mail addresses because it was not handling all sorts of addresses as it should. Well, yeah, ok, I read about the problems imap_rfc822_parse_adrlist() has, but shouldn't it just work at least as advertized in the manual? Plus, this is breaking an existing application (Twiggi). Nowadays I use an e-mail address parser class written in pure PHP that comes with this MIME parser class: http://www.phpclasses.org/mimeparser Thanks, I'll have a look at that. Ben -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Image Resizing
At 12:38 PM -0800 12/20/08, Stephen Alistoun wrote: Hi all, What is the best way in PHP to Resize an Image to a specific width. For Example I have images in the following sizes: (1) 200px width and 350px height (2) 125px width and 220px height (3) 166px width and 455px height I want all the images to resize to 100px width but the height adjusts automatically. Regards, Stephen Stephen: Here's the code. http://webbytedd.com/b/thumb/ Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Image Resizing
nice post Tedd and useful web site :) -Gary "tedd" wrote in message news:p06240802c573f5a71...@[192.168.1.101]... At 12:38 PM -0800 12/20/08, Stephen Alistoun wrote: Hi all, What is the best way in PHP to Resize an Image to a specific width. For Example I have images in the following sizes: (1) 200px width and 350px height (2) 125px width and 220px height (3) 166px width and 455px height I want all the images to resize to 100px width but the height adjusts automatically. Regards, Stephen Stephen: Here's the code. http://webbytedd.com/b/thumb/ Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Passing var from one page to itself
At 4:10 PM +1300 12/21/08, Aslan wrote:
Hey there,
I have a problem where I have a simple -script that I am wanting to
pass back to itself three times
1) Symptoms - > 2) Troubleshooting questions 3) Answer to problem
-snip-
I have it currently all on one page, but it isn't quite what I was after
..
Any help would be appreciated!
Hi Aslan:
Keeping it all on one page (one script) is fine -- no problems with that.
Here's the technique I use.
$step = isset($__POST ['step']) ? $__POST ['step'] :1;
if($step == 1)
{
// do the first page stuff (Symptoms)
// with a POST form that has an
}
if($step == 2)
{
// do the second page stuff ( Troubleshooting questions)
// with a POST form that has an
}
if($step == 3)
{
// do the third page stuff (Answer to problem)
// with a POST form that has an
}
If you want to pass variables between pages (trips from client to the
server nad back again), you have four options, namely: 1)
writing/reading a file; 2) writing/reading a database entry; 3)
passing via a POST/GET; 4) or using SESSIONS.
For most things, I prefer using POST/GET and/or SESSIONS. Try this format:
$var1 = isset($_POST['var1']) ? $_POST['var1'] : null;
$var2 = isset($_SESSION['var2']) ? $_SESSION['var2'] : null;
That's the way I pass data between client and server.
However, what you are describing sounds a bit like this:
http://webbytedd.com/b/exam/
With this example, I'm not passing anything to the server --
everything is kept client-side and is quick.
If interested, all the code is there.
Cheers,
tedd
--
---
http://sperling.com http://ancientstones.com http://earthstones.com
[PHP] eof bof in php
Hi, I'm very new to php. Please can someone point me in the right direction?
I want to display a message: 'No Products Found' if my search record set
returns no value.
I think I need to be looking at this section of my code ...
$query_rsSearch = sprintf("SELECT * FROM products WHERE product_name LIKE
%s", GetSQLValueString("%" . $colname_rsSearch . "%", "text"));
$rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
die(mysql_error());
$row_rsSearch = mysql_fetch_assoc($rsSearch);
$totalRows_rsSearch = mysql_num_rows($rsSearch);
?>
Thanks
- Gary Maddock-Greene
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] eof bof in php
On Sun, 2008-12-21 at 15:22 +, Gary Maddock-Greene wrote:
> Hi, I'm very new to php. Please can someone point me in the right direction?
> I want to display a message: 'No Products Found' if my search record set
> returns no value.
>
> I think I need to be looking at this section of my code ...
>
> $query_rsSearch = sprintf("SELECT * FROM products WHERE product_name LIKE
> %s", GetSQLValueString("%" . $colname_rsSearch . "%", "text"));
> $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
> die(mysql_error());
> $row_rsSearch = mysql_fetch_assoc($rsSearch);
> $totalRows_rsSearch = mysql_num_rows($rsSearch);
> ?>
>
> Thanks
>
> - Gary Maddock-Greene
>
>
Can you not just use the $totalRows_rsSearch value inside of an if
statement?
Ash
www.ashleysheridan.co.uk
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] eof bof in php
Thanks Ashley ... I have been trying that but I think my syntax id shot!!
Please click on a product for further information."
?>
?>
View Product
--
- Gary Maddock-Greene
"Ashley Sheridan" wrote in message
news:1229873521.4229.6.ca...@localhost.localdomain...
On Sun, 2008-12-21 at 15:22 +, Gary Maddock-Greene wrote:
Hi, I'm very new to php. Please can someone point me in the right
direction?
I want to display a message: 'No Products Found' if my search record set
returns no value.
I think I need to be looking at this section of my code ...
$query_rsSearch = sprintf("SELECT * FROM products WHERE product_name LIKE
%s", GetSQLValueString("%" . $colname_rsSearch . "%", "text"));
$rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
die(mysql_error());
$row_rsSearch = mysql_fetch_assoc($rsSearch);
$totalRows_rsSearch = mysql_num_rows($rsSearch);
?>
Thanks
- Gary Maddock-Greene
Can you not just use the $totalRows_rsSearch value inside of an if
statement?
Ash
www.ashleysheridan.co.uk
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] eof bof in php
On Sun, 2008-12-21 at 15:40 +, Gary Maddock-Greene wrote:
> Thanks Ashley ... I have been trying that but I think my syntax id shot!!
>
> if ($totalRows_rsSearch="0")
> echo "Sorry no products were found";
> else
> echo "Please click on a product for further information."
> ?>
>
>
>
>
>
> ?>
> View Product
>
>
>
>
>
>
>
> --
> - Gary Maddock-Greene
> "Ashley Sheridan" wrote in message
> news:1229873521.4229.6.ca...@localhost.localdomain...
> > On Sun, 2008-12-21 at 15:22 +, Gary Maddock-Greene wrote:
> >> Hi, I'm very new to php. Please can someone point me in the right
> >> direction?
> >> I want to display a message: 'No Products Found' if my search record set
> >> returns no value.
> >>
> >> I think I need to be looking at this section of my code ...
> >>
> >> $query_rsSearch = sprintf("SELECT * FROM products WHERE product_name LIKE
> >> %s", GetSQLValueString("%" . $colname_rsSearch . "%", "text"));
> >> $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
> >> die(mysql_error());
> >> $row_rsSearch = mysql_fetch_assoc($rsSearch);
> >> $totalRows_rsSearch = mysql_num_rows($rsSearch);
> >> ?>
> >>
> >> Thanks
> >>
> >> - Gary Maddock-Greene
> >>
> >>
> > Can you not just use the $totalRows_rsSearch value inside of an if
> > statement?
> >
> >
> > Ash
> > www.ashleysheridan.co.uk
> >
>
>
It might be because you're comparing the total to a string rather than a
number if ($totalRows_rsSearch="0")
If you remove the quote marks, it should work.
Ash
www.ashleysheridan.co.uk
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] eof bof in php
I have tried that but to no avail :)
// All seems OK to here, then the syntax error unexpected T_VARIABLE
appears
echo Please click on a product for further information.
View Product
--
- Gary Maddock-Greene
"Ashley Sheridan" wrote in message
news:1229875150.4229.9.ca...@localhost.localdomain...
On Sun, 2008-12-21 at 15:40 +, Gary Maddock-Greene wrote:
Thanks Ashley ... I have been trying that but I think my syntax id shot!!
Please click on a product for further information."
?>
$row_rsSearch['product_subtitle'];
?>
View Product
--
- Gary Maddock-Greene
"Ashley Sheridan" wrote in message
news:1229873521.4229.6.ca...@localhost.localdomain...
> On Sun, 2008-12-21 at 15:22 +, Gary Maddock-Greene wrote:
>> Hi, I'm very new to php. Please can someone point me in the right
>> direction?
>> I want to display a message: 'No Products Found' if my search record
>> set
>> returns no value.
>>
>> I think I need to be looking at this section of my code ...
>>
>> $query_rsSearch = sprintf("SELECT * FROM products WHERE product_name
>> LIKE
>> %s", GetSQLValueString("%" . $colname_rsSearch . "%", "text"));
>> $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
>> die(mysql_error());
>> $row_rsSearch = mysql_fetch_assoc($rsSearch);
>> $totalRows_rsSearch = mysql_num_rows($rsSearch);
>> ?>
>>
>> Thanks
>>
>> - Gary Maddock-Greene
>>
>>
> Can you not just use the $totalRows_rsSearch value inside of an if
> statement?
>
>
> Ash
> www.ashleysheridan.co.uk
>
It might be because you're comparing the total to a string rather than a
number if ($totalRows_rsSearch="0")
If you remove the quote marks, it should work.
Ash
www.ashleysheridan.co.uk
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] eof bof in php
On Sun, 2008-12-21 at 16:22 +, Gary Maddock-Greene wrote:
> I have tried that but to no avail :)
>
> if ($totalRows_rsSearch=0)
> echo "Sorry no products were found";
> else
>
>
> // All seems OK to here, then the syntax error unexpected T_VARIABLE
> appears
>
>
> echo Please click on a product for further information.
>
>
>
>
>
>?>
> View Product
>
>
>
>
>
>
>
> --
> - Gary Maddock-Greene
> "Ashley Sheridan" wrote in message
> news:1229875150.4229.9.ca...@localhost.localdomain...
> > On Sun, 2008-12-21 at 15:40 +, Gary Maddock-Greene wrote:
> >> Thanks Ashley ... I have been trying that but I think my syntax id shot!!
> >>
> >> >> if ($totalRows_rsSearch="0")
> >> echo "Sorry no products were found";
> >> else
> >> echo "Please click on a product for further information."
> >> ?>
> >>
> >>
> >>
> >>
> >>
> >> >> $row_rsSearch['product_subtitle'];
> >> ?>
> >> View Product
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> --
> >> - Gary Maddock-Greene
> >> "Ashley Sheridan" wrote in message
> >> news:1229873521.4229.6.ca...@localhost.localdomain...
> >> > On Sun, 2008-12-21 at 15:22 +, Gary Maddock-Greene wrote:
> >> >> Hi, I'm very new to php. Please can someone point me in the right
> >> >> direction?
> >> >> I want to display a message: 'No Products Found' if my search record
> >> >> set
> >> >> returns no value.
> >> >>
> >> >> I think I need to be looking at this section of my code ...
> >> >>
> >> >> $query_rsSearch = sprintf("SELECT * FROM products WHERE product_name
> >> >> LIKE
> >> >> %s", GetSQLValueString("%" . $colname_rsSearch . "%", "text"));
> >> >> $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
> >> >> die(mysql_error());
> >> >> $row_rsSearch = mysql_fetch_assoc($rsSearch);
> >> >> $totalRows_rsSearch = mysql_num_rows($rsSearch);
> >> >> ?>
> >> >>
> >> >> Thanks
> >> >>
> >> >> - Gary Maddock-Greene
> >> >>
> >> >>
> >> > Can you not just use the $totalRows_rsSearch value inside of an if
> >> > statement?
> >> >
> >> >
> >> > Ash
> >> > www.ashleysheridan.co.uk
> >> >
> >>
> >>
> > It might be because you're comparing the total to a string rather than a
> > number if ($totalRows_rsSearch="0")
> >
> > If you remove the quote marks, it should work.
> >
> >
> > Ash
> > www.ashleysheridan.co.uk
> >
>
>
Just spotted that you've omitted the semicolon from the second echo
statement as well.
Ash
www.ashleysheridan.co.uk
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] eof bof in php
if (0 == $totalRows_rsSearch) {
echo "Sorry no products were found";
} else
Anthony Gentile
On Sun, Dec 21, 2008 at 11:22 AM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
> I have tried that but to no avail :)
>
> if ($totalRows_rsSearch=0)
> echo "Sorry no products were found";
> else
>
>
> // All seems OK to here, then the syntax error unexpected T_VARIABLE
> appears
>
>
> echo Please click on a product for further information.
>
>
>
>
>
> ?>
>View Product
>
>
>
>
>
>
>
> --
> - Gary Maddock-Greene
> "Ashley Sheridan" wrote in message
> news:1229875150.4229.9.ca...@localhost.localdomain...
>
> On Sun, 2008-12-21 at 15:40 +, Gary Maddock-Greene wrote:
>>
>>> Thanks Ashley ... I have been trying that but I think my syntax id shot!!
>>>
>>> >> if ($totalRows_rsSearch="0")
>>> echo "Sorry no products were found";
>>> else
>>> echo "Please click on a product for further information."
>>> ?>
>>>
>>>
>>>
>>>
>>>
>>>>> $row_rsSearch['product_subtitle'];
>>> ?>
>>>View Product
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> - Gary Maddock-Greene
>>> "Ashley Sheridan" wrote in message
>>> news:1229873521.4229.6.ca...@localhost.localdomain...
>>> > On Sun, 2008-12-21 at 15:22 +, Gary Maddock-Greene wrote:
>>> >> Hi, I'm very new to php. Please can someone point me in the right
>>> >> direction?
>>> >> I want to display a message: 'No Products Found' if my search record
>>> >> set
>>> >> returns no value.
>>> >>
>>> >> I think I need to be looking at this section of my code ...
>>> >>
>>> >> $query_rsSearch = sprintf("SELECT * FROM products WHERE product_name
>>> >> LIKE
>>> >> %s", GetSQLValueString("%" . $colname_rsSearch . "%", "text"));
>>> >> $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
>>> >> die(mysql_error());
>>> >> $row_rsSearch = mysql_fetch_assoc($rsSearch);
>>> >> $totalRows_rsSearch = mysql_num_rows($rsSearch);
>>> >> ?>
>>> >>
>>> >> Thanks
>>> >>
>>> >> - Gary Maddock-Greene
>>> >>
>>> >>
>>> > Can you not just use the $totalRows_rsSearch value inside of an if
>>> > statement?
>>> >
>>> >
>>> > Ash
>>> > www.ashleysheridan.co.uk
>>> >
>>>
>>>
>>> It might be because you're comparing the total to a string rather than a
>> number if ($totalRows_rsSearch="0")
>>
>> If you remove the quote marks, it should work.
>>
>>
>> Ash
>> www.ashleysheridan.co.uk
>>
>>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Re: [PHP] eof bof in php
On Sun, 2008-12-21 at 11:39 -0500, Anthony Gentile wrote:
> if (0 == $totalRows_rsSearch) {
> echo "Sorry no products were found";
> } else
>
> Anthony Gentile
>
>
>
> On Sun, Dec 21, 2008 at 11:22 AM, Gary Maddock-Greene <
> g...@maddock-greene.co.uk> wrote:
>
> > I have tried that but to no avail :)
> >
> > > if ($totalRows_rsSearch=0)
> > echo "Sorry no products were found";
> > else
> >
> >
> > // All seems OK to here, then the syntax error unexpected T_VARIABLE
> > appears
> >
> >
> > echo Please click on a product for further information.
> >
> >
> >
> >
> >
> > > ?>
> >View Product
> >
> >
> >
> >
> >
> >
> >
> > --
> > - Gary Maddock-Greene
> > "Ashley Sheridan" wrote in message
> > news:1229875150.4229.9.ca...@localhost.localdomain...
> >
> > On Sun, 2008-12-21 at 15:40 +, Gary Maddock-Greene wrote:
> >>
> >>> Thanks Ashley ... I have been trying that but I think my syntax id shot!!
> >>>
> >>> >>> if ($totalRows_rsSearch="0")
> >>> echo "Sorry no products were found";
> >>> else
> >>> echo "Please click on a product for further information."
> >>> ?>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> >>> $row_rsSearch['product_subtitle'];
> >>> ?>
> >>>View Product
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> --
> >>> - Gary Maddock-Greene
> >>> "Ashley Sheridan" wrote in message
> >>> news:1229873521.4229.6.ca...@localhost.localdomain...
> >>> > On Sun, 2008-12-21 at 15:22 +, Gary Maddock-Greene wrote:
> >>> >> Hi, I'm very new to php. Please can someone point me in the right
> >>> >> direction?
> >>> >> I want to display a message: 'No Products Found' if my search record
> >>> >> set
> >>> >> returns no value.
> >>> >>
> >>> >> I think I need to be looking at this section of my code ...
> >>> >>
> >>> >> $query_rsSearch = sprintf("SELECT * FROM products WHERE product_name
> >>> >> LIKE
> >>> >> %s", GetSQLValueString("%" . $colname_rsSearch . "%", "text"));
> >>> >> $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
> >>> >> die(mysql_error());
> >>> >> $row_rsSearch = mysql_fetch_assoc($rsSearch);
> >>> >> $totalRows_rsSearch = mysql_num_rows($rsSearch);
> >>> >> ?>
> >>> >>
> >>> >> Thanks
> >>> >>
> >>> >> - Gary Maddock-Greene
> >>> >>
> >>> >>
> >>> > Can you not just use the $totalRows_rsSearch value inside of an if
> >>> > statement?
> >>> >
> >>> >
> >>> > Ash
> >>> > www.ashleysheridan.co.uk
> >>> >
> >>>
> >>>
> >>> It might be because you're comparing the total to a string rather than a
> >> number if ($totalRows_rsSearch="0")
> >>
> >> If you remove the quote marks, it should work.
> >>
> >>
> >> Ash
> >> www.ashleysheridan.co.uk
> >>
> >>
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
D'oh, not sure how I missed that one too, the double ==. No wonder it
wasn't working.
Ash
www.ashleysheridan.co.uk
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Create PHP form from MySQL table structure
Hi folks Anybody got any recommendations for a utility which would create a quick head start by creating the php/html code for a basic form using the field structure of a MySQL table ? Thanks for any suggestions. -- Ronnie MacGregor Scotland Ronnie at dBASEdeveloper dot co dot uk www.dBASEdeveloper.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: imap_rfc822_parse_adrlist problem
Hello, on 12/21/2008 11:12 AM Ben Stuyts said the following: >>> Since upgrading to php 5.2.8 I have a problem with >>> imap_rfc822_parse_adrlist. When I run the example given on the manual >>> page at http://nl3.php.net/imap_rfc822_parse_adrlist: >>> ... >>> So the host part isn't filled in correctly. I have verified this on two >>> FreeBSD 7 machines. On an older FreeBSD 5 machine with php4 this works >>> fine. Before the update, I was running php 5.2.6 and there was no >>> problem either. Any ideas? >> >> Sometime ago I decided to not use IMAP library functions to parse e-mail >> addresses because it was not handling all sorts of addresses as it >> should. > > Well, yeah, ok, I read about the problems imap_rfc822_parse_adrlist() > has, but shouldn't it just work at least as advertized in the manual? > Plus, this is breaking an existing application (Twiggi). PHP always had backwards incompatibility breaking problems with new releases. That is why PHP 5 took time to be adopted. Actuall, most ISP were sort of forced to upgrade because the announcement of the end of support to PHP 4 versions. Anyway, if you found a bug, you only need to report it to bugs.php.net to have it checked and hopefully fixed. Since it is related with an external library, maybe it is not PHP fault. PHP has a extensive test suite but I guess you either found a case that is not well tested or it is not understood as a bug. >> Nowadays I use an e-mail address parser class written in pure PHP that >> comes with this MIME parser class: >> >> http://www.phpclasses.org/mimeparser > > Thanks, I'll have a look at that. -- Regards, Manuel Lemos Find and post PHP jobs http://www.phpclasses.org/jobs/ PHP Classes - Free ready to use OOP components written in PHP http://www.phpclasses.org/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Create PHP form from MySQL table structure
At 10:35 AM + 12/21/08, R B MacGregor wrote: Hi folks Anybody got any recommendations for a utility which would create a quick head start by creating the php/html code for a basic form using the field structure of a MySQL table ? Thanks for any suggestions. -- Ronnie MacGregor Scotland Ronnie at dBASEdeveloper dot co dot uk Interesting. I am sure that one can write a script to find all the fields in a table and create a form from that. However, I don't know of any utility that does that. Hope that helps, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] eof bof in php
Thanks guys .. I can get this part working great ..
Sorry no products were found";
} else
echo "Please click on a product for further information."
?>
But I want to add the following so that only the products table appears when
product are present. I cannot seem to add this code into the above after the
echo "Please click on a product for further information.". I can't
get the syntax right ...
I appreciate everyones help
--
- Gary Maddock-Greene
"Ashley Sheridan" wrote in message
news:1229878234.4229.12.ca...@localhost.localdomain...
On Sun, 2008-12-21 at 11:39 -0500, Anthony Gentile wrote:
if (0 == $totalRows_rsSearch) {
echo "Sorry no products were found";
} else
Anthony Gentile
On Sun, Dec 21, 2008 at 11:22 AM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
> I have tried that but to no avail :)
>
> if ($totalRows_rsSearch=0)
> echo "Sorry no products were found";
> else
>
>
> // All seems OK to here, then the syntax error unexpected T_VARIABLE
> appears
>
>
> echo Please click on a product for further information.
>
>
>
>
>
>> $row_rsSearch['product_subtitle'];
> ?>
>View Product
>
>
>
>
>
>
>
> --
> - Gary Maddock-Greene
> "Ashley Sheridan" wrote in message
> news:1229875150.4229.9.ca...@localhost.localdomain...
>
> On Sun, 2008-12-21 at 15:40 +, Gary Maddock-Greene wrote:
>>
>>> Thanks Ashley ... I have been trying that but I think my syntax id
>>> shot!!
>>>
>>> >> if ($totalRows_rsSearch="0")
>>> echo "Sorry no products were found";
>>> else
>>> echo "Please click on a product for further information."
>>> ?>
>>>
>>>
>>>
>>>
>>>
>>>>> $row_rsSearch['product_subtitle'];
>>> ?>
>>>View Product
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> - Gary Maddock-Greene
>>> "Ashley Sheridan" wrote in message
>>> news:1229873521.4229.6.ca...@localhost.localdomain...
>>> > On Sun, 2008-12-21 at 15:22 +, Gary Maddock-Greene wrote:
>>> >> Hi, I'm very new to php. Please can someone point me in the right
>>> >> direction?
>>> >> I want to display a message: 'No Products Found' if my search
>>> >> record
>>> >> set
>>> >> returns no value.
>>> >>
>>> >> I think I need to be looking at this section of my code ...
>>> >>
>>> >> $query_rsSearch = sprintf("SELECT * FROM products WHERE
>>> >> product_name
>>> >> LIKE
>>> >> %s", GetSQLValueString("%" . $colname_rsSearch . "%", "text"));
>>> >> $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
>>> >> die(mysql_error());
>>> >> $row_rsSearch = mysql_fetch_assoc($rsSearch);
>>> >> $totalRows_rsSearch = mysql_num_rows($rsSearch);
>>> >> ?>
>>> >>
>>> >> Thanks
>>> >>
>>> >> - Gary Maddock-Greene
>>> >>
>>> >>
>>> > Can you not just use the $totalRows_rsSearch value inside of an if
>>> > statement?
>>> >
>>> >
>>> > Ash
>>> > www.ashleysheridan.co.uk
>>> >
>>>
>>>
>>> It might be because you're comparing the total to a string rather
>>> than a
>> number if ($totalRows_rsSearch="0")
>>
>> If you remove the quote marks, it should work.
>>
>>
>> Ash
>> www.ashleysheridan.co.uk
>>
>>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
D'oh, not sure how I missed that one too, the double ==. No wonder it
wasn't working.
Ash
www.ashleysheridan.co.uk
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Create PHP form from MySQL table structure
On Sun, Dec 21, 2008 at 7:24 PM, tedd wrote: > At 10:35 AM + 12/21/08, R B MacGregor wrote: > >> Hi folks >> >> Anybody got any recommendations for a utility which would create a quick >> head >> start by creating the php/html code for a basic form using the field >> structure >> of a MySQL table ? >> >> Thanks for any suggestions. >> >> -- >> Ronnie MacGregor >> Scotland >> >> Ronnie at >> dBASEdeveloper >> dot co dot uk >> > > > Interesting. > > I am sure that one can write a script to find all the fields in a table and > create a form from that. However, I don't know of any utility that does > that. > > Hope that helps, > > tedd I wrote a class for my upcoming opensource cms ( aikicms ) , that can handle an array of added value description of a db table, and convert it into forms for inserting, and editing. the array looks like this: $insertArray= array( "tablename" => "aiki_something", "pkey" => "id", "selection1" => "cityid:NAME:aikiads_cities:id:cities", //values form other table: aikiads_cities "textinput1" => "name:NAME", "textblock" => "bodytext:NAME", "upload" => "filename:NAME:jpg:resize:640|n_|75|s_:/home/paintings:/home/paintings/s_", "staticselect" => "staticname:NAME:letters", "staticselect" => "staticname:NAME:date_years:2002-2008", "imagefolderupload" => "filedname:NAME:jpg:resize:640|n_|75|s_:/home/paintings:/home/paintings/s_", ); the values of this method instead of just walking throw each filed and putting a text block for it, that the class can automatically generate upload forms with image resizing and stored procedures of linked tables inside mysql.. I think you'll understand what I mean by just looking to the array, the code will be available soon under GPL, if anyone is interesting I can send the beta class source for further improvement, maybe adding a function that can find each field of a table and Hey that's a text filed just add: "textinput1" => "name:NAME", then the class will build the form for you
Re: [PHP] eof bof in php
...missing semicolon and some brackets.
Sorry no products were found";
} else {
echo "Please click on a product for further information.";
}
?>
If there is more code you can show by perhaps pasting here:
http://pastebin.redlinktech.com
We can help with further syntax problems.
Anthony Gentile
On Sun, Dec 21, 2008 at 12:33 PM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
> Thanks guys .. I can get this part working great ..
>
> if (0 == $totalRows_rsSearch) {
> echo "Sorry no products were found";
> } else
> echo "Please click on a product for further information."
> ?>
>
> But I want to add the following so that only the products table appears
> when product are present. I cannot seem to add this code into the above
> after the echo "Please click on a product for further
> information.". I can't get the syntax right ...
>
> I appreciate everyones help
>
> --
> - Gary Maddock-Greene
> "Ashley Sheridan" wrote in message
> news:1229878234.4229.12.ca...@localhost.localdomain...
>
> On Sun, 2008-12-21 at 11:39 -0500, Anthony Gentile wrote:
>>
>>> if (0 == $totalRows_rsSearch) {
>>> echo "Sorry no products were found";
>>> } else
>>>
>>> Anthony Gentile
>>>
>>>
>>>
>>> On Sun, Dec 21, 2008 at 11:22 AM, Gary Maddock-Greene <
>>> g...@maddock-greene.co.uk> wrote:
>>>
>>> > I have tried that but to no avail :)
>>> >
>>> > >> > if ($totalRows_rsSearch=0)
>>> > echo "Sorry no products were found";
>>> > else
>>> >
>>> >
>>> > // All seems OK to here, then the syntax error unexpected T_VARIABLE
>>> > appears
>>> >
>>> >
>>> > echo Please click on a product for further information.
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> $row_rsSearch['product_subtitle'];
>>> > ?>
>>> >View Product
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> > --
>>> > - Gary Maddock-Greene
>>> > "Ashley Sheridan" wrote in message
>>> > news:1229875150.4229.9.ca...@localhost.localdomain...
>>> >
>>> > On Sun, 2008-12-21 at 15:40 +, Gary Maddock-Greene wrote:
>>> >>
>>> >>> Thanks Ashley ... I have been trying that but I think my syntax id
>>> >>> shot!!
>>> >>>
>>> >>> >> >>> if ($totalRows_rsSearch="0")
>>> >>> echo "Sorry no products were found";
>>> >>> else
>>> >>> echo "Please click on a product for further information."
>>> >>> ?>
>>> >>>
>>> >>>
>>> >>>
>>> >>>
>>> >>>
>>> >>>>> >>> $row_rsSearch['product_subtitle'];
>>> >>> ?>
>>> >>>View Product
>>> >>>
>>> >>>
>>> >>>
>>> >>>
>>> >>>
>>> >>>
>>> >>>
>>> >>> --
>>> >>> - Gary Maddock-Greene
>>> >>> "Ashley Sheridan" wrote in message
>>> >>> news:1229873521.4229.6.ca...@localhost.localdomain...
>>> >>> > On Sun, 2008-12-21 at 15:22 +, Gary Maddock-Greene wrote:
>>> >>> >> Hi, I'm very new to php. Please can someone point me in the right
>>> >>> >> direction?
>>> >>> >> I want to display a message: 'No Products Found' if my search >>>
>>> >> record
>>> >>> >> set
>>> >>> >> returns no value.
>>> >>> >>
>>> >>> >> I think I need to be looking at this section of my code ...
>>> >>> >>
>>> >>> >> $query_rsSearch = sprintf("SELECT * FROM products WHERE >>> >>
>>> product_name
>>> >>> >> LIKE
>>> >>> >> %s", GetSQLValueString("%" . $colname_rsSearch . "%", "text"));
>>> >>> >> $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
>>> >>> >> die(mysql_error());
>>> >>> >> $row_rsSearch = mysql_fetch_assoc($rsSearch);
>>> >>> >> $totalRows_rsSearch = mysql_num_rows($rsSearch);
>>> >>> >> ?>
>>> >>> >>
>>> >>> >> Thanks
>>> >>> >>
>>> >>> >> - Gary Maddock-Greene
>>> >>> >>
>>> >>> >>
>>> >>> > Can you not just use the $totalRows_rsSearch value inside of an if
>>> >>> > statement?
>>> >>> >
>>> >>> >
>>> >>> > Ash
>>> >>> > www.ashleysheridan.co.uk
>>> >>> >
>>> >>>
>>> >>>
>>> >>> It might be because you're comparing the total to a string rather
>>> >>> than a
>>> >> number if ($totalRows_rsSearch="0")
>>> >>
>>> >> If you remove the quote marks, it should work.
>>> >>
>>> >>
>>> >> Ash
>>> >> www.ashleysheridan.co.uk
>>> >>
>>> >>
>>> >
>>> > --
>>> > PHP General Mailing List (http://www.php.net/)
>>> > To unsubscribe, visit: http://www.php.net/unsub.php
>>> >
>>> >
>>>
>> D'oh, not sure how I missed that one too, the double ==. No wonder it
>> wasn't working.
>>
>>
>> Ash
>> www.ashleysheridan.co.uk
>>
>>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Re: [PHP] eof bof in php
I've corrected those errors thanks but how do I insert this code as the else
statement?
View Product
--
- Gary Maddock-Greene
""Anthony Gentile"" wrote in message
news:2ce4207d0812210959k3491690ctbc4f0dbf971ac...@mail.gmail.com...
...missing semicolon and some brackets.
Sorry no products were found";
} else {
echo "Please click on a product for further information.";
}
?>
If there is more code you can show by perhaps pasting here:
http://pastebin.redlinktech.com
We can help with further syntax problems.
Anthony Gentile
On Sun, Dec 21, 2008 at 12:33 PM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
Thanks guys .. I can get this part working great ..
Sorry no products were found";
} else
echo "Please click on a product for further information."
?>
But I want to add the following so that only the products table appears
when product are present. I cannot seem to add this code into the above
after the echo "Please click on a product for further
information.". I can't get the syntax right ...
I appreciate everyones help
--
- Gary Maddock-Greene
"Ashley Sheridan" wrote in message
news:1229878234.4229.12.ca...@localhost.localdomain...
On Sun, 2008-12-21 at 11:39 -0500, Anthony Gentile wrote:
if (0 == $totalRows_rsSearch) {
echo "Sorry no products were found";
} else
Anthony Gentile
On Sun, Dec 21, 2008 at 11:22 AM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
> I have tried that but to no avail :)
>
> if ($totalRows_rsSearch=0)
> echo "Sorry no products were found";
> else
>
>
> // All seems OK to here, then the syntax error unexpected T_VARIABLE
> appears
>
>
> echo Please click on a product for further information.
>
>
>
>
>
>
$row_rsSearch['product_subtitle'];
> ?>
>View Product
>
>
>
>
>
>
>
> --
> - Gary Maddock-Greene
> "Ashley Sheridan" wrote in message
> news:1229875150.4229.9.ca...@localhost.localdomain...
>
> On Sun, 2008-12-21 at 15:40 +, Gary Maddock-Greene wrote:
>>
>>> Thanks Ashley ... I have been trying that but I think my syntax id
>>> shot!!
>>>
>>> >> if ($totalRows_rsSearch="0")
>>> echo "Sorry no products were found";
>>> else
>>> echo "Please click on a product for further information."
>>> ?>
>>>
>>>
>>>
>>>
>>>
>>>>> $row_rsSearch['product_subtitle'];
>>> ?>
>>>
>>> ?>">View Product
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> - Gary Maddock-Greene
>>> "Ashley Sheridan" wrote in message
>>> news:1229873521.4229.6.ca...@localhost.localdomain...
>>> > On Sun, 2008-12-21 at 15:22 +, Gary Maddock-Greene wrote:
>>> >> Hi, I'm very new to php. Please can someone point me in the
>>> >> right
>>> >> direction?
>>> >> I want to display a message: 'No Products Found' if my search
>>> >> >>>
>> record
>>> >> set
>>> >> returns no value.
>>> >>
>>> >> I think I need to be looking at this section of my code ...
>>> >>
>>> >> $query_rsSearch = sprintf("SELECT * FROM products WHERE >>> >>
product_name
>>> >> LIKE
>>> >> %s", GetSQLValueString("%" . $colname_rsSearch . "%", "text"));
>>> >> $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
>>> >> die(mysql_error());
>>> >> $row_rsSearch = mysql_fetch_assoc($rsSearch);
>>> >> $totalRows_rsSearch = mysql_num_rows($rsSearch);
>>> >> ?>
>>> >>
>>> >> Thanks
>>> >>
>>> >> - Gary Maddock-Greene
>>> >>
>>> >>
>>> > Can you not just use the $totalRows_rsSearch value inside of an
>>> > if
>>> > statement?
>>> >
>>> >
>>> > Ash
>>> > www.ashleysheridan.co.uk
>>> >
>>>
>>>
>>> It might be because you're comparing the total to a string rather
>>> than a
>> number if ($totalRows_rsSearch="0")
>>
>> If you remove the quote marks, it should work.
>>
>>
>> Ash
>> www.ashleysheridan.co.uk
>>
>>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
D'oh, not sure how I missed that one too, the double ==. No wonder it
wasn't working.
Ash
www.ashleysheridan.co.uk
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] eof bof in php
Sorry no products were found";
} else {
echo "Please click on a product for further information.";
while ($row_rsSearch = mysql_fetch_assoc($rsSearch)){
echo "
". $row_rsSearch['product_name']."
". $row_rsSearch['product_subtitle'] ."
";
}
}
?>
is probably going to give you the result you want. However you should know
it is bad practice to mix PHP and HTML as horridly as I just showed you. AKA
you don't want your PHP writing your HTML.
Anthony Gentile
On Sun, Dec 21, 2008 at 1:07 PM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
> I've corrected those errors thanks but how do I insert this code as the
> else statement?
>
>
>
>
>
> ?>
>View Product
>
>
>
>
>
>
>
> --
> - Gary Maddock-Greene
> ""Anthony Gentile"" wrote in message
> news:2ce4207d0812210959k3491690ctbc4f0dbf971ac...@mail.gmail.com...
>
> ...missing semicolon and some brackets.
>>
>> > if (0 == $totalRows_rsSearch) {
>> echo "Sorry no products were found";
>> } else {
>> echo "Please click on a product for further information.";
>> }
>> ?>
>>
>> If there is more code you can show by perhaps pasting here:
>> http://pastebin.redlinktech.com
>> We can help with further syntax problems.
>>
>> Anthony Gentile
>>
>>
>>
>> On Sun, Dec 21, 2008 at 12:33 PM, Gary Maddock-Greene <
>> g...@maddock-greene.co.uk> wrote:
>>
>> Thanks guys .. I can get this part working great ..
>>>
>>> >> if (0 == $totalRows_rsSearch) {
>>> echo "Sorry no products were found";
>>> } else
>>> echo "Please click on a product for further information."
>>> ?>
>>>
>>> But I want to add the following so that only the products table appears
>>> when product are present. I cannot seem to add this code into the above
>>> after the echo "Please click on a product for further
>>> information.". I can't get the syntax right ...
>>>
>>> I appreciate everyones help
>>>
>>> --
>>> - Gary Maddock-Greene
>>> "Ashley Sheridan" wrote in message
>>> news:1229878234.4229.12.ca...@localhost.localdomain...
>>>
>>> On Sun, 2008-12-21 at 11:39 -0500, Anthony Gentile wrote:
>>>
if (0 == $totalRows_rsSearch) {
> echo "Sorry no products were found";
> } else
>
> Anthony Gentile
>
>
>
> On Sun, Dec 21, 2008 at 11:22 AM, Gary Maddock-Greene <
> g...@maddock-greene.co.uk> wrote:
>
> > I have tried that but to no avail :)
> >
> > > if ($totalRows_rsSearch=0)
> > echo "Sorry no products were found";
> > else
> >
> >
> > // All seems OK to here, then the syntax error unexpected T_VARIABLE
> > appears
> >
> >
> > echo Please click on a product for further information.
> >
> >
> >
> >
> >
> >
> $row_rsSearch['product_subtitle'];
> > ?>
> >View Product
> >
> >
> >
> >
> >
> >
> >
> > --
> > - Gary Maddock-Greene
> > "Ashley Sheridan" wrote in message
> > news:1229875150.4229.9.ca...@localhost.localdomain...
> >
> > On Sun, 2008-12-21 at 15:40 +, Gary Maddock-Greene wrote:
> >>
> >>> Thanks Ashley ... I have been trying that but I think my syntax id
> >>> shot!!
> >>>
> >>> >>> if ($totalRows_rsSearch="0")
> >>> echo "Sorry no products were found";
> >>> else
> >>> echo "Please click on a product for further information."
> >>> ?>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> >>> $row_rsSearch['product_subtitle'];
> >>> ?>
> >>>View Product
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> --
> >>> - Gary Maddock-Greene
> >>> "Ashley Sheridan" wrote in message
> >>> news:1229873521.4229.6.ca...@localhost.localdomain...
> >>> > On Sun, 2008-12-21 at 15:22 +, Gary Maddock-Greene wrote:
> >>> >> Hi, I'm very new to php. Please can someone point me in the >>>
> >> right
> >>> >> direction?
> >>> >> I want to display a message: 'No Products Found' if my search
> >>> >> >>>
> >> record
> >>> >> set
> >>> >> returns no value.
> >>> >>
> >>> >> I think I need to be looking at this section of my code ...
> >>> >>
> >>> >> $query_rsSearch = sprintf("SELECT * FROM products WHERE >>> >>
> product_name
> >>> >> LIKE
> >>> >> %s", GetSQLValueString("%" . $colname_rsSearch . "%", "text"));
> >>> >> $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
> >>> >> die(mysql_error());
> >>> >> $row_rsSearch = mysql_fetch_assoc($rsSearch);
> >>> >> $totalRows_rsSearch = mysql_num_rows($rsSearch);
> >>> >> ?>
> >>> >>
> >>> >> Thank
Re: [PHP] eof bof in php
err forgot the closing > in ".
Anthony Gentile
Cell: 704.657.8550
Diese E-Mail ist vertraulich. Wenn Sie nicht der rechtmaessige Empfaenger
sind, duerfen Sie den Inhalt weder kopieren noch verbreiten oder benutzen.
Sollten Sie diese E-Mail versehentlich erhalten haben, senden Sie diese
bitte an uns zurueck und loeschen Sie sie anschliessend.
This email is confidential. If you are not the intended recipient, you must
not copy, disclose or use its contents. If you have received it in error,
please inform us immediately by return email and delete the document.
On Sun, Dec 21, 2008 at 1:21 PM, Anthony Gentile wrote:
> if (0 == $totalRows_rsSearch) {
> echo "Sorry no products were found";
> } else {
> echo "Please click on a product for further information.";
> while ($row_rsSearch = mysql_fetch_assoc($rsSearch)){
> echo " $row_rsSearch['product_image']."
>
> ". $row_rsSearch['product_name']."
>". $row_rsSearch['product_subtitle'] ."
>
> Product
>
>
>
>
>";
> }
>
> }
> ?>
>
> is probably going to give you the result you want. However you should know
> it is bad practice to mix PHP and HTML as horridly as I just showed you. AKA
> you don't want your PHP writing your HTML.
>
> Anthony Gentile
>
>
>
> On Sun, Dec 21, 2008 at 1:07 PM, Gary Maddock-Greene <
> g...@maddock-greene.co.uk> wrote:
>
>> I've corrected those errors thanks but how do I insert this code as the
>> else statement?
>>
>>
>>
>>
>>
>>> ?>
>>View Product
>>
>>
>>
>>
>>
>>
>>
>> --
>> - Gary Maddock-Greene
>> ""Anthony Gentile"" wrote in message
>> news:2ce4207d0812210959k3491690ctbc4f0dbf971ac...@mail.gmail.com...
>>
>> ...missing semicolon and some brackets.
>>>
>>> >> if (0 == $totalRows_rsSearch) {
>>> echo "Sorry no products were found";
>>> } else {
>>> echo "Please click on a product for further information.";
>>> }
>>> ?>
>>>
>>> If there is more code you can show by perhaps pasting here:
>>> http://pastebin.redlinktech.com
>>> We can help with further syntax problems.
>>>
>>> Anthony Gentile
>>>
>>>
>>>
>>> On Sun, Dec 21, 2008 at 12:33 PM, Gary Maddock-Greene <
>>> g...@maddock-greene.co.uk> wrote:
>>>
>>> Thanks guys .. I can get this part working great ..
>>> if (0 == $totalRows_rsSearch) {
echo "Sorry no products were found";
} else
echo "Please click on a product for further information."
?>
But I want to add the following so that only the products table appears
when product are present. I cannot seem to add this code into the above
after the echo "Please click on a product for further
information.". I can't get the syntax right ...
I appreciate everyones help
--
- Gary Maddock-Greene
"Ashley Sheridan" wrote in message
news:1229878234.4229.12.ca...@localhost.localdomain...
On Sun, 2008-12-21 at 11:39 -0500, Anthony Gentile wrote:
>
> if (0 == $totalRows_rsSearch) {
>> echo "Sorry no products were found";
>> } else
>>
>> Anthony Gentile
>>
>>
>>
>> On Sun, Dec 21, 2008 at 11:22 AM, Gary Maddock-Greene <
>> g...@maddock-greene.co.uk> wrote:
>>
>> > I have tried that but to no avail :)
>> >
>> > > > if ($totalRows_rsSearch=0)
>> > echo "Sorry no products were found";
>> > else
>> >
>> >
>> > // All seems OK to here, then the syntax error unexpected T_VARIABLE
>> > appears
>> >
>> >
>> > echo Please click on a product for further information.
>> >
>> >
>> >
>> >
>> >
>> >
>> $row_rsSearch['product_subtitle'];
>> > ?>
>> >View Product
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > --
>> > - Gary Maddock-Greene
>> > "Ashley Sheridan" wrote in message
>> > news:1229875150.4229.9.ca...@localhost.localdomain...
>> >
>> > On Sun, 2008-12-21 at 15:40 +, Gary Maddock-Greene wrote:
>> >>
>> >>> Thanks Ashley ... I have been trying that but I think my syntax id
>> >>> shot!!
>> >>>
>> >>> > >>> if ($totalRows_rsSearch="0")
>> >>> echo "Sorry no products were found";
>> >>> else
>> >>> echo "Please click on a product for further information."
>> >>> ?>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>> >>> $row_rsSearch['product_subtitle'];
>> >>> ?>
>> >>>View Product
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>> --
>> >>> - Gary Maddock-Greene
>> >>> "Ashley Sheridan" wrote in message
>> >>> news:1229873521.4229.6.ca...@localhost.localdomain..
Re: [PHP] eof bof in php
That's got it thanks Anthony. I love when you learn something. It was the
back slash \ preceeding the "'s in my html that I wasn't aware of. Now I
know they are needed if using "" in your code.
Thank you so much for your help.
--
- Gary Maddock-Greene
""Anthony Gentile"" wrote in message
news:2ce4207d0812211021g215d5346wb0afcedf039ef...@mail.gmail.com...
Sorry no products were found";
} else {
echo "Please click on a product for further information.";
while ($row_rsSearch = mysql_fetch_assoc($rsSearch)){
echo "
". $row_rsSearch['product_name']."
". $row_rsSearch['product_subtitle'] ."
";
}
}
?>
is probably going to give you the result you want. However you should know
it is bad practice to mix PHP and HTML as horridly as I just showed you.
AKA
you don't want your PHP writing your HTML.
Anthony Gentile
On Sun, Dec 21, 2008 at 1:07 PM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
I've corrected those errors thanks but how do I insert this code as the
else statement?
$row_rsSearch['product_subtitle'];
?>
View Product
--
- Gary Maddock-Greene
""Anthony Gentile"" wrote in message
news:2ce4207d0812210959k3491690ctbc4f0dbf971ac...@mail.gmail.com...
...missing semicolon and some brackets.
Sorry no products were found";
} else {
echo "Please click on a product for further information.";
}
?>
If there is more code you can show by perhaps pasting here:
http://pastebin.redlinktech.com
We can help with further syntax problems.
Anthony Gentile
On Sun, Dec 21, 2008 at 12:33 PM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
Thanks guys .. I can get this part working great ..
Sorry no products were found";
} else
echo "Please click on a product for further information."
?>
But I want to add the following so that only the products table appears
when product are present. I cannot seem to add this code into the above
after the echo "Please click on a product for further
information.". I can't get the syntax right ...
I appreciate everyones help
--
- Gary Maddock-Greene
"Ashley Sheridan" wrote in message
news:1229878234.4229.12.ca...@localhost.localdomain...
On Sun, 2008-12-21 at 11:39 -0500, Anthony Gentile wrote:
if (0 == $totalRows_rsSearch) {
echo "Sorry no products were found";
} else
Anthony Gentile
On Sun, Dec 21, 2008 at 11:22 AM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
> I have tried that but to no avail :)
>
> if ($totalRows_rsSearch=0)
> echo "Sorry no products were found";
> else
>
>
> // All seems OK to here, then the syntax error unexpected
> T_VARIABLE
> appears
>
>
> echo Please click on a product for further information.
>
>
>
>
>
>
$row_rsSearch['product_subtitle'];
> ?>
>
> ?>">View Product
>
>
>
>
>
>
>
> --
> - Gary Maddock-Greene
> "Ashley Sheridan" wrote in message
> news:1229875150.4229.9.ca...@localhost.localdomain...
>
> On Sun, 2008-12-21 at 15:40 +, Gary Maddock-Greene wrote:
>>
>>> Thanks Ashley ... I have been trying that but I think my syntax
>>> id
>>> shot!!
>>>
>>> >> if ($totalRows_rsSearch="0")
>>> echo "Sorry no products were found";
>>> else
>>> echo "Please click on a product for further
>>> information."
>>> ?>
>>>
>>>
>>>
>>>
>>>
>>>>> $row_rsSearch['product_subtitle'];
>>> ?>
>>>View Product
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> - Gary Maddock-Greene
>>> "Ashley Sheridan" wrote in message
>>> news:1229873521.4229.6.ca...@localhost.localdomain...
>>> > On Sun, 2008-12-21 at 15:22 +, Gary Maddock-Greene wrote:
>>> >> Hi, I'm very new to php. Please can someone point me in the
>>> >> >>>
>> right
>>> >> direction?
>>> >> I want to display a message: 'No Products Found' if my search
>>> >> >>>
>> record
>>> >> set
>>> >> returns no value.
>>> >>
>>> >> I think I need to be looking at this section of my code ...
>>> >>
>>> >> $query_rsSearch = sprintf("SELECT * FROM products WHERE >>> >>
product_name
>>> >> LIKE
>>> >> %s", GetSQLValueString("%" . $colname_rsSearch . "%",
>>> >> "text"));
>>> >> $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
>>> >> die(mysql_error());
>>> >> $row_rsSearch = mysql_fetch_assoc($rsSearch);
>>> >> $totalRows_rsSearch = mysql_num_rows($rsSearch);
>>> >> ?>
>>> >>
>>> >> Thanks
>>> >>
>>> >> - Gary Maddock-Greene
>>> >>
>>> >>
>>> > Can you not just use the $totalRows_rsSearch value inside of an
>>> > if
>>> > statement?
>>> >
>>> >
>>> > Ash
>>> > www.ashleysheridan.co.uk
>>> >
>>>
>>>
>>> It might be because you're comparing the total to a string
>>> rather
>>> than a
>> number if ($totalRows_rsSearch="0")
>>
>> If you remove the quote marks, it should work.
>>
>>
>
Re: [PHP] eof bof in php
thanks for the advice re html and php mashup!! I will research to find the
way to do it outside the php.
- Gary Maddock-Greene
""Anthony Gentile"" wrote in message
news:2ce4207d0812211021g215d5346wb0afcedf039ef...@mail.gmail.com...
Sorry no products were found";
} else {
echo "Please click on a product for further information.";
while ($row_rsSearch = mysql_fetch_assoc($rsSearch)){
echo "
". $row_rsSearch['product_name']."
". $row_rsSearch['product_subtitle'] ."
";
}
}
?>
is probably going to give you the result you want. However you should know
it is bad practice to mix PHP and HTML as horridly as I just showed you.
AKA
you don't want your PHP writing your HTML.
Anthony Gentile
On Sun, Dec 21, 2008 at 1:07 PM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
I've corrected those errors thanks but how do I insert this code as the
else statement?
$row_rsSearch['product_subtitle'];
?>
View Product
--
- Gary Maddock-Greene
""Anthony Gentile"" wrote in message
news:2ce4207d0812210959k3491690ctbc4f0dbf971ac...@mail.gmail.com...
...missing semicolon and some brackets.
Sorry no products were found";
} else {
echo "Please click on a product for further information.";
}
?>
If there is more code you can show by perhaps pasting here:
http://pastebin.redlinktech.com
We can help with further syntax problems.
Anthony Gentile
On Sun, Dec 21, 2008 at 12:33 PM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
Thanks guys .. I can get this part working great ..
Sorry no products were found";
} else
echo "Please click on a product for further information."
?>
But I want to add the following so that only the products table appears
when product are present. I cannot seem to add this code into the above
after the echo "Please click on a product for further
information.". I can't get the syntax right ...
I appreciate everyones help
--
- Gary Maddock-Greene
"Ashley Sheridan" wrote in message
news:1229878234.4229.12.ca...@localhost.localdomain...
On Sun, 2008-12-21 at 11:39 -0500, Anthony Gentile wrote:
if (0 == $totalRows_rsSearch) {
echo "Sorry no products were found";
} else
Anthony Gentile
On Sun, Dec 21, 2008 at 11:22 AM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
> I have tried that but to no avail :)
>
> if ($totalRows_rsSearch=0)
> echo "Sorry no products were found";
> else
>
>
> // All seems OK to here, then the syntax error unexpected
> T_VARIABLE
> appears
>
>
> echo Please click on a product for further information.
>
>
>
>
>
>
$row_rsSearch['product_subtitle'];
> ?>
>
> ?>">View Product
>
>
>
>
>
>
>
> --
> - Gary Maddock-Greene
> "Ashley Sheridan" wrote in message
> news:1229875150.4229.9.ca...@localhost.localdomain...
>
> On Sun, 2008-12-21 at 15:40 +, Gary Maddock-Greene wrote:
>>
>>> Thanks Ashley ... I have been trying that but I think my syntax
>>> id
>>> shot!!
>>>
>>> >> if ($totalRows_rsSearch="0")
>>> echo "Sorry no products were found";
>>> else
>>> echo "Please click on a product for further
>>> information."
>>> ?>
>>>
>>>
>>>
>>>
>>>
>>>>> $row_rsSearch['product_subtitle'];
>>> ?>
>>>View Product
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> - Gary Maddock-Greene
>>> "Ashley Sheridan" wrote in message
>>> news:1229873521.4229.6.ca...@localhost.localdomain...
>>> > On Sun, 2008-12-21 at 15:22 +, Gary Maddock-Greene wrote:
>>> >> Hi, I'm very new to php. Please can someone point me in the
>>> >> >>>
>> right
>>> >> direction?
>>> >> I want to display a message: 'No Products Found' if my search
>>> >> >>>
>> record
>>> >> set
>>> >> returns no value.
>>> >>
>>> >> I think I need to be looking at this section of my code ...
>>> >>
>>> >> $query_rsSearch = sprintf("SELECT * FROM products WHERE >>> >>
product_name
>>> >> LIKE
>>> >> %s", GetSQLValueString("%" . $colname_rsSearch . "%",
>>> >> "text"));
>>> >> $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
>>> >> die(mysql_error());
>>> >> $row_rsSearch = mysql_fetch_assoc($rsSearch);
>>> >> $totalRows_rsSearch = mysql_num_rows($rsSearch);
>>> >> ?>
>>> >>
>>> >> Thanks
>>> >>
>>> >> - Gary Maddock-Greene
>>> >>
>>> >>
>>> > Can you not just use the $totalRows_rsSearch value inside of an
>>> > if
>>> > statement?
>>> >
>>> >
>>> > Ash
>>> > www.ashleysheridan.co.uk
>>> >
>>>
>>>
>>> It might be because you're comparing the total to a string
>>> rather
>>> than a
>> number if ($totalRows_rsSearch="0")
>>
>> If you remove the quote marks, it should work.
>>
>>
>> Ash
>> www.ashleysheridan.co.uk
>>
>>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://
[PHP] Re: Create PHP form from MySQL table structure
R B MacGregor wrote: Hi folks Anybody got any recommendations for a utility which would create a quick head start by creating the php/html code for a basic form using the field structure of a MySQL table ? Thanks for any suggestions. Look at Pear HTML_QuickForm and other HTML classes. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] eof bof in php
I guess you are right about mixing php with html. Actually the suggestion
you gave breaks my search function. If I now search for a product called
'type 22' the space and first digit 2 breaks the serach. Also the \" in the
htnl / php is causing a break in the image path urls ... so back to the
drawing board for me :)
--
- Gary Maddock-Greene
""Gary Maddock-Greene"" wrote in message
news:b4.82.23981.dee8e...@pb1.pair.com...
thanks for the advice re html and php mashup!! I will research to find the
way to do it outside the php.
- Gary Maddock-Greene
""Anthony Gentile"" wrote in message
news:2ce4207d0812211021g215d5346wb0afcedf039ef...@mail.gmail.com...
Sorry no products were found";
} else {
echo "Please click on a product for further information.";
while ($row_rsSearch = mysql_fetch_assoc($rsSearch)){
echo "
". $row_rsSearch['product_name']."
". $row_rsSearch['product_subtitle'] ."
";
}
}
?>
is probably going to give you the result you want. However you should
know
it is bad practice to mix PHP and HTML as horridly as I just showed you.
AKA
you don't want your PHP writing your HTML.
Anthony Gentile
On Sun, Dec 21, 2008 at 1:07 PM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
I've corrected those errors thanks but how do I insert this code as the
else statement?
$row_rsSearch['product_subtitle'];
?>
View Product
--
- Gary Maddock-Greene
""Anthony Gentile"" wrote in message
news:2ce4207d0812210959k3491690ctbc4f0dbf971ac...@mail.gmail.com...
...missing semicolon and some brackets.
Sorry no products were found";
} else {
echo "Please click on a product for further information.";
}
?>
If there is more code you can show by perhaps pasting here:
http://pastebin.redlinktech.com
We can help with further syntax problems.
Anthony Gentile
On Sun, Dec 21, 2008 at 12:33 PM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
Thanks guys .. I can get this part working great ..
Sorry no products were found";
} else
echo "Please click on a product for further information."
?>
But I want to add the following so that only the products table
appears
when product are present. I cannot seem to add this code into the
above
after the echo "Please click on a product for further
information.". I can't get the syntax right ...
I appreciate everyones help
--
- Gary Maddock-Greene
"Ashley Sheridan" wrote in message
news:1229878234.4229.12.ca...@localhost.localdomain...
On Sun, 2008-12-21 at 11:39 -0500, Anthony Gentile wrote:
if (0 == $totalRows_rsSearch) {
echo "Sorry no products were found";
} else
Anthony Gentile
On Sun, Dec 21, 2008 at 11:22 AM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
> I have tried that but to no avail :)
>
> if ($totalRows_rsSearch=0)
> echo "Sorry no products were found";
> else
>
>
> // All seems OK to here, then the syntax error unexpected
> T_VARIABLE
> appears
>
>
> echo Please click on a product for further information.
>
>
>
>
>
>
$row_rsSearch['product_subtitle'];
> ?>
>
> ?>">View Product
>
>
>
>
>
>
>
> --
> - Gary Maddock-Greene
> "Ashley Sheridan" wrote in message
> news:1229875150.4229.9.ca...@localhost.localdomain...
>
> On Sun, 2008-12-21 at 15:40 +, Gary Maddock-Greene wrote:
>>
>>> Thanks Ashley ... I have been trying that but I think my syntax
>>> id
>>> shot!!
>>>
>>> >> if ($totalRows_rsSearch="0")
>>> echo "Sorry no products were found";
>>> else
>>> echo "Please click on a product for further
>>> information."
>>> ?>
>>>
>>>
>>>
>>>
>>>
>>>>> $row_rsSearch['product_subtitle'];
>>> ?>
>>>View Product
>>>
>>>
>>>
>>>
>>>
>>> >>> ?>
>>>
>>> --
>>> - Gary Maddock-Greene
>>> "Ashley Sheridan" wrote in message
>>> news:1229873521.4229.6.ca...@localhost.localdomain...
>>> > On Sun, 2008-12-21 at 15:22 +, Gary Maddock-Greene wrote:
>>> >> Hi, I'm very new to php. Please can someone point me in the
>>> >> >>>
>> right
>>> >> direction?
>>> >> I want to display a message: 'No Products Found' if my search
>>> >> >>>
>> record
>>> >> set
>>> >> returns no value.
>>> >>
>>> >> I think I need to be looking at this section of my code ...
>>> >>
>>> >> $query_rsSearch = sprintf("SELECT * FROM products WHERE >>>
>>> >> >>
product_name
>>> >> LIKE
>>> >> %s", GetSQLValueString("%" . $colname_rsSearch . "%",
>>> >> "text"));
>>> >> $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
>>> >> die(mysql_error());
>>> >> $row_rsSearch = mysql_fetch_assoc($rsSearch);
>>> >> $totalRows_rsSearch = mysql_num_rows($rsSearch);
>>> >> ?>
>>> >>
>>> >> Thanks
>>> >>
>>> >> - Gary Maddock-Greene
>>> >>
>>> >>
>>> > Can you not just
Re: [PHP] eof bof in php
I guess you are right about mixing php with html. Actually the suggestion
you gave breaks my search function. If I now search for a product called
'type 22' the space and first digit 2 breaks the serach. Also the \" in the
htnl / php is causing a break in the image path urls ... so back to the
drawing board for me :)
--
- Gary Maddock-Greene
""Gary Maddock-Greene"" wrote in message
news:b4.82.23981.dee8e...@pb1.pair.com...
thanks for the advice re html and php mashup!! I will research to find the
way to do it outside the php.
- Gary Maddock-Greene
""Anthony Gentile"" wrote in message
news:2ce4207d0812211021g215d5346wb0afcedf039ef...@mail.gmail.com...
Sorry no products were found";
} else {
echo "Please click on a product for further information.";
while ($row_rsSearch = mysql_fetch_assoc($rsSearch)){
echo "
". $row_rsSearch['product_name']."
". $row_rsSearch['product_subtitle'] ."
";
}
}
?>
is probably going to give you the result you want. However you should
know
it is bad practice to mix PHP and HTML as horridly as I just showed you.
AKA
you don't want your PHP writing your HTML.
Anthony Gentile
On Sun, Dec 21, 2008 at 1:07 PM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
I've corrected those errors thanks but how do I insert this code as the
else statement?
View Product
--
- Gary Maddock-Greene
""Anthony Gentile"" wrote in message
news:2ce4207d0812210959k3491690ctbc4f0dbf971ac...@mail.gmail.com...
...missing semicolon and some brackets.
Sorry no products were found";
} else {
echo "Please click on a product for further information.";
}
?>
If there is more code you can show by perhaps pasting here:
http://pastebin.redlinktech.com
We can help with further syntax problems.
Anthony Gentile
On Sun, Dec 21, 2008 at 12:33 PM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
Thanks guys .. I can get this part working great ..
Sorry no products were found";
} else
echo "Please click on a product for further information."
?>
But I want to add the following so that only the products table
appears
when product are present. I cannot seem to add this code into the
above
after the echo "Please click on a product for further
information.". I can't get the syntax right ...
I appreciate everyones help
--
- Gary Maddock-Greene
"Ashley Sheridan" wrote in message
news:1229878234.4229.12.ca...@localhost.localdomain...
On Sun, 2008-12-21 at 11:39 -0500, Anthony Gentile wrote:
if (0 == $totalRows_rsSearch) {
echo "Sorry no products were found";
} else
Anthony Gentile
On Sun, Dec 21, 2008 at 11:22 AM, Gary Maddock-Greene <
g...@maddock-greene.co.uk> wrote:
> I have tried that but to no avail :)
>
> if ($totalRows_rsSearch=0)
> echo "Sorry no products were found";
> else
>
>
> // All seems OK to here, then the syntax error unexpected
> T_VARIABLE
> appears
>
>
> echo Please click on a product for further information.
>
>
>
>
>
>
$row_rsSearch['product_subtitle'];
> ?>
>View Product
>
>
>
>
>
>
>
> --
> - Gary Maddock-Greene
> "Ashley Sheridan" wrote in message
> news:1229875150.4229.9.ca...@localhost.localdomain...
>
> On Sun, 2008-12-21 at 15:40 +, Gary Maddock-Greene wrote:
>>
>>> Thanks Ashley ... I have been trying that but I think my syntax
>>> id
>>> shot!!
>>>
>>> >> if ($totalRows_rsSearch="0")
>>> echo "Sorry no products were found";
>>> else
>>> echo "Please click on a product for further
>>> information."
>>> ?>
>>>
>>>
>>>
>>>
>>>
>>>>> $row_rsSearch['product_subtitle'];
>>> ?>
>>>View Product
>>>
>>>
>>>
>>>
>>>
>>> >> ?>
>>>
>>> --
>>> - Gary Maddock-Greene
>>> "Ashley Sheridan" wrote in message
>>> news:1229873521.4229.6.ca...@localhost.localdomain...
>>> > On Sun, 2008-12-21 at 15:22 +, Gary Maddock-Greene wrote:
>>> >> Hi, I'm very new to php. Please can someone point me in the
>>> >> >>>
>> right
>>> >> direction?
>>> >> I want to display a message: 'No Products Found' if my search
>>> >> >>>
>> record
>>> >> set
>>> >> returns no value.
>>> >>
>>> >> I think I need to be looking at this section of my code ...
>>> >>
>>> >> $query_rsSearch = sprintf("SELECT * FROM products WHERE >>>
>>> >> >>
product_name
>>> >> LIKE
>>> >> %s", GetSQLValueString("%" . $colname_rsSearch . "%",
>>> >> "text"));
>>> >> $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
>>> >> die(mysql_error());
>>> >> $row_rsSearch = mysql_fetch_assoc($rsSearch);
>>> >> $totalRows_rsSearch = mysql_num_rows($rsSearch);
>>> >> ?>
>>> >>
>>> >> Thanks
>>> >>
>>> >> - Gary Maddock-Greene
>>> >>
>>> >>
>>> > Can you not just use the $totalRows_rsSearch value inside of
>>> > an
>>> > if
>>> > sta
[PHP] Variable as an index
Hello, I am trying to output the value of the following:($x is an int incremented by a for statement. echo " '$users[$x][U]' "; I have tried putting the quotes all over and all I get is: 'Array[U]'. What am I doing wrong. Thanks Mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Variable as an index
MikeP schrieb: I have tried putting the quotes all over and all I get is: 'Array[U]'. Try to avoid accessing the two-dimensional array $users inside a string. Use echo's ability to accept multiple parameters: echo '', $users[$x]['U'], ''; Or by concating the string with the .-Operator: echo ''.$users[$x]['U'].''; The first method is faster and needs less memory. -- http://bithub.net/ Synchronize and share your files over the web for free -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Variable as an index
$users is an array and you are trying to simply put it in a string. $x seems to be undefined ergo it's not printing anything. If 'U' is the index in the array for your variable, use the '.' operator to concatenate strings: echo " '" . $users[$x]['U'] ."' "; Tim-Hinnerk Heuer http://www.ihostnz.com On Mon, Dec 22, 2008 at 10:44 AM, MikeP wrote: > Hello, > I am trying to output the value of the following:($x is an int incremented > by a for statement. >echo " > > '$users[$x][U]' >"; > > I have tried putting the quotes all over and all I get is: > 'Array[U]'. > > What am I doing wrong. > Thanks > Mike > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >
Re: [PHP] Variable as an index
OK. I would think it uses more memory then, but doubt it would be slower. Isnt the output buffered in memory anyway though in PHP? Surely the buffer is bigger than 100 bytes (which is about the length of this string). So one way or the other, the memory is used. Tim-Hinnerk Heuer http://www.ihostnz.com On Mon, Dec 22, 2008 at 11:12 AM, Marc Steinert wrote: > German Geek schrieb: > >> Why is the first method faster and uses less memory? >> >> >> > Because the concatenation operator first reassembles a new string, stores > it in memory then passes this newly created string to the echo function, if > I'm not misstaken. > > > -- > http://bithub.net/ > Synchronize and share your files over the web for free > >
Re: [PHP] Variable as an index
Why is the first method faster and uses less memory? Tim-Hinnerk Heuer http://www.ihostnz.com On Mon, Dec 22, 2008 at 10:59 AM, Marc Steinert wrote: > MikeP schrieb: > >> I have tried putting the quotes all over and all I get is: >> 'Array[U]'. >> >> >> > Try to avoid accessing the two-dimensional array $users inside a string. > Use echo's ability to accept multiple parameters: > > echo '', $users[$x]['U'], ''; > > Or by concating the string with the .-Operator: > > echo ''.$users[$x]['U'].''; > > The first method is faster and needs less memory. > > -- > http://bithub.net/ > Synchronize and share your files over the web for free > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >
Re: [PHP] Variable as an index
German Geek schrieb: Why is the first method faster and uses less memory? Because the concatenation operator first reassembles a new string, stores it in memory then passes this newly created string to the echo function, if I'm not misstaken. -- http://bithub.net/ Synchronize and share your files over the web for free -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Variable as an index
for e.g. $var = 'world'; echo "hello $var"; vs echo 'hello '.$var; The first uses twice as many opcodes as compared to the second. The first is init a string and adding to it the first part(string) and then the second part (var); once completed it can echo it out. The second is simply two opcodes, a concatenate and an echo. Interpolation. Anthony Gentile On Sun, Dec 21, 2008 at 5:47 PM, German Geek wrote: > OK. I would think it uses more memory then, but doubt it would be slower. > Isnt the output buffered in memory anyway though in PHP? Surely the buffer > is bigger than 100 bytes (which is about the length of this string). So one > way or the other, the memory is used. > > Tim-Hinnerk Heuer > > http://www.ihostnz.com > > > On Mon, Dec 22, 2008 at 11:12 AM, Marc Steinert wrote: > > > German Geek schrieb: > > > >> Why is the first method faster and uses less memory? > >> > >> > >> > > Because the concatenation operator first reassembles a new string, stores > > it in memory then passes this newly created string to the echo function, > if > > I'm not misstaken. > > > > > > -- > > http://bithub.net/ > > Synchronize and share your files over the web for free > > > > >
Re: [PHP] Replacing special characters with their HTML equivalents
On Sun, Dec 21, 2008 at 18:30, James Colannino wrote: > Hey everyone. I have a question. I have a web scraper that grabs > information from web pages that often contain characters such as vowels > with umlots (I know I spelled that wrong.) Welcome to the list, James. Check out htmlentities(): http://php.net/htmlentities -- daniel.br...@parasane.net || danbr...@php.net http://www.parasane.net/ || http://www.pilotpig.net/ Unadvertised dedicated server deals, too low to print - email me to find out! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Variable as an index
True, it might mean the very slightest in milliseconds...depending on what you're doing/hardware. However, no harm in understanding the difference/how it works. Many will code echo "Hello World" and echo 'Hello World'; and never know the difference, I just happen to think being aware of the details will help for the long term programmer. Since, I brought it up, I'll go ahead and give another example. Ternaries that make a lot of people feel awesome because a lot is being accomplished in one line are also more opcodes than their if-else statement equivalents...and often times can be more confusing to future maintainers of the code. Anthony Gentile On Sun, Dec 21, 2008 at 6:20 PM, Chris wrote: > Anthony Gentile wrote: > >> for e.g. >> $var = 'world'; >> echo "hello $var"; >> vs >> echo 'hello '.$var; >> >> The first uses twice as many opcodes as compared to the second. The first >> is >> init a string and adding to it the first part(string) and then the second >> part (var); once completed it can echo it out. The second is simply two >> opcodes, a concatenate and an echo. Interpolation. >> > > I'd call this a micro-optimization. If changing this causes that much of a > difference in your script, wow - you're way ahead of the rest of us. > > > http://blog.libssh2.org/index.php?/archives/28-How-long-is-a-piece-of-string.html > > http://www.phpbench.com/ > > -- > Postgresql & php tutorials > http://www.designmagick.com/ > >
[PHP] Replacing special characters with their HTML equivalents
Hey everyone. I have a question. I have a web scraper that grabs information from web pages that often contain characters such as vowels with umlots (I know I spelled that wrong.) The data is editable, so the characters show up unmodified in an editable text box. However, when I try to import the data into a MySQL database, the first occurrence of such a character, along with the rest of the string, is truncated from the result. Not all special characters cause the problem; vowels with macrons work, for example. I don't know if it's failing during the actual query or if the character is being filtered out at some earlier stage, but whatever the cause, it's not working. My question is, is there a way to replace these characters with their HTML equivalents? For example, the a with an umlot over the top is ä in HTML, so before the query is made, and before the filtering on the string is done, I'd like to replace that special character with its HTML representation. This allows the user to see the character while it's in its text box, yet at the same time allow it to be successfully imported into the database. I know about str_replace, but assuming it's the right function for the job, how would I go about representing these special characters in PHP so that it will understand what I'm trying to do? Thanks! James -- "Black holes are where God divided by zero." --Steven Wright signature.asc Description: OpenPGP digital signature
Re: [PHP] Variable as an index
Anthony Gentile wrote: True, it might mean the very slightest in milliseconds...depending on what you're doing/hardware. Connecting to a db will (probably) take longer than most of those differences, let alone running a query & processing the results. Ternaries that make a lot of people feel awesome because a lot is being accomplished in one line are also more opcodes than their if-else statement equivalents...and often times can be more confusing to future maintainers of the code. I dislike ternaries for their over-use - I've seen nested ternaries and it's taken me 10 mins to read the code.. *shudder*. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Replacing special characters with their HTML equivalents
Daniel Brown wrote: > Welcome to the list, James. Thanks :) > Check out htmlentities(): http://php.net/htmlentities I'll check that out. James -- "Black holes are where God divided by zero." --Steven Wright signature.asc Description: OpenPGP digital signature
Re: [PHP] Variable as an index
Anthony Gentile wrote: for e.g. $var = 'world'; echo "hello $var"; vs echo 'hello '.$var; The first uses twice as many opcodes as compared to the second. The first is init a string and adding to it the first part(string) and then the second part (var); once completed it can echo it out. The second is simply two opcodes, a concatenate and an echo. Interpolation. I'd call this a micro-optimization. If changing this causes that much of a difference in your script, wow - you're way ahead of the rest of us. http://blog.libssh2.org/index.php?/archives/28-How-long-is-a-piece-of-string.html http://www.phpbench.com/ -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Variable as an index
Yes, i agree with this. Even if it takes a few nano seconds more to write out more understandable code, it's worth doing it because code management is more important than sqeezing out the last nano second. And then also an $var = "Hello"; echo "$val World"; has less characters than and is more readable than $var = "Hello"; echo $var ." World"; So it would take maybe a few nano seconds less to read it from the hard drive. And we all know that disk I/O is more expensive than pushing around variables in main memory in terms of time. And RAM is soo cheap these days. Tim-Hinnerk Heuer http://www.ihostnz.com On Mon, Dec 22, 2008 at 12:50 PM, Anthony Gentile wrote: > True, it might mean the very slightest in milliseconds...depending on what > you're doing/hardware. However, no harm in understanding the difference/how > it works. > Many will code echo "Hello World" and echo 'Hello World'; and never know > the > difference, I just happen to think being aware of the details will help for > the long term programmer. > Since, I brought it up, I'll go ahead and give another example. Ternaries > that make a lot of people feel awesome because a lot is being accomplished > in one line are also more opcodes than their if-else statement > equivalents...and often times can be more confusing to future maintainers > of > the code. > > Anthony Gentile > > > > On Sun, Dec 21, 2008 at 6:20 PM, Chris wrote: > > > Anthony Gentile wrote: > > > >> for e.g. > >> $var = 'world'; > >> echo "hello $var"; > >> vs > >> echo 'hello '.$var; > >> > >> The first uses twice as many opcodes as compared to the second. The > first > >> is > >> init a string and adding to it the first part(string) and then the > second > >> part (var); once completed it can echo it out. The second is simply two > >> opcodes, a concatenate and an echo. Interpolation. > >> > > > > I'd call this a micro-optimization. If changing this causes that much of > a > > difference in your script, wow - you're way ahead of the rest of us. > > > > > > > http://blog.libssh2.org/index.php?/archives/28-How-long-is-a-piece-of-string.html > > > > http://www.phpbench.com/ > > > > -- > > Postgresql & php tutorials > > http://www.designmagick.com/ > > > > >
Re: [PHP] Replacing special characters with their HTML equivalents
On Sunday 21 December 2008 5:30:25 pm James Colannino wrote: > Hey everyone. I have a question. I have a web scraper that grabs > information from web pages that often contain characters such as vowels > with umlots (I know I spelled that wrong.) > > The data is editable, so the characters show up unmodified in an > editable text box. However, when I try to import the data into a MySQL > database, the first occurrence of such a character, along with the rest > of the string, is truncated from the result. Not all special characters > cause the problem; vowels with macrons work, for example. > > I don't know if it's failing during the actual query or if the character > is being filtered out at some earlier stage, but whatever the cause, > it's not working. > > My question is, is there a way to replace these characters with their > HTML equivalents? For example, the a with an umlot over the top is > ä in HTML, so before the query is made, and before the filtering on > the string is done, I'd like to replace that special character with its > HTML representation. This allows the user to see the character while > it's in its text box, yet at the same time allow it to be successfully > imported into the database. > > I know about str_replace, but assuming it's the right function for the > job, how would I go about representing these special characters in PHP > so that it will understand what I'm trying to do? > > Thanks! > > James You may find this useful: http://www.garfieldtech.com/blog/unicode-8-vs-16 -- Larry Garfield la...@garfieldtech.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Variable as an index
2008/12/21 German Geek :
> Yes, i agree with this. Even if it takes a few nano seconds more to write
> out more understandable code, it's worth doing it because code management is
> more important than sqeezing out the last nano second. And then also an
> $var = "Hello";
> echo "$val World";
>
> has less characters than and is more readable than
>
> $var = "Hello";
> echo $var ." World";
>
> So it would take maybe a few nano seconds less to read it from the hard
> drive. And we all know that disk I/O is more expensive than pushing around
> variables in main memory in terms of time. And RAM is soo cheap these days.
>
> Tim-Hinnerk Heuer
>
> http://www.ihostnz.com
Agreed. Although I tend to use ' instead of " unless I need
interpolation, if I feel it's really going to make that much of a
difference then I start looking at rewriting that section in C or
refactoring. String interpolation shouldn't be a bottleneck.
Getting back to the original question though, the correct way to
express a multidimensional array access inside a string is to use
curly braces, and include quotes around any string index names:
echo "An array: {$arr[$foo]['bar']}\n";
Torben
> On Mon, Dec 22, 2008 at 12:50 PM, Anthony Gentile wrote:
>
>> True, it might mean the very slightest in milliseconds...depending on what
>> you're doing/hardware. However, no harm in understanding the difference/how
>> it works.
>> Many will code echo "Hello World" and echo 'Hello World'; and never know
>> the
>> difference, I just happen to think being aware of the details will help for
>> the long term programmer.
>> Since, I brought it up, I'll go ahead and give another example. Ternaries
>> that make a lot of people feel awesome because a lot is being accomplished
>> in one line are also more opcodes than their if-else statement
>> equivalents...and often times can be more confusing to future maintainers
>> of
>> the code.
>>
>> Anthony Gentile
>>
>>
>>
>> On Sun, Dec 21, 2008 at 6:20 PM, Chris wrote:
>>
>> > Anthony Gentile wrote:
>> >
>> >> for e.g.
>> >> $var = 'world';
>> >> echo "hello $var";
>> >> vs
>> >> echo 'hello '.$var;
>> >>
>> >> The first uses twice as many opcodes as compared to the second. The
>> first
>> >> is
>> >> init a string and adding to it the first part(string) and then the
>> second
>> >> part (var); once completed it can echo it out. The second is simply two
>> >> opcodes, a concatenate and an echo. Interpolation.
>> >>
>> >
>> > I'd call this a micro-optimization. If changing this causes that much of
>> a
>> > difference in your script, wow - you're way ahead of the rest of us.
>> >
>> >
>> >
>> http://blog.libssh2.org/index.php?/archives/28-How-long-is-a-piece-of-string.html
>> >
>> > http://www.phpbench.com/
>> >
>> > --
>> > Postgresql & php tutorials
>> > http://www.designmagick.com/
>> >
>> >
>>
>
--
Torben Wilson
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
