[PHP-DB] String Connection
To anyone that may know... I would like to connect with connection string in odbc_connect Any help or ideas? Thank you in advance, Andrés García -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] invalid select results from sybase with php - SOLVED
Od: "David Olszyński" <[EMAIL PROTECTED]> Temat: Re: [PHP-DB] invalid select results from sybase with php - SOLVED > I couldn't believe it: The problem is that php can't handle such big > numbers! :-O > Damned language! ;-) Nothing new - PHP also cann't handle NUMERIC type with scale > 9 in InterBase, they will be always seen as integers... Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] RE: New with MySQL 3.23: Commands out of sync error
I just started running MySQL 3.23.37 with php-4.0.5. Anyway, I am randomly getting this same problem. Probably 90% of the time I don't encounter a problem, but the other 10% I get the Commands out of sync error. I never got it before upgrading MySQL. Any suggestions out there? Maybe in the meantime I should revert to an older version of MySQL. Perhaps I should use mysql_free_result() in between any calls, but that seems to be excessive. I'll give it a try in the meantime, but would love to hear any advice or comments. Thanks > -Original Message- > From: Alexander Fordyce [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 19, 2001 10:10 AM > To: [EMAIL PROTECTED] > Subject: New with MySQL 3.23: Commands out of sync error > > > Hi. > > I have just run into a strange problem that I'm having a hell > of a time > extricating myself from. Here's the story... > > Recently, I upgraded to MySQL 3.23.33, mainly to experiment > with some of the > new transactional capabilities. But a whole chunk of code > which had always > worked perfectly began failing. After adding evil debug code > to display all > MySQL error messages, I found that I was getting the > following error when > trying to retrieve data from a query result: > > "Commands out of sync; You can't run this command now" > > I looked up this error on the mysql site, and was taken to > this page... > http://www.mysql.com/doc/C/o/Commands_out_of_sync.html > It mentions the need to use the command mysql_use_result(), > but php doesn't > support that. I understand that it's on the "to do" list. > > Does anyone else have experience with this problem? At the > moment, it has > me completely incapacitated, as moving back to MySQL 3.22 is > not an option. > The applications in question are seriously heavy with > database usage, and > can't really be slimmed down. > > (Another problem which may be related is that I have been getting > unpredictable results connecting to the database with > mysql_connect and > pconnect -- sometimes it fails to connect for no apparent > reason (about 1 > time in 20, maybe (which is a lot))). > > Thanks in advance... > Alex > > - - - - - - - - - - - - > Alexander Fordyce > [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Need help with PHP on NT - Urgent
Hi, I am using NT 4.0 Serv PK 6 & Oracle 8.1.1.6 Release 2 and i want to connect to the database using php scripts, what i would like to know is how do i set up iis 4.0 to do this? Sean -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] The Dreaded Oracle 8 TNS:ORA-12154 Connection Error
I am running PHP 4.0.4pl1 in CGI mode on Windows NT4 SP6, using Apache or IIS Web
Server's.
I am concentrating on Apache for this problem as it is identical irrespective of the
Web Server.
I'm using one of the simplest possible connection mechanisms ...
if ($conn=Ora_Logon("user@mydatabase","pass"))
{
echo "SUCCESS ! Connected to database\n";
Ora_Logoff($conn);
}
else
{
echo "Failed :-( Could not connect to database\n";
}
This works fine if PHP is run as an apache module but fails with the message
"Warning: Oracle: Connection Failed: ORA-12154: TNS:could not resolve service name in
c:\program files\apache group\apache\htdocs\ora.php on line 10"
When Apache is re-configured to run PHP as CGI (other html on the same page suce as
phpinfo() shows up just fine).
At first I thought the Apache user may have been affecting privileges but the Apache
"User" option doesn't work under Windows & I even tried running Apache as a service
using the Administrator
account - no change. Have tried environment paths to ORACLE_HOME, TNS_PATH etc. etc.
etc. all to no avail. We use sqlnet.ora with an oracle name server.
I have to use CGI as PHP4 isn't to production level for use as a Filter with IIS &
corporate policy dictates that I must prove PHP against ASP on the existing IIS server
before I can even attempt using
Apache.
I would greatly appreciate any construction :-) advise anyone can offer.
Regards, Paul Shortis
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Connection to AS/400.
Dear Nicaolas,
Take a look at:
http://www.faqts.com/knowledge_base/view.phtml/aid/5613/fid/12
http://www.faqts.com/knowledge_base/view.phtml/aid/3536/fid/10
http://www.faqts.com/knowledge_base/view.phtml/aid/257/fid/14
http://www.phpbuilder.com/forum/read.php3?num=1&id=100815&loc=0&thread=100815
DB2 Version 7.1 for Linux HOWTO
http://www.linuxdoc.org/HOWTO/DB2-HOWTO/
Hope this help.
Regards,
Chris Lee
On 7 May 2001 12:32:50 -0700, [EMAIL PROTECTED] ("Nicolas
Machado") wrote:
>OK, I have Linux, Apache and PHP, somebody knows if exist something like
>ODBC to connect to DB2/400.
>I mean, exist ODBC for linux?
>
>Thank for all.
>Best Regards
>
>
>---
>Este Mail NO contiene Virus.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.251 / Virus Database: 124 - Release Date: 26/04/01
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Oracle 8.1.1.6 Release 2 & NT & PHP
Hi, Could anyone tell me what steps i have to take when configuring Oracle 8i Ent Rel 2 for Windows NT Service Pack 6a. Sean -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] connection to Oracle 7.3 with ora_logon()
On Sat, 5 May 2001 01:26, Philippe Saladin wrote: > Hello, > > Newbie to PHP, I try to connect to an Oracle 7.3 database. > Is there something special to do to use the oracle functions, as > ora_logon?? I obtain a message "fatal error : Call to undefined function: > ora_logon()" SqlNet Client is installed > > Best regards > > Philippe Did you compile oracle support into PHP? Wayne -- Wayne Bastow - DBA - Central Coast Health Phone: 61 2 43203231 Email: wbastowATccahsDOThealthDOTnswDOTgovDOTau Linux, the choice of a GNU generation Kernel 2.2.16-22 on a i686 Running Windows on a Pentium is like having a brand new Porsche but only be able to drive backwards with the handbrake on. (Unknown source) == This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of the NSW Department of Health. == -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] php-db Digest 4 May 2001 07:42:01 -0000 Issue 595
php-db Digest 4 May 2001 07:42:01 - Issue 595
Topics (messages 9104 through 9118):
Re: Newbie question
9104 by: CC Zona
9107 by: ~BD~
Re: Mystery variable query?
9105 by: CC Zona
9108 by: martin helie
9109 by: Gyozo Papp
9110 by: CC Zona
9111 by: Johannes Janson
9112 by: martin helie
Re: interbase (?) field contents does not show
9106 by: Larry Rivera
ora_logon receive ora-12154
9113 by: Miguel
9115 by: Steve Farmer
mp3 upload
9114 by: Kelvin
Re: updating database on internet server
9116 by: Benny
Re: PHP and Access to DB2.
9117 by: Chris Lee
Apache+PHP+MySQL installation at once - HOW?
9118 by: Vojtech Dvorak
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
--
In article <034101c0d3f3$0dd747e0$41041dd8@winbox>,
[EMAIL PROTECTED] ("~BD~") wrote:
> at the end of my script, I run a set of closing and clean-up procedures..
> what I would like to be able to do is that when a user bails out of the
> script by closing the browser or leaving the site/page, detect that they've
> gone, and then go ahead and run my closing procedures.. is this possible?
http://php.net/manual/en/features.connection-handling.php
http://php.net/register-shutdown-function
--
CC
EXACTLY what I was looking for...
Thanks!
http://www.bustdustr.net
Home of Radio Free Bd
- Original Message -
From: CC Zona <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 03, 2001 1:42 PM
Subject: Re: [PHP-DB] Newbie question
> In article <034101c0d3f3$0dd747e0$41041dd8@winbox>,
> [EMAIL PROTECTED] ("~BD~") wrote:
>
> > at the end of my script, I run a set of closing and clean-up
procedures..
> > what I would like to be able to do is that when a user bails out of the
> > script by closing the browser or leaving the site/page, detect that
they've
> > gone, and then go ahead and run my closing procedures.. is this
possible?
>
> http://php.net/manual/en/features.connection-handling.php
> http://php.net/register-shutdown-function
>
> --
> CC
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
In article <9crr9l$4c4$[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("martin helie") wrote:
> assuming:
>
> $var="1234";(type does not seem to matter)
>
> this query returns no error, but no result either:
>
> mysql("database","SELECT * FROM table WHERE id='$var'");
When you call mysql_query is it perhaps from inside a function, where
variable $var has not been passed or made global?
(BTW, whenever you experience problems with a query, it's a good idea to
echo the query string to the browser. Often, this simple step makes it
very clear where the problem lies. Using mysql_error() and $php_errormsg
on a query failure also can give you very useful information.)
--
CC
Hi guys,
I'll answer this and the previous mail.
First, thanks for the insight.
1. There is such a function as "mysql" whose arguments are
mysql("database","query",[resource id])
very useful as it avoids having to call mysql_connect_db()
As for printing the query, I had done that, and everything was fine. I have
however, found the problem!
(sorry about the waste of bandwidth, but maybe someone will avoid making the
same mistake).
The problem was not related to variable scope, but rather because the
variable "1234" had some HTML formatting added to it somewhere in the
script.
The problem, evidently, is that echoing the variable didn't show the html
formatting (it was something like "" in an obvious way!
I wish there were a php debugger.
Again, thanks for the suggestions,
Martin
"CC Zona" <[EMAIL PROTECTED]> wrote in message
9cs5ef$6js$[EMAIL PROTECTED]">news:9cs5ef$6js$[EMAIL PROTECTED]...
> In article <9crr9l$4c4$[EMAIL PROTECTED]>,
> [EMAIL PROTECTED] ("martin helie") wrote:
>
> > assuming:
> >
> > $var="1234";(type does not seem to matter)
> >
> > this query returns no error, but no result either:
> >
> > mysql("database","SELECT * FROM table WHERE id='$var'");
>
> When you call mysql_query is it perhaps from inside a function, where
> variable $var has not been passed or made global?
>
> (BTW, whenever you experience problems with a query, it's a good idea to
> echo the query string to the browser. Often, this simple step makes it
> very clear where the problem lies. Using mysql_error() and $php_errormsg
> on a query failure also can give you very useful information.)
>
> --
> CC
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mai
Re: [PHP-DB] invalid select results from sybase with php - SOLVED
David Olszyński wrote: > Hello. > > I have a strange problem. Look: > > $query = "select id from rates where id = 9521.0"; > $result = sybase_query($query); > $a = sybase_fetch_row($result); > echo $a[0]; > > This code prints number 9520.0!!! > > The column id is auto-incremented so it always has a unique value. But > when I select values from this column using php I get a list like this: > 9520.0 > 9520.0 > 9522.0 > 9524.0 > 9524.0 > 9524.0 > ..., > while doing the same query from isql or from perl DBI I get correct > values: 9520 > 9521 > 9522 > 9523 > 9524 > 9525 > ... > > Can anyone help me with this? > > I use PHP 4.0.4pl1 (./configure --with-mysql --with-apache=../apache > --enable-track-vars --enable-trans-sid) compiled in Apache/1.3.19, Linux > 2.4.2 SMP, Sybase 11.9.2.4, RedHat 7.0. > > David Olszynski > I couldn't believe it: The problem is that php can't handle such big numbers! :-O Damned language! ;-) David Olszynski -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Connection to AS/400.
Thanks Stefan :) Nicolas, ODBC does indeed exist for Linux - to use it with PHP you need to build PHP with an ODBC Driver Manager, such as iODBC. A HOWTO for this is available at the www.iodbc.org site. You still need a driver for PHP to use with the Driver Manager, however, and there is not currently an ODBC driver that will talk to AS/400 directly. As a work around, you can use OpenLink's Multi-Tier ODBC driver on the Linux box to talk to DB2 Connect, e.g. install Multi-Tier drivers with client and server component both on the Linux box, install DB2 Connect on the same Linux box and configure a service to the AS/400, and then configure your ODBC DSN to with the existing DB2 Connect service name in the Database name field. Our Multi-Tier drivers are available for free download at http://www.openlinksw.com. They do not expire and come with a free 2 user connection. Also, free support is available at http://www.openlinksw.com/support/suppindx.htm if you run into problems. Hope this helps! Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Stefan Siefert [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 07, 2001 3:50 PM > To: Nicolas Machado; [EMAIL PROTECTED] > Subject: AW: [PHP-DB] Connection to AS/400. > > > Also if ODBC isn't native for linux (not yet) there are several ports (or > Projects) for linux the best I know is unixODBC (www.unixODBC.org), but > there is also the iodbc project (www.iodbc.org). Last but not least, is > there a company which sells ODBC solutions and support them > (www.openlinksw.com). The support is very usefull!! > > Greetings, > > Stefan Siefert > > -Ursprüngliche Nachricht- > Von: Nicolas Machado [mailto:[EMAIL PROTECTED]] > Gesendet: Montag, 7. Mai 2001 21:36 > An: [EMAIL PROTECTED] > Betreff: [PHP-DB] Connection to AS/400. > > > OK, I have Linux, Apache and PHP, somebody knows if exist something like > ODBC to connect to DB2/400. > I mean, exist ODBC for linux? > > Thank for all. > Best Regards > > > --- > Este Mail NO contiene Virus. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.251 / Virus Database: 124 - Release Date: 26/04/01 > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
AW: [PHP-DB] Connection to AS/400.
Also if ODBC isn't native for linux (not yet) there are several ports (or Projects) for linux the best I know is unixODBC (www.unixODBC.org), but there is also the iodbc project (www.iodbc.org). Last but not least, is there a company which sells ODBC solutions and support them (www.openlinksw.com). The support is very usefull!! Greetings, Stefan Siefert -Ursprüngliche Nachricht- Von: Nicolas Machado [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 7. Mai 2001 21:36 An: [EMAIL PROTECTED] Betreff: [PHP-DB] Connection to AS/400. OK, I have Linux, Apache and PHP, somebody knows if exist something like ODBC to connect to DB2/400. I mean, exist ODBC for linux? Thank for all. Best Regards --- Este Mail NO contiene Virus. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.251 / Virus Database: 124 - Release Date: 26/04/01 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Connection to AS/400.
OK, I have Linux, Apache and PHP, somebody knows if exist something like ODBC to connect to DB2/400. I mean, exist ODBC for linux? Thank for all. Best Regards --- Este Mail NO contiene Virus. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.251 / Virus Database: 124 - Release Date: 26/04/01 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] php 4 + Oracle 8 + FreeBSD w/ Linux Emulation
We're looking into getting PHP under FreeBSD (4.3) to talk to
a remote Oracle server that runs on NT. In the past we have
used OpenLink, but we'd rather not touch anything on the NT
side.
It's apparent that one can install Oracle 8.x for Linux under
Linux emulation on FreeBSD. My question is, will the link
("ld") of PHP + Apache + Oracle(Linux) work correctly under
this platform?
Thanks. -T.H.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] ODBC and Memofields
Marcel,
You should generate an ODBC trace (Tracing tab in the ODBC Administrator).
This will expose if the issue is in your Paradox driver, and what it is.
Either way, following up with the driver manufacturer would be a good idea.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Marcel Spaarman [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 07, 2001 9:06 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] ODBC and Memofields
>
>
> To anyone that may know...
>
> I'm having a problem with the memofields in my Paradox Database.
> My DSN cannot handle them and I don't know why.
> All I get is an external error:
>
> Warning: SQL error: [Microsoft][ODBC Paradox Driver] Unexpected error
> from external database driver (28610)., SQL state S1000 in
> SQLExecDirect in C:\HTTP_ROOT\release.php on line 10
>
> This is my script:
>
> $connection = odbc_connect("ODBC_Connect","","")
> or die("Couldn't connect to Database.");
>
> $sql = "SELECT Catalog.LabelCopyFF, Release.ReleaseId
> FROM Catalog, Release
> WHERE Release.ReleaseId = Catalog.ReleaseId
> AND Release.Title = '$name'";
>
> $sql_result = odbc_exec($connection, $sql)
> or die("Couldn't execute statement.");
>
> while ($record = odbc_fetch_row($sql_result))
> {
> $resultaat = odbc_result ($sql_result,"LabelCopyFF");
> echo "$resultaat";
> }
>
> odbc_free_result($sql_result);
> odbc_close($connection);
> ?>
>
>
> Can anyone please help me to handle this problem
>
> Thnx !
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] ODBC and Memofields
To anyone that may know... I'm having a problem with the memofields in my Paradox Database. My DSN cannot handle them and I don't know why. All I get is an external error: Warning: SQL error: [Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (28610)., SQL state S1000 in SQLExecDirect in C:\HTTP_ROOT\release.php on line 10 This is my script: Can anyone please help me to handle this problem Thnx ! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Download files extracted from db using Internet Exploded
Hi, When using Internet Exploded to download files from a website which extracts an file from a mysql db I encounter a weird problem. How I do this is simple, I use an href link that looks something like this, downloadcontent.php?PHPSESSID=33f8022176ba48bb8f4421d59d1792a6&attachment_ai d=3 The following php code should extract a particular attachment from the db, in this case, attachment_aid 3 and let the user either open or save it. Problem is, SCENARIO 1: User click on link User click on save RESULT: Internet Explorer tries to save the page which contained the html href link SCENARIO 2: User click on open (A new save/open dialog appears) User clicks on save RESULT: Internet explorer saves the file with it's correct filename SCENARIO 3: User clicks on open (A new save/open dialog appears) User clicks on open RESULT: File is correctly opened Now, it seems like Internet Explorer really wants me to click open once before actually choosing either to open or save it.. Does anyone know how to solve this problem, I don't want the users to have to figure out this "workaround" by themselves... // Mattias -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] dynamic form inputs and updating
hey all,
I would like to create a form that does the following: [I have up to step 3 completed.]
1. queries a db and gets the values of ID, TITLE, and FILENAME
2. generates a form that with a text input area for each TITLE where i can enter the
filename of the picture that corresponds to the TITLE
3. echo's the current value in the input box if a value is present
4. UPDATES the FILENAME column
I am trying to insert the filename of the pictures that correspond to each TITLE. I
think that i need to use some sort of loop and also somehow tie the ID to each input
so that the UPDATE executes correctly.
thanks much,
olinux
Here's some of my code.
This generates the form inputs
while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$title = $row['title'];
$filename = $row['filename'];
$form .= "$title
[PHP-DB] dynamic input tyep text updates
hey all, I am trying to create a form that does the following: [ i have most of it
done]
1. queries the db and gets the values of the ID, TITLE, and FILENAME columns in a table
2. creates a form with the TITLE with the filename echoed if it
exists
3. on submission the form update the FILENAME field.
I have completed up to step 2. I am not sure how i should name the fields to make this
easiest. The purpose of the form is so i can insert a value for a picture that
corresponds to each TITLE. here's some of my my code.
this builds the form input fields.
while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$title = $row['title'];
$filename = $row['filename'];
$form .= "$title
