[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

Re: [PHP-DB] PHP mysqli is NOT trapping some errors when calling stored procedure

2019-02-12 Thread Venkat Hariharan
Yes, I do have all reqd privs. In fact, as long as a duplicate key situation isnt encountered, I am able to invoke the stored proc from PHP alright and the record gets saved in the database. But when I try to re-do it using the same value (thereby I am expecting that 1062-DUPLICATE KEY error

Re: [PHP-DB] PHP mysqli is NOT trapping some errors when calling stored procedure

2019-02-12 Thread Aziz Saleh
Do you have sufficient privileges to execute stored procedures (procs_priv) on PHP's end? On Tue, Feb 12, 2019 at 11:07 AM Venkat Hariharan wrote: > Can you take a look at the issue that I've described at > >

Fwd: [PHP-DB] PHP ODBC odbc_fetch_array returns uninitialized values for Booleans

2015-06-30 Thread Bruce Bailey
systems. Bruce -- Forwarded message -- From: Bastien Koert phps...@gmail.com Date: Mon, Jun 29, 2015 at 7:21 PM Subject: Re: [PHP-DB] PHP ODBC odbc_fetch_array returns uninitialized values for Booleans To: Bruce Bailey brucebailey...@gmail.com, php-db@lists.php.net

[PHP-DB] PHP ODBC odbc_fetch_array returns uninitialized values for Booleans

2015-06-29 Thread Bruce Bailey
*Description* The PHP function odbc_fetch_array returns uninitialized values for PostgreSQL boolean values. On older systems, this function returned '1' for true and '0' for false values. On our 64 bit system, the boolean values appear to be uninitialized data. *Additional information*

Re: [PHP-DB] PHP ODBC odbc_fetch_array returns uninitialized values for Booleans

2015-06-29 Thread Bastien Koert
Is it a truly a three state field (true, false, null) or just T/F? Perhaps a default value for the field might be better? On Mon, Jun 29, 2015 at 11:42 AM Bruce Bailey brucebailey...@gmail.com wrote: *Description* The PHP function odbc_fetch_array returns uninitialized values for PostgreSQL

[PHP-DB] php x64 VC11 ThreadSafe (experimental) and Firebird x64 support (on windows x64)

2015-05-05 Thread Delmar Wichnieski
dear members php x64 VC11 (experimental) does not yet support x64 firebird? When it will support? environment Windows Server 2012 R2 Datacenter x64 = OK Firebird 2.5.4 x64 = OK Apache Lounge 2.4.12 VC11 x64 = OK PHP 5.6.8 VC11 x64 = OK In the php.ini file extension=php_interbase.dll and

[PHP-DB] PHP 7 and sqlsrv

2015-04-10 Thread John Hermsen
I was wondering if there is anyone who manager to compile the sqlsrv driver for php 7. I have tried, but I haven't been able to get it compiled yet. Thanks, John

[PHP-DB] PHP 5.6 OpenSSL changes and mysqli

2015-02-09 Thread Chupaka
Hello. Since 5.6, all encrypted client streams now enable peer verification by default. The problem I faced is with MySQL connection: we're connecting to old MySQL server with self-signed certificate, and are using simple SSL connection without certificates: mysql_connect(address, user,

[PHP-DB] PHP 5.3 and mariadb 5.5.32 pam auth problem.

2013-08-16 Thread Rafał Radecki
Hi All. I have: - one devel application server with php53-mysql-5.3.27-1 MariaDB-compat-5.5.32-1.x86_64 MariaDB-common-5.5.32-1.x86_64 MariaDB-shared-5.5.32-1.x86_64 MariaDB-client-5.5.32-1.x86_64 - one devel database server with MariaDB-compat-5.5.30-1.x86_64 MariaDB-server-5.5.30-1.x86_64

[PHP-DB] php code for sending SMS

2012-09-26 Thread Dr Vijay Kumar
I wish to send a SMS to a mobile no. thru PHP/HTML. Any suggestions Please? -- Dr Vijay Kumar, E 9/18 Vasant Vihar, New Delhi-110 057 Ph: 09868 11 5354, 011-2615 4488 Email :Dr Vijay Kumarvaibhavinformat...@gmail.com

Re: [PHP-DB] php code for sending SMS

2012-09-26 Thread tamouse mailing lists
On Wed, Sep 26, 2012 at 1:18 AM, Dr Vijay Kumar vaibhavinformat...@gmail.com wrote: I wish to send a SMS to a mobile no. thru PHP/HTML. Any suggestions Please? Try an email - SMS gateway? http://en.wikipedia.org/wiki/List_of_SMS_gateways -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] PHP-DB] Re: No data?

2012-07-26 Thread Brad
I apologize, I may have been mistaken about the role of $_FILES but this - http://dev.mysql.com/doc/refman/5.0/en/load-data.html confuses me. The use of $_FILES with LOAD DATA is littered over the internet and manuals as a 1 shot deal. No hand off to another directory for storage till the next

Re: [PHP-DB] PHP-DB] Re: No data?

2012-07-26 Thread Karl DeSaulniers
Jim I believe your correct. Upload the file to temp move the file to your dir on your server and rename file you can also set the permissions of the file while moving it. put url to file (not temp file) in database (not the file contents) done Best, Karl On Jul 26, 2012, at 4:50 PM, Brad

RE: [PHP-DB] PHP-DB] Re: No data?

2012-07-26 Thread Brad
Drats, I think you are correct. :) -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Thursday, July 26, 2012 5:59 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] PHP-DB] Re: No data? Jim I believe your correct. Upload the file to temp move the file

[PHP-DB] PHP MySQL High CPU on Query

2012-06-12 Thread David Christensen
I have a situation where a query run from PHP/Zend Framework on a MySQL database seems to hit the CPU harder than the same query run via the MySQL command line. The query is a simple SELECT statement querying 2 tables, 12 columns with a short WHERE clause that filters the results to less than 100

[PHP-DB] PHP and two phase commit transactions

2012-05-26 Thread Christian Ferrari
Dear all, I'm the author of LIXA project (http://lixa.sourceforge.net/) and I would discuss a little about two phase commit transactions for PHP applications. Two phase commit means I can write a program that uses two (or more) Resource Managers (for example databases, like MySQL and PostgreSQL)

RE: [PHP-DB] [PHP] PHP Database Problems -- Code Snippets - Any more Ideas?

2012-05-04 Thread Gavin Chalkley
2012 15:10 To: php-db-lists.php.net; php-gene...@lists.php.net Subject: [PHP-DB] [PHP] PHP Database Problems -- Code Snippets - Any more Ideas? I am sending this again to see if more ideas for solution of this problem are available. Ethan === Dear list - Sorry for the attachment. Here

[PHP-DB] PHP Database Problems

2012-05-02 Thread Ethan Rosenberg
have a database mysql describe Intake3; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | Site | varchar(6) | NO | PRI | | | | MedRec | int(6) | NO |

RE: [PHP-DB] PHP Database Problems

2012-05-02 Thread Gavin Chalkley
: [PHP-DB] PHP Database Problems have a database mysql describe Intake3; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | Site | varchar(6) | NO | PRI

[PHP-DB] PHP Database Problems -- Code Snippets

2012-05-02 Thread Ethan Rosenberg
Dear list - Sorry for the attachment. Here are code snippets --- GET THE DATA FROM INTAKE3: function handle_data() { global $cxn; $query = select * from Intake3 where 1; if(isset($_Request['Sex']) trim($_POST['Sex']) != '' ) { if

Re: [PHP-DB] php adodb book suggestins

2012-01-27 Thread David McGlone
On Thu, 2012-01-26 at 11:59 +, Lester Caine wrote: David McGlone wrote: On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote: David McGlone wrote: can anyone suggest any good up to date books out there on php adodb. The only documentation on ADOdb is the website

Re: [PHP-DB] php adodb book suggestins

2012-01-27 Thread Lester Caine
David McGlone wrote: I started with PHP just before PHP5 was finally released, so never used PHP4, and found ADOdb very early on so have never used anything else. One gets stuck in one's way when something simply works ... Probably why I'm finding PDO such a backwards step having been

Re: [PHP-DB] php adodb book suggestins

2012-01-26 Thread David McGlone
On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote: David McGlone wrote: can anyone suggest any good up to date books out there on php adodb. The only documentation on ADOdb is the website http://adodb.sourceforge.net/#docs ... has ANYBODY seen it described in a php book? While I

Re: [PHP-DB] php adodb book suggestins

2012-01-26 Thread Lester Caine
David McGlone wrote: On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote: David McGlone wrote: can anyone suggest any good up to date books out there on php adodb. The only documentation on ADOdb is the website http://adodb.sourceforge.net/#docs ... has ANYBODY seen it

Re: [PHP-DB] php adodb book suggestins

2012-01-26 Thread Matijn Woudt
On Thu, Jan 26, 2012 at 12:06 PM, David McGlone da...@dmcentral.net wrote: On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote: David McGlone wrote: can anyone suggest any good up to date books out there on php  adodb. The only documentation on ADOdb is the website

[PHP-DB] php adodb book suggestins

2012-01-25 Thread David McGlone
can anyone suggest any good up to date books out there on php adodb. -- David M. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP, PDO and MS-SQL ?

2011-12-09 Thread Andreas
Hi, could someone tell me what I need to install and how to configure everything so that I can connect with PHP and PDO to a MS-SQL server? I have an OpenSuse 11.4 installation. I added the Apache-PHP repository and upgraded to PHP 5.3.8. php-mssql, -php-odbc, libfreetds and the

RE: [PHP-DB] PHP + SQLite - Issues with update

2011-10-21 Thread N . A . Morgan
] Sent: 21 October 2011 04:04 To: php-db@lists.php.net Subject: [PHP-DB] PHP + SQLite - Issues with update Hello, I am running into some issues trying to update a column in a table in a SQLite database using PHP on Windows and was hoping could get some help on this mailer. Here is the create

RE: [PHP-DB] PHP + SQLite - Issues with update

2011-10-21 Thread Prashant Prabhudesai (pprabhud)
Message- From: n.a.mor...@brighton.ac.uk [mailto:n.a.mor...@brighton.ac.uk] Sent: Friday, October 21, 2011 2:33 AM To: Prashant Prabhudesai (pprabhud); php-db@lists.php.net Subject: RE: [PHP-DB] PHP + SQLite - Issues with update Try using the query: $db-query(update SERVER set Token

[PHP-DB] PHP + SQLite - Issues with update

2011-10-20 Thread Prashant Prabhudesai
Hello, I am running into some issues trying to update a column in a table in a SQLite database using PHP on Windows and was hoping could get some help on this mailer. Here is the create and insert statement - CREATE TABLE SERVER ( IPAddress varchar(100) not null unique primary key, Token

[PHP-DB] PHP EOL

2011-07-02 Thread Karl DeSaulniers
Hello All, Happy pre independence for my American PHPers. And good health to all others. Have a quick question.. I have this code I use for the end of line characters used in my mailers. [Code] // Is the OS Windows or Mac or Linux if (strtoupper(substr(PHP_OS,0,5)=='WIN')) {

Re: [PHP-DB] PHP EOL

2011-07-02 Thread Karl DeSaulniers
On Jul 2, 2011, at 3:01 AM, Karl DeSaulniers wrote: Hello All, Happy pre independence for my American PHPers. And good health to all others. Have a quick question.. I have this code I use for the end of line characters used in my mailers. [Code] // Is the OS Windows or Mac or Linux if

[PHP-DB] PHP Delete confirmation

2011-04-28 Thread Chris Stinemetz
I have been trying to figure out how to add delete confirmation for the bellow snippet of code. I would prefer not to use javascript. Can anyone offer any advise on how to right the delete confirmation in PHP? Thank you in advance. P.S. I apologize for the indention. For some reason gmail messes

[PHP-DB] PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mysql.so'

2011-03-08 Thread Scott Wen
Hi, I installed mysql and php. Its OK. After I install php-mysql, the following messages come out. PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mysql.so' - libmysqlclient.so.15: cannot open shared object file: No such file or directory in Unknown on line

Re: [PHP-DB] PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mysql.so'

2011-03-08 Thread nagendra prasad
Are you getting any error msg while installing it. Try to get a new copy of php-mysql from internet and install it. On Tue, Mar 8, 2011 at 4:17 PM, Scott Wen wen.xue...@gmail.com wrote: Hi, I installed mysql and php. Its OK. After I install php-mysql, the following messages come out.

[PHP-DB] php as cgi and sqlite

2011-02-04 Thread Randolph Dohm
Hello, http://arado.sf.net is a URL database / Open Source Websearch Engine and RSS Reader, in c++ /qt using sqlite. the urlbase.sql is currently addressed by a Qt gui. There is as well the code for a php interface to address the urlbase.sql. The PDO does not interact proper, has anyone experience

[PHP-DB] PHP Search DB Table

2010-12-14 Thread Oliver Kennedy
Hello Everyone Apologies if I have not done this in the correct way, this is the first time I have turned to your for help so I am unaware if I have to submit this according to a certain protocol, if that is the case then please let me know and I will go through the proper channels. My

[PHP-DB] [PHP] mySQL query assistance...

2010-11-29 Thread Daniel P. Brown
On Mon, Nov 29, 2010 at 14:35, Don Wieland d...@dwdataconcepts.com wrote: Hi all, Is there a list/form to get some help on compiling mySQL queries? I am executing them via PHP, but do not want to ask for help here if it is no the appropriate forum. Thanks ;-)    Yes.    For MySQL queries,

Re: [PHP-DB] PHP Exercises

2010-10-31 Thread jn2
Sanjay Mantoor wrote: Twaha, I found PHP manual is best. Refer http://www.php.net/manual/en/ On Fri, Oct 31, 2008 at 1:49 PM, Twaha Uddessy udde...@yahoo.com wrote: Hello all, Iam new here,trying hard to study PHP.Can anyone help me with a link where I can get PHP exercises

Re: [PHP-DB] PHP application hosted on a dektop ubuntu(localhost) vs A .NET software installed on Windows

2010-08-06 Thread maarten
Hello, without further information, it is not really possible to give any kind of indication that a web app can replace the original app. We do not know what the original app is supposed to do, how it works, ... Having said that, I think most apps would be possible to transform to some web app.

Re: [PHP-DB] PHP application hosted on a dektop ubuntu(localhost) vs A .NET software installed on Windows

2010-08-06 Thread Vinay Kannan
Thanks for your reply Maarten, Its a hotel management application for a hotel.. Thanks, Vinay On Fri, Aug 6, 2010 at 1:03 PM, maarten maarten.fo...@edchq.com wrote: Hello, without further information, it is not really possible to give any kind of indication that a web app can replace the

Re: [PHP-DB] PHP application hosted on a dektop ubuntu(localhost) vs A .NET software installed on Windows

2010-08-06 Thread Vinay Kannan
Actually there is no customer registrations happening, its just a resturant and there wouldnt be any registrations and stuff, its a valid point of hosting it on a webserver and building it like any web app, but then internet connection might also be a problem in that area, and if the internet

[PHP-DB] PHP application hosted on a dektop ubuntu(localhost) vs A .NET software installed on Windows

2010-08-05 Thread Vinay Kannan
Hi, I need some help and its actually got nothing to do with any coding help. My friend owns a business and has been using a software developed on VB6.0 installed on a Windows XP it is a bit outdated though and I personally feel the company which sold the software has overdone the sales, coz I

[PHP-DB] PHP ERP Applications Need Suggestions????

2010-06-28 Thread Mohamed Hashim
*Hello everyone,* *I just want to develop a big ERP applications.Can anyone tell me which framework will be better for ERP (HR,Finance,Inventory,Production,Administration etc etc) means CakePHP,Codeigniter and also database PostgreSql or Mysql or shall i go with Core PHP? Thanks in advance

Re: [PHP-DB] PHP ERP Applications Need Suggestions????

2010-06-28 Thread Adriano Rodrigo Guerreiro Laranjeira
Hello! You should look at same good stable ERP's PHP based, and start your new project from one of them. By example: * BlueErp * Dolibarr * GNU Enterprise * WebERP Cheers, Adriano Laranjeira. On Mon, 28 Jun 2010 17:17:26 +0530 Mohamed Hashim nmdhas...@gmail.com wrote: *Hello everyone,*

[PHP-DB] PHP / iODBC / PostGreSQL: running into a deadlock

2010-05-24 Thread prometheus
Hi, I recently decided to setup my mac for some php developments. OS X 10.5 already ships with Apache, PHP and I chose PostGreSQL as DB server. I picked a package link from the official website and I installed it. The DB server is running smoothly. Now, as OS X's php module is not

Re: [PHP-DB] PHP / iODBC / PostGreSQL: running into a deadlock

2010-05-24 Thread Chris
To try to solve this issue, I grabed the sources for PHP (5.3.2) and libiodbc (3.52.7). When ran under GDB, I can observe the following: odbc_exec() [PHP code] calls SQLAllocStmt() [libiodbc code], which calls some internal function that tries to call SQLAllocStmt(), in some indirect recursive

[PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Alexander Schunk
Hello, i am writing a small login script for a website. The username and passwort are stored in a database in two separate columns. I have it like this: while($dbbenutzer = mysql_fetch_row($sqlbenutzername)) while($dbpasswort = mysql_fetch_row($sqlpasswort)){ echo

Re: [PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Karl DeSaulniers
Hi, Maybe try... $benutzername = $_GET['username']; $pass = $_GET['password']; $result = SELECT * FROM usertable WHERE sqlbenutzername='$benutzername'; while($r = mysql_fetch_row($result)) { $dbbenutzer = $r[sqlbenutzername]; $dbpasswort = $r[sqlpasswort]; }

Re: [PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Peter Lind
On 29 April 2010 15:00, Karl DeSaulniers k...@designdrumm.com wrote: Hi, Maybe try... $benutzername = $_GET['username']; $pass = $_GET['password']; $result = SELECT * FROM usertable WHERE sqlbenutzername='$benutzername'; Don't use values from $_GET without sanitizing first. If using

Re: [PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Karl DeSaulniers
Yes. You are correct. Did not include that part, sry. Dont forget mysql_real_escape_string. :) Karl On Apr 29, 2010, at 9:37 AM, Peter Lind wrote: On 29 April 2010 15:00, Karl DeSaulniers k...@designdrumm.com wrote: Hi, Maybe try... $benutzername = $_GET['username']; $pass =

Re: [PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Peter Lind
On 29 April 2010 16:44, Alexander Schunk asch...@gmail.com wrote: Hello, i have it now as follows: while($dbbenutzer = mysql_fetch_assoc($sqlbenutzername))        while($dbpasswort = mysql_fetch_assoc($sqlpasswort)){ You have things very twisted. Check the code posted by Karl - you only

[PHP-DB] php-db-unsubscr...@lists.php.net

2010-02-16 Thread Kevin Murphy
php-db-unsubscr...@lists.php.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP Objects and SQL Results

2010-02-13 Thread Moritz Fuchs
Hi, Why don't you just try the following: $query = SELECT * FROM foo WHERE UserID = .$uID . ORDER BY bar; $result = mysql_query($query); //get the first row $row = mysql_fetch_object($result); //get the next row while ($next = mysql_fetch_object($result)) { //do something with row/next

Re: [PHP-DB] PHP Objects and SQL Results

2010-02-13 Thread Richard Quadling
On 12 February 2010 23:46, Paul Hollingworth devine...@msn.com wrote: Thanks for the code Eric, it seems to loosely provide the functionality that I'm after. Just out of interest though, is there no other way to find the next result row in an object apart from dumping it into an array?

[PHP-DB] PHP Objects and SQL Results

2010-02-12 Thread Paul
Hi all, I'm currently having a problem correctly formatting a table within a while loop. I'm using an object to store the results of a query, and using the while to iterate through it each row to produce the output: $query = SELECT * FROM foo WHERE UserID = .$uID . ORDER BY bar; $result =

Re: [PHP-DB] PHP Objects and SQL Results

2010-02-12 Thread Eric Lee
On Sat, Feb 13, 2010 at 3:26 AM, Paul devine...@msn.com wrote: Hi all, I'm currently having a problem correctly formatting a table within a while loop. I'm using an object to store the results of a query, and using the while to iterate through it each row to produce the output: $query =

Re: [PHP-DB] PHP Objects and SQL Results

2010-02-12 Thread Paul Hollingworth
Thanks for the code Eric, it seems to loosely provide the functionality that I'm after. Just out of interest though, is there no other way to find the next result row in an object apart from dumping it into an array? Thanks, Paul Eric Lee wrote: On Sat, Feb 13, 2010 at 3:26 AM, Paul

Re: [PHP-DB] PHP Objects and SQL Results

2010-02-12 Thread Karl DeSaulniers
Hi Paul, Can't you just? $query = SELECT DISTINCT bar FROM foo WHERE UserID = .$uID; $result = mysql_query($query); while($obj = mysql_fetch_assoc($result) { $bar = $obj['bar']; if ($bar == something) { //do this } } I'm some what a beginner, so sorry if this

Re: [PHP-DB] PHP Objects and SQL Results

2010-02-12 Thread Eric Lee
On Sat, Feb 13, 2010 at 7:46 AM, Paul Hollingworth devine...@msn.comwrote: Thanks for the code Eric, it seems to loosely provide the functionality that I'm after. Just out of interest though, is there no other way to find the next result row in an object apart from dumping it into an array?

[PHP-DB] php, session_set_save_handler disappearing session vars

2010-02-04 Thread Jason Gerfen
I have used session classes before and am at a loss as to why I cannot for the life of me get this to work... Any help is appreciated. I might just be confused with the database connection handles in order to pull and store session information as there was some information posted on php.net

[PHP-DB] PHP Help with pagination

2010-01-28 Thread Karl DeSaulniers
Hey nagendra, I tried to post this a while ago, but it may be too long for the list. ?php if ($Submit) { // perform search only if correct form was entered. $db = mysql_connect ($Host, $User, $Password); mysql_select_db ($DBName) or die (Cannot connect to database); //check if the

[PHP-DB] PHP and MYSQL Update problem

2010-01-26 Thread Simone Fornara
Hello, I have a little problem with a sql command string $q = UPDATE episodes SET episode_title = '$_POST[episode_title]' , episode_scheduleddate = .strtotime($_POST['episode_scheduleddate']). , episode_description = '$_POST[episode_description]' WHERE episode_id = $_POST[episode_id]; I keep

Re: [PHP-DB] PHP and MYSQL Update problem

2010-01-26 Thread Manu Gupta
try .. $q = addslashes(UPDATE episodes SET episode_title = '$_POST[episode_title]' , episode_scheduleddate = .strtotime($_POST['episode_scheduleddate']). , episode_description = '$_POST[episode_description]' WHERE episode_id = $_POST[episode_id]); or try $q = UPDATE episodes SET episode_title =

Re: [PHP-DB] PHP and MYSQL Update problem

2010-01-26 Thread Chris
Manu Gupta wrote: try .. $q = addslashes(UPDATE episodes SET episode_title = '$_POST[episode_title]' , episode_scheduleddate = .strtotime($_POST['episode_scheduleddate']). , episode_description = '$_POST[episode_description]' WHERE episode_id = $_POST[episode_id]); or try $q = UPDATE episodes

Re: [PHP-DB] PHP Update query

2009-11-04 Thread Jason Gerfen
$query = UPDATE `clients` SET `company` = '$company', `contact` = '$contact', `phone` = '$phone', `city` = '$city' WHERE `clients`.`reference` =$client LIMIT 1; $client_result=mysql_query($query); // now check for errors mysql_error() mysql_errno() Sudheer Satyanarayana wrote: On Tuesday 03

[PHP-DB] PHP Update query

2009-11-02 Thread Ron Piggott
How do I test if an UPDATE query worked $query = UPDATE `clients` SET `company` = '$company', `contact` = '$contact', `phone` = '$phone', `city` = '$city' WHERE `clients`.`reference` =$client LIMIT 1; $client_result=mysql_query($query); ??? Ron

Re: [PHP-DB] PHP Update query

2009-11-02 Thread Chris
Ron Piggott wrote: How do I test if an UPDATE query worked $query = UPDATE `clients` SET `company` = '$company', `contact` = '$contact', `phone` = '$phone', `city` = '$city' WHERE `clients`.`reference` =$client LIMIT 1; $client_result=mysql_query($query); ???

Re: [PHP-DB] PHP Update query

2009-11-02 Thread Yves Sucaet
Hi Ron, Have a look at http://www.php.net/manual/en/function.mysql-info.php - Original Message - From: Ron Piggott ron@actsministries.org To: PHP DB php-db@lists.php.net Sent: Monday, November 02, 2009 11:59 PM Subject: [PHP-DB] PHP Update query How do I test if an UPDATE query

Re: [PHP-DB] PHP Update query

2009-11-02 Thread Sudheer Satyanarayana
On Tuesday 03 November 2009 11:29 AM, Ron Piggott wrote: How do I test if an UPDATE query worked $query = UPDATE `clients` SET `company` = '$company', `contact` = '$contact', `phone` = '$phone', `city` = '$city' WHERE `clients`.`reference` =$client LIMIT 1; $client_result=mysql_query($query);

[PHP-DB] PHP stored within mySQL table

2009-10-23 Thread Ron Piggott
I am working on a shopping cart ... specifically writing about the delivery time lines. I thought I would include the information pages (like store policies, contact us, about us) for my shopping cart within a mysql table. But I ran into a challenge when I got to the Delivery time line

[PHP-DB] PHP on Pear

2009-10-15 Thread Vinay Kannan
Hello, I've been programming on PHP for almost a year now, many examples that I've gone through or some of the reference books that I've read and many websites which show examples of PHP pgramming seem to be using PEAR package, and I've never used PEAR or any other Package, I was wondering whats

Re: [PHP-DB] PHP on Pear

2009-10-15 Thread Chris
Vinay Kannan wrote: Hello, I've been programming on PHP for almost a year now, many examples that I've gone through or some of the reference books that I've read and many websites which show examples of PHP pgramming seem to be using PEAR package, and I've never used PEAR or any other Package,

[PHP-DB] PHP output in the mySQL table

2009-09-10 Thread Ron Piggott
I am wondering if I can put PHP into a mySQL table. When I tried doing: echo stripslashes(mysql_result($article_titles_result,0,article)); The PHP coding displays, not rendered PHP. Any suggestions? Ron

Re: [PHP-DB] PHP output in the mySQL table

2009-09-10 Thread Chris
Ron Piggott wrote: I am wondering if I can put PHP into a mySQL table. When I tried doing: echo stripslashes(mysql_result($article_titles_result,0,article)); The PHP coding displays, not rendered PHP. You'd need to 'eval' it (http://www.php.net/eval), though be very careful as any php

[PHP-DB] php mysql calendar

2009-08-05 Thread nikos
Hello list Can someone suggest me a php mysql calender, easy configurable for special needs? I found some googling but the most of them query records form a specific table and its impossible to change the sql query. Thank you in advance Nikos

[PHP-DB] PHP won't return any records

2009-06-30 Thread Steve Fink
Everyone, I have never used the PHP mssql functions before, I am versed in MySql instead, I cannot get the following code to return any records. The variables $dbserver, $dbuser, $dbpasswd are defined in a config file and are being read and the connection is being made because I can change any

Re: [PHP-DB] PHP- Mysql problem

2009-06-28 Thread Gary
Daniel, Now that is just funny stuff... Have you tried http://lmgtfy.com/?q=access+denied+for+user+odbc+localhost or the newer http://www.lmbify.com/search.php?s=access+denied+for+user+odbc+localhost Daniel Brown danbr...@php.net wrote in message

[PHP-DB] PHP-Extension for Cego database

2009-06-18 Thread Bjoern Lemke
Hi folks, since I am providing an opensource dbms called cego ( more information about cego on my home page www.lemke-it.com ), I am interested in the integration of the database into PHP. Is there anyone out there who can support this and give me some hints ? Thanks in advance for any comment

RE: [PHP-DB] PHP-Extension for Cego database

2009-06-18 Thread Honey Hassan
GOOD afternon,to alll I am new to php,mysql i want to create user login account in a page please help me ,,, _ Drag n’ drop—Get easy photo sharing with Windows Live™ Photos.

[PHP-DB] PHP- Mysql problem

2009-06-18 Thread NADARAJAH SIVASUTHAN NADARAJAH
Dear all, When I try to retrive data from two tables using JOIN OR INNER JOIN it display error message given below; Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\wamp\www\ap_v5\inc\profile.inc.php on line

Re: [PHP-DB] PHP-Extension for Cego database

2009-06-18 Thread Bastien Koert
On Thu, Jun 18, 2009 at 2:00 AM, Bjoern Lemkele...@lemke-it.com wrote: Hi folks, since I am providing an opensource dbms called cego ( more information about cego on my home page www.lemke-it.com ), I am interested in the integration of the database into PHP. Is there anyone out there who

Re: [PHP-DB] PHP- Mysql problem

2009-06-18 Thread Bastien Koert
On Thu, Jun 18, 2009 at 6:03 AM, NADARAJAH SIVASUTHAN NADARAJAHnsivasut...@live.com wrote: Dear all,        When I try to retrive data from two tables using JOIN OR INNER JOIN it display error message given below; Warning: mysql_query() [function.mysql-query]: Access denied for user

Re: [PHP-DB] PHP- Mysql problem

2009-06-18 Thread Daniel Brown
On Thu, Jun 18, 2009 at 06:03, NADARAJAH SIVASUTHAN NADARAJAHnsivasut...@live.com wrote: Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\wamp\www\ap_v5\inc\profile.inc.php on line 285

[PHP-DB] php 5.2.9 and Postgres 8.3.7

2009-06-17 Thread Didier Gasser-Morlay
Hello, I tried all day yesterday to setup a brand new machine with a fresh Linux install; with apache 2.2.10 (from source) php 5.2.9 (from source) and PostgresQL 8.3.7 (from the very neat one-click installer provided by Enterprisedb) ; everything compiles and installs fine but when trying to

Re: [PHP-DB] php 5.2.9 and Postgres 8.3.7

2009-06-17 Thread danaketh
Do you have postgres module for PHP installed? This will probably be the cause. Didier Gasser-Morlay napsal(a): Hello, I tried all day yesterday to setup a brand new machine with a fresh Linux install; with apache 2.2.10 (from source) php 5.2.9 (from source) and PostgresQL 8.3.7 (from the

Re: [PHP-DB] php 5.2.9 and Postgres 8.3.7

2009-06-17 Thread Didier Gasser-Morlay
Lester, Sorry, I should have said: Yes: Postgres is up running happily on the machine yes : Postgres is listed in phpinfo; with the correct version; php was connecting fine to the dababase, this message only happens on the 1st query which is when the function pg_escape_string is called.

Re: [PHP-DB] php 5.2.9 and Postgres 8.3.7

2009-06-17 Thread Didier Gasser-Morlay
Lester, Sorry, I should have said: Yes: Postgres is up running happily on the machine yes : Postgres is listed in phpinfo; with the correct version; php was connecting fine to the dababase, this message only happens on the 1st query which is when the function pg_escape_string is called.

[PHP-DB] php and mysql image script

2009-05-28 Thread Wilson Osemeilu
I need a simple php mysql image upload script with display script too and to make this easier the mysql database table to use  

Re: [PHP-DB] php and mysql image script

2009-05-28 Thread Bastien Koert
On Thu, May 28, 2009 at 4:19 PM, Wilson Osemeilu engrwi...@yahoo.comwrote: I need a simple php mysql image upload script with display script too and to make this easier the mysql database table to use STFW -- Bastien Cat, the other other white meat

Re: [PHP-DB] PHP Postgres - query not writing to database.

2009-05-11 Thread Carol Walter
I have copied the queries into psql and wrapped them in a BEGIN and COMMIT. Even from psql the queries appear to work but don't store the information. There don't appear to be errors in the log either. Thanks for your help, Carol km_tezt=# begin; BEGIN km_tezt=# INSERT INTO

Re: [PHP-DB] PHP Postgres - query not writing to database.

2009-05-11 Thread Carol Walter
To all who helped. Thank you very much. I found the problem. There is a leading blank on the last name field that I couldn't see. It was coming from my program code. Thanks for all your help. Carol On May 11, 2009, at 4:23 PM, Carol Walter wrote: I have copied the queries into psql

Re: [PHP-DB] PHP Postgres - query not writing to database.

2009-05-11 Thread danaketh
Glad that you found the problem :) Carol Walter napsal(a): To all who helped. Thank you very much. I found the problem. There is a leading blank on the last name field that I couldn't see. It was coming from my program code. Thanks for all your help. Carol On May 11, 2009, at 4:23 PM,

Re: [PHP-DB] PHP Postgres - query not writing to database.

2009-05-10 Thread danaketh
I'd suggest you to copy the echoed queries and run them directly in terminal (if you have access). Also if you have remote access to the database and can use tools like pgAdmin or Navicat, that could help you with testing. Or send me the table structure and I'll try them myself ;) Carol

[PHP-DB] PHP Postgres - query not writing to database.

2009-05-08 Thread Carol Walter
Hello, I have a PHP program that contains a number of postgres queries. At the end of the program, it needs to write data to a database. You can see the code that I'm using below. I have die clauses on all the queries and I have the program echoing the queries that it runs to the

[PHP-DB] PHP Generator

2009-04-29 Thread conor mahaney
Thanks for all the suggestions. I just going to keep my head down and keep learning and practicing, I probably be sending many more questions conor _ Windows Live™ SkyDrive™: Get 25 GB of free online storage.

[PHP-DB] php generators

2009-04-28 Thread conor mahaney
Hello Everyone, I am a beginner with PHP and Mysql and have dived into a project that may be to much for me right now. I am still learning php and do not have enough knowledge to accomplish what I am trying to. I have been looking into PHP code generators and was wondering if anyone has any

Re: [PHP-DB] php generators

2009-04-28 Thread Jonathan Langevin
Most code generators are bloated, poorly designed, and just plain trouble.The only code generator that I currently like, is the one for CakePHP, but you'll have to do some heavy reading to get up-to-speed on how to develop with Cake (especially considering it uses Object Oriented development

Re: [PHP-DB] php generators

2009-04-28 Thread harvey
Dreamweaver has some php generation. That's how I started to learn. I am not an expert by any means, and I am sure that experts will not like the code, but for a beginner, I found it totally fine On 4/28/2009 12:40 PM, conor mahaney wrote: Hello Everyone, I am a beginner with PHP and Mysql

  1   2   3   4   5   6   7   8   9   10   >