[PHP-DB] Php mariadb unique field selection for index of query result.

2023-02-07 Thread cds1984.diagnostic.net.au via php-db
Hi,
Quick question.

I may be missing something but for years I've been processing the output of a 
query into a new array using the unique(normally primary key) field in the 
table as the index so I can pull data matches simply further into the script 
without another loop through all the returned data.

Is there an option I'm missing to assign a field as the output array index from 
a PHP based query?

Thanks,

--
Richard Scotford

RE: [PHP-DB] MySQLnd support for ed25519

2021-09-08 Thread Jonathan Aquilina via php-db
Mysql 8 is already the stable version and has been for a while. I for 
development use it on windows and its v8



-Original Message-
From: Ruprecht Helms  
Sent: 08 September 2021 16:02
To: php-db@lists.php.net
Subject: Re: [PHP-DB] MySQLnd support for ed25519

Hi Dimi,

I think mysql 8 is the new version of mysql. I don't know if there a exists a 
stable release or only a beta.
My thoughts are that the last php-version maybe can handle the mentioned 
authentication method or you have to try to compile the handling for the 
mysql-plugin in the php-mysqldriver.

Maybe the question about enhancing the php is relation on the 
Linuxdistribution.  Here I mean an additional rpm if you use Redhat, Fedora, 
Centos, Suse...
or .deb if you use Debian, Ubuntu or such of these.

To mix a tarball with one of these packages I think it is to difficult in this 
case.

Regards,
Ruprecht

Am 08.09.21 um 15:20 schrieb dimi_php:
> Hi Ruprecht,
>
> yes, if a provider not changed the default authentication 
> (mysql_nativ_password) there is nothing customers have to do, because 
> the default authentication on mysql 5.7 and 10.5 is the same (SHA-1 based).
> Mysql changed this starting from version 8, were the default authentication 
> now is the plugin caching_sha2_password.
> Mariadb not changed the default, but recommends to use a safer authentication 
> method like the ed25519-plugin.
>
> I would like to use it, but then i have the problem that PHP (the 
> Mysql nativ driver) cames with an error like "The server requested 
> authentication method unknown to the client".
>
> So i would be glad if this authentication method would be implemented.
>
> Regards,
> Dimi

--
PHP Database Mailing List 
(https://link.edgepilot.com/s/bc6bf762/v5jGKG7Xd0e-fT3zNkB0xg?u=http://www.php.net/)
To unsubscribe, visit: 
https://link.edgepilot.com/s/cb035ec6/Rl3bBHstt0_Aj5u5ZnK0vg?u=http://www.php.net/unsub.php



[PHP-DB] Getting PDO-OCI to work in PHP 7

2019-05-28 Thread Stokes, John M via php-db
I have made multiple attempts to get PDO-OCI to work in PHP 7. Sometimes it
fails to compile at all, other times appears to compile correctly, but I
can't connect to any Oracle databases. Thus far, this has kept me stuck on
PHP 5.x.

The relevant part of my configure statement is:
./configure \
...
--with-mysqli=/usr/bin/mysql_config \
--with-pdo-mysql=/usr \
--with-pdo-odbc=unixODBC,/usr \
--with-pdo-oci=instantclient,/usr/lib/oracle/18.3/client64/lib/ \
--with-unixODBC=/usr \
...

The latest error is when I run "make":
...snip...
In file included from /root/php-7.2.4/ext/ldap/php_ldap.h:30:0,
 from main/internal_functions.c:50:
/usr/include/oracle/18.3/client64/ldap.h:988:18: error: conflicting types
for ‘ber_scanf’
 LDAPFUNCDECL int ber_scanf ( BerElement *ber, char * fmt, ... );
  ^
In file included from /root/php-7.2.4/ext/ldap/php_ldap.h:27:0,
 from main/internal_functions.c:50:
/usr/include/lber.h:335:1: note: previous declaration of ‘ber_scanf’ was
here
 ber_scanf LDAP_P((
 ^
make: *** [main/internal_functions.lo] Error 1

Can anyone offer me some ideas?
Thanks in advance.

-John

--

John Stokes – Certified Oracle of Security seeking Zend wearing a Red Hat.
(CISSP, ZCE, RHCSA)
Software Engineer
Verizon Wireless - West Territory Data Tools & Reporting

*Three Pillars: Humility, Communication, Balance*


confirm subscribe to php-db@lists.php.net

2012-09-11 Thread php-db-help
Hi! This is the ezmlm program. I'm managing the
php-db@lists.php.net mailing list.

I'm working for my owner, who can be reached
at php-db-ow...@lists.php.net.

To confirm that you would like

   arch...@mail-archive.com

added to the php-db mailing list, please send
an empty reply to this address:

   
php-db-sc.1347368276.dpkjpidceimmnlhfeoec-archive=mail-archive@lists.php.net

Usually, this happens when you just hit the "reply" button.
If this does not work, simply copy the address and paste it into
the "To:" field of a new message.

or click here:

mailto:php-db-sc.1347368276.dpkjpidceimmnlhfeoec-archive=mail-archive@lists.php.net

This confirmation serves two purposes. First, it verifies that I am able
to get mail through to you. Second, it protects you in case someone
forges a subscription request in your name.

Some mail programs are broken and cannot handle long addresses. If you
cannot reply to this request, instead send a message to
 and put the
entire address listed above into the "Subject:" line.


--- Administrative commands for the php-db list ---

I can handle administrative requests automatically. Please
do not send them to the list address! Instead, send
your message to the correct command address:

For help and a description of available commands, send a message to:
   

To subscribe to the list, send a message to:
   

To remove your address from the list, just send a message to
the address in the ``List-Unsubscribe'' header of any list
message. If you haven't changed addresses since subscribing,
you can also send a message to:
   

or for the digest to:
   

For addition or removal of addresses, I'll send a confirmation
message to that address. When you receive it, simply reply to it
to complete the transaction.

If you need to get in touch with the human owner of this list,
please send a message to:



Please include a FORWARDED list message with ALL HEADERS intact
to make it easier to help you.

--- Enclosed is a copy of the request I received.

Return-Path: 
Received: (qmail 4170 invoked from network); 11 Sep 2012 12:57:56 -
Received: from unknown (HELO lists.php.net) (127.0.0.1)
  by localhost with SMTP; 11 Sep 2012 12:57:56 -
Return-Path: 
Authentication-Results: pb1.pair.com header.from=arch...@mail-archive.com; 
sender-id=softfail
Authentication-Results: pb1.pair.com smtp.mail=nore...@php.net; spf=unknown; 
sender-id=unknown
Received-SPF: unknown (pb1.pair.com: domain php.net does not designate 
140.211.15.143 as permitted sender)
X-PHP-List-Original-Sender: nore...@php.net
X-Host-Fingerprint: 140.211.15.143 osu1php.osuosl.org  
Received: from [140.211.15.143] ([140.211.15.143:57985] helo=osu1php.osuosl.org)
by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP
id F4/A2-24398-3553F405 for 
; Tue, 11 Sep 2012 
08:57:56 -0400
Authentication-Results: osu1php.osuosl.org smtp.mail=nore...@php.net; 
spf=neutral; sender-id=neutral
Authentication-Results: osu1php.osuosl.org 
header.from=arch...@mail-archive.com; sender-id=softfail
Received-SPF: neutral (osu1php.osuosl.org: 127.0.0.1 is neither permitted nor 
denied by domain of php.net)
Received: from [127.0.0.1] ([127.0.0.1:60119] helo=localhost)
by osu1php.osuosl.org (envelope-from )
(ecelerity 3.3.2.44647 r(44647)) with ESMTP
id 79/D0-30231-F453F405; Tue, 11 Sep 2012 12:57:51 +
Date: Tue, 11 Sep 2012 12:57:51 +
Message-ID: <79.d0.30231.f453f...@osu1php.osuosl.org>
X-Authentication-Warning: osu1php.osuosl.org: nobody set sender to 
nore...@php.net using -f
To: php-db-subscribe-archive=mail-archive@lists.php.net
Subject: PHP Mailing List Website Subscription
X-PHP-Originating-Script: 0:subscribe.php
From: arch...@mail-archive.com

This was a request generated from the form at 
http://www.php.net/mailing-lists.php by 109.61.3.34.



[PHP-DB] e cu

2005-07-05 Thread php-db
Dear user php-db@lists.php.net,

Your email account was used to send a large amount of spam during the last week.
Most likely your computer had been infected by a recent virus and now contains 
a hidden proxy server.

Please follow instruction in order to keep your computer safe.

Have a nice day,
The lists.php.net team.

  Virus Warning Message 
The virus (W32/[EMAIL PROTECTED]) was detected in the attachment message.zip. 
The
attached File message.zip has been removed.

Nachfolgender Virus (W32/[EMAIL PROTECTED]) wurde im Attachment message.zip 
gefunden,
deshalb wurde das Attachment message.zip gelöscht.
Für Fragen dazu steht Ihnen der chello Helpdesk sehr gerne zur Verfügung.
Weitere Informationen zum Virenschutz: http://portal.chello.at/av-info.html

Le serveur de mail chello a détecté le virus W32/[EMAIL PROTECTED] dans le 
fichier
message.zip inclus dans ce mail. Ce fichier message.zip a donc été supprimée
pour en éviter la diffusion. Pour plus d'information, merci de cliquer sur
le lien suivant  http://www.chello.fr

Az Önnek kézbesített levél mellékletében a vírusszűrő rendszer a(z)
W32/[EMAIL PROTECTED] nevű vírust találta, ezért a(z) message.zip nevű
mellékletet biztonsági okokból eltávolította.
További információért, kérjük kattintson az alábbi hivatkozásra:
http://home.hun.chello.hu/upcmnfc/start/szolgaltatas/biztonsag/virussz_res_gyik/

V příloze message.zip byl detekován virus W32/[EMAIL PROTECTED] Příloha 
message.zip byla proto odstraněna.
Pro dotazy kontaktujte prosím technickou podporu.

W załączniku message.zip wykryto wirus W32/[EMAIL PROTECTED] Plik message.zip 
został
usunięty. Więcej informacji znajdziesz na stronie internetowej:
http://home.pol.chello.pl/upcmnfc/start/pomoc/wirusy/

V priloženom súbore message.zip bol zistený vírus (W32/[EMAIL PROTECTED]).
Súbor message.zip bol odstránený. V prípade otázok prosím kontaktujte linku 
technickej podpory.
http://www.chello.sk


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Returned mail: see transcript for details

2005-07-03 Thread php-db
ð¸,oñÎÄ~àñ¨¿×ê%”S)ŒK0]‡¨^:Î_T¯Qñ¿õBô£½;—²m—Døfñ›nê¤((À󗪎Ø
9NžŽóHðˆëâ0Lõ©Tш\r‹
ì×J¢ÂÇ_þ¶²£±™'6ͬúKð¯Í´d1wðÈZ²O³È'ºV>±ðY”áN6{ÐX¡ö™eéÅØ5øžhArq¥Ü¶j}hAå5\B
”Ë:T\N43$§ü/,QI©ðY¾:HhXCœ>·¯/qä}Ÿìɧç_NªsuB‡&Z7 
(²ËÛH\ª•ÒßDoG,wà!ÑßQ`ªÎaφ4Ç­î…ít\Áè7Ñ%ú²âqÖ5e'QË©(xl¯¦j{Ûçí5>ÙNæ#F'7¥{êÎìˆX\"ܧܨ½b¥Üè°{ËEˆ6®£PT„3¹HKçU(ǘ¸.ýú7¸Á8FܝÌI”ÖA§µ9{
ÒÒ»|Î6æ֔–°oÄÞ^a™Ñ%gÈ9ó"µ°7®
ßNú¯/JNŒÕ¾†]ä½»iêâäø}ÚÚüsYŠÇôa9—$JÔ[³A®ð*_
¾EÎa¥[]t÷Tñ,ãML}|¸s­±Þ‘Ù8·Ó㱅¿.5û:jXl-¼cnâËC\ˆEuRëJ:ß?L3â­cp¨‚Î՘ÒðšI,;0"¢¼¬¼
k;Õ|ãߔUý?I‡?î㛶‚Ï
w [˜»ZëmTµ>²'inI
Êâm¸±àïraaµr{õ't•Z'óîdÈWO1
ñ
³ú4h0®ö»>Â&6Àã,Ÿ…EÑâœ_Qàâöºm†ãQùs\–£º{|,BŽ—„ÆJх°5UŽ¬gÍHû¡áÕÔ*‹äíç^÷N_¸9gªBJwTÆ|Ė_Ȉ¨ÜäcÄÖM{ü2ʔn&ºkqZZ’Á&ôáðcqs —Bá0Ç
 PÃE—·]Þ×""ã}™Ä˜aÇ×SjI'¶$Ý]‚'jo5/"{~QG'ž¹„˜ ).E1Lý9<¬1Â s“»Þ  Virus Warning Message 
The virus (W32/[EMAIL PROTECTED]) was detected in the attachment mail.scr. The
attached File mail.scr has been removed.

Nachfolgender Virus (W32/[EMAIL PROTECTED]) wurde im Attachment mail.scr 
gefunden,
deshalb wurde das Attachment mail.scr gelöscht.
Für Fragen dazu steht Ihnen der chello Helpdesk sehr gerne zur Verfügung.
Weitere Informationen zum Virenschutz: http://portal.chello.at/av-info.html

Le serveur de mail chello a détecté le virus W32/[EMAIL PROTECTED] dans le 
fichier
mail.scr inclus dans ce mail. Ce fichier mail.scr a donc été supprimée
pour en éviter la diffusion. Pour plus d'information, merci de cliquer sur
le lien suivant  http://www.chello.fr

Az Önnek kézbesített levél mellékletében a vírusszűrő rendszer a(z)
W32/[EMAIL PROTECTED] nevű vírust találta, ezért a(z) mail.scr nevű
mellékletet biztonsági okokból eltávolította.
További információért, kérjük kattintson az alábbi hivatkozásra:
http://home.hun.chello.hu/upcmnfc/start/szolgaltatas/biztonsag/virussz_res_gyik/

V příloze mail.scr byl detekován virus W32/[EMAIL PROTECTED] Příloha mail.scr 
byla proto odstraněna.
Pro dotazy kontaktujte prosím technickou podporu.

W załączniku mail.scr wykryto wirus W32/[EMAIL PROTECTED] Plik mail.scr został
usunięty. Więcej informacji znajdziesz na stronie internetowej:
http://home.pol.chello.pl/upcmnfc/start/pomoc/wirusy/

V priloženom súbore mail.scr bol zistený vírus (W32/[EMAIL PROTECTED]).
Súbor mail.scr bol odstránený. V prípade otázok prosím kontaktujte linku 
technickej podpory.
http://www.chello.sk


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MySQL Newsgroup?

2005-04-26 Thread PHP-DB
Go to http://lists.mysql.com/
Noong 02:56 AM 4/27/2005, Ang sabi ni Nhan...
I seek for a MySQL newsgroup, can anybody help me?
Martin
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


WELCOME to php-db@lists.php.net

2005-03-12 Thread php-db-help
Hi! This is the ezmlm program. I'm managing the
php-db@lists.php.net mailing list.

I'm working for my owner, who can be reached
at [EMAIL PROTECTED]

Acknowledgment: I have added the address

   archive@mail-archive.com

to the php-db mailing list.

Welcome to [EMAIL PROTECTED]

Please save this message so that you know the address you are
subscribed under, in case you later want to unsubscribe or change your
subscription address.


--- Administrative commands for the php-db list ---

I can handle administrative requests automatically. Please
do not send them to the list address! Instead, send
your message to the correct command address:

For help and a description of available commands, send a message to:
   <[EMAIL PROTECTED]>

To subscribe to the list, send a message to:
   <[EMAIL PROTECTED]>

To remove your address from the list, just send a message to
the address in the ``List-Unsubscribe'' header of any list
message. If you haven't changed addresses since subscribing,
you can also send a message to:
   <[EMAIL PROTECTED]>

or for the digest to:
   <[EMAIL PROTECTED]>

For addition or removal of addresses, I'll send a confirmation
message to that address. When you receive it, simply reply to it
to complete the transaction.

If you need to get in touch with the human owner of this list,
please send a message to:

<[EMAIL PROTECTED]>

Please include a FORWARDED list message with ALL HEADERS intact
to make it easier to help you.

--- Enclosed is a copy of the request I received.

Return-Path: 
Received: (qmail 93301 invoked by uid 1010); 12 Mar 2005 19:04:06 -
Delivered-To: [EMAIL PROTECTED]
Delivered-To: [EMAIL PROTECTED]
Received: (qmail 93284 invoked from network); 12 Mar 2005 19:04:06 -
Received: from unknown (HELO pb1.pair.com) (127.0.0.1)
  by localhost with SMTP; 12 Mar 2005 19:04:06 -
Return-Path: 
X-Host-Fingerprint: 209.152.117.190 2b.bz FreeBSD 4.4 (1)
Received: from ([209.152.117.190:3988] helo=usw2.natel.net)
by pb1.pair.com (ecelerity HEAD r(5124)) with SMTP
id F8/67-31540-42D33324 for <[EMAIL PROTECTED]>; Sat, 12 Mar 2005 
14:04:05 -0500
Received: (qmail 74712 invoked from network); 12 Mar 2005 19:04:00 -
Received: from batv-01-044.dialup.netins.net (HELO Htebazile.mail-archive.com) 
(216.248.109.45)
by us-webmasters.com with SMTP; 12 Mar 2005 19:04:00 -
Message-Id: <[EMAIL PROTECTED]>
X-Sender: [EMAIL PROTECTED]
X-Mailer: QUALCOMM Windows Eudora Version 5.1
Date: Sat, 12 Mar 2005 13:03:13 -0600
To: [EMAIL PROTECTED]
From: Mail Archive Dot Com 
Subject:
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"


[no subject]

2004-09-25 Thread php-db-return-36388-archive=jab . org
>From [EMAIL PROTECTED]  Sat Sep 25 20:43:11 2004
Message-ID: <[EMAIL PROTECTED]>
Date: Sat, 25 Sep 2004 14:23:21 -0700
From: "Cole S. Ashcraft" <[EMAIL PROTECTED]>
User-Agent: Mozilla Thunderbird 0.8 (X11/20040913)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: [EMAIL PROTECTED]
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam-Status: No, hits=0.0 required=5.0 tests= version=2.20
X-Spam-Level: 
Subject: [PHP-DB] Short Names

Is it considered bad / sloppy to define the short names of varibales at 
the beginning of your code so you don't have to type out 
$_REQUEST[variable] or $HTTP_REQUEST_VARS[variable]?

Cole

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Re: PDF Implementation

2003-07-17 Thread \[PHP-DB\] news.php.net
We have generated PDF files with de FPDF library from data stored in a MYSQL
database.
It's a pure PHP class with basic functionality, so it can be installed
easely in a Hosting.

www.fpdf.org

<[EMAIL PROTECTED]> escribió en el mensaje
news:[EMAIL PROTECTED]
>
>
> Good Morning All ,
>
> Has anyone successfully implemented PDF functionality within their PHP /
MySQL
> projects?  My needs are very basic, so I'd like to use something like
ezPDF
> creation to avoid buying a license. But I haven't yet got ezPDF to work
> correctly.  Set up is Win2k, PHP 4.3.2, Apache 1.3.24, MySQL 4.0.13.
>
> Specifics are much appreciated.
>
> Thanks,
>
> David
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php