php-general Digest 31 Aug 2011 11:39:27 - Issue 7463
Topics (messages 314663 through 314668):
Re: Code should be selv-maintaining!
314663 by: Jason Pruim
314664 by: Matt Graham
scroll down list -visible, but not possible to choose
314665 by: robert.myself.com
Hi,
Got so excellent and fast help last time so trying again here
I have the below function with array for satus of issues where I need to have
'Resolved/Closed' visible but not available for choice
This as closing is a separate function to ensure correct resolution code is
selected
Is it possible to get the actual sql that is being used to query or
update the database?
E.g
$sth = $dbh-prepare (update table set field=?, field2=? where id=?);
mysqli_bind_param ($sth, 'ssi', 'text1', 'text2', 10);
$sth-execute();
Something like $sth-sql? Or $dbh-sql?
I want to see update
Date: Wed, 31 Aug 2011 04:30:56 -0400
From: rob...@myself.com
To: php-general@lists.php.net
Subject: [PHP] scroll down list -visible, but not possible to choose
Hi,
Got so excellent and fast help last time so trying again here
I have the below function with array for satus of issues
On 31.08.2011 11:23, Peet Grobler wrote:
Is it possible to get the actual sql that is being used to query or
update the database?
E.g
$sth = $dbh-prepare (update table set field=?, field2=? where id=?);
mysqli_bind_param ($sth, 'ssi', 'text1', 'text2', 10);
$sth-execute();
Something like
On 08/31/2011 05:23 AM, Peet Grobler wrote:
Is it possible to get the actual sql that is being used to query or
update the database?
E.g
$sth = $dbh-prepare (update table set field=?, field2=? where id=?);
mysqli_bind_param ($sth, 'ssi', 'text1', 'text2', 10);
$sth-execute();
Something
Am 30.08.2011 12:11, schrieb Per Jessen:
Merlin Morgenstern wrote:
Hi there,
I am having some trouble with utf8_decode(). Somehow the function
returns output=input
e.g.:
$input = '%20%C3%9Cbersetzung%20franz';
$output = utf8_decode($input);
echo $input.'br'.$output;
My goal is to decode the
Hi there,
I do have a search form on my site which posts search queries to
follogin URL:
/subapp_search/search.php
Depending on the search parameters it will then redirect to the
appropriate URL. e.g.: /suche/labrador
I now discovered in google webmastertools that this very page
On 8/31/2011 1:38 PM, John Black wrote:
Hi Peet,
not sure if there is a method to echo the sql but you can set your
development MySQL server to log all queries to a log file.
Use the log file with tail and you'll get a live view of all queries the
server attempts to process.
I already
Genius!
-Original Message-
From: Matt Graham [mailto:danceswithcr...@usa.net]
Sent: Tuesday, August 30, 2011 5:59 PM
To: php-general@lists.php.net
Subject: Re: [PHP] Code should be selv-maintaining!
From: David Harkness davi...@highgearmedia.com
I don't always use braces, but when I
Peet,
Could you do something like this instead? This is using named placeholders
and a separate line for your statement
but I was able to get it to echo the statement in this manner.
$sql = UPDATE table SET field1=:field1, field2=:field2 WHERE id=:id;
$sth = $dbh-prepare($sql);
Merlin,
Do you have a robots.txt file in your root folder?
A text document named robots.txt in your document root containing the
following text
should solve your problem.
# robots.txt for http://www.yourdomain.com/
User-agent: *
Disallow: /subapp_search/search.php
User-Agent: Googlebot
Hi,
I have opend Bug #51739 in 2010. It was closed as bogus before my last
question was answered. It would be fine to know what you think about that
bug.
In short:
var_dump((float)8315e839da08e2a7afe6dd12ec58245d);
results in float(INF)
This is because 8315 is treated as base and
Jen Rasmussen j...@cetaceasound.com writes:
Peet,
Could you do something like this instead? This is using named placeholders
and a separate line for your statement
but I was able to get it to echo the statement in this manner.
$sql = UPDATE table SET field1=:field1, field2=:field2 WHERE
Hi there Richard
It's part of the prepared statements
http://php.net/manual/de/pdo.prepared-statements.php
;)
2011/8/31 Richard Riley rile...@googlemail.com
Jen Rasmussen j...@cetaceasound.com writes:
Peet,
Could you do something like this instead? This is using named
placeholders
Original Message
From: Louis Huppenbauer louis.huppenba...@gmail.com
To: php-general@lists.php.net
Sent: Wed, Aug 31, 2011, 10:24 AM
Subject: Re: [PHP] Re: mysqli sql question
Hi there Richard
It's part of the prepared statements
http://php.net/manual/de/pdo.prepared-statements.php
;)
Peet,
Here is the PHP PDO link: http://php.net/manual/en/book.pdo.php
If you look on example #2 on this page:
http://www.php.net/manual/en/pdostatement.execute.php
That is pretty much how it's setup (although the example I gave is update,
this is select).
And please correct me I said the
You want:
if($status == $selected) echo selected = ' selected' ;
(I didn't bother with \s)
And BTW, unless the support person is actually sitting on top of the
customer (and I can see situations where that would help), you want it
to say Waiting *for* Customer
Ken
On Wed, Aug 31, 2011 at
On 08/31/2011 09:03 AM, magic-...@damage.devloop.de wrote:
Hi,
I have opend Bug #51739 in 2010. It was closed as bogus before my last
question was answered. It would be fine to know what you think about
that bug.
In short:
var_dump((float)8315e839da08e2a7afe6dd12ec58245d);
results in
On Wed, 31 Aug 2011, rob...@myself.com wrote:
I have the below function with array for satus of issues where I need to have
'Resolved/Closed' visible but not available for choice
This as closing is a separate function to ensure correct resolution code is
selected
Already tried removing
On 08/31/2011 01:48 PM, Shawn McKenzie wrote:
The cast to float is truncating the invalid characters and since your
string contains a float that is INF (8315e839) before the truncation at
the d, then it returns INF. Makes perfect sense.
Just FYI... Don't post your troubles or
Okay, so I've finally got an opportunity to start converting our code to
use Mysqli instead of the old mysql_* functions. Mysqli is new to me, but
I thought things were going well until the first time I tried to run a
query with a syntax error in it, and it threw up a PHP warning. Being that
On Aug 30, 2011, at 3:09 PM, Robert Cummings wrote:
On 11-08-30 11:36 AM, Richard Quadling wrote:
On 30 August 2011 15:04, Tedd Sperlingtedd.sperl...@gmail.com wrote:
To all:
I prefer the Whitesmiths style:
http://rebel.lcc.edu/sperlt/citw229/brace-styles.php
But style is really up
Dear Danial,
I saw some update on EasyPHP via this group so I just thought to receive
support as well as such advertisement.
I'm sorry to spam this group.
Regards.
On Mon, Aug 29, 2011 at 7:26 PM, Daniel Brown danbr...@php.net wrote:
On Sun, Aug 28, 2011 at 07:10, EasyPHP
On Wed, Aug 31, 2011 at 08:20:14PM -0400, Tedd Sperling wrote:
On Aug 30, 2011, at 3:09 PM, Robert Cummings wrote:
On 11-08-30 11:36 AM, Richard Quadling wrote:
On 30 August 2011 15:04, Tedd Sperlingtedd.sperl...@gmail.com
wrote:
To all:
I prefer the Whitesmiths style:
On Tue, 30 Aug 2011 10:04:54 -0400, Tedd Sperling wrote:
I prefer the Whitesmiths style:
http://rebel.lcc.edu/sperlt/citw229/brace-styles.php
But style is really up to the individual -- what works best for you
is the best (unless it's a team effort or the clients demand).
I note on your page
26 matches
Mail list logo
