Greetings, Sharmad!
At 17.07.2001, 08:27, you wrote:
SN> Hi,
SN> Can anyone tell me how to protect my database or else how can i set my
password in postgres for every database.
Can you be more specific?
If your problem is that anyone can connect to any DB on local box
(which is th
Hi,
You could use something like
#start
do
{
echo "";
$fields=odbc_num_fields($data2);
for($i=3 ; $i<=$fields ; $i++)
echo "";
if (odbc_result($data2,$i) = 'SOX')
echo "".odbc_result($data2,$i)."";
else
echo odbc_result($data2,$i);
echo "\n";
} while(odbc_fetc
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 pro
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 PAs
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 functions,
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. mysql.so
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
___ _ _
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 e
dl("mysql.so"); won't compile it... You need to provide the "mysql.so"
file for it to link to, but I don't know where to obtain it... :(
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 12:12 AM
To: Matthew Loff; 'PHP DB Mailing List'
Subje
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 n
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 [m
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"
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 i
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,,
MySQL is a DBMS. Oracle is a DBMS. Different products from
different vendors. MySQL doesn't tell you if you have O
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 modu
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] =
Help.
I just spent the last hour looking for the
the PHP extension library to see what the
the PHP extension defined in library is to put in
dl (string library);
to load an extension at run time.
has someone seen the library door?
I Keep missing it?
Ken
- Original Message -
From: "Matth
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:
if(!extension_
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
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 need..
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,,
K
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
http://www.rfbd
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: <[EMAI
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 Zon
In article <012601c10e4a$6c7a2ec0$b943500c@zeospantera>,
[EMAIL PROTECTED] (Ken Sommers) wrote:
> Suppose I Need to get Vendor prices from a very large remote (Oracle) price
> list .
> They probably don't have PHP installed.
If...
-you have PHP installed,
-AND you have Oracle support compiled
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 "";
(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 L
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 databas
In article <00c801c10e3f$758ba8a0$b943500c@zeospantera>,
[EMAIL PROTECTED] (Ken Sommers) wrote:
> are you saying that i can grab the output of your echo() statements in YOUR
> PHP script by Fopen()ing your URL
Yes, you can use it that way.
> IF so,, is this done much?
It's done. I can't qua
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 PROTE
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,
>
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 ques
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
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?
Suppo
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 i
"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 fr
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 nam
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
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
Sub
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),
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,
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 it'
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 acce
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 t
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 t
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
of an html page?
is this the "body we are talking about or some other body?
what is the secret code involved?
thanks a
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, "SELE
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 1
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
select * from test where cat like 'c'
or, a little broader
select *from text where cat like '%c%'
Miles Thompson
At 02:56 PM 7/16/01 -0400, McShen wrote:
>ok. I use set to make a table. here is my table 'test'
>+---+--+
>| name | cat |
>+---+--+
>| shen | a,c |
>| shen1 |
> -Original Message-
> From: McShen [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 1:56 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Re: enum !!
>
>
> ok. I use set to make a table. here is my table 'test'
> +---+--+
> | name | cat |
> +---+--+
> | shen
BTW, did i insert those data correctly?
here was what i type
insert into test values('shen','a,c');
insert into test values('shen1','a,c');
I think they were wrong.
How do i insert 2 values ?
"McShen" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> ok. I us
ok. I use set to make a table. here is my table 'test'
+---+--+
| name | cat |
+---+--+
| shen | a,c |
| shen1 | b,c |
+---+--+
How can I find all records that contain 'c'?
i tried
select * from test where cat='c';
it returned "empty set";
please help
"Tom Hodder"
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 PR
"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 |
> +---
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 | | NUL
Make sure you have ENCTYPE="multipart/form-data" in the tag,
otherwise it will not work. You should have a begin and end 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
[EMAI
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
> c
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,
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 the
When i use php (all version) with oci8 version 8.1.7 on linux, all character
like éèàù etc, are converted.
script:
";
?>
Fonction value is "générique" and appear "generique" on web page.
How can i get good charater?
Thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe
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] Questio
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
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
- Web-Development
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
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
securing.
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
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
ther eis no problem connecting to the db every page unless you have problems
that are discussed at postgresql.org regarding persistant connections.
i used them had problems with zillions of postmasters starting.
use the following and include it in the pages that need db access.
Steve
"Cornel
HI NG!
I need a unixODBC connection to a DB2 Server for executing PHP scripts on a
Webserver!
On the Webserver(Redhat 6.2) Apache is installed with PHP and unixodbc; the
DB is running on a other Server(RS6000, AIX);
UnixODBC works fine, i have allready connected to a Sybase ASA 7.0.1, The
Sysbase
Hi all,
I am stuck on a problem and I can certainly do with some help.
I want to create an array with the values of one field from a mysql database
and then add all of it up.
if ($numrows>0) {
$i=0;
while ($list = mysql_fetch_array($result))
$total[$i]=($list["price"]*$l
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) )
{
//
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
b
Jennifer Arcino Demeterio wrote:
> i have a script to identify if the input is a combination of letters and
> numbers
>
> if (eregi("[a-zA-Z0-9][0-9]+[a-zA-Z][0-9a-zA-Z]",$fieldvalue))
> print "alphanumeric"
> } else {
> not an alphanumeric
> }
> my problem is, when the string ends with a number,
In article <001601c10dc9$e4513780$[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Jennifer Arcino Demeterio) wrote:
> i have a script to identify if the input is a combination of letters and
> numbers
>
> if (eregi("[a-zA-Z0-9][0-9]+[a-zA-Z][0-9a-zA-Z]",$fieldvalue))
> print "alphanumeric"
> } else
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 con
76 matches
Mail list logo
