[PHP-DB] RE: Informix user wierdness
This is more an Informix question rather than a PHP question but I hope someone can help I've installed the Linux-SE version and CSDK of Informix from informix.com and installation has gone fine including createing the demo DB. I can also start 'dbaccess' and browse/query the tables so the envvars seem fine. However, when I endeavour to use the PHP functions, I get an error in ifx_connect() I constantly get the error: E [SQLSTATE=IX 000 SQLCODE=-952] User ()'s password is not correct for the database server. Note how the username field is empty. What's the procedure for 'logging in' to the DB? I created the demo DB as a normal user and I've read that the user auth stuff is done through the operating system. Using 'dbaccess' to try and connect to the DB as the same user rather then starting dbaccess in the DB dir causes the same error to occur so it's obviously something in the setup. My sqlhosts line is 'demo_se seipcpipdev sqlexec' and the ifx_connect line is 'ifx_connect("stores7@demo_se", "testuser", "mypasswd")' Answered my own question after taking some time out ;). Here's what I found for the sake of the archives. Turns out Informix has some sort of PAM/shadow password problem which means it won't talk nicely because it tries to auth the user, but because of the bug it can't get the user and therein lies the problem. Luckily I'm on a dev box so I was able to run 'pwunconv' to return my passwd file to a non shadow state which in a production system is 'not a good thing'(tm) A search in comp.databases.informix on google/deja on shadow and PAM etc will reveal the problem. Apparently there are workarounds for this but I haven't found the, yet. I suspect they will require surgery to something important :) Cheers, Graeme -- 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] Query with Access
I'd try adding: $conn = odbc_connect("pruebas_php", "", "") or die("cannot connect to pruebas_php"); $resultado1 = odbc_exec($conn,"SELECT Nombre, Apellido1, Apellido2 FROM Personas") or die ("cannot execute query"); -- Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://superid.dyndns.org:8080/freesql/index.php ""Fernando Buitrago"" [EMAIL PROTECTED] wrote in message 9a6l42$e5r$[EMAIL PROTECTED]">news:9a6l42$e5r$[EMAIL PROTECTED]... Well, this is my code, but it dosen't work, please, help me, this table has 5 records, and the result of the query is -1. Code html head titleLista Datos/title meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /head body bgcolor="#FF" text="#00" ? $conn = odbc_connect("pruebas_php", "", ""); $resultado1 = odbc_exec($conn,"SELECT Nombre, Apellido1, Apellido2 FROM Personas"); echo odbc_num_rows($resultado1); $cantidad_articulos = 0; for ($cantidad_articulos=1;$cantidad_articulos=odbc_num_rows($resultado1);$cant idad_articulos++) { echo odbc_result($resultado1,2); echo odbc_result($resultado1,3); echo odbc_result($resultado1,4); } ? /body /html Regards -- 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]
Re: [PHP-DB] metabase support
Hello Dean, On 01-Apr-01 06:38:32, you wrote: I just want to make sure that I'm understanding what metabase supports. It does not support: - references - primary keys Does anyone find that this prevents you from using metabase? Or do you find that you have to hack your way around these deficiencies? You can live perfectly well without both. In practice primary keys are not much more than declaring a unique index on the key fields. References or foreign keys have a role of assuring database integrity. This means that if you update your database tables and not assure that specified references exist consistently, the DBMS will fail on those updates. It's not like it will avoid your application bugs, but at least if your application has a bug that would break the database integrity, well placed references/foreign keys will prevent that to happen. Your application will just stop working until you fix the bugs. I use MySQL most of the time, so I've learned to design without explicit references, but I'd like to have the opportunity to at least specify references in the schema definition (which MySQL allows but doesn't do anything with). It seems that with a DBMS-independent abstraction layer like metabase something like this should be supported. Support for primary/foreign keys is in my to do list. It just did not become a priority because there are other things more important to add like BLOBs. Metabase is about to go Open Source. I am just waiting to finish a great design tool before I announce when Metabase will be open for other developers to contribute with work that I can't do right away. Anyway, that should not stop you from using Metabase as it is. Metabase is the only PHP database abstraction package that does schema management. You can live without schema management, but it provides great schema maintenance aid. When support for primary/foreign keys is added explicitly you will be able to upgrade your schemas without worry. So, you can use Metabase with schema management as it is now. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp -- -- 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 an MySQL
Can someone recommend a book that shows how to use PHP and MySQL. I need to see how to pass parms from a form to a PHP so I can Update, Add and Delete records. Thanks for the help. Jim Ray -- 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] PHP an MySQL
I would recommend the first two books listed on this page: http://www.webdesigns1.com/php/books.php I've read both. Jeff Oien Can someone recommend a book that shows how to use PHP and MySQL. I need to see how to pass parms from a form to a PHP so I can Update, Add and Delete records. Thanks for the help. Jim Ray -- 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]
Re: [PHP-DB] Search results
In article 001301c0bafa$34d15be0$[EMAIL PROTECTED], [EMAIL PROTECTED] ("David Drummond") wrote: Can anyone tell me what is the best way to implement displaying multiple search results using next and previous buttons to cycle through all the results. I see this method done on a lot of sites but don't know how to do it in PHP. "Limit" is how it's commonly done (though what's "best" really depends on what you're doing). In mysql, it would be something like: mysql_query("select foo from bar limit 5,10",$connect) //show ten records from result set, starting with the sixth I believe phpbuilder.com has a tutorial on this. If not them, then you shouldn't have much trouble finding examples on one of the other PHP tutorial sites. -- 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]
RE: [PHP-DB] CSS versus Includes
When I asked the question, what I meant was should I use the includes to hold page style details or a CSS file. And someone who understood that this was not an apples and oranges situation but one of approach answered that Netscape was not fully supportive of CSS and suggested includes may be the way to go. -Original Message- From: Patrick Dunford [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 01, 2001 6:58 PM To: [EMAIL PROTECTED] Subject:RE: [PHP-DB] CSS versus Includes On 31 Mar 2001 13:19:45 -0800 AD in php.db, Michael Geier said: this post is about apples and oranges... CSS (Cascading Style Sheets) have nothing to do with includes. They only have to do with formatting elements on a web page. They can be written inside the document, or can referenced externally via a LINK tag. Includes can be anything from a configuration file, a block of text, or a header or footer statement that works across multiple pages, so you don't have to duplicate code. Including a CSS :) -- === Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, to him be glory in the church and in Christ Jesus throughout all generations, for ever and ever! Amen. -- Ephesians 3:20-21 http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010331 === Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/ -- 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]
Re: [PHP-DB] CSS versus Includes
"Matt Braynard" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... | When I asked the question, what I meant was should I use the includes to | hold page style details or a CSS file. And someone who understood that this | was not an apples and oranges situation but one of approach answered that | Netscape was not fully supportive of CSS and suggested includes may be the | way to go. Whether you link to an external stylesheet, embed a style block or declare the styles in-line is a matter for author management of the CSS property declarations. The use of includes or scripting the actual link, block or inline styling in the document does not matter a wit. Importantly, if the styling is included, the interpretation is still done by the client browser. Whether includes or in-document coding are used, the restrictions and bugs and failure to parse, where invalid markup or styling is involved, still apply. What I do notice, however, with some Nav4x browsers, that escaping the quotes on class names in printf() causes these browsers to sometimes escape the whole class declaration. eg. printf('tr td class=\'id\' align=\'right\'%s/td td class=\'lname\'%s/td td class=\'fname\'%s/td td class=\'logon\'%s/td td class=\'logoff\'%s/td /tr ', $myrow['id'], $myrow['lname'], $myrow['fname'],$myrow['logon'], $myrow['logoff']); The solution for some documents is to write as such td class=id align=right%s/td How this will affect xml documents I am not sure Also with tables, if the data is being extracted from a database, as above, and the data in a particular field row is null, the td cell styling background will collapse with Nav4x browsers. This might be solved by a conditional statement inserting some content where the database row/field content is null, or constructing the database table with pseudo content, such as nbsp; as the default for fields likely to have null content. Sorry, but my experience is that oranges are oranges and apples and apples are apples. Nice thought! but I do not think you can get out of browser non-compliance by using PHP. Tim Morris -- 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] retrieving images
Hello, I'm trying to retrieve and output all the binary images in my images table. This is what I have, $result = mysql_query("SELECT * FROM images",$db); if ($myrow = mysql_fetch_array($result)) { // display list if there are records to display do { $filetype = ($myrow["filetype"]); header("Content-type: $filetype"); echo $myrow["binary_junk"]."br\n"; } while ($myrow = mysql_fetch_array($result)); } else { // no records to display echo "Sorry, no records were found!"; When I run this, it only returns the first image in the table. Have really know idea where to go from here. Is one image all that can be done? Ok.. some information for you, as you seem to mis-understand some things here... A web-browser can handle certain pices of information being thrown down it's gullett.. The Content-type: is what determines this. If you start by throwing it an image/gif, then it will expenct a gif to come down. If you start throwing "BR"'s down, it will not only corrupt the image, but not do anything remotely related to HTML. Basically what you need to do is to set up a second PHP routine which grabs the binary data from the dataqbase and displays it, using IMG tags. The first routine just sets up the IMG tags pointing to the second.. I've got an example of the code required to do something like this if you want to take a look.. (http://elfgrove.virtual.net.au/~bekar/test.phps) hope this helps. bkx -- 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] uploading files.
"olinux" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... | here is the working script on my local windows machine. note that you will | need to change $the_path | Everything is pretty self explanatory. You can read the article that I took | this from at http://phpbuilder.com/columns/bealers2904.php3 | | olinux Adapted excellently. Many thanks Tim Morris -- 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] select data from a drop down box in a form
I like to select data out of a drop down box in my form field from a mysql database. While I do that I also like that it reloads the page and put the relevant products of that drop down box in another field. Ex: Category 1 Category 2 Category 3 are in the drop down box and when I choose Category 1 I like to display another field which displays me all the products which are in that categorie. I know it can be down just not to sure how? -- 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] PHP on WIN32 with DB2 CLI
Actually, CLI is almost function-for-function the same as ODBC. The PHP implementation of ODBC is quite a simplified version, but it covers most of the basic function. Chris, what is it that you are trying to do, specifically? Dan Phil Jackson wrote: Chris - I think to use DB2's CLI interface, you need a compiled langauge, like some flavor of C++ or VB. I've seen some examples using the CLI interface, so my question is why on earth would you chose that over generic ODBC? That CLI is nasty-looking, pages of code versus what you can do in a few lines with ODBC.. - but I have a project using both DB2 on a mainframe and DB2 UDB - so I am very interested in your thoughts on all this! Phil J. Chris Book wrote: Hi, I've compiled php before with --with-ibm-db2 to use DB2's CLI driver. Now I'm working on NT with the php binary, and I can't figure out how to connect to DB2 except with ODBC. I would prefer to use the CLI interface than an ODBC interface. Is this possible or am I stuck with ODBC on NT? Thanks, Chris Book [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]
[PHP-DB] multiple file uploads
Hi all, I am combining a couple of scripts to create one that handles multiple files... I am using these two scripts. So far the script WILL upload. but i am having some trouble getting it to work totally right. If you run it you will see that the form is printed twice... and a couple other things that i would like to do are check file type and insert the info into a db. the script is practically complete and i would appreciate the help of anyone who can assist me. I am compiling these two scripts http://phpbuilder.com/columns/bealers2904.php3 http://www.hotscripts.com/cgi-bin/jump.cgi?ID=9644 the second is supposed to be a multiple file uploader, but i could not get it to work. you can see what i have compiled so far. http://www.angelfire.com/ak5/olinux/mult_upload.txt thans much, olinux
Re: [PHP-DB] select data from a drop down box in a form
There are probably a million ways to do this... here is one :) (note that the file should be named "fieldtest.php" -- Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://superid.dyndns.org:8080/freesql/index.php html body script language=javascript function copyfield() { var ind; ind=document.myform.myfield.selectedIndex; window.navigate("formtest.php?otherfield=" +document.myform.myfield[ind].text); } /script form name=myform select name=myfield onchange=copyfield(); ? $db = mysql_connect("localhost",$username,$password); $rs=mysql_db_query( $databasename, "select myfield from mytable"); while($row=mysql_fetch_array($rs)) { echo "option$row[0]/option"; } ? p input type=text name=otherfield value="? echo "$otherfield";?" /form /body /html ""Petra"" [EMAIL PROTECTED] wrote in message 9a8qou$bp3$[EMAIL PROTECTED]">news:9a8qou$bp3$[EMAIL PROTECTED]... I like to select data out of a drop down box in my form field from a mysql database. While I do that I also like that it reloads the page and put the relevant products of that drop down box in another field. Ex: Category 1 Category 2 Category 3 are in the drop down box and when I choose Category 1 I like to display another field which displays me all the products which are in that categorie. I know it can be down just not to sure how? -- 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] ecommerce - storing as an array or temporary record
I am developing a script that will eventually be a "pay-to-list your whatever" script. I am wondering if the best way to hold data throughout the four forms would be to hold these in an array - each form would array_push() the vars into the $listing array. Or would it be better to insert the records as they come in - each form - ? I am thinking that one connection to the DB might be easiest to carry out. thanks much, olinux
Re: [PHP-DB] Search results
I've not seen the limit function, but it sounds quite uselfull. Whatever method, you could pass the first or last keys related to the current page and an indication as to whether you are going forwards or backwards - I suppose that in PHP it could all be done in one file, self-referential-like, as the "arrows" would somehow comprise a form. Phil J. CC Zona wrote: In article 001301c0bafa$34d15be0$[EMAIL PROTECTED], [EMAIL PROTECTED] ("David Drummond") wrote: Can anyone tell me what is the best way to implement displaying multiple search results using next and previous buttons to cycle through all the results. I see this method done on a lot of sites but don't know how to do it in PHP. "Limit" is how it's commonly done (though what's "best" really depends on what you're doing). In mysql, it would be something like: mysql_query("select foo from bar limit 5,10",$connect) //show ten records from result set, starting with the sixth I believe phpbuilder.com has a tutorial on this. If not them, then you shouldn't have much trouble finding examples on one of the other PHP tutorial sites. -- 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] -- 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] metabase support
""Manuel Lemos"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I just want to make sure that I'm understanding what metabase supports. It does not support: - references - primary keys Does anyone find that this prevents you from using metabase? Or do you find that you have to hack your way around these deficiencies? You can live perfectly well without both. In practice primary keys are not much more than declaring a unique index on the key fields. References or foreign keys have a role of assuring database integrity. This means that if you update your database tables and not assure that specified references exist consistently, the DBMS will fail on those updates. It's not like it will avoid your application bugs, but at least if your application has a bug that would break the database integrity, well placed references/foreign keys will prevent that to happen. Your application will just stop working until you fix the bugs. I use MySQL most of the time, so I've learned to design without explicit references, but I'd like to have the opportunity to at least specify references in the schema definition (which MySQL allows but doesn't do anything with). It seems that with a DBMS-independent abstraction layer like metabase something like this should be supported. Support for primary/foreign keys is in my to do list. It just did not become a priority because there are other things more important to add like BLOBs. Metabase is about to go Open Source. I am just waiting to finish a great design tool before I announce when Metabase will be open for other developers to contribute with work that I can't do right away. Anyway, that should not stop you from using Metabase as it is. Metabase is the only PHP database abstraction package that does schema management. You can live without schema management, but it provides great schema maintenance aid. When support for primary/foreign keys is added explicitly you will be able to upgrade your schemas without worry. So, you can use Metabase with schema management as it is now. Regards, Manuel Lemos Thanks for your comments, Manuel. I will consider them. However, I was wondering if anyone else who is less biased :-) wanted to comment on my questions. Thanks. Dean Hall. -- 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] ecommerce - storing as an array or temporary record
I am developing a script that will eventually be a "pay-to-list your whatever" script. I am wondering if the best way to hold data throughout the four forms would be to hold these in an array - each form would array_push() the vars into the $listing array. Or would it be better to insert the records as they come in - each form - ? I am thinking that one connection to the DB might be easiest to carry out. Why store them in a database? In any case, Serialize()/UnSerialize() and Sessions.. bkx -- 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]