Just for the archive: problem was caused because the query returned
multiple result sets (which is not supported by PDO).
If the stored procedures only return one result set, everything works fine.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
driver or is it a bug?
Regards,
Marco
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
marco schrieb:
[code]
function preGenerateForm()
{
$this-fb_preDefElements['alive'] =
HTML_QuickForm::
createElement('advcheckbox','alive','Ali
ve',null,null,$this-alive);
}
[/code]
this code generate a only one checkbox..
i would like to generate a list of checkbox so i tryed [code
would really appreciate any of
them.
Cheers
Marco
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi.
how could i put an image to a table (mysql) and show whenever i saw the
record, for example photo of a customer.
I am putting the images on a folder, and only put the image name on
database.
i want to store image and show after.
Thank's in advance
MB
--
PHP Database Mailing List
);
$id_tabella, $id_colonna and $connessione has the correct value...
The same query runs perfectly if I exec it directly on the db.
Do you have any suggestions?
Marco
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
the client and the
server share the same machine.
Does anyone have a clue on what is going on or point me to some tests I
can do?
Thank you all,
marco
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Good afternoon dear friends:
I want to ask you, how I must setup my PHP.INI file, to send e-mail from my
Web Site if my SMTP server requires authentication. Otherwise, I want to
know if exits some kind of public SMTP sever that I could use.
Thank you very much.
mArK
Buenos días a todos:
Espero que alguno de ustedes hable español y me pueda ayudar a descubrir qué
está mal en el siguiente código:
El objetivo de la función es acceder a una base de Datos (MySQL) y mostrar
los registros que cumplan cierta condición. Si no existe ningún registro
que cumpla la
Hi Jeroen,
If you're going to update the file...the database will be locked...
but if your just going to view it...it should be fine
Jeroen Verhoeven [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
I try to acces an access database from a PHP script runnig on an NT
machine
with
\result.php on line
Do U know why?
Thanks in advance
Marco
I have correct case sensitive error but it still don't work:
RESULT CODE:
$keys = explode ( , $_POST [chiave]);
$query = ;
foreach ($keys as $parola){
$parola = trim($parola);
if ($parola != )
$query .= titolo LIKE '%$parola%' OR testo LIKE '%$parola%' OR autore LIKE
'%$parola%' OR ;
}
$query
i've correct the problem
the script was right
thx
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-Notice: Use of undefined constant data..
-Notice: Use of undefined constant mail...
-Undefined variable
Why in my scripts i always get error notice like this?
How can i solve this problem?
Thanks
Try in the current snapshot at http://snaps.php.net (also, more info on
my blog).
Cheers,
Marco Tabini
http://blogs.phparch.com
On Fri, 2003-07-04 at 13:01, Adam Lundrigan wrote:
that doesn't seem to workit tells me that the libmysql.dll file is not a
PHP module. Where can I track down
for me to
reference my own site than someone else's):
http://blogs.phparch.com/mt/archives/14.html
http://blogs.phparch.com/mt/archives/19.html
http://blogs.phparch.com/mt/archives/23.html
These also include some comments directly from MySQL on this whole
thing.
Cheers,
Marco
On Sun
Sorry then, the library. The purpose was not to confuse, but, of course,
to inform.
Marco
On Sun, 2003-06-29 at 21:39, Rasmus Lerdorf wrote:
On Sun, 29 Jun 2003, Marco Tabini wrote:
The MySQL extension has been debundled because MySQL has changed its
licensing policy and, effective 4.0
On Thu, 2003-06-26 at 08:09, CPT John W. Holmes wrote:
if(preg_match('/[0-9]/',$myVar))
Same thing, fewer characters:
if (preg_match('/\d/', $myVar))
Marco
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi Jerry--
No, md5 is a one-way hash. That's why it's so safe--because if someone
steals the information he still can't tell what the passwords are.
You may want to reset the passwords upon your users' request and send it
to them via e-mail instead.
Cheers,
Marco
--
php|architect
(but not that much) more complicated. So
you see, it's mathematically impossible to retrieve the original
password starting from the hash... which is a Good Thing(tm) :-)
Marco
--
php|architect -- The Magazine for PHP Professionals
Come try us out at http://www.phparch.com and get a free trial issue
On Tue, 2003-06-24 at 09:36, JeRRy wrote:
Hi,
Hmmm okay... So if the passowrd was.
[snip]
There are ways to avoid this. Typically, you can add a random token (or
a salt) to the password before you calculate its checksum. This way, two
users with the same password will have two different
to reverse it. So I really have no idea what to
think, instead I'm going to give the examples I have
recieved a go and see what happens.
Well, I haven't heard of md5 being broken, although it's been claimed
that it is breakable. I'd love to see the references they have sent you!
Cheers,
Marco
Sure, but only the first eight characters of the password are actually
used to make the hash (IIRC).
Marco
On Tue, 2003-06-24 at 10:15, Hutchins, Richard wrote:
I already admitted that this stuff was mostly over my head. However, I
started messing around with it a bit and would like to know
You probably want something like:
select * from offtime where type like '{$type}%'
As a side note, are you making sure that $type does not contain any
malicious code?
Cheers,
Marco
--
php|architect - The Monthly Magazine for PHP Professionals
Come check us out on the web
. We have something similar working on IE, Opera 5+ and
Netscape 6+, so it is possible to do it, although it requires a bit of
Javascript work.
Cheers,
Marco
--
php|architect - The Monthly Magazine for PHP Professionals
Come check us out on the web at http://www.phparch.com
I usually build an SSH tunnel whenever I need to connect securely to a
remote MySQL server. There's a tutorial on how to do that here:
http://www.netsys.com/cgi-bin/display_article.cgi?908
Marco
--
php|architect - The Magazine for PHP Professionals
The monthly magazine dedicated
I have a database which allows people to upload info and foto's. There's a
unique ID field, but some people tend to upload their info more than once
(its a contest site). What I'm able to do is to see how may duplicates there
are using the following statement:
$query=SELECT COUNT(*) as cnt,
y=SELECT COUNT(email) as cnt, voornaam,achternaam,leeftijd,ID,email
FROM
modellen GROUP BY email HAVING cnt 1;
HTH,
Bastian
Marco Alting schrieb:
I have a database which allows people to upload info and foto's. There's
a
unique ID field, but some people tend to upload their info more than
onc
general). You
have to do it procedurally by calling the entire table row by row.
2. Procedurally:
validate user data before entry in the DB
HTH
Ignatius
- Original Message -
From: Marco Alting [EMAIL PROTECTED]
To: [EMAIL PROTECTE
make it quite easy.
Hope this helps!
Marco
--
php|architect - The magazine for PHP Professionals
The monthly worldwide magazine dedicated to PHP programmers
Come visit us at http://www.phparch.com!
On Sun, 2002-12-01 at 08:30, peter wrote:
Hi,
I am pretty much new to the field
and have an instance of MySQL running on each web server, so that all
database connections are local and performed through UNIX sockets, which
are generally the fastest (assuming you're running UNIX, of course).
This may require a bit of data redesign, but it's worked for me in the
past.
Marco
) two people
have signed on with the same username, in which case you can decide who
gets the boot. This, too, is not a completely foolproof method
(particularly if you don't use SSL), but it's a good starting point.
Hope this helps.
Cheers,
Marco
--
php|architect - The magazine
It really depends on the DBMS you are using, but you can use aliases as
a trick to solve this problem:
select a.col1 as a_col1, b.col1 as b_col1 from a join b on a.id=b.id
This will return the two columns a_col1 and b_col1
Cheers,
Marco
--
php|architect - The magazine for PHP
If you have a column that gives you the newness of each row--I'm
assuming a date here:
delete from my_table order by date_inserted desc limit 100, -1
This should work... I recommend a db backup first :-)
Marco
php|architect - The magazine for PHP Professionals
The monthly
Can you reverse your sorting order? In that case, the last row now
becomes the first--making things much easier and faster! :-)
Marco
--
php|architect - The magazine for PHP Professionals
The monthly worldwide magazine dedicated to PHP programmers
Come visit us at http
you.
Marco
--
php|architect - The magazine for PHP Professionals
The first monthly worldwide magazine dedicated to PHP programmers
Come visit us at http://www.phparch.com!
---BeginMessage---
I'm having problems with a query. The query as it reads in my code is:
$sql_element_low
Uhm... are you sure it's not working? It's an update statement, maybe
the row has already the NULL value before you execute the query?
Otherwise, everything seems to be in order... sorry :-)
Marco
--
php|architect - The magazine for PHP Professionals
The first monthly worldwide
Hi Gavin,
Have you tried escaping your input? Take a look at the following:
http://ca.php.net/manual/en/function.mysql-real-escape-string.php
It should help you take care of the problem.
Marco
--
php|architect - The magazine for PHP Professionals
The first monthly worldwide
If you don't want to change your SQL statement:
echo date ('Y/m/d', strtotime ($myrow['datefield']));
Marco
--
php|architect - The magazine for PHP Professionals
The first monthly worldwide magazine dedicated to PHP programmers
Come visit us at http://www.phparch.com
while ($a[] = mysql_fetch_row ($rs));
should work
Marco
--
php|architect - The magazine for PHP Professionals
The monthly worldwide magazine dedicated to PHP programmers
Come visit us at http://www.phparch.com!
On Wed, 2002-11-13 at 19:27, John A DAVIS wrote:
Is there anyway
Perhaps I don't understand what it is you're looking for, but...
$a = array();
for ($i = 0; $i $maxvalue; $i++)
{
$a[$year] = $value;
}
but this is almost too simple, which probably just means I didn't quite
understand your question.
Marco
--
php|architect - The magazine
...
Marco
--
php|architect - The magazine for PHP Professionals
The monthly worldwide magazine dedicated to PHP programmers
Come visit us at http://www.phparch.com!
---BeginMessage---
Making an update query that adapts to the number of fields that are to be
updated
() );
while ($row = mysql_fetch_assoc ($result))
echo $row['Field'];
This loops through each row in the result set and prints out the value
of the field called Field, which actually contains the name of the
field in the table.
Cheers,
Marco
On Sun, 2002-11-10 at 10:18, David Rice
of writing this--but this one should be clearer.
Marco
-
php|architect -- The Monthly Magazine For PHP Professionals
Come visit us on the web at http://www.phparch.com!
On Fri, 2002-11-08 at 10:04, Paul Ihrig wrote:
Hello All!
i am new to the list to PHP..
So i have
Except when you have a million records, which may take a few seconds to
build. :-)
Marco
-
php|architect -- The Monthly Magazine For PHP Professionals
Come visit us on the web at http://www.phparch.com!
On Fri, 2002-11-08 at 11:12, Maxim Maletsky wrote:
Index is always re
I think you might be missing a = sign in your if statement.
Marco
-
php|architect -- The Monthly Magazine For PHP Professionals
Come visit us on the web at http://www.phparch.com!
On Fri, 2002-11-08 at 11:26, Paul Ihrig wrote:
well i tried that..
but it out puts the right
You can use exec
http://ca.php.net/manual/en/ref.exec.php
You will probably need to call the mysql shell like so:
/path_to_mysql/mysql -u user -p password [-h host] -D database -e \\.
filename
Marco
--
php|architect - The magazine for PHP Professionals
The first monthly
Ok, going out on a limb here... have you tried something like
select e.id, title, location, address, contact, category, event_time,
urllink, descript, min(event_date) from eventTable e inner join
dateTable d on e.id = d.id group by e.id
?
Marco
--
php|architect - The magazine
My guess? Because we're all professionals at work and trying to solve a
specific problem...since we're adults, I guess the learning part should
be up to each of us--the information is certainly there even in the
answer. :-)
Marco
--
php|architect - The magazine for PHP
questions--anybody who's tired of answering that
register_globals has been turned off in recent versions raise your hand!
:-)
Marco
--
php|architect - The magazine for PHP Professionals
The first monthly worldwide magazine dedicated to PHP programmer
Come visit us at http
, for the most
part, so nothing particularly ominous.
Marco
--
php|architect - The magazine for PHP Professionals
The first monthly worldwide magazine dedicated to PHP programmer
Come visit us at http://www.phparch.com!
---BeginMessage---
Hi there everyone,
Why are so many attachments
Make sure that the encoder you use actually makes string unreadable.
Otherwise, you can use a simple trick, like for example XORing the whole
string with FF or something similar.
--
php|architect - The magazine for PHP Professionals
The first monthly worldwide magazine dedicated to
Numeric IDs are probably a bit faster--although if properly indexed not
by much--plus you can use self-numbering columns with them.
Marco
--
php|architect - The magazine for PHP Professionals
The first monthly worldwide magazine dedicated to PHP programmer
Come visit us at http
Did you restart the server? Are you sure you modified the right php.ini?
On Thu, 2002-10-31 at 14:53, Edward Peloke wrote:
I know this is off topic to the db list but..
I am attempting to use the mail function. I have set the smtp in the
php.ini file to my smtp server but when I run the
What's on line 48?
On Sun, 2002-10-27 at 18:43, alex hogan wrote:
Hi All,
I am new to the list, as a matter of fact this is my first post so if
I'm covering territory that has been already covered please excuse me.
I am using PHP/MySQL/Dreamweaver MX. I expect the razzing to start
the rowRsId variable is never defined... that's why PHP is complaining.
On Sun, 2002-10-27 at 19:53, alex hogan wrote:
Sorry..., my bad. Too wrapped up in the problem.
Notice: Undefined variable: row_rsID in
D:\web\hogana\demo\login\TMPbl2tw4o24u.php on line 48
Warning: Cannot add
number_format():
http://ca.php.net/manual/en/function.number-format.php
On Thu, 2002-10-17 at 14:52, Manoj Japher wrote:
hi,
I would like to format my output. I would like to represent my
integer outputs as 2,000 instead of 2000 which it prints by
default.
For e.g. I want 200 to
It seems to me that the first time you go through the loop, if
$record-wave_num is != $prior_wave then you print the wave number but
not the person's name--but you already have a record there with a
person's name!
Try taking out the else statement--if you follow the code from there you
should be
a random token to the URL so that they can't bookmark the files at
all.).
Marco
On Mon, 2002-10-14 at 08:58, Adam Royle wrote:
I was wondering about people's thoughts on file security through php
using database authentication.
Take the following example:
I have a folder (in webroot) called
Well, you can use the break statement to exit a loop or code block, but
wouldn't you rather want to create a single loop that can handle any
number of files?
On Mon, 2002-10-14 at 13:54, Michael Knauf/Niles wrote:
Ok, next question:
Here's my upload script:
?
if
How about
select * from table where birthday between now() and date_add(now(),
interval 15 day);
Assuming, of course, you're using MySQL.
Cheers,
Marco
On Mon, 2002-10-14 at 16:20, Steve Vernon wrote:
Hiya,
Just wondering what is the best way to do this please.
I have
);
}
echo '/table';
}
else
echo 'bNo results found./b';
}
You can embellish the resulting HTML code as needed. (Also, please note
that I'm doing this from memory... so it might not work right off ;)
Marco
On Mon, 2002-10-07 at 16:07, Edward
$_REQUEST is an associative array consisting of the contents of $_GET,
$_POST, $_COOKIE, and $_FILES
Also, they are not function but arrays, as Hatem said.
You can usa $_REQUEST as a catch-all that provides you with both what
was passed to your page through the URL query ($_GET) and what was
Also, if you decide to use serialize() and unserialize() through the
post variables (I'd recommend against using it in the query URL because
some browsers have a limit as to how much data they can fit into it),
you should consider encrypting it in some way or at least appending an
encrypted CRC
neficial to check the event log. More clues may lie in
there. If the webserver has any type of error log check that as well.
Aaron Weiker
-Original Message-
From: Marco Lanini [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 22, 2002 1:10 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-D
, i'm Italian) :\
Aaron T. Weiker [EMAIL PROTECTED] ha scritto nel messaggio
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Are you able to connect to the MySQL server using a client?
Aaron Weiker
-Original Message-
From: Marco Lanini [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 22
Hi
sorry for my english but i'm italian.
I have a server who run with
WIN XP HOME
Abyss Web Server (Freeware) www.aprelium.com
MySql 4.0.1-alpha-nt
PHP 4.2.1
when i use mysql_connect($host,$user,$pass) or die(mysql_error()); function
he write:
Can't create TCP/IP socket (10106)
i have
to check
the firewall settings, to make sure that windows XP
isn't preventing the connection.
For the $host, you may want to either use
'localhost' or 127.0.0.1
Cheers,
Dan
-Original Message-
From: Marco Lanini [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 11:20 AM
To: [EMAIL P
in selectbox 2.
Was that clear? I hope so.
Does anybody has a solution for this situation? Or maybe sample code?
Thank you in advance for any help.
Kind regards and greetings from Cologne/Germany,
Marco.
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit
0@ANDreY...
phpMyAdmin has changed to amp; and then put it in the DB.
So it is better not to use phpMyAdmin or any toher web based tool for
tasks which includes entering. Not sure for ,
Regards,
Andrey Hristov
- Original Message -
From: Marco Coletta [EMAIL PROTECTED]
To: [EMAIL P
I have a problem with symbol .
In PHP script I have a variable with a string assigned containing the
symbol '' :
$myvariable = 'Smith Sons';
when I insert the variable in the database :
$query=insert into mytable (mycolumn) values
(myvalue1='$myvariable');;
$result=mysql_query($query);
if
do this (crontab file)
35 23 * * * root lynx http://www.host.com/dir/file.php -accept_all_cookies
it's work!
marco
-Mensaje original-
De: Harpreet [mailto:[EMAIL PROTECTED]]
Enviado el: Jueves, 20 de Diciembre de 2001 02:21 p.m.
Para: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Asunto: [PHP
task manager
-Mensaje original-
De: George Loch [mailto:[EMAIL PROTECTED]]
Enviado el: Jueves, 20 de Diciembre de 2001 05:56 PM
Para: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Asunto: [PHP-DB] Re: [mysql-support] RE: [PHP-DB] Run php page
automatically
What if you are on win2K?
-
for flex... lex
checking for yywrap in -ll... no
checking lex output file root... ./configure: lex: command not found
configure: error: cannot find output from lex; giving up
what is lex??? and where I did wrong?
thank you very much. Bye
Marco R.
--
PHP Database Mailing List (http
Hi, I'm trying to install php-4.0.6 in my SCO Unix box but when I run the
make command I get the next error:
/bin/sh ../libtool --silent --mode=link gcc -g -O2 -o libZend.la -lifsql
-lif
asf -lifgen -lifos -lifgls -lnsl_s -lcrypt_i -lgen -lsocket -lnsl -lsuds
-ltinfo
-lprot -lx -ltinfo -lc
Help!,
Can any one point out web hosting companies that will give me PHP and
PostgreSQL support
for an affordable price?
Marco Gaiani
Marco A. Gaiani
Editorial Comitee
www.entomotropica.org
mailto:[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail
also interested in Unix-only
solutions.
Thanks in advance,
Marco Draijer
--
This message contains information that may be privileged or confidential and
is the property of the Cap Gemini Ernst Young Group. It is only
hello everybody, can anyone tellme how i can do a "mount" in a server from php
script?, "system(mount * * *)" doesn't work!
marco eyzaguirre
Lima - Peru
hello everybody, can anyone tellme how i can do a "mount" in a server from
php script?, "system(mount * * *)" doesn't work!
marco eyzaguirre
Lima - Peru
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional comm
79 matches
Mail list logo