Check www.p2p.wrox.com...more later on this
Phil J.
Nicolas Machado wrote:
Hy, somebody knows if exist a driver for database access to DB2/400, running
on AS/400.
Something like a module.
Thanks.
---
Este Mail NO contiene Virus.
Checked by AVG anti-virus system
else if
it appears elsewhere - and don't change it's type!
Phil J.
- Original Message -
From: "Richard Scott Crawford" [EMAIL PROTECTED]
To: "Phil Jackson" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, April 22, 2001 1:17 AM
Subject: Re: [PHP-DB] Designing a datab
Paul,
You upload the script to your server and request the page in your browser,
as you would any typical html page. The server retrieves the page, sees the
php or php3 tag, knows to kick in the php interpreter, tries to parse the
script within the various tags, if successfull, and returns to
Well to start with, I would examine the nature of the data you want to
store, it's datatype, size, ect. Follow the other reccommendations as to
not repeating data
across tables. I tend to use autonumber fields for keys quite often. Also,
think about what data could go into "domain" tables
Try stripslashes(fieldname) to "unescape" those slashes when retieving from DB
Phil J.
Jennifer Arcino Demeterio wrote:
Hello all,
I am having a problem in inserting text with apostrophe to mysql database.
When a user fills out a form field that includes an apostrophe ex. Jen's ,
Some good advice already given, and I quite agree. MySQL is no light-weight -
comparable to MS SQLServer and Oracle in performance. Also, running the DB on a
dedicated DB server may buy some performance. If you must check out SQLServer, then
http://www.sqlteam.com is a good place to start.
Duke,
The best thing is to get a good book on the subject. There is 1st normal
form, 2nd normal formetc. (quite a few).
I would think that 1st normal form should do (i.e. no repeating groups as in
address1, address2...addressN) Look at how the data relates to each other.
The nature of
Try using :
SELECT table1.UserName
, table1.City
, table1.State
, table2.Sex
, table2.Age
,table3.SpouseAge
FROM table1
, table2
, table3
WHERE table1.UserName = table2.UserName
AND table1.UserName =
In the last part of a script that loads the image into the database:
$qs = FetchImage.php3?nbr=.$lastone;
echo center;
echo image src='.$qs.';
Where $lastone is a reference to the image just inserted into the DB:
$lastone = mysql_insert_id($someonnection);
Notice that the img src is a php
Here, I think you may be over - using session variables a bit...have not used them in
php, as I have version 3, which doesn't support them. However, by day I am an ASP
developer, and article after article I read warns about session variables! They are
great, but can hog
memory, especially if
Hi,
ok, first of all make sure your form tag is like :
form method="POST" name="ImageForm" action="UploadImage.php3"
ENCTYPE="multipart/form-data"
The ENCTYPE is important!
Next, make sure you have a field like:
input type="file" size="50" name="txtImage"
type="file" is important! This will
Hi,
Check out
http://www.zdnet.com/devhead/stories/articles/0,4413,2643888,00.html
for a good workable example of using PHP/MySql to do this - the principles
should
be the same.
Also, search www.asptoday.com for the word "blob" to find some good articles
on the topic.
Phil J.
Marcel Liberda
Brian,
To echo your other replies, there is always a trade-off between cost, ease of
mainenance, usability, and functionality.
PHP seems to go quite hand-in-hand with MySQL, despite some limitations. I'd
take a look at the MySQL site and
see first if you can live with those limitations.
Ive
Hmmm...given that the form fields all had the same names - i.e. you were
performing
the same sql, you could use and include or "required" file that did all the DB
work.
Or - you could have a generic includr file function that you passed a
connectstring and
sqlstring to as variables
Phil J.
Julio,
It is much more efficient to do that type of validation client-side, using
Javascript. No
sense in making another round trip to the server if not necessary.
Here is a quicke example:
if (document.autoform.txtVehicleNumber.value == ""){
document.autoform.txtVehicleNumber.focus()
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,
I think you will have to send mime mail to send the page as an attachment.
See
http://www.wrox.com/Books/Book_down.asp?section=11_3isbn=1861002963subject=subject_id=
There you can download some source code from the "Proffesional PHP" book as
a zip file. There will be a "mime_mail.inc" and a
What is retrieved if you do a Select Count(*) from myDb where
condition = parameters?
Seems your result set should contain this value...
Phil J.
DC wrote:
Hi All
I cant quite work out how to count the number of rows in my mysql db that
match a certain critieria and the show that number
If there are some fields that you absolutley require, or must be in a valid
format, I'd
use javascript to edit the form first - no reason to make a round trip to
the server for
something you can do server-side.
**Or** - say the form is for selecting an automobile - make is required but
color
Hi,
If I were to try to connect to a MySQL DB from some scripting language,
in the connection string what do I put in the "provider=" string for
an ODBC connection?
I'd like to try this from an ASP application using ADO, but need to know
this. Before
you boo and hiss - I've duplicated the
Dunno without looking at code, but try storing the value of $customer into a
local variable when the script is invoked - something is wiping it clean.
my thunks,
Phil J.
Scott Kalbach wrote:
I am having a problem with losing a variables value. What I am doing is
taking the value from a
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
I think your only choices are to put this value into either a database or if
you are using
php4 - to use a session varible - or use a cookie if you are trying to
persist this value
across multiple pages for multiple users...or pass as a querystring to the
next page..
or as a hidden form variable
Hi,
Does anyone know the proper method for inserting an image(*.jpg or
*.gif) into a MySql database blob field? I am recieving the file via an
html form with the usual enctype for this and input type=file
parameters. I can save it as just a regular file and then display it
fine on the page, but
Perhaps the quote marks within quote marks? PHP,as is javascript, very
particular..
Try:
echo "Name: $row['user_id'].'br\n"; or some such.
or
echo "Name".$row[user_id]."br\n";
It's the quote marks within that are playing havoc..
Phil J.
Chris Hall wrote:
I keep getting this error on a little
25 matches
Mail list logo