() method is working.
After more playing, I still cannot seem to actually USE the results
of an odbc_columns() call on DB2 since just about everything
"fetch-related" segfaults. Is there another method or set of methods
that I'm missing?
Thoughts? Ideas?
-Szii
--
PHP Database Ma
=path. Make sure you run the CATALOG
commands on the client so that it can find the AS400 database.
'Luck!
-Szii
At 10:41 AM 2/4/2001 -0800, Pete Lancashire wrote:
I'm going to be trying to connect to the native DB2 database in a AS/400
So far thats all I know about the IBM side.
Can someone give
add a line into /etc/ld.so.conf too.
-Szii
At 11:08 PM 2/4/2001 -0500, Chris Book wrote:
Hello,
I've installed db2 and created the default instance at /home/db2inst1/.
PHP is compiled with the --with-ibm-db2 option, however when I try to start
apache I get the message: "Cannot load /etc/httpd/mod
http://www.php.net/manual/en/function.eval.php
Couple of notes from the userbase show how to include HTML in
a php $content passed to eval()
'Luck.
-Szii
At 05:07 PM 2/8/2001 +1300, Simon Helson wrote:
Hey guys - I've been mulling this one over for a few days now - and still
haven't come up
Is there a known way to "reset" this field? If I make a call and it
succeeds,
then it should be set. If it fails, shouldn't it at least be reset to 0
or -1 instead
of simply the last successful insert? Is this the expected behavior?
-Szii
--
PHP Database Mailing List (http://w
Off the top of my head, and it's 3am local so take this with a grain of
salt, but I think that
this will work...
Update Table1, Table2 SET Table1.column1 = 'blah', Table2.column1='foo'
WHERE
Table1.ID = x AND Table2.ID = y
'Luck
-Szii
- Original Message -
From: Lester June Cabrera
The newest MySQL code has transactions via their implementation of
Sleepcat's BDB tables.
If you use BDB tables instead of MyISAM you can do transactions.
Check the syntax on CREATE TABLE for details on how to create
BDB tables.
'Luck
-Szii
- Original Message -
From: Gary Huntress
*begins dousing Paul S with water before the flames start*
-Szii
- Original Message -
From: Paul S [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 20, 2001 3:04 PM
Subject: [PHP-DB] PHP question needing info
I have a question that I need help with.
The question
Read The Fine Manual?
exec();
-Szii
- Original Message -
From: Paul S [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 20, 2001 4:13 PM
Subject: [PHP-DB] reword my question
How do I execute a shell script in php?
I just started to use php and I am learning
Perhaps...?
$x = 0;
while ($x 7)
{
if (!isset($myArray[$x]))
{
$myArray[$x] =0;
}
}
-Szii
- Original Message -
From: Tyrone Mills [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 24, 2001 3:58 PM
Subject: [PHP-DB] Can't get my head around this problem
This is not really related to PHPDB
Send me the code . It looks like you have an unbalanced double-quote.
Same thing's happening with your footer, too.
Should be an easy fix.
-Szii
- Original Message -
From: Brian Tegtmeier [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday
that inc's your start by one, and then adds 3500.
Drop the second if($start == 0) clause which sets $start to 1.
'Luck
-Szii
- Original Message -
From: Jimmy Brake [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 15, 2001 9:54 PM
Subject: [PHP-DB] 'the missing character
Export as a comma-delimited file, explode() the file one line
at a time along commas, and use insert via normal methods.
Not sure if MySQL has a parser for comma-delim (probably
does) but this way you have more control over how it goes in.
-Szii
- Original Message -
From: Gabriel
, but it seems to work...
-Szii
- Original Message -
From: Jimmy Brake [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 15, 2001 9:58 PM
Subject: [PHP-DB] 'the missing character' YIKES
I forgot to detail the problem, I loose a character every once in a while
basically every 3500
Sorry, last message was a little vague.
Your SQL will fail because of the ',' after the SET clause.
Therefore affected_rows shows 0, and inserts a new row.
Then when you match with the LIKE clause, it's going to match
multiple times.
Miles, you were SO close with #2. =)
-Szii
- Original
)) // It's checked, therefore it's set - if it's not
checked, it's just not set.
{
echo Set\n;
}
else
{
echo Not set\n;
}
}
/XMP
This will give you Set/Not Set lines 80 times.
G'luck..
-Szii
- Original Message -
From: John Starkey [EMAIL PROTECTED]
To: [EMAIL PROTECTED
;
or if you wanted to check multiple groups,
SELECT UserID from GroupMemberTable WHERE GroupID IN (4,2,3);
The map table may get huge depending on the number of users/groups,
but it's a possibility.
-Szii
- Original Message -
From: Doug Schasteen [EMAIL PROTECTED]
To: php-db list [EMAIL
!\;; // note that it's got a ; INSIDE the
string...it's PHP in there, after all
eval($str);
If you wanted to pre-generate it, I don't see any reason why you couldn't
addslashes()
the code, and INSERT it that way. Pull it back out, stripslashes() it, and
eval() it.
Voila!
-Szii
- Original
for
work.
It's amazing how many people know people that know people and you end up
with work. 8-)
-Szii
- Original Message -
From: David Balatero [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 02, 2001 11:27 PM
Subject: [PHP-DB] kinda unrelated, but curious...
...where do you
This is not VB - this is better. Probably want to name all of your text
fields something
similar, since they'll be mixed in with the drop downs, radio buttons,
etc...
Check $HTTP_POST_VARS and $HTTP_GET_VARS in your form's target.
-Szii
- Original Message -
From: Peter J. Krawetzky
solution.
Anyone have any ideas/thoughts?
Thanks.
-Szii
--
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]
it on two different links, it's seems to modify both
links. Almost like it's global
*shrug*
-Szii
- Original Message -
From: Paul Burney [EMAIL PROTECTED]
To: Szii [EMAIL PROTECTED]; php mailing list [EMAIL PROTECTED]
Sent: Monday, August 13, 2001 2:28 PM
Subject: Re: [PHP-DB] MySQL
.
If you just need a super fast lightweight database, OpenSource.
For everything else, DB2.
And if you need a kick-arse track-anything-anywhere-anyhow system, look at
Camstar Systems,
which will handle backends of both DB2 and Oracle. It's better than the
Oracle MES/tracking modules.
-Szii
.
Check out http://www.php.net/manual/en/ref.session.php
'Luck
-Szii
- Original Message -
From: Matthew Tedder [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 30, 2001 12:30 PM
Subject: [PHP-DB] Learning PHP Sessions
?php
/*
Hi,
I'm new to PHP and am having trouble
;
-Szii
- Original Message -
From: Kim Kohen [EMAIL PROTECTED]
To: PHP [EMAIL PROTECTED]
Sent: Wednesday, March 27, 2002 5:18 PM
Subject: [PHP-DB] Another Drop down question
Hello all,
I'm trying for the first time to use a dynamically created popup menu from a
mysql database
.
**
http://www.php.net/manual/en/function.fopen.php
http://www.php.net/manual/en/function.fputs.php
http://www.php.net/manual/en/function.fclose.php
Party on!
-Szii
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Try
SELECT TableA.Category, TableB.PersonID
FROM TableA LEFT JOIN TableB ON (TableA.CategoryID = TableB.TableAID)
WHERE TableB.ClientID = $cid
ORDER BY TableA.Category ASC
LEFT JOIN states that you should return all TableA, inserting NULL for TableB
if there is no match.
'Luck
-Szii
that the above SEQUENCE is important. If you deviate from it,
you may get unknown variable or other error messages.
-Szii
- Original Message -
From: Prodoc [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 22, 2002 2:38 PM
Subject: Re: [PHP-DB] Re: Retrieve information from mutiple
This is more of a MySQL question, but you can set the column default for
the auto_increment column to something other than 1.
Look up the SET DEFAULT clause of the table create / alter table
calls.
-Szii
- Original Message -
From: Dan Swensen [EMAIL PROTECTED]
To: php [EMAIL PROTECTED
not being used
correctly
'Luck
-Szii
- Original Message -
From: Evans, Josh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 23, 2002 11:26 AM
Subject: [PHP-DB] please help!
Database: sites
I have to columns: id and site. I will have approx 800 entries in the db
when I am
Well, that looks like a problem within the findLoginType()
call. Since it's not been included, it's hard to help you. :)
'Luck
-Szii
- Original Message -
From: J. Wharton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 23, 2002 11:09 AM
Subject: [PHP-DB] User getting
, or what the
status is currently.
'Luck!
-Szii
- Original Message -
From: J. Wharton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 24, 2002 8:51 AM
Subject: Re: [PHP-DB] User getting superuser access. ack!
here's the code for findLoginType($username):
function
hehehe, you recoded PHP to reconnect to MSSQL, but you forgot
to redo your connection stuff. Sybase error: means that you're
connecting to Sybase and not MSSQL. *wink*
'Luck
-Szii
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 25, 2002 10
put in a var_dump($sql);die(); right after
$result = mysql_query($sql);
Then copy/paste it into mysql's command line util, and see what
you get.
-Szii
- Original Message -
From: Neil [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 25, 2002 6:34 PM
Subject: [PHP-DB
When you build the list up, originally, you'll NOT put selected on Choose City, but
move it to Alexandria.
-Szii
- Original Message -
From: its me [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 26, 2002 1:39 AM
Subject: [PHP-DB] selected problem
i have the file
I believe it's because $CLIENTID is not set at ALL before you
register it. (ie, isset($CLIENTID) would fail) Therefore it cannot
register the variable...there's nothing for it to register or track.
Try...
$CLIENTID = ;
session_register(CLIENTID);
$CLIENTID=SOMEVALUE;
- Original Message
.
$name = This is Paul's field.
.
.
.
INSERT INTO table ( name ) VALUES ( '$name' )
Will fail, because you have VALUES ('This is Paul');
Post the full value of $name via var_dump($name) and
var_dump($query) and we'll see what we can find with it.
'Luck
-Szii
--
PHP Database Mailing List (http
AddSlashes() or AddCSlashes()
-Szii
- Original Message -
From: Paul [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 02, 2002 4:11 PM
Subject: Re: [PHP-DB] Re: Spaces Problem php mysql
On Thursday 02 May 2002 10:10 am, you wrote:
- Original Message -
From
Delete from does not work with multiple tables, AFAIK..
-Szii
- Original Message -
From: andy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 03, 2002 2:02 AM
Subject: [PHP-DB] sql querry problem
Hi there,
I do have 2 tables. One contains an update for the other one
SELECT DISTINCT L.*
from data.languages L, data2.user U
WHERE L.id IN (U.language_1, U.language_2, U.language_3)
order by name;
I believe the IN clause is a shade faster than multiple ORs, but
I'm not 100% sure.
'Luck
-Szii
- Original Message -
From: andy [EMAIL PROTECTED
foreach($website = mysql_fetch_array($result))
{
$text = You can go here: strong?=$website['originalDomain']?/strong and find
information;
eval($text);
}
You get the idea...
'Luck
-Szii
- Original Message -
From: Bogdan ROMAN [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday
interface.
You can also use the mysql_error() and mysql_errno() calls
to see what went wrong.
-Szii
- Original Message -
From: cin [EMAIL PROTECTED]
html
body
? php
mysql_connect(localhost, test, testpw);
mysql_select_db(testdb);
msyql_query(insert into firsttab (first_name
doesn't even require an eval() call.
Apologies for the confusion..
-Szii
- Original Message -
From: [EMAIL PROTECTED]
To: Bogdan ROMAN [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 11:11 AM
Subject: Re: [PHP-DB] DB and eval. HELP !!!
foreach($website
... :)
-Szii
- Original Message -
From: [EMAIL PROTECTED]
To: Bogdan ROMAN [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 11:21 AM
Subject: Re: [PHP-DB] DB and eval. HELP !!!
Oops, minor oversights on my part.
If you're calling eval() in the context of a PHP script, you
://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT
'Luck
-Szii
- Original Message -
From: admin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 5:48 PM
Subject: [PHP-DB] JOIN statement not producing expected output
Okay, now this is my first try
in `my.cnf' or just exclude a set of
databases with replicate-ignore-db.
--
Two-way replication is not supported yet.
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Replication
'Luck
-Szii
Your questions are far too vague and XML/XML:Schema/XSLT etc
are far too complicated to explain without definitive focus'd questions.
XML allows you to do whatever YOU want in whatever format
YOU want.
Best help I can give is this...
http://www.w3.org/
'Luck
-Szii
- Original Message
Hmm...odd. I guess their %s (yes that was a typo) looks for a space
as a delimiter and not the specified next one.
Easiest workarounds off the cuff...
1) sscanf() to get the bulk of the data out, then regex out the %s string.
2) eregi_replace() Jun with the numeric
3) Dump it as numeric
Because it's not $s in the context of a printf() call. It is %s to denote a
string replacement.
-Mike
- Original Message -
From: Matthew Crouch [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 12:41 PM
Subject: [PHP-DB] got it, thanks
Seth Yount wrote:
in
SQL JOINs...
http://www.mysql.com/doc/J/O/JOIN.html
-Mike
- Original Message -
From: Noah Spitzer-Williams [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 4:21 PM
Subject: [PHP-DB] check two tables at same time?
hey guys,
im trying to figure out a query
MySQL doesn't support subselects.
Look up mysql_insert_id(). It'll return the ID of the last inserted record.
Or just break out the second INSERT statement into one SELECT
and then the actual INSERT.
-Mike
- Original Message -
From: Christine Clerc [EMAIL PROTECTED]
To: [EMAIL
- Original Message -
From: Cosby, Christopher [EMAIL PROTECTED]
I don't want to start a tangent here, but the most accepted way for
generating HTML with PHP is to NOT generate HTML with PHP. Thus, the
original code should be written like this:
Huh? .. most accepted way for
Just a quick follow up...
from http://www.w3.org/MarkUp/html-spec/html-spec_8.html#SEC8.1
When there is only one single-line text input field in a form, the user agent
should accept Enter in that field as a request to
submit the form.
and a random link...
exec() the query results.
-Mike
- Original Message -
From: Matthew Tedder [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 2:31 PM
Subject: [PHP-DB] PHP in Database Fields..
Question:
I want to put PHP code into database fields holding HTML text, how can
I'm sorry, brainfart.
Don't exec(), eval().
Apologies.
-Mike
- Original Message -
From: Matthew Tedder [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 4:00 PM
Subject: Re: [PHP-DB] PHP in Database Fields..
On Monday 24 June 2002 09:21 pm,
One large PHP block is more efficient than multiple small blocks of
php.
It's a tradeoff of multiple invocations of the parser versus having
the parse run through (and ignore) normal text. We have run tests
inhouse that validate the performance difference is fairly small, but
it does exist.
There's a long thread somewhere in the archives of PHPBuilder.com
in regards to getting DB2/PHP to work on an AS/400.
-Mike
- Original Message -
From: John Lim [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 25, 2002 12:01 AM
Subject: [PHP-DB] Re: DB400 on AS/400
Hi Mike
Make sure you're exec'ing against the correct database with identical schema.
Different MySQL versions? Schema? Permissions?
var_dump() and cut'n'paste onto the server to make sure the query DOES
run, then look for remote DB connection issues, permissions, database, etc.
Are there multiple
You're going to have to rip open the MS-specific format and
handbuild (or script) your PHP to custom-build that format with
the correct data fields. While it can be done, it's a good bit of
time and energy.
-Mike
- Original Message -
From: Dib, Walid (MED, Stagiaire GEMS) [EMAIL
okay, couple of questions in this one... =)
First...
?=$myData? is shorthand for ?php echo $myData; ? if you care.
With a textarea there is no value attribute.
TEXTAREA?=$myData?/TEXTAREA
Your UPDATE call via sprintf() is okay for the parameter passing,
but you're missing single quotes
You need to have keys in each table to join them together.
Once you have those keys in place, you can match the keys
across the tables and use a WHERE clause to filter the results.
'Luck!
-Mike
- Original Message -
From: José Moreira [EMAIL PROTECTED]
To: Php-Db [EMAIL PROTECTED]
Sent:
Sorry, that was vague. ODBC is a standard of connectivity
and IS supported by the AS/400 platform.
With that said, if AS/400 has ODBC support and PHP has
ODBC support then the two can talk.
-Mike
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL
62 matches
Mail list logo