i honestly don't know direct stats on uptime, they seem pretty good, i
haven't tried hitting them yet and been greeted with an error :P
i have experienced lag-periods, but don't know if this is becuase of me
being in AUS and them in the US, because of my dodgy dial-up ISP, or becuase
of their
hi.. friends
i have a database (mysql) in which their r many records. Through PHP i want them to
display on the page.
Main requirement is that there should be a NEXT - PREVIOUS facility. So if there r 20
records and suppose only 10 should show up on scren at a time, then a NEXT link should
rough and readysomething like this should work...
$pagesize = 20;
$page = $page ? $page : 1;
$pages = ceil(mysql_num_rows( $results ) / $pagesize );
mysql_data_seek( $results, ($page - 1) * $pagesize );
while( ($row = mysql_fetch_object( $results )) ( $counter++
$pagesize) )
{
//
Hello,
Pranot Kokate wrote:
hi.. friends
i have a database (mysql) in which their r many records. Through PHP i want them to
display on the page.
Main requirement is that there should be a NEXT - PREVIOUS facility. So if there r
20 records and suppose only 10 should show up on scren
Why not simply : [a-zA-Z0-9]+ that would match any sequence of letters or
numbers ?
- Mensaje original -
De: Jennifer Arcino Demeterio [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviado: lundi 16 juillet 2001 04:35
Asunto: [PHP-DB] problem with regular expression
i have a script to
I have been working on a multi-tier solution that is based off some of the
scripting found at phpbuilder.com. It works with Linux, Apache and MySQL, as
well as uses .htaccess to optionally authenticate, allowing you to
authenticate in multiple ways, depending on what kind of data you are
PHP manual says:
fopen
fopen -- Opens file or URL
Description
int fopen (string filename, string mode [, int use_include_path])
If filename begins with http://; (not case sensitive), an HTTP 1.0
connection is opened to the specified server, the page is requested using
the HTTP GET method, and a
Hi Brian,
... well, I think that there'll be a few people interesting in it,
me too. Why simply put it on phpclasses or the other well-known
source- and project-stores ??
If you don't want to do this, please let me know if you could mail
me this then.
TIA,
Mike
Michael Rudel
-
On Mon, Jul 16, 2001 at 10:41:15AM -0300, Thomas wrote:
- Mensaje original -
De: Jennifer Arcino Demeterio [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviado: lundi 16 juillet 2001 04:35
Asunto: [PHP-DB] problem with regular expression
i have a script to identify if the input is a
You could split the string on the slashes with explode('/',$string) and
then manipulate the array elements you get back.
Good luck,
Ben
-Original Message-
From: Dennis Kaandorp [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 15, 2001 9:21 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB]
When i use php (all version) with oci8 version 8.1.7 on linux, all character
like éèàù etc, are converted.
script:
?
// connection a la base linux
$c = ocilogon(toto,totopass,linux);
$sql = select * from toto_table where fonction like 'g%';
$stmt = ociparse($c, $sql );
ociexecute($stmt);
hi,
i've got myself into a bit of a mess. i have a database with approx 4000
records (mysql) and when i populated the database i was given 4000 text
files with the product name as the file name and the description of the
product as the contents.
so i set up a text field in the table to hold
PHP manual says:
fopen
fopen -- Opens file or URL
Description
int fopen (string filename, string mode [, int use_include_path])
If filename begins with http://; (not case sensitive), an HTTP 1.0
connection is opened to the specified server, the page is requested using
the HTTP GET method, and a
BD pressed the little lettered thingies in this order...
Ugh!
I'm sure this is fairly simple, but I have yet to come up with a way to do
it...
In a nutshell, our application creates, uses and drops a table while the
user is working on the site. Unfortunately, because of other
Make sure you have ENCTYPE=multipart/form-data in the FORM tag,
otherwise it will not work. You should have a begin and end FORM tag and
make sure it has the ENCTYPE attribute, and the METHOD='POST' and the ACTION
attribute filled in, too.
Comp.Mail.Sendmail [EMAIL PROTECTED] wrote in message
how do i store multiple data in one field?
i have a table like this
+---+---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+---+--+-+-+---+
| test | enum('a','b','c') | YES | |
McShen [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
how do i store multiple data in one field?
i have a table like this
+---+---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
First normal form (1NF), A table in which the intersection of every column
and record contains one, and only one, value.
-Original Message-
From: Hugh Bothwell [mailto:[EMAIL PROTECTED]]
Sent: 16 July 2001 19:21
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: enum !!
McShen [EMAIL
Yes, that syntax is OK if you EXACTLY match the structure of the table. If
you redesign the table and insert a column between name and cat, your data
will go into the new field. For that reason I prefer
insert into test set name = shen, cat = a,c
Yes, one insert statement per line. To do
The body of the response is the data that the
http://www.site.com/MovieResponder.php script would produce.
The fread() call that I meantioned before would read -all- of this data
into a variable.
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July
I applaud your efforts to learn SQL.
I wonder, though, if the PHP-DB list the best place to learn SQL. I would
think that a book or a web-based tutorial on SQL would be more conducive to
your efforts.
In the example you have given below, you would probably want to use LIKE.
For example,
thanks for response,
I am curious, how does the http://www.site.com/MovieResponder.php script get
the data in the body?.
what is the mechanism involved?
is this body the
body
/php echo $data;?
/body
of an html page?
is this the body we are talking about or some other body?
what is the secret
Whats up guys? I got a quick question about how the Mac OSX Server handles the Apache
modules. I am not sure, but I am hoping that the way it handles Apache is the same as
the PC port. I was reading some documentation in a info.php file from the OSX Server
Library directory and it said I had
The httpd.conf file is in /etc/http/conf
thanks,
beckie
http://www.onlymacintosh.com
On Tue, 17 Jul 2001, Brian Tegtmeier
wrote:
Whats up guys? I got a quick question about how the Mac OSX Server handles the
Apache modules. I am not sure, but I am hoping that the way it handles Apache is
MovieResponder.php can generate -anything- you want... HTML code, a
serialize()d array, or anything else...
By using fopen() to call http://www.wherever.com/MovieResponder.php and
fread() to grab the data to a local variable, you're calling the
MovieResponder.php script as if you are simply
MR.Loff,
I see the concept.. but i still don;t see the secret code.
for this process:
And you created MovieResponder.php to give you this response:
Movie One 1977
Movie Two 1977
Movie Three 1977
how does it GIVE..is there a php function called GIVE()?
where does the Give() function Give
Ken--
There's no secret code. By giving the response, I mean the
MovieResponder.php outputs that data... This is the most elementary of
PHP features... See:
http://www.php.net/manual/en/function.echo.php
http://www.php.net/manual/en/function.print.php
By giving the data to your script, I am
In article 008101c10e0f$379207e0$c844500c@zeospantera,
[EMAIL PROTECTED] (Ken Sommers) wrote:
PHP manual says:
fopen
fopen -- Opens file or URL
Description
int fopen (string filename, string mode [, int use_include_path])
If filename begins with http://; (not case sensitive), an HTTP
I looked up Output();
could not find output() function in PHP.
what is the secret code to output?
Ken
- Original Message -
From: Matthew Loff [EMAIL PROTECTED]
To: 'Ken Sommers' [EMAIL PROTECTED]; 'PHP DB Mailing List'
[EMAIL PROTECTED]
Sent: Monday, July 16, 2001 2:05 PM
Subject: RE:
Ken--
Output is a term I use to describe using echo or print on the data.
There aren't any secret codes in PHP. :) There are functions and
language constructs.
See http://www.php.net/manual/en/functions.php
Perhaps you should look into purchasing a book to learn how to get
started with
Is it possible to exchange data on remote databases in PHP mysql?
Suppose I had a MUSIC database that you wanted your site visitors to be able
to query,and it was OK with me because you had a MOVIE database that I
wanted MY site visitors to be able to query,
Could we swing this?
what is the
are you saying that i can grab the output of your echo() statements in
YOUR PHP script by Fopen()ing your URL in MY script and then Fread()ing
that resulting file pointer?
--Yes! That's -exactly- what I've been trying to explain. :)
That's the -best- way I can think of retrieving the info
I'm experiencing slowness in the fetching of result sets. I
set the cursortype parameter as suggested by Christian
Szardenings to SQL_CUR_USE_ODBC, and I get the following:
Warning: SQL error: [IBM][CLI Driver] CLI0150E Driver not
capable. SQLSTATE=S1C00, SQL state S1C00 in
SQLSetConnectOption
thanks CC,
are you saying that i can grab the output of your echo() statements in YOUR
PHP script by Fopen()ing your URL
in MY script and then Fread()ing that resulting file pointer?
IF so,, is this done much? or are there easier more stable less error-prone
ways to access remote databases?
thx alot!
Doug Semig [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I applaud your efforts to learn SQL.
I wonder, though, if the PHP-DB list the best place to learn SQL. I would
think that a book or a web-based tutorial on SQL would be more conducive
to
The mysql_connect() function accepts a host name, which can be the
internet address of another machine! However-- the MySQL database on
that machine has to be set up to allow outside connections for whatever
particular username/password you are using!
Please see these pages to answer your
In article 00c801c10e3f$758ba8a0$b943500c@zeospantera,
[EMAIL PROTECTED] (Ken Sommers) wrote:
Suppose I had a MUSIC database that you wanted your site visitors to be able
to query,and it was OK with me because you had a MOVIE database that i
wanted MY site visitors to be able to query,
Suppose I Need to get Vendor prices from a very large remote (Oracle) price
list .
They probably don't have PHP installed.
What are my options?
Ken
- Original Message -
From: Matthew Loff [EMAIL PROTECTED]
To: 'Ken Sommers' [EMAIL PROTECTED]; 'PHP DB Mailing List'
[EMAIL PROTECTED]
In article 00d201c10e41$9fa2e340$b943500c@zeospantera,
[EMAIL PROTECTED] (Ken Sommers) wrote:
Is it possible to exchange data on remote databases in PHP mysql?
PHP is a scripting language.
MySQL is a database management system (DBMS).
Two different things.
Suppose I had a MUSIC database
(Quote from an annotation found on
http://www.php.net/manual/en/function.ocilogon.php):
[EMAIL PROTECTED] 31-Mar-2000 11:32
Regarding connecting to an Oracle Db on NT from Linux, here is what you
need to do. Little Oracle knowledge is a prerequisite.
1. Install Oracle database client onto
How would I code IF .odbc_result($data2,$i) = 'SOX' THEN make it a link? By link I
mean that I want the word SOX highlited in blue and underlined and referencing a
webpage that explains SOX verbosefully. Don't know PHP IF THEN syntax too well.
/* fill table with data */
do
{
echo tr;
I am not familiar with Oracle, but by looking through the PHP docs, it
appears that you can't connect remotely to an Oracle server...
Am I wrong about this, or is it a limitation of the Oracle library, or
is Oracle not built to allow remote connections?
-Original Message-
From: CC
Great,
thanks for a complete answer
I love it..
I ran
mysql show variables;
to see if my host server has Oracle support,,
I don't see anything about Oracle or any other DBMS,,
any way to tell without asking them?
ken
- Original Message -
From: CC Zona [EMAIL PROTECTED]
To: [EMAIL
Thanks, Christopher...
I feel better now knowing that I wasn't just missing something really
obvious.. on the other hand, I should have thought of the stateless aspect
myself
I'll take the timestamp approach, and see what I can come up with...
BD
http://www.bustdustr.net
Any one use or know of a php/mysql/unix-Linux hosting company with
PHP database support compiled with all the major DBMS's such as:
mSQL
MySQL
PostgreSQL
Sybase
Oracle
Informix
MS-SQL
Other ODBC Database
I will need to use some or all of these DBMS PHP functions
for remote access.
thanks,,
Even if a PHP host doesn't have all the DBMS extensions you need, you
could compile them and load them yourself with dl()
http://www.php.net/manual/en/function.dl.php
I thought you might want to keep that in mind, in case one particular
host has a great price but not all the features you
Thanks for the HOT tip..on the dl() function.
should the dl() function work an ANY PHP4 host?
or do restrictons apply?
would I put the dl() at the top of EVERY script page In which I Need the
functionality..?
or just load it once per session and check and see if it';s already loaded
before
I'm not sure if dl() can be restricted in php.ini-- Someone else will
have to comment on that...
I believe you'll have to dl() on every page you create... You could
always do the following for portability to other PHP hosts, just in case
they have the module already compiled in:
is this what some of them look like
is this the name that would go into the dl() function??
print_r (get_loaded_extensions());
will print a list like:
Array
(
[0] = xml
[1] = wddx
[2] = standard
[3] = session
[4] = posix
[5] = pgsql
[6] = pcre
[7] = gd
[8] = ftp
The ext/ directory under the PHP source tree contains the source to the
extensions...
You're right about the dl() syntax, except the parameter would need to
be in quotes, and dl() requires the full filename of the extension.
For xml, it would be:
dl(xml.so);
But compiling those shared
In article 001b01c10e52$0c08e060$3c41500c@zeospantera,
[EMAIL PROTECTED] (Ken Sommers) wrote:
I ran
mysql show variables;
to see if my host server has Oracle support,,
sighMySQL is a DBMS. Oracle is a DBMS. Different products from
different vendors. MySQL doesn't tell you if you have
Here is an opportunity that you can take up FREE. If you join as an
affiliate, we'll teach you how to build a profitable business on the
Internet, using our system to create an income stream and earn income
globally, 24 hours a day.
Don't let this opportunity slip past you - our organization
thanks Mat,
I found this FAQ:
When I try to connect to mysql from php I get this error: Call to
unsupported or undefined function mysql_connect();
Updated: 2001-06-01
Either you miss mysql support in the php module or you need to load mysql
dynamicly in your scripts by inserting:
dl(mysql.so);
That's all there is to it, I'm just not sure how to compile the mysql.so
file! I looked through the PHP source tree, but the makefiles don't
seem to be able to build the shared libs.
Maybe it, along with others, can be downloaded from somewhere.
-Original Message-
From: Ken Sommers
I'm hoping the dl(mysql.so); compiles it for you.
I found this FAQ: http://www.alt-php-faq.org/#id7
When I try to connect to mysql from php I get this error: Call to
unsupported or undefined function mysql_connect();
Updated: 2001-06-01
Either you miss mysql support in the php module or you need
I think and hope it works like this
the .so(unix) or .dll(win32) file is already a binary compiled executable
(I know for a fact that the Win 32 dll's ARE) I looked at one with my file
viewer quick view plus
I have php4/mysql/apache on my local host computer (Win95) I am typing into
now.
so the
Hi,
Can anyone tell me how to protect my database or else how can i set my
password in postgres for every database.
-Thanks
Sharmad
--
Donot rely on the Operating System which don't have any sources for.
-Seen somewhere on the Net
___ _
You're correct that .so files are like Windows' .dll files... However,
if the library were already available on the PHP host, it most likely
would already be included in the PHP binary...
Perhaps (as you suggested) you need to find binary distributions of each
individual library (e.g.
Do you mean the hosting company would have compiled PHP with all the
extenions available at compile time?
I have looked at two different hosting company's phpinfo()
the only dbms they build PHP with is mysql..or its' already built in
I think the resoning is: IF you want other dbms PHP
Hi all',
I have a mysql_query that reads:
$testResult = mysql_query(SELECT * FROM login_table where Pass =
password('$password')) or die (ouch);
$num_rows = mysql_num_rows($testResult);
the problem is that I keep getting a value of 0 for $num_rows when I know
the table has 1 entry for PAss
guys and gals,
as sad as i am to admit it, i am in the process of converting a php project
into ASP. this means i am using an dobc connection to connect to the exact
same database as i was using under php (it's a mysql database, so using the
myodbc driver on win2k machine) and i am having some
61 matches
Mail list logo