[PHP-DB] How to create a new Table in prostgresql from a Webinterface
Hello, Never I have done this before (no need) but now I need to create a new table with some colums from a Webinterface and do not know how to do that. Please can anyone point me into the right direction ? Thanks, Greetings and nice Weekend Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/8845235667100 Strasbourg/France IRC #Debian (irc.icq.com) signature.pgp Description: Digital signature
[PHP-DB] Re: [PHP] How to create a new Table in prostgresql from a Webinterface
Am 2004-08-14 17:42:20, schrieb Watty: > What language are you using? php4 under Debian GNU/Linux 3.0 wirh postgresql 7.4.2 (Backport) > Watty Greetings Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/8845235667100 Strasbourg/France IRC #Debian (irc.icq.com) signature.pgp Description: Digital signature
[PHP-DB] Re: LOAD DATA LOCAL INFILE
Am 2004-08-16 19:11:50, schrieb James Hatridge: > Hi Dani et al.. > > The guys at MySQL turned this off for security reasons. :( They and SuSE say > that you can turn it back on, but I've never been able to get it to work. > > There are two ways to handle this, first you have to use "LOAD DATA INFILE". > The file then needs to be either in /tmp and readable by everyone (this is > best). Or the way I do it is put in the same dir where the database is, > ie /var/lib/mysql/databaseXXX. The problem with this is that you have to > change the premissions. Which is not a good idea on an internet machine. > > Hope this helps, What about: http://www.ispirer.com/doc/sqlways36/troubleshooting/mysql_db.html In MySQL 4.0.x LOCAL will only work if MySQL server was started with --local-infile=1. > JIM Hello, Greetings Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/8845235667100 Strasbourg/France IRC #Debian (irc.icq.com) signature.pgp Description: Digital signature
[PHP-DB] Re: Re: November 2, 2004
Am 2004-11-02 07:22:13, schrieb Lester Caine: > There are many more of us who do not have the right to vote in the US, > just as we do not have the right to claim our 3.5% guaranteed mortgage. > Americans need to start thinking about OTHER countries rather than > assuming that they can just bombard every list with 'relevant' > information that is totally irrelevant to the rest of the world. > > THAT is one of the major reasons the rest of the world gets p*d of > Americans ;) Agreed. Greetings Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/8845235667100 Strasbourg/France IRC #Debian (irc.icq.com) signature.pgp Description: Digital signature
[PHP-DB] Re: Re: November 2, 2004
Am 2004-11-01 19:30:50, schrieb Joseph Crawford: > > Do we care? Realy? Unlikely. Maybe you should send your 'useful' info on > > a national mailinglist only. > > i am sorry but i do care, if you do not care about voting you dont > care if the war comes to the US. Maybe, but I am in France !!! It is enough if I see every day in TV how many Iraqis-Children (around 17.000 curently) are killed by American Commandos. Political stuff has nothing to do on this list !!! Greetings Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/8845235667100 Strasbourg/France IRC #Debian (irc.icq.com) signature.pgp Description: Digital signature
[PHP-DB] Re: Re: November 2, 2004
Am 2004-11-02 03:04:10, schrieb GH: > However, when other countries are in trouble or need something... who > do they turn to? America Are you sure ? Its only you American(s) which think so. > Therefore everyone in the world has an interest in what happens in the > american body politic just as Americans have an interest in what > happens to the British Prime Minister and in parts of the British body > politic. But in FR/DE we p***s on you americans... We do not like to play WARGAMES for Petrol and Profit !!! Greetings Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/8845235667100 Strasbourg/France IRC #Debian (irc.icq.com) signature.pgp Description: Digital signature
[PHP-DB] Re: Re: November 2, 2004
Am 2004-11-02 03:06:35, schrieb GH: > and by the way the main reason we have problems in America > > * People with out health insurance This is every countries own problem... In Europe ALL People has a "health insurance". > * No affordable housing Is this my problem ? > * and a huge debt Do not play WAR with innocents. > * amongst others Who ? > is because we give aid to almost any country who asks for it and Who ask for you ? - NOBODY. Americans are egoists and they are afraid they must play alone like a little children... America is fare from Europe and much more from Near East. > allow them to take the American's jobs... Rassist ? > Just a thought Greetings Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/8845235667100 Strasbourg/France IRC #Debian (irc.icq.com) signature.pgp Description: Digital signature
[PHP-DB] Re: passing both an anchor and a variable
Hello Perry, Am 2004-11-12 09:57:30, schrieb Perry, Matthew (Fire Marshal's Office): > How do you append both an anchor and a variable to a URL with PHP? I do not understand what you mean but something like: http://www.myserver.tld//">URL ? Greetings Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/8845235667100 Strasbourg/France IRC #Debian (irc.icq.com) signature.pgp Description: Digital signature
[PHP-DB] Re: list test subject
Am 2005-06-24 13:56:31, schrieb JeRRy: > Hi, > ut for now you can try/read these to help at your end: > > https://www.interstar.com.au/StarNet/access_problems.asp Hey, the internet is only Working with InfernalExploder 4.01 to 6 and Nutscrape 4.08 to 7.1 So I am Ghostsurfer with Mozilla, and eLinks... > http://www.lib.flinders.edu.au/resources/problemisps.html > http://www.lib.flinders.edu.au/resources/accessprob.html > > Ignore the names on the sites in refrence as the majority ISP's are the same > thse days. But you can try what they say. > > I found this to work: > > - Clearing my cache/history OK > - Running a spyware program What do you mean with it ? TCPA ? DRM ? > - Running a registry cleanup program Where can I find such thing ? > - running scandisk [EMAIL PROTECTED]:~ > scandisk Command not found. > - rebooting my pc [EMAIL PROTECTED]:~ > uptime 11:02:05 up 176 days, 17:38, 2 users, load average: 1.83, 1.56, 1.27 are you happy ? > Seems to fix problems under a temp. basis. If anyone else can bring > light on this feel free to do so. > > Jerry Have a nice Day Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/8845235667100 Strasbourg/France IRC #Debian (irc.icq.com) signature.pgp Description: Digital signature
[PHP-DB] Re: list test subject
Am 2005-06-25 00:26:13, schrieb JeRRy: > Obviously Michelle the instructions provided with the subject "Re: > list test subject" was for Windows users. Not that hard to figure > out! But thanks for your smart, i think, response. But if someone like to know, whether a list is alive or not, he/she schould look into the List-Archive. I get every day 10-20 mails, asking "is this list alive". And then I get 20-70 messages each day from people, which do not know how to unsubscribe... > Some emails maybe delayed due to DNS issues global. One instance was Bizzar, never have seen this problem... germany, france, espagne, morocco, algeria, turkey, iran or afghanistan. Where do you live ? I know, that the USA are realy underdeveloped (Broadband, ...) but broken DNS or such issues? > I sent an email this morning to a server on the other side of the > world to me. To this point it is not delivered nor have I got a > response saying it bounced. I bet it arrives in the morning or > sometime in the near future before the 3 days give up period some > emails are given. :-/ > Another is I tried to load http://www.getpaid2reademails.com/ and > I can't access it but people elsewhere can. When I ran anonymous > browsing it works. (another location) More bizzare!!! > This list seems to be working fine now, I just got a swag of emails > sworming in all at once. But when I see the date/time emails were > sent I see there is quite a delay in some hitting the inboxes. Maybe you should ask your ISP what happen... > But it's great to see people interested if the list is still > ACTIVE... Rather than forgetting it exists if people don't get > emails every so hours. The list has lovers.. :) :-) > Michelle, go back to your little box. Little Box ? > J Greetings Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/8845235667100 Strasbourg/France IRC #Debian (irc.icq.com) signature.pgp Description: Digital signature
[PHP-DB] Re: Virus?
Am 2005-07-05 11:32:33, schrieb [EMAIL PROTECTED]: > Hi! > > Re php-db, I've been getting a lot of returned mailed messages for messages I > never sent. > > What is happening? There is someone which target php.net because he/she must be very angry. I have gotten more the 300 of this bullshit and all blackliste because there is never a "From: [EMAIL PROTECTED]" or something similar which post to the list. > Tony Greetings Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/8845235667100 Strasbourg/France IRC #Debian (irc.icq.com) signature.pgp Description: Digital signature
[PHP-DB] Re: .
Am 2005-07-06 14:55:46, schrieb JeRRy: > Is there a way to "spoof" away php-db@lists.php.net who continues to > send a virus via this mailing list. Why does this address need > privlidges to send to the list anyway? The sender is using this to > make it look like from the list but we all know it's fake. Well most > do, I hope noone got caught out, because who's liable if they do? The > list owners? I hope not but it points that way. > > Or does that email address repressent something else to the list? > > I have not seen anyone consider pointing this out, or maybe the list > admin are not about as often as daily. In procmail: :0 * ^Mailing-List:.*(php-) * ^From:.*(MAILER-DAEMON|noreply|php-db|postmaster)@lists.php.net /dev/null > J Greetings Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/8845235667100 Strasbourg/France IRC #Debian (irc.icq.com) signature.pgp Description: Digital signature
[PHP-DB] Advanced search form
Hello *, I have a search form and I like to add advanced search options like "this is a search" -XXX Test which mean, 1) "this is a search" must be in this order 2) -XXXDo not find XXX contents 3) TestAND Does anyone has a PHP/PGSQL code sniplet? Thanks Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant ######### Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/8845235667100 Strasbourg/France IRC #Debian (irc.icq.com) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Eliminating character sets from DB entry
Am 2006-04-30 19:59:06, schrieb Chris Payne: > Hi there everyone, > > Is there a way to allow Only English character sets in database entry with > MySQL and PHP? I'm getting an awful lot of SPAM which is in > Chinese/Japanese and i'd love to be able to block these charactersets from > being inserted into my databases. ??? If you store your Messages in a MySQL database, the script, which store the messages schould check the "Content-Type:" Header before inserting. And second, you should roun spamassassin/spamc on each message before passing the message to the script... This two advices should you save some headache... Note: I have now over 7 million messages in my PostgreSQL and to 99,999% spamfree (using fetchmail, procmail and a php5 script). Greetings Michelle Konzack -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/8845235667100 Strasbourg/France IRC #Debian (irc.icq.com) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Sending filing attachments using PHP
Am 2006-05-12 10:09:46, schrieb JupiterHost.Net: > Right after rebuilding php and apache and breaking PHP funtionality for > everyone, just so you can send a semi complex MIME message? That is the > epitome of PHP's lameness and why I can't sit quietly by and not > recommend an easy to install and use and maintain solution. Hmmm, I send per day around 80.000 different E-Mails created with php5 most of them are mime-encoded and multipart... I do not know, which problems you have, but it works perfectly Even complex multiparts with message/rfc822 and binaries inside. OK, the message should not be bigger then 20 MByte except you have a machine like mine... 32 CPU's and 64 GByte of memory. > - no fiddling with apache No problem for apache 1.3 with php5 > - no fiddling with the interpretet binary apt-get install ... > - no possibility of breaking anyone's scripts It just works... So why bother wit a language no ene knows how this crappy syntax works? ;-) Greetings Michelle Konzack -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/6/6192519367100 Strasbourg/France IRC #Debian (irc.icq.com) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: PDF BLOB to Email
Am 2006-05-11 14:21:07, schrieb Adrian Bruce: > Hi > > I have pdf's stored as a blob in a MySQL database, how can i set a > script (PHP obviously!) to email these blobs as pdf files. The only way > i can think of at the moment is to write them to disk and then attach > them to the mail before sending it. This doesn't seem that efficient > but perhaps it is the only way?? Whay not create the E-Mail in memory and the echo it into "sendmail -t" This is what I do... The temporary files laying around (like after crasches or $USER abort) Greetings Michelle Konzack -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/6/6192519367100 Strasbourg/France IRC #Debian (irc.icq.com) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Sending filing attachments using PHP
Am 2006-05-12 15:39:44, schrieb JupiterHost.Net: > Why not use Perl, it has all the "pros" but does not have the cons :) Oh yes it has... Perl is a memory monster... I have no problems to soupport over 17.000 Users on 32 CPU machine with 64 GByte of memory using apache 1.3 and php5. Perl would just kill the machine... > In fact, I use it for several high volumn websites: > - with persistent database connections and persistently running > instances of the script >(which is the *only* positive PHP has, except it means running PHP > as "nobody" and with really really bad permissions) Why this? > - without doing *anything* with apache apache servs only websites and the output of the php... > - works with SuExec so it runs as the user so the permissions can be > 700 and config files 600 - try that with PHP without days of fiddling > and breaking stuff and finally giving up ;) Sorry? - I do exactly the same with my 17.000 users using suphp. Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/6/6192519367100 Strasbourg/France IRC #Debian (irc.icq.com) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Re: Sending filing attachments using PHP
Am 2006-05-12 11:58:37, schrieb JupiterHost.Net: > I was referring to building PHP/Apache in general * What do you talking about? -- I have compiled Apache and php5 the standard way and ABSOLUTLY NOTHING was missing. > >listen on a port lower than 1024, which is true for all tools since it's > >a platform limitation. > > * I'm speaking in generalitites of working with PHP not specifics > components of the technology. ??? > >Yeah, you're definitely smoking somethin'. The PEAR package Mail_Mime is > >another example of a pure-php class. It certainly does not use anything > >perl related at all. I'd really like to know what makes you think it does. > > I never said PEAR or any specific package used Perl, I'd simply offered > a better solution that happend to be done in Perl. No, it is NOT a better solution, because if I use perl I have to maintain TWO scripting languages and install I do not know how many modules from CPAN... maybe 100-200? > Good day to all, sorry if I was to ambiguouse or I've offended. Good by! -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/6/6192519367100 Strasbourg/France IRC #Debian (irc.icq.com) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] tsearch2, PHP5 with Bidi + US-ASCII
Hello Nerds, Geeks and Gurus, I have a multilingual Database of arround 380 to 390 GByte with data in environement 60 languages. the entired Database is INICODE. Since version 5, PHP is supporting UNICODE very nice, but whenever I want to search a bidi-string (farsi, arabic or hebrew) it returns nothing. Languages like chinese or russian are working perfect. Whats going wrong here? Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/6/6192519367100 Strasbourg/France IRC #Debian (irc.icq.com) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] tsearch2, PHP5 with Bidi + US-ASCII
Am 2006-09-08 06:53:10, schrieb Chris: > You're using postgres aren't you ? If you copy/paste the query and run Yes ;-) > it through psql do you get results? This is what I have already tried... and WHY I do not find the error. Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant ##### Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/6/6192519367100 Strasbourg/France IRC #Debian (irc.icq.com) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: tsearch2, PHP5 with Bidi + US-ASCII
Am 2006-09-11 10:40:06, schrieb Chris: > Michelle Konzack wrote: > >Am 2006-09-08 06:53:10, schrieb Chris: > > > >>You're using postgres aren't you ? If you copy/paste the query and run > > > >Yes ;-) > > considering tsearch was in the subject that was rather a silly question > wasn't it ;) > > >>it through psql do you get results? > > > >This is what I have already tried... and WHY I do not find the error. > > So you do get results running the query through psql but not through php? Yes. I have tested following: 1) Text to search has ONLY RTL language (farsi, arabic, hebrew) and search string is RTL. - Works perfectly using pgadmin and then a UNICODE Terminal with psql. 2) Text to search has ONLY RTL AND LTR language (e.g. farsi + german) and search string is RTL. - Works perfectly using pgadmin and then a UNICODE Terminal with psql. 3) Text to search has ONLY RTL AND LTR language (e.g. farsi + german) and search string is RTL AND LTR. - Failed on both pgadmin and psql. Then I have echoed the SELECT string from PHP5 into a RTL capable UNICODE viewer and all is shown right. This let my brain smoking... since I need this Type of search. If you search things like this in Google it works perfectly! Maybe Google IS God! Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/6/6192519367100 Strasbourg/France IRC #Debian (irc.icq.com) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: 20K photos
Am 2007-04-29 12:22:32, schrieb elk dolk: > Hi all, > Imagine that you want to put some 2 historical photos On display in > your website , you use PHP and MySQL. > Preparing a photo album with 200 photos is no problem but for 2 photos! > would you do it in the same way? > > Please comment. - END OF REPLIED MESSAGE - Where is the Problem? I have a PostgreSQL Database of 680 GByte on a Raid-5 (1,8 TByte) plus 130 million files on a extra partition of 7.2 TByte (Raid-5). I link it directly from the PostgreSQL over php into the FS. Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant ##### Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSN LinuxMichi 0033/6/6192519367100 Strasbourg/France IRC #Debian (irc.icq.com) signature.pgp Description: Digital signature
Re: [PHP-DB] html input element rendering html entities
Am 2009-07-16 12:37:32, schrieb Govinda: > I am newbie here, but isn't it that you just need to save at this ^^ > point the same way that you saved the data in the first place? > If it worked the first time, why not now? If you have a where you edit stuff, you can type a © and if you send it it will be encoded as ©. Now if you like to edit again, it will be inserted as © and NOT ©. This mean, you have to revert the © to a literal © before you show it in the . Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack c/o Shared Office KabelBW ICQ #328449886 +49/177/9351947Blumenstasse 2 MSN LinuxMichi +33/6/61925193 77694 Kehl/Germany IRC #Debian (irc.icq.com) signature.pgp Description: Digital signature
[PHP-DB] Re: test
Am 2004-01-28 16:32:39, schrieb Viorel Dragomir: >Please do NOT open attachments files without having an Antivirus installed. >Like this guys did. > >Sending emails with attachments to a list is not a common behaviour. >Thanks Which attachments ? It was only a pgp signature ! And, why install a Virus-Scanner ? I have a collection of mor then 8700 different Viruses and more then 800 MBytes in my Mail-Folders. Nothing dangerous for me. - I use the right Operating System. ;-) Michelle -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Weird error... (after server crash @ISP)
Hello Guys, I was just informed by a visitor, that a bunch of my websites show PHP/pgsql errors... Of course, they relay all on the same database scripts and now I discovered, that the physical server had an error, my ISP replaced the harddisks and put a backup of the content on it! Several month old! WTF? I am now for 6 month (or longer) in Estonia and have no physical access to my Backups in Strasbourg which really p..s me off! However, the offending sniplet is: 8<-- [47]} elseif (DB_TYPE == 'pgsql') { [48] [49] function db_connect($host=DB_HOST, $port=DB_PORT, $database=DB_NAME, $user=DB_USER, $pass=DB_PASS, $link='db_link') { [50]global $$link; [51]$$link = pg_pconnect("host=$host port=$port dbname=$database user=$user password=$pass"); [52]return $$link; [53] } [54] [55] function db_close($link='db_link') { [56]global $$link; [57]return pg_close($link); [58] } [59] [60] function db_error($query, $errno, $error) { [61]die("Error $errno$error$query"); [62] } [63] [64] function db_query($query, $link='db_link') { [65]global $$link; [66]$result = pg_query($link, $query) or db_error($query, '', pg_last_error($link)); [67]return $result; [68] } [69] [70] function db_fetch_array($db_query) { [71]return pg_fetch_array($db_query); [72] } [73] [74] function db_free_result($db_query) { [75]return pg_free_result($db_query); [76] [77] function db_fetch_fields($db_query) { [78]return pg_fetch_fields($db_query); [79] } [80] [81] function db_input($string, $link='db_link') { [82]return pg_escape_string($link, $string); [83]return addslashes($string); [84] } 8<-- [Sun May 28 12:14:20 2017] [error] [client 85.29.216.115] PHP Warning: pg_query() expects parameter 1 to be resource, string given in /srv/tdphp-vserver2/includes/01_database.inc on line 64 [Sun May 28 12:14:20 2017] [error] [client 85.29.216.115] PHP Warning: pg_last_error() expects parameter 1 to be resource, string given in /srv/tdphp-vserver2/includes/01_database.inc on line 64 The page show "Resource id #17". This script was working 68 days ago (before the crash) but it seems, I sit on my line and do not find the error. Any suggestions? Have a nice Sunday -- Michelle KonzackMiila ITSystems @ TDnet GNU/Linux Developer 00372-54541400 signature.asc Description: Digital signature
[PHP-DB] Re: Weird error... (after server crash @ISP)
Forgotten one thing: the calling script! 8<-- $db_link = db_connect(); $db_result = db_query($db_link, "SELECT serial,category FROM categories WHERE serial=0"); $cat_array = db_fetch_array($db_result); 8<-- -- Michelle KonzackMiila ITSystems @ TDnet GNU/Linux Developer 00372-54541400 signature.asc Description: Digital signature
[PHP-DB] [SOLVED] Re: Weird error... (after server crash @ISP)
I have not remarked, that > [64] function db_query($query, $link='db_link') { was messed up. It should be: function db_query($link='db_link', $query) { Thanks -- Michelle KonzackMiila ITSystems @ TDnet GNU/Linux Developer 00372-54541400 signature.asc Description: Digital signature