I am in the process of improving a database scheme considerably in MySQL, by
breaking tables into smaller tables and so one. I am wondering if there is a
simple SQL statement to take ALL ROWS of fields 'f1', 'f2', 'f3', and copy
them to the another table Then I can remove the fields in the ori
Hi Netlanders
Traditionally, we have two files in our apps. A HTML page that has a form
and a PHP file that processes the form info. I have a web-based front end
that is used to added data to a table. Can I do this with one PHP file
alone?
Regards
Sridhar Ranganathan
_
Thanx, will try. Curious: using the Professional PHP Programming book, and got
the other code which didn't work. How is one to know how to move these things
around? Just practice and error?
Can you help with this also, can't get the Generate . . . functions to respond,
such as:
test");
}
?>
is t
I tried to do this using mssql7 php extension, and it didnt work.
However Unified ODBC functions worked well.. whats the problem?
Extension, Server, or may be i'm doing wrong queries?
for inserting image: $result = mssql_query("insert into image_table
values ($id, '$image_data')");
- not work
Hi.. i'm using MySql version 3.22.32 and I installed the Apache Compile Kit
containing the following:
Apache 1.3.14
php3 3.0.16
php4 4.0.3pl1
I have the following problem while using PHP4.. Wheneven I write to the
database, I see the following warning on the resultant page on the browser :
"Wa
The CREATE TABLE .. FROM ... SQL will do what you require, but I don't
think this is included in MySQL (one to check)...however if performance is
becoming an issue, ,then you may want to consider migrating to a different
DBMS (mySQL is not so good at handling large record sets, and has a much
cut-
After spending the last two weeks feverishly learning and coding php &
mySql, I'm ready to go live and have discovered that my Hostpro Virtual
Server (Used to be Vservers? never mind...) "doesn't support
password-protecting individual databases". I thought it strange that I
didn't need any user/pa
Try this:
Error " . mysql_errno() . ": " . mysql_error() . "";
elseif (mysql_num_rows($result) == 0)
echo "Query executed successfully!";
?>
Best regards,
Joseph H.
http://BlueChillies.com
Your Freeware and Shareware Download Destination
>Another strange error, parsing:
>
>if ($result == 0)
Yes .. you can do it like this.
Have two functions
1)generateForm();
2)processData();
In the generateForm function use a hidden form field called say "action"
with a value say "process"
Then put a code like this.
if ($action == "process") {
processData();
}
else {
ge
Hi,
You can use
"insert into newTable(field1,field2,field3) select red,green,blue from
oldTable"
HTH
Jaski
At 10:11 PM 2/4/01 +1300, phobo wrote:
>I am in the process of improving a database scheme considerably in MySQL, by
>breaking tables into smaller tables and so one. I am wondering if the
Not trying to write an ad here, but Hostpro is a company that rents server
space and lets me serve multiple domains out of my space. I went with them
to save money, and because they offer tons of goodies, SSI, CGI, PERL, PHP,
mySql, shell & CRON access, unlimited email accounts with aliases and
vi
Does php log its activity anywere? especially for debugging purposes?
Some of my scripts don't show any browser window areas, but also don't
show any results int he browser, i.e., a blank screen, and yet aren't
working. thanx.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
(Marc Bragg) wrote:
> Does php log its activity anywere? especially for debugging purposes?
> Some of my scripts don't show any browser window areas, but also don't
> show any results int he browser, i.e., a blank screen, and yet aren't
> workin
Has anyone seen a good lession or code example on paging records from MS Sql
7? Say I have 300 records and
want to break them down to 10 per page using [previous | next ] and a list
of page numbers at the bottom.
tia
-Scott
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e
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 me a short update on what options I have ?
TIA !!!
-pete
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For addit
> 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 me a short update on what options I have ?
- JDBC - exec an external program.
- unixODBC ...etc.
- PHP with native ibm db2 support
I have successfully
There's been a lot of talk about this recently. Check the archives for the
last 2 months, and PHPBuilder.com
Last I heard, you needed DRDA(DB2 Connect) installed, as well as
the runtime client.
Also on the client - DB2 Application Development package. Use this to
compile PHP --with-ibm-db2=.
Hello,
Well, I haven't used arrays in PHP too much and am wondering how I might
go about this:
I want to loop through a result set, say with ODBC, and use the
"fetch_array" function for each row. Now, What I want is a an array of all
the rows, so I could then access the "Name" column in Row 5 l
Like this:
$blah = "hello";
$miaow[$blah][5] = 3.14;
( is the same as doing $miaow["hello"][5] = 3.14; )
- Siggy
- Original Message -
From: "Alarion" <[EMAIL PROTECTED]>
To: "'PHP-DB'" <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 10:06 AM
Subject: [PHP-DB] arrays
> Hello,
>
In article <000401c08e92$84cf2030$0100a8c0@phobo>, phobo
<[EMAIL PROTECTED]> writes
>I am in the process of improving a database scheme considerably in MySQL, by
>breaking tables into smaller tables and so one. I am wondering if there is a
>simple SQL statement to take ALL ROWS of fields 'f1', 'f2
Right, but what I am trying to figure out, is how to get the "key" names for
the arrays.
for example, if I have a users table:
users
-
id
name
password
and I want to select * from users and load ALL the data into an array, for
the use in easily moving back and forth in the data set,
see www.php.net/odbc
you want to use odbc_field_name() and odbc_num_fields()
Siggy
- Original Message -
From: "Alarion" <[EMAIL PROTECTED]>
To: "'phobo'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 11:46 AM
Subject: RE: [PHP-DB] arrays
> Right, but wha
Thanks for the tip - I'll give it a read and see if it'll work for me. I
need to get a handle on sessions & cookies anyway, maybe this is a good
time.
I don't have any php books, good or otherwise. I've been using the
documentation at www.php.net and scanning the list archives to feel my way
arou
Hi Mark,
I run Oracle 8i with apache and PHP 4 on about 6 different machines ,
all connect to a remote DB and i have no problems @ all.
Regards
Steve Farmer
At 8:29 AM -0600 2/2/01, Mark Farver wrote:
>I am running Oracle 8.0.5 Net8 drivers on a Win95 system using Apache
>and PHP4.04pl1. I'm g
Dear [EMAIL PROTECTED],
{Thank you - you have been automatically removed from all future mailings.}
Every month over 1,000,000 new commerce web-sites join the internet. Newcomers to the
Net who need your help.
The question is, how do you trace them, and sell them your Internet Program?
In fa
Drew,
It is a good idea to explicitly close the connection and release the
connection handle on the server side. If Apache PHP threads do not exit
normally the database session can remain open. This leaves a zombie
connection on the database server.
What is your connection/close logic and what
Hi,
Does anyone know of or have a problem that means that the
HTML server will not receive the message back from the MySQL
server to say close the connection.
The two servers are on two seperate machines.
The html server is Apache using the PHP scripting language.
The error messages I
Hi everybody,
We recently had (and have) similar problems running PHP4/Apache with 10
FreeBSD Clients and a SunE450 with Oracle 8.1.6. The machine is quite
powerful (4 procs, 4 Gigs RAM). Anyway, we had to limit the number of
simultaneous dedicated connections after our server was blown up wit
Hi Lisa,
>Can search engines index any HTML pages that have .php as its extension (any
>.php pages without a '?' or '&' in the URL) ? For example:
>http://www.blablabla.com/blabla.php
>
>Thanks,
>Lisa E
yes they can, but my experience is, that most search engine robots do _not_
index pages endi
James Smith wrote:
>Is there a way that when a user signs up for a
>user/pass on a site, to automatically update the
>.htpasswd on the site? Right now I'm running a Win2k
>Pro, with Apache installed and MySQL/PHP.
>
>Thanks,
>
>James
The quite simpliest method is to put appropriate directives
Hello,
I am a newbie. I downloaded a new php 4.0.4pl1 rpm and installed it in
my linux box Red Hat version 7.0 which also has a mysql server inside.
The problem is whenever it comes to calculations using bcmath functions,
PHP returns fatal error. I realized that the rpm version of php is not
compi
Suhardi,
Download the source and configure and make it with the appropriate directives.
Wayne
On Mon, 5 Feb 2001 14:18, Suhardi Hamid wrote:
> Hello,
> I am a newbie. I downloaded a new php 4.0.4pl1 rpm and installed it in
> my linux box Red Hat version 7.0 which also has a mysql server insi
You could also run something like:
system("htpasswd -b passwordilf $user $password"),,,basically get the shell to
run a the htpasswd program supplied by apache. you might have to play around
with the permissions to do this, so the webserver can execute the htpasswd
binary.
/cody caughlan
Victor
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/modules/libphp4.so into
server: libdb2.so.1: cannot open shared object file: No such file o
Chris,
Looks like libphp4.so need sto know where libdb2.so.1 is. I would look at two
things: if db2 libraries are not in the standard location then you need to
specify the location in --with-ibm-db2=/home/ (this is a guess).
or
look at ldconfig - you will probably need to specify the db2
Hi,
you might want to take a look at this one:
http://www.thewebmasters.net/php/Htpasswd.phtml
Works in both php3 and php4.
Give you functions for adding/deleting/listing/renaming users + much more,
in standard .htpaccess password files.
I use it myself on several sites, it works great.
- t.a
Am I blind? Or is there no support with the regular oracle functions to connect to a
database that is hosted on another machine?
The manual has this:
$conn = Ora_Logon(username, password);
but I don't see anywhere to put the host string.
- Doug Schasteen
Well, if it says that it's looking for it in /etc/httpd/modules then it's
obviously not looking in /home/db2inst1/sqllib/lib, eh?
Try a symlink...
"ln -s /home/db2inst1/sqllib/lib/libdb2.so.1
/etc/httpd/modules/libphp4.so/libdb2.so.1"
Or copy the library.
Or I think you can add a line into /et
Hi all,
Thought I would try sending this again - didn't get a reply last time -
guess I'll give up if this attempt doesn't get a reply . .
I've just subscribed and haven't even got any mail from the list yet so I
hope this isn't a dumb question . .
The php xBase interface is very basic so:
W
39 matches
Mail list logo
