[PHP-DB] PHP & MySQL High CPU on Query

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] mySQL query assistance...

On Mon, Nov 29, 2010 at 14:35, Don Wieland 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, write to the MySQL G

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

On 29 April 2010 16:44, Alexander Schunk 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 need *ONE* row

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

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 wrote: Hi, Maybe try... $benutzername = $_GET['username']; $pass = $_GET['password']; $result = "SELE

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

On 29 April 2010 15:00, Karl DeSaulniers 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 mysql_* functions,

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

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"]; } if($b

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

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 $dbbenutz

[PHP-DB] php mysql calendar

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

Re: [PHP-DB] PHP- Mysql problem

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" wrote in message news:ab5568160906180636r239f214eh7e4871da7139c...@mail.g

Re: [PHP-DB] PHP- Mysql problem

On Thu, Jun 18, 2009 at 06:03, NADARAJAH SIVASUTHAN NADARAJAH 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 http://google.com/search?q=Access%20denied%20for%20user%

Re: [PHP-DB] PHP- Mysql problem

On Thu, Jun 18, 2009 at 6:03 AM, NADARAJAH SIVASUTHAN NADARAJAH 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 > 'ODBC

[PHP-DB] PHP- Mysql problem

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 285

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

Micah Gersten wrote: Chris wrote: Micah Gersten wrote: Chris wrote: Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli Either mysqli or pdo since they'd deal with the mysql client directly. ADODB is a php library, so it's not going to be as fast because you have php

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

Chris wrote: > Micah Gersten wrote: >> Chris wrote: >>> Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli >>> Either mysqli or pdo since they'd deal with the mysql client directly. >>> >>> ADODB is a php library, so it's not going to be as fast because

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

YVES SUCAET wrote: How does the "default" php_mysql.dll compare to these? Is mysqli faster than mysql? I'd call that a native driver. No idea about mysqli vs mysql. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

Micah Gersten wrote: Chris wrote: Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli Either mysqli or pdo since they'd deal with the mysql client directly. ADODB is a php library, so it's not going to be as fast because you have php code overhead. ADODB is precompi

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

Chris wrote: > Micah Gersten wrote: >> Which is the fastest driver for this? >> ADODB >> PDO >> mysqli > > Either mysqli or pdo since they'd deal with the mysql client directly. > > ADODB is a php library, so it's not going to be as fast because you > have php code overhead. > ADODB is precompiled

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

How does the "default" php_mysql.dll compare to these? Is mysqli faster than mysql? tia, Yves -- Original Message -- Received: Wed, 19 Nov 2008 04:00:46 PM CST From: Chris <[EMAIL PROTECTED]> To: Micah Gersten <[EMAIL PROTECTED]>Cc: PHP DB Subject: Re: [PHP-DB] P

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli Either mysqli or pdo since they'd deal with the mysql client directly. ADODB is a php library, so it's not going to be as fast because you have php code overhead. -- Postgresql & php tutorials http://www.designmagic

[PHP-DB] PHP MySQL Driver Choice -- Fastest?

Which is the fastest driver for this? ADODB PDO mysqli Anything else? -- Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP-MySQL connection for particular module

I should've checked the assumption. A little strange though for a scripting language. I'd say, since default behaviour of mysql_* functions is to assume the last opened link when a parameter is not passed, and since default behaviour is to evaluate null, false and 0 the same, mysql_* functions sho

Re: [PHP-DB] PHP-MySQL connection for particular module

> [new code] > if (!mysql_connect($a, $b, $c)) return; > > if (!mysql_select_db($dbname)) return; > > $res = mysql_query("SELECT * FROM manual;", $link); > [/new code] Isn't going to work because $link is not defined and definitely not a resource like mysql_query expects. > OR, optionally, to

Re: [PHP-DB] PHP-MySQL connection for particular module

-275 wrote: > > > > http://myprojects.srhost.info > eric{at}myprojects{dot}srhost{dot}info > - Original Message - > From: "bateivan" <[EMAIL PROTECTED]> > To: > Sent: Tuesday, June 17, 2008 11:19 PM &g

Re: [PHP-DB] PHP-MySQL connection for particular module

It's great that you got your problem solved :). On Thu, Jun 19, 2008 at 12:30 PM, bateivan <[EMAIL PROTECTED]> wrote: > > Hello Isaak, > > You've scored the bulleye! It works! > Also, I tested by including "common.php" instead of "database.php" and it > worked too. > This solution is perfect for

Re: [PHP-DB] PHP-MySQL connection for particular module

Hello Isaak, You've scored the bulleye! It works! Also, I tested by including "common.php" instead of "database.php" and it worked too. This solution is perfect for me as I can keep my code compact and tidy. I would, definetely, recommend this site to my fellow developers. Thank you very much,

Re: [PHP-DB] PHP-MySQL connection for particular module

What you said wasn't wrong - you'd just produce a couple of warnings. By taking away the assignment of the $link variable you're unsetting it, meaning it will have a value equal to NULL. All of the following should work. [old code] if (!($link = mysql_connect($a, $b, $c))) return; if (!mysql_sele

Re: [PHP-DB] PHP-MySQL connection for particular module

My mistake then, it's been a while that I used it that way so some things do fade away from my mind. On Thu, Jun 19, 2008 at 1:57 AM, Chris <[EMAIL PROTECTED]> wrote: > Isaak Malik wrote: > > Because then the connection resource isn't stored in the $link variable > > and you will be able to use t

Re: [PHP-DB] PHP-MySQL connection for particular module

Isaak Malik wrote: > Because then the connection resource isn't stored in the $link variable > and you will be able to use the mysql functions without passing that > variable to each function. RTM again. The link parameter is completely optional. If you don't specify it, it uses the last connect

Re: [PHP-DB] PHP-MySQL connection for particular module

To Evert: 4. I am posting some of my code to compare. Module "carmade.php" works v.s. "login.php" which does not. Also, I am posting my "database.php" which is establishing the connection and is included in every page through "layout.php"->"common.php"->"database.php". To bateivan: I can only gu

Re: [PHP-DB] PHP-MySQL connection for particular module

Pastebin works lots better when you're posting code: www.pastebin.com I don't see your database.php included in both of these modules. Where do you include it? EVert On Wed, Jun 18, 2008 at 9:38 PM, bateivan <[EMAIL PROTECTED]> wrote: > > Hello, > > To answer these qwestions: > 1. I am using "in

Re: [PHP-DB] PHP-MySQL connection for particular module

Hello, To answer these qwestions: 1. I am using "include" in my code. 2. About the "$link = mysql_connect('localhost', 'root', 'testing');" variable. I can just include this line before mysql_query function and it works even without entering into mysql_query the "$link" variable. (Like the connec

Re: [PHP-DB] PHP-MySQL connection for particular module

Thank you, Chris, I tried your suggestion using regular connection. Unfortunately, I got the same result. See my reply to Isaak,s reply where I am going to post portion of my code to visualize what I am talking about. Thanx again chris smith-9 wrote: > > >> It means that either your mysql co

Re: [PHP-DB] PHP-MySQL connection for particular module

Because then the connection resource isn't stored in the $link variable and you will be able to use the mysql functions without passing that variable to each function. On Wed, Jun 18, 2008 at 1:51 AM, Chris <[EMAIL PROTECTED]> wrote: > > > It means that either your mysql conenction details are no

Re: [PHP-DB] PHP-MySQL connection for particular module

excuseme but, you can access by terminal? [shell] ODBC is the user? or is a ODBC database? Please answer me and i can help you. **Excuse me my english is bad. :( El 17/06/2008, a las 06:51 p.m., Chris escribió: It means that either your mysql conenction details are not correctly set or th

Re: [PHP-DB] PHP-MySQL connection for particular module

> It means that either your mysql conenction details are not correctly set or > the connection resource isn't accessible for your mysql functions. I suggest > you first try by replacing: > > $link = mysql_pconnect('localhost', 'root', 'testing'); > > into: > > mysql_pconnect('localhost', 'root'

Re: [PHP-DB] PHP-MySQL connection for particular module

http://myprojects.srhost.info eric{at}myprojects{dot}srhost{dot}info - Original Message - From: "bateivan" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 17, 2008 11:19 PM Subject: [PHP-DB] PHP-MySQL connection for p

Re: [PHP-DB] PHP-MySQL connection for particular module

If you get an error of this kind: "Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\Program Files\Apache Software Foundation\Apache2.2\htdocs\login.php on line 17 Warning: mysql_query() [function.mysql-query]: A link to the server

[PHP-DB] PHP-MySQL connection for particular module

Hello, First of all, please, have in mind that I am new in this business. I have a problem connecting with data base in one particular module. That's right. The rest of the modules can connect to db, update tables with new info but this one is refusing giving me message like this: "Warning: mys

Re: [PHP-DB] php + mysql + copy file

Hi, try this, $carpeta = $_SERVER['DOCUMENT_ROOT']."/subidos"; // nombre de la carpeta ya creada. chmool 777 (todos los permisos) copy($_FILES['file']['tmp_name'] , $carpeta . $_FILE['file']['name']); Regards, Tacio Vilela 2008/4/2 Chris <[EMAIL PROTECTED]>: > > $carpeta = "subidos";

Re: [PHP-DB] php + mysql + copy file

$carpeta = "subidos"; // nombre de la carpeta ya creada. chmool 777 (todos los permisos) copy($_FILES['file']['tmp_name'] , $carpeta . '/' . $_FILE ['file']['name']); It's $_FILES not $_FILE (an 's' on the end). It's always worth using error_reporting(E_ALL) and ini_set('d

[PHP-DB] php + mysql + copy file

Hello I have the next code: -- archive_a_subir.php -- In archive_subir.php: You can see this in http://www.portbora.com.ar/foro/archivo_a_subir.php, when I run these appears the next warning Warning: copy(subidos/) [

Re: [PHP-DB] PHP, MySQL and Lookups

On Wed, Feb 27, 2008 at 9:52 AM, Tobias Franzén <[EMAIL PROTECTED]> wrote: > Consider this, if you have not already: > What if two users happen to have the same password? > > It is wrong to assume that no two users will never have the same > password. Doing an update like that, just based on th

Re: [PHP-DB] PHP, MySQL and Lookups

Daniel Brown wrote: On Tue, Feb 26, 2008 at 8:55 AM, Henry Felton <[EMAIL PROTECTED]> wrote: Hi everyone, I'm just getting into PHP at the moment and was wondering; what code would I need to look at a field value entered in a form, then if that value is found in my table, enter all the ot

Re: [PHP-DB] PHP, MySQL and Lookups

On Tue, Feb 26, 2008 at 8:55 AM, Henry Felton <[EMAIL PROTECTED]> wrote: > Hi everyone, > > I'm just getting into PHP at the moment and was wondering; what code would I > need to look at a field value entered in a form, then if that value is found > in my table, enter all the other information e

RES: [PHP-DB] PHP, MySQL and Lookups

2008 10:55 Para: php-db@lists.php.net Assunto: [PHP-DB] PHP, MySQL and Lookups Hi everyone, I'm just getting into PHP at the moment and was wondering; what code would I need to look at a field value entered in a form, then if that value is found in my table, enter all the other information enter

Re: [PHP-DB] PHP, MySQL and Lookups

On Feb 26, 2008, at 8:55 AM, Henry Felton wrote: Hi everyone, I'm just getting into PHP at the moment and was wondering; what code would I need to look at a field value entered in a form, then if that value is found in my table, enter all the other information entered in the form, to the

[PHP-DB] PHP, MySQL and Lookups

Hi everyone, I'm just getting into PHP at the moment and was wondering; what code would I need to look at a field value entered in a form, then if that value is found in my table, enter all the other information entered in the form, to the other fields on that record. Basically, what I'm trying to

Re: [PHP-DB] PHP/MySQL - Matrix

Eduardo Vizcarra wrote: Hi Chris How do I save the matrix in the session ? Actually, my first question is, what do you mean by a session ? http://www.php.net/session Look under the examples. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www

Re: [PHP-DB] PHP/MySQL - Matrix

Hi Chris How do I save the matrix in the session ? Actually, my first question is, what do you mean by a session ? Regards Eduardo "Chris" <[EMAIL PROTECTED]> escribió en el mensaje news:[EMAIL PROTECTED] > >> When I get all the records from the photos table, I am using a web page >> to displ

Re: [PHP-DB] PHP/MySQL - Matrix

When I get all the records from the photos table, I am using a web page to display only the first record, then, if the user hits a next link then the user should be able to see the next record (next picture) and so on, I do not want to do a select every time the user hits next or back to get t

[PHP-DB] PHP/MySQL - Matrix

Hi, I am developing a web site where I have a photos table, several records from the photos table can be linked to a different table referentially. When I do a SELECT to all photos records I can get multiple records, I do not have any problems doing this, the problem is all the procedure after

Re: [PHP-DB] PHP + MySQL

On 7/18/07, Dan Maret <[EMAIL PROTECTED]> wrote: I just can't figure it out and Google yielded no help. I have a table named 'settings' which contains two fields, 'item' and 'content'. What I would like to do is grab that data and use the 'item' field as the name, and use the respective 'content

[PHP-DB] PHP + MySQL

I just can't figure it out and Google yielded no help. I have a table named 'settings' which contains two fields, 'item' and 'content'. What I would like to do is grab that data and use the 'item' field as the name, and use the respective 'content' as the value in an array. For Example: Array (

Re: [PHP-DB] PHP & MySQL Issue!

On Jul 12, 2007, at 9:50 PM, Austin C wrote: Hello, I dont get any errors. Just a blank page. But, I go to the database, and it did what I told it to with the header table, but not with the circulation table. After you built the SQL for the circulation table, you did not execute it [with

Re: [PHP-DB] PHP & MySQL Issue!

On Jul 12, 2007, at 9:50 PM, Austin C wrote: Hello, I dont get any errors. Just a blank page. But, I go to the database, and it did what I told it to with the header table, but not with the circulation table. Check your error log or add this as the first line in your script. ini_set('displa

Re: [PHP-DB] PHP/MySQL UTF-8 SNAFU

Charles Sheinin napsal(a): Ok, so I have a fully UTF-8 MySQL database with a fully UTF-8 table. I have a php page which has "content="application/xhtml+xml; charset=utf-8" />" at the top of the html section and "mysql_set_charset("utf8");" after my connection (it's php 2.2.3, so that's more or

Re: [PHP-DB] PHP & MySQL Issue!

Hello, I dont get any errors. Just a blank page. But, I go to the database, and it did what I told it to with the header table, but not with the circulation table. On 7/12/07, Niel <[EMAIL PROTECTED]> wrote: Hi Give us a clue? What's the error(s) you get returned? -- Niel Archer -- PHP Databa

Re: [PHP-DB] PHP & MySQL Issue!

Austin C wrote: Hello everyone, im trying to use PHP to create 2 tables in a database and populate them with tables, however, it just wont work. Where does it stop working? Looks fine from what you've shown us but you need to track down the problem a bit further. -- Postgresql & php tutoria

Re: [PHP-DB] PHP & MySQL Issue!

Hi Give us a clue? What's the error(s) you get returned? -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP & MySQL Issue!

- Original Message - From: "Austin C" <[EMAIL PROTECTED]> To: Sent: Friday, July 13, 2007 8:41 AM Subject: [PHP-DB] PHP & MySQL Issue! > Hello everyone, im trying to use PHP to create 2 tables in a database and > populate them with tables, however, it just

[PHP-DB] PHP & MySQL Issue!

Hello everyone, im trying to use PHP to create 2 tables in a database and populate them with tables, however, it just wont work. Here is my full code: Install- Processing Database Info . . . . . "; $cxn = mysqli_connect($hostname,$dbusername,$dbpassword,$dbname) or die ("Basic Library Sy

Re: [PHP-DB] PHP/MySQL UTF-8 SNAFU

Hi What functions are you using? Many of PHP's functions are not multibyte aware and default to ASCII. I had this problems myself end of last year. -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP/MySQL UTF-8 SNAFU

Ok, so I have a fully UTF-8 MySQL database with a fully UTF-8 table. I have a php page which has "content="application/xhtml+xml; charset=utf-8" />" at the top of the html section and "mysql_set_charset("utf8");" after my connection (it's php 2.2.3, so that's more or less the same as "mysql_quer

[PHP-DB] PHP - MySQL webhosting

If anyone is interested in some VERY good webhosting that has support for PHP and MySQL, please take a look at the following link: http://www.sturdyhosting.com/idevaffiliate/idevaffiliate.php?id=100 They offer domain names for $8.95 and also webhositng solutions for as low as $2.95 per month.

[PHP-DB] PHP - MySQL webhosting

If anyone is interested in some VERY good webhosting that has support for PHP and MySQL, please take a look at the following link: http://www.sturdyhosting.com/idevaffiliate/idevaffiliate.php?id=100 They offer domain names for $8.95 and also webhositng solutions for as low as $2.95 per month.

[PHP-DB] PHP-MySQL CMS Generator

Does anyone know of a program that can generate a good Content Management System? For example, it would ask which fields to add to a database table, the types of the fields, etc and create the database in MySQL and php's to manage the data. I did find a few such programs already (AppGini, PHPRunn

RE: [PHP-DB] PHP/Mysql search

Thanks, I have somewhere to start! Eustace -Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 4:10 PM To: [EMAIL PROTECTED]; php-db@lists.php.net Subject: RE: [PHP-DB] PHP/Mysql search http://www.weberdev.com/get_example-4236.html is an example

Re: [PHP-DB] PHP/Mysql search

Miguel Guirao wrote: CREATIVITY is what you are looking for. What do you mean by CREATIVITY? -J -Original Message- From: Eustace [mailto:[EMAIL PROTECTED] Sent: Lunes, 22 de Mayo de 2006 07:59 a.m. To: php-db@lists.php.net Subject: [PHP-DB] PHP/Mysql search Hello, Please be

RE: [PHP-DB] PHP/Mysql search

http://www.weberdev.com/get_example-4236.html is an example that I wrote that does this bastien From: "Eustace" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> To: Subject: [PHP-DB] PHP/Mysql search Date: Mon, 22 May 2006 14:58:59 +0200 Hello, Please be patient

RE: [PHP-DB] PHP/Mysql search

CREATIVITY is what you are looking for. -Original Message- From: Eustace [mailto:[EMAIL PROTECTED] Sent: Lunes, 22 de Mayo de 2006 07:59 a.m. To: php-db@lists.php.net Subject: [PHP-DB] PHP/Mysql search Hello, Please be patient and assist meI am building a web application where a

[PHP-DB] PHP/Mysql search

Hello, Please be patient and assist meI am building a web application where a search function is required. I have a number of drop down lists from which a user has to select what they are searching for..they may choose to do a multi-fields search or search only one. Are there any resources yo

[PHP-DB] PHP/MySQL/Linux developer needed in Long Beach, CA

Hello, We're looking for a PHP developer to work on-site in Long Beach to start immediately. Job description is below. Thanks, Christian Internet Transaction Services, Inc. - An Internet Paymenet Processing company located in Long Beach, CA is looking to hire a contract PHP developer

Re: [PHP-DB] PHP, MySQL and Apache

Hi kinfe, To connect to myql from php you only need build your php with mysql support. Now, for render vxml documents you are using apache o IIS ? I recommend LAMP (Linux+Apache+Myql+Php) Regards, Luis Morales On Mon, 2006-02-27 at 16:07 +0100, Kinfe Tadesse wrote: > Hi all, > > I intend

RE: [PHP-DB] PHP, MySQL and Apache

@lists.php.net Subject: [PHP-DB] PHP, MySQL and Apache Hi all, I intend to create a database to be accessed from a voice application. I plan to use MySQL as a database engine and PHP as a scripting language to generate dynamic VoiceXML documents. However, I have two questions I could not get answers to

[PHP-DB] PHP, MySQL and Apache

Hi all, I intend to create a database to be accessed from a voice application. I plan to use MySQL as a database engine and PHP as a scripting language to generate dynamic VoiceXML documents. However, I have two questions I could not get answers to: 1. Do I need to install Apache to work with

[PHP-DB] PHP, MySQL, XML books recommendation

hi guys, any recommendation on good books or resources for me? I'm totally clueless about XML but would love to pick it up now. Any one can give me titles of good books? thanks!! look forward to hear from you, hwee

RE: [PHP-DB] Php-MySQL general function for insert, update,delete, count query

ase query failed: ". mysql_error(); }else{ return $result; }//end if }//end function ?> bastien From: "Rasim ÞEN" <[EMAIL PROTECTED]> Reply-To: "Rasim ÞEN" <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject:

[PHP-DB] Php-MySQL general function for insert, update,delete, count query

Hi friends, I am using one perfect function for my queries for PHP+Oracle pages, this is below == function sorgu($sql) { global $baglanti; $stmt=ociparse($baglanti,$sql); $sonuc=ociexecute($stmt,OCI_DEFAULT); $erra=OCIError(); $e=$erra['mes

RE: [PHP-DB] PHP/MySQL with Javascript

you can supply the value to js as a hidden variable in the form bastien From: "Chris Payne" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] PHP/MySQL with Javascript Date: Wed, 15 Jun 2005 16:55:32 -0400 Hi there everyone, Just a quick question, I have a login system that st

Re: [PHP-DB] PHP/MySQL with Javascript

You can have PHP generate a small javascript section where you define the variables or you can use cookies. - Frank > Hi there everyone, > > > > Just a quick question, I have a login system that stores whether you are > logged in or not with a PHP Session. However, I need it so when people >

[PHP-DB] PHP/MySQL with Javascript

Hi there everyone, Just a quick question, I have a login system that stores whether you are logged in or not with a PHP Session. However, I need it so when people submit a form to add an item to their cart that Javascript can pickup the PHP Value of whether people are logged in or not. I don'

[PHP-DB] PHP/MySQL Access Denied

Everybody's favorite problem but this one is strange. I can connect to my mysql 4.1.7 database fine from the command line, but php won't connect no matter what I try, I always get the same error. Here is the script close(); ?> This is what I get, doesn't matter what username/password I use, o

RE: [PHP-DB] PHP&MySQL left/substring etc problem

quot;; (B?> (B (BThat prints out a list of all the keys and values of $row and tells you what (Bcolumns you're receiving (and their names). (B (BJos (B (B-Original Message- (BFrom: Sugimoto [mailto:[EMAIL PROTECTED] (BSent: 19 April 2005 07:58 (BTo: php-db@lists.php.net (BS

Re: [PHP-DB] PHP&MySQL left/substring etc problem

> But when I tried, "select left (loc1,3) from openart_table where.." Try without the space between 'left' and '(', I mean... LEFT(loc1, 3) where loc1 is the name of the column, and 3 the characters you want to show. -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevide

[PHP-DB] PHP&MySQL left/substring etc problem

Hello, (BI need your help about PHP (ver 4.3.1) and MySQL (ver 3.23) database. (BI am struggling to customise a database (using left command etc), and am (Bstuck now. (BPlease have a brief look at my scripts below. (B (BWhat I do like to do is to get first 3 letters from "loc1" column from (

RE: [PHP-DB] PHP, MySQL and phpMyAdmin versions...

> -Original Message- > From: Bastien Koert [mailto:[EMAIL PROTECTED] > > huh? you can and should be able to upgrade to 4.0.x without too many > problems. PHP 4.3.9 has no problems with that, nor will PHPMyAdmin. Moving > to mySQL 4.1 will involve more pain as the protocols are vastly diff

RE: [PHP-DB] PHP, MySQL and phpMyAdmin versions...

the folders from the v3 db to the data folder in the v4 db) hth bastien From: Mark Benson <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP, MySQL and phpMyAdmin versions... Date: Fri, 17 Dec 2004 15:58:08 + I am running MySQL 3.23.49 under Windows NT (XP Home). I also r

[PHP-DB] PHP, MySQL and phpMyAdmin versions...

I am running MySQL 3.23.49 under Windows NT (XP Home). I also run PHP 4.3.9 on the same server, and use phpMyAdmin 2.6.0-pl2 for admin to my databases. I cannot upgrade to MySQL 4.x becuase apparently the MySQL API included with my PHP distro is not up to date enough to work with the revised sec

Re: [PHP-DB] php mysql dates

Dear Irm Jr, Here are two functions:: http::/www.php.net/strtotime http::/www.php.net/mktime using these functions togethor you can do the need full. BTW why not store just unix time stamp in mysql database. Most People use a string field in mysql database to store timestamp, it simply work wit

RE: [PHP-DB] php mysql dates

Thanks for the replies. I believe I have two solutions now! Take care. Much apprecitated. -Original Message- From: Swan, Nicole [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 28, 2004 2:48 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] php mysql dates I would suggest creating

RE: [PHP-DB] php mysql dates

Specialist Carroll College CCIT (406)447-4310 -Original Message- From: Justin Patrin [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 28, 2004 3:44 PM To: Irm Jr Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] php mysql dates On Wed, 28 Jul 2004 14:39:01 -0700, Irm Jr <[EMAIL PROTECTED]>

Re: [PHP-DB] php mysql dates

ay to deal with that, IMHO, is strtotime and date. $mysqlDate = date('Y-m-d', strtotime($month.' '.$day.', '.$year)); If you're using dates far in the past or future, though, this won't work. Better to use a date handling class, such as: http://pear.p

RE: [PHP-DB] php mysql dates

Sure I understand Y-m-d. But won't the database cry because the Month is in text format? (January, february)? Thanks again. Subject: Re: [PHP-DB] php mysql dates On Wed, 28 Jul 2004 14:30:24 -0700, Irm Jr <[EMAIL PROTECTED]> wrote: > > Hi all, currently I have a form

[PHP-DB] php mysql dates

Hi all, currently I have a form which prompts for the user to choose a date. The dropdown lists are stored into variables: $month//e.g. January, February, ... $day //e.g 1 - 31 $year //e.g. 2004 (four digits) then combined into $articleDate How can I manipulat

[PHP-DB] php/mysql error

I am getting a weird error on one of my servers that says something about "query requires full tablescan". I was not getting this error until today that I noticed. I Googled for a minute and saw where a ton of other sites had the same problem but no "reason" why. I did find one board that said t

[PHP-DB] Php-Mysql, select and update trouble

Dear Phpers, I have the following part of a script that retrieve an URL site. I'd like to count the clicks for every URL. I have added to mysql table a column "hit". May anybody tell me how to insert into an sql selection also an update, referring to the HIT variable (i.e. to realize a select and

[PHP-DB] PHP/MySQL learning project

Hi everyone! In trying to learn PHP and MySQL, I'm trying to create a web-based database application that will keep track of my movies. I have five tables (shown in the graphic). I'm trying to be able to display the results of the tables with one movie title, all of the actors associated with it

[PHP-DB] PHP / MySQL Developer

Hi All, This is just a request to all you programmers out there, I have been programming using PHP/MySql for approx 5 years now. I was involved in a motor car accident last year October and I broke my back in 3 places, this has left me paralyzed from the waist down but luckily my I can still co

Re: [PHP-DB] php-mysql problem

hello, did you load the mysql module in your php.ini configuration file? i.e. is the following line there: extension=mysql.so regards On Thu, 13 May 2004 11:47:41 -0400 Jianping Zhu <[EMAIL PROTECTED]> wrote: > have redhat 9.0 and Server version: Apache/2.0.40. > i have installed rpms php-4.

[PHP-DB] php-mysql problem

have redhat 9.0 and Server version: Apache/2.0.40. i have installed rpms php-4.2.2-17.2.i386.rpm php-mysql-4.2.2-17.2.i386.rpm After i create a database called mydb and serveral tables in mysql, I tried to run following testdb.php script --

  1   2   3   4   >