RE: [PHP-DB] MySQL database converter ?

[Bastien Koert]

DB Designer4 from fabforce (www.fabforce.net/dbdesigner4/)
bastien
From: Nayyar Ahmed <[EMAIL PROTECTED]>
Reply-To: Nayyar Ahmed <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL database converter ?
Date: Tue, 4 Jan 2005 10:36:20 +0500
Hello All:
Is there any tool available for conversion of M$ Access, Oracle etc 
Databases
to MySQL database ?

TIA:
--
Nayyar Ahmad
Lecturer
Faculty Of Computer Science,
Institute Of Management Sciences,
Hayat Abad Peshawar , Pakistan.
Office : 92-091-9217404 , 9217452
Cell :  92-0333-9139461
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL database converter ?

[Jochem Maas]

Nayyar Ahmed wrote:
Hello All:
Is there any tool available for conversion of M$ Access, Oracle etc Databases
to MySQL database ?
google will probably give you more answers than this list (try also 
searching for the term 'datapump' and variations on it)

IBExpert is one tool that will allow you to reverse engineer an existing 
DB and then use the model that is created to generate SQL to create a 
new DB in the format of your choice (the 3 you mention are supported)

also bare in mind that not all features of each database can be 
translated to the others.

TIA:
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] MySQL database converter ?

[Manoj Kumar]

Hi Everybody , 
 
 Daffodil DB Migration tool provide import/export from a database to
another. It is available at http://www.daffodildb.com/download/index.jsp and

comes with One$DB and DaffodilDB . Use DaffodilDB Browser to import and
export purpose. 


Regards,
Manoj Kr. Sheoran 
www.daffodildb.com 



-Original Message-
From: Nayyar Ahmed [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 04, 2005 11:06 AM
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL database converter ?

Hello All:

Is there any tool available for conversion of M$ Access, Oracle etc
Databases
to MySQL database ?

TIA:

-- 
Nayyar Ahmad

Lecturer
Faculty Of Computer Science,
Institute Of Management Sciences,
Hayat Abad Peshawar , Pakistan.
Office : 92-091-9217404 , 9217452
Cell :  92-0333-9139461

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MySQL database converter ?

[Nayyar Ahmed]

Hello All:

Is there any tool available for conversion of M$ Access, Oracle etc Databases
to MySQL database ?

TIA:

-- 
Nayyar Ahmad

Lecturer
Faculty Of Computer Science,
Institute Of Management Sciences,
Hayat Abad Peshawar , Pakistan.
Office : 92-091-9217404 , 9217452
Cell :  92-0333-9139461

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mysql database function problem

[Andres]

Hello Everybody!

I tried to connect with a mysql databasem , but It shows the follow error:

Warning: mysql_numrows(): supplied argument is not a valid MySQL result
resource in c:\inetpub\wwwroot\ejercicios\cap11\cursor.php on line 25

Número de filas en el resultado:

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result
resource in c:\inetpub\wwwroot\ejercicios\cap11\cursor.php on line 29

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result
resource in c:\inetpub\wwwroot\ejercicios\cap11\cursor.php on line 32

Warning: mysql_free_result(): supplied argument is not a valid MySQL result
resource in c:\inetpub\wwwroot\ejercicios\cap11\cursor.php on line 40

It seems doesn't  recognize the mysql functions I wrote in the code, or did
I something wrong?

I'm a newbie trying to learn and I have php 4.3.2  with mysql 4.0.13 in a
windows xp with ISS 5.0 and I've Installed those programs a lot of times
trying to fix it up but the problem remains.

I'll really appreciate any help.

Andres



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL Database connection Problem

[Jason Wong]

On Friday 03 January 2003 17:11, conbud wrote:
> Jason Wong wrote:
> > On Friday 03 January 2003 17:00, conbud wrote:
> >>Hello can someone give me some possible reasons this error happens when
> >>I use the mysql client to add a tabe to a database.
> >>
> >>mysql> create table home (id int not null, heading blob not null,
> >> -> primary key (id), unique id (id));
> >>ERROR 3: Error writing file './nrlug/home.frm' (Errcode: 28)
> >
> > This is obviously a mysql question. Go to their website and search on the
> > error message.
>
> Jason that seems to be your answer to everything, that and RTFM. 

I try to answer questions appropriately.

> Well I
> have already done both and cant seem to find anything on it, so thats
> why I would ask  here. Makes sense huh ?

No, it would make more sense to ask on the mysql mailing list. One would hope 
that the people there would know more about mysql than the people here.

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *


/*
The ultimate game show will be the one where somebody gets killed at the end.
-- Chuck Barris, creator of "The Gong Show"
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL Database connection Problem

[Andrey Hristov]

what about the permissions? are they ok?


Andrey

- Original Message -
From: "conbud" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 03, 2003 11:30 AM
Subject: Re: [PHP-DB] MySQL Database connection Problem


> Andrey thanks, but I seen that already and theres over 80 gig left on the
> server and about 17 gig of that is still alloted to the database.
>
> "Andrey Hristov" <[EMAIL PROTECTED]> wrote in message
> 010c01c2b309$8d8d7210$1601a8c0@andreywin">news:010c01c2b309$8d8d7210$1601a8c0@andreywin...
> >
> > http://www.alt-php-faq.org/local/74/
> >
> > Question :
> >
> > I am trying to create a database and keep getting an error :- (Errcode:
> 28)
> >
> > Answer :
> >
> > errcode: 28
> >
> > No space left on device
> >
> > This means that you are out of disk space.
> > Try du to see how much space is free/used
> >
> >
> > Best regards
> > Andrey Hristov
> >
> >
> > - Original Message -
> > From: "conbud" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > Sent: Friday, January 03, 2003 11:11 AM
> > Subject: Re: [PHP-DB] MySQL Database connection Problem
> >
> >
> > > Jason Wong wrote:
> > > > On Friday 03 January 2003 17:00, conbud wrote:
> > > >
> > > >>Hello can someone give me some possible reasons this error happens
> when
> > > >>I use the mysql client to add a tabe to a database.
> > > >>
> > > >>mysql> create table home (id int not null, heading blob not null,
> > > >> -> primary key (id), unique id (id));
> > > >>ERROR 3: Error writing file './nrlug/home.frm' (Errcode: 28)
> > > >
> > > >
> > > > This is obviously a mysql question. Go to their website and search
on
> > the
> > > > error message.
> > > >
> > >
> > > Jason that seems to be your answer to everything, that and RTFM. Well
I
> > > have already done both and cant seem to find anything on it, so thats
> > > why I would ask  here. Makes sense huh ?
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL Database connection Problem

[conbud]

Andrey thanks, but I seen that already and theres over 80 gig left on the
server and about 17 gig of that is still alloted to the database.

"Andrey Hristov" <[EMAIL PROTECTED]> wrote in message
010c01c2b309$8d8d7210$1601a8c0@andreywin">news:010c01c2b309$8d8d7210$1601a8c0@andreywin...
>
> http://www.alt-php-faq.org/local/74/
>
> Question :
>
> I am trying to create a database and keep getting an error :- (Errcode:
28)
>
> Answer :
>
> errcode: 28
>
> No space left on device
>
> This means that you are out of disk space.
> Try du to see how much space is free/used
>
>
> Best regards
> Andrey Hristov
>
>
> - Original Message -
> From: "conbud" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, January 03, 2003 11:11 AM
> Subject: Re: [PHP-DB] MySQL Database connection Problem
>
>
> > Jason Wong wrote:
> > > On Friday 03 January 2003 17:00, conbud wrote:
> > >
> > >>Hello can someone give me some possible reasons this error happens
when
> > >>I use the mysql client to add a tabe to a database.
> > >>
> > >>mysql> create table home (id int not null, heading blob not null,
> > >> -> primary key (id), unique id (id));
> > >>ERROR 3: Error writing file './nrlug/home.frm' (Errcode: 28)
> > >
> > >
> > > This is obviously a mysql question. Go to their website and search on
> the
> > > error message.
> > >
> >
> > Jason that seems to be your answer to everything, that and RTFM. Well I
> > have already done both and cant seem to find anything on it, so thats
> > why I would ask  here. Makes sense huh ?
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL Database connection Problem

[Andrey Hristov]

http://www.alt-php-faq.org/local/74/

Question :

I am trying to create a database and keep getting an error :- (Errcode: 28)

Answer :

errcode: 28

No space left on device

This means that you are out of disk space.
Try du to see how much space is free/used


Best regards
Andrey Hristov


- Original Message -
From: "conbud" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 03, 2003 11:11 AM
Subject: Re: [PHP-DB] MySQL Database connection Problem


> Jason Wong wrote:
> > On Friday 03 January 2003 17:00, conbud wrote:
> >
> >>Hello can someone give me some possible reasons this error happens when
> >>I use the mysql client to add a tabe to a database.
> >>
> >>mysql> create table home (id int not null, heading blob not null,
> >> -> primary key (id), unique id (id));
> >>ERROR 3: Error writing file './nrlug/home.frm' (Errcode: 28)
> >
> >
> > This is obviously a mysql question. Go to their website and search on
the
> > error message.
> >
>
> Jason that seems to be your answer to everything, that and RTFM. Well I
> have already done both and cant seem to find anything on it, so thats
> why I would ask  here. Makes sense huh ?
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL Database connection Problem

[conbud]

Jason Wong wrote:

On Friday 03 January 2003 17:00, conbud wrote:


Hello can someone give me some possible reasons this error happens when
I use the mysql client to add a tabe to a database.

mysql> create table home (id int not null, heading blob not null,
-> primary key (id), unique id (id));
ERROR 3: Error writing file './nrlug/home.frm' (Errcode: 28)



This is obviously a mysql question. Go to their website and search on the 
error message.


Jason that seems to be your answer to everything, that and RTFM. Well I 
have already done both and cant seem to find anything on it, so thats 
why I would ask  here. Makes sense huh ?


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL Database connection Problem

[Jason Wong]

On Friday 03 January 2003 17:00, conbud wrote:
> Hello can someone give me some possible reasons this error happens when
> I use the mysql client to add a tabe to a database.
>
> mysql> create table home (id int not null, heading blob not null,
>  -> primary key (id), unique id (id));
> ERROR 3: Error writing file './nrlug/home.frm' (Errcode: 28)

This is obviously a mysql question. Go to their website and search on the 
error message.

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *


/*
"sic transit discus mundi"
(From the System Administrator's Guide, by Lars Wirzenius)
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL Database connection Problem

[Andrey Hristov]

  Hi,
 Does mysql user has rights to write in this directory or permissions over
this file?

Andrey

- Original Message -
From: "conbud" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 03, 2003 11:00 AM
Subject: [PHP-DB] MySQL Database connection Problem


> Hello can someone give me some possible reasons this error happens when
> I use the mysql client to add a tabe to a database.
>
> mysql> create table home (id int not null, heading blob not null,
>  -> primary key (id), unique id (id));
> ERROR 3: Error writing file './nrlug/home.frm' (Errcode: 28)
>
> Any help would be appreciated
>
> Lee
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MySQL Database connection Problem

[conbud]

Hello can someone give me some possible reasons this error happens when 
I use the mysql client to add a tabe to a database.

mysql> create table home (id int not null, heading blob not null,
-> primary key (id), unique id (id));
ERROR 3: Error writing file './nrlug/home.frm' (Errcode: 28)

Any help would be appreciated

Lee


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] mysql database not 'taking' changes

[Mark]

--- Jody Cleveland <[EMAIL PROTECTED]> wrote:
> > Sorry. Stupid technospeak on my part.
> 
> No problem, much ignorance on my part.
> 
> > When you connect to the database, you tell it to use a particular
> > username and password. When these new tables were created, did
> you
> > change the permissions in the mysql table for the user, or does
> that
> > account have access to all the tables/databases? Basically, did
> you
> > grant or change permissions when the new tables were created?
> 
> I created a database called squirrelmail. I was logged in as root
> when I
> created it, but after I created the database, I typed:
> GRANT select,insert,update,delete ON squirrelmail.* TO
> squirreluser@localhost IDENTIFIED BY 'sqpassword';
> 
> > BTW, CRUD = Create, Read, Update, Delete
> 
> I was wondering what that meant!
> 
> It looks like the changes take now, but I have to logout of
> squirrelmail and
> log back in for them to take effect. Any ideas?

Not to punt, but you might want to check with the Squirrelmail folks
to see if that's normal behavior. I don't use it personally, but I
can refer you to a few people who do if no one on this list knows...

> 
> Thanks!
> 
> Jody


=
Mark Weinstock
[EMAIL PROTECTED]
***
You can't demand something as a "right" unless you are willing to fight to death to 
defend everyone else's right to the same thing.
-Stolen from the now-defunct Randy's Random mailing list.
***

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] mysql database not 'taking' changes

[Jody Cleveland]

> Sorry. Stupid technospeak on my part.

No problem, much ignorance on my part.

> When you connect to the database, you tell it to use a particular
> username and password. When these new tables were created, did you
> change the permissions in the mysql table for the user, or does that
> account have access to all the tables/databases? Basically, did you
> grant or change permissions when the new tables were created?

I created a database called squirrelmail. I was logged in as root when I
created it, but after I created the database, I typed:
GRANT select,insert,update,delete ON squirrelmail.* TO
squirreluser@localhost IDENTIFIED BY 'sqpassword';

> BTW, CRUD = Create, Read, Update, Delete

I was wondering what that meant!

It looks like the changes take now, but I have to logout of squirrelmail and
log back in for them to take effect. Any ideas?

Thanks!

Jody

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] mysql database not 'taking' changes

[Mark]

Sorry. Stupid technospeak on my part.

When you connect to the database, you tell it to use a particular
username and password. When these new tables were created, did you
change the permissions in the mysql table for the user, or does that
account have access to all the tables/databases? Basically, did you
grant or change permissions when the new tables were created?

BTW, CRUD = Create, Read, Update, Delete

--- Jody Cleveland <[EMAIL PROTECTED]> wrote:
> > Does the user that the script runs as have full CRUD access to
> the
> > new tables? Have you set any restrictions on what that user can
> do to
> > the table(s)?
> 
> Boy, do I feel lost...
> 
> How would I check that?
> 
> Thanks!
> 
> Jody
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 


=
Mark Weinstock
[EMAIL PROTECTED]
***
You can't demand something as a "right" unless you are willing to fight to death to 
defend everyone else's right to the same thing.
-Stolen from the now-defunct Randy's Random mailing list.
***

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] mysql database not 'taking' changes

[Jody Cleveland]

> Does the user that the script runs as have full CRUD access to the
> new tables? Have you set any restrictions on what that user can do to
> the table(s)?

Boy, do I feel lost...

How would I check that?

Thanks!

Jody

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql database not 'taking' changes

[Mark]

Does the user that the script runs as have full CRUD access to the
new tables? Have you set any restrictions on what that user can do to
the table(s)?

--- Jody Cleveland <[EMAIL PROTECTED]> wrote:
> Hello,
> 
> I'm using a product called Squirrelmail for my web based email. In
> it, it
> uses a database for user preferences and address books. (I posted
> to that
> list, and it was suggested to check here) I created the database
> squirrel. I
> created two tables, one called addresses and one called prefs. For
> some
> reason, when I try to change preferences, it never writes that
> information
> to the database. But, I can addresses just fine.
> 
> Is there anything with php settings, or the database itself that
> may need to
> be changed?
> 
> Thanks!  Oh, I'm running Redhat 8, Apache 2, PHP 4.3.0 RC1.
> 
> -Jody Cleveland
> 
> Winnefox Library System
> Computer Support Specialist
> [EMAIL PROTECTED]
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 


=
Mark Weinstock
[EMAIL PROTECTED]
***
You can't demand something as a "right" unless you are willing to fight to death to 
defend everyone else's right to the same thing.
-Stolen from the now-defunct Randy's Random mailing list.
***

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mysql database not 'taking' changes

[Jody Cleveland]

Hello,

I'm using a product called Squirrelmail for my web based email. In it, it
uses a database for user preferences and address books. (I posted to that
list, and it was suggested to check here) I created the database squirrel. I
created two tables, one called addresses and one called prefs. For some
reason, when I try to change preferences, it never writes that information
to the database. But, I can addresses just fine.

Is there anything with php settings, or the database itself that may need to
be changed?

Thanks!  Oh, I'm running Redhat 8, Apache 2, PHP 4.3.0 RC1.

-Jody Cleveland

Winnefox Library System
Computer Support Specialist
[EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL Database Connection Error ?

[Jason Wong]

On Wednesday 28 August 2002 20:48, R Strang wrote:
> i have a simple guest book script from a book by jay greenspan i think ,
> when i run seems oikay i fill in the form and click submit, after
> submitting iam getting this error ?
>
> PHP Warning: Failed opening 'dbconnect.php' for inclusion

It's looking for a file called 'dbconnect.php' ...

> here is the Exact Contense for the dbconnection.php file

... but you named the file 'dbconnection.php'?

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *


/*
We can embody the truth, but we cannot know it.
-- Yates
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MySQL Database Connection Error ?

[R Strang]

i have a simple guest book script from a book by jay greenspan i think ,
when i run seems oikay i fill in the form and click submit, after submitting
iam getting this error ?

PHP Warning: Failed opening 'dbconnect.php' for inclusion
(include_path='c:\php\includes') in
c:\Inetpub\wwwroot\php\create_entry.php
on line 5 PHP Notice:
Undefined variable: submit in c:\Inetpub\wwwroot\php\create_entry.php on
line 6

i had a look at the 'Include_path' in the php.ini file but it seemed oikay.
i have Win98 runing PWS i checked it with the  script and it
works.

here is the Exact Contense for the dbconnection.php file

mysql_connect("localhost","richie","richie")or
die ("Could not connect to database");
mysql_select_db("guestbook")or
die ("Could not select database");

'richie' is both my password and user, im a newbie to all this PHP stuff so
if someone could please Explain to me how to get PHP to work with MySQL id
be very grateful.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL database

[Miles Thompson]

As Brian Clark just pointed out on php-general, in response to another 
issue ...
http://www.faqts.com/knowledge_base/index.phtml/fid/51/

Some very specific refernces. You'll find what you need there.

Miles

At 06:08 PM 1/19/2002 +0100, Morten Nielsen wrote:
>Hi,
>
>Could anybody explain to me how I should make a table with usernames and
>passwords.
>I want to make a site, where users can sign up and enter some values, which
>is stored in a different table.
>How do I grant the necessary acces to the tables, so users can enter values
>into them?
>
>Please help,
>Morten
>
>
>
>--
>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]


-- 
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]

Re: [PHP-DB] MySQL database

[Miles Thompson]

Morten,

What's your level of knowledge of both databases and PHP?  Please have a 
look at the Introductory Tutorial (Link at the top left of www.php.net). At 
the end of that tutorial, which is admittedly rudimentary, there are links 
to more advanced ones, including ones specifically for user authentication.

Regards - Miles Thompson

At 06:08 PM 1/19/2002 +0100, Morten Nielsen wrote:
>Hi,
>
>Could anybody explain to me how I should make a table with usernames and
>passwords.
>I want to make a site, where users can sign up and enter some values, which
>is stored in a different table.
>How do I grant the necessary acces to the tables, so users can enter values
>into them?
>
>Please help,
>Morten
>
>
>
>--
>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]


-- 
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]

[PHP-DB] MySQL database

[Morten Nielsen]

Hi,

Could anybody explain to me how I should make a table with usernames and
passwords.
I want to make a site, where users can sign up and enter some values, which
is stored in a different table.
How do I grant the necessary acces to the tables, so users can enter values
into them?

Please help,
Morten



-- 
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]

Re: [PHP-DB] MySql database data has html code in it

[CrossWalkCentral]

That did it thanks for the help.


--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!

"Paul Burney" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> on 9/1/01 7:12 PM, CrossWalkCentral at [EMAIL PROTECTED] wrote:
>
> > Yea I tried that before I posted I even tried editing the data in the
table
> > to but the  before  and  after and it still will not show it.
>
> You need to encode the < and > characters.  You can do so via the
> htmlspecialchars() function.
>
> 
>
> Sincerely,
>
> Paul Burney
>
> ++
> Paul Burney
> Webmaster && Open Source Developer
> UCLA -> GSE&IS -> ETU
> (310) 825-8365
> <[EMAIL PROTECTED]>
> 
> ++
>
>



-- 
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]

Re: [PHP-DB] MySql database data has html code in it

[Paul Burney]

on 9/1/01 7:12 PM, CrossWalkCentral at [EMAIL PROTECTED] wrote:

> Yea I tried that before I posted I even tried editing the data in the table
> to but the  before  and  after and it still will not show it.

You need to encode the < and > characters.  You can do so via the
htmlspecialchars() function.



Sincerely,

Paul Burney

++
Paul Burney
Webmaster && Open Source Developer
UCLA -> GSE&IS -> ETU
(310) 825-8365
<[EMAIL PROTECTED]>

++



-- 
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]

Re: [PHP-DB] MySql database data has html code in it

[CrossWalkCentral]

Yea I tried that before I posted I even tried editing the data in the table
to but the  before  and  after and it still will not show it.

--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!

"Ali Nayeri" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
>
> I'm just a newbie and don't know that much but would putting:
>
> Echo ($code);
>
> solve the problem. That's what most people use to display HTML code on an
> HTML page.
>
> As I said I'm new and I never tried it. But you can try and see if it
works.
>
> Ali
>
> -Original Message-
> From: CrossWalkCentral [mailto:[EMAIL PROTECTED]]
> Sent: September 1, 2001 6:46 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] MySql database data has html code in it
>
>
> Hello
> Another question for the pros.
>
> I have a Mysql database which contains a table labled html
> in this table I have some short html scripts
> I have created a search for my scripts and when I Echo them (example code
> below) It only shows me the text and not the html script itself
>
> Echo ($code);
>
> Is their another function that I can use to display to contents of this
> variblae?
> I assueme that PHP is trying to process it as part of the echo statement.
>
> --
> Cross Walk Central
> www.crosswalkcentral.net
> Support Center
> Your Web Hosting Community!
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
> _
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>



-- 
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]

RE: [PHP-DB] MySql database data has html code in it

[Ali Nayeri]

Hi,

I'm just a newbie and don't know that much but would putting:

Echo ($code);

solve the problem. That's what most people use to display HTML code on an
HTML page.

As I said I'm new and I never tried it. But you can try and see if it works.

Ali

-Original Message-
From: CrossWalkCentral [mailto:[EMAIL PROTECTED]]
Sent: September 1, 2001 6:46 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySql database data has html code in it


Hello
Another question for the pros.

I have a Mysql database which contains a table labled html
in this table I have some short html scripts
I have created a search for my scripts and when I Echo them (example code
below) It only shows me the text and not the html script itself

Echo ($code);

Is their another function that I can use to display to contents of this
variblae?
I assueme that PHP is trying to process it as part of the echo statement.

--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


-- 
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]

[PHP-DB] MySql database data has html code in it

[CrossWalkCentral]

Hello
Another question for the pros.

I have a Mysql database which contains a table labled html
in this table I have some short html scripts
I have created a search for my scripts and when I Echo them (example code
below) It only shows me the text and not the html script itself

Echo ($code);

Is their another function that I can use to display to contents of this
variblae?
I assueme that PHP is trying to process it as part of the echo statement.

--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!




-- 
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]

[PHP-DB] MySQL Database Locking - needed?

[Tom Peck]

Hi

The company I work for has recently developed a Car Dealer type site, which 
acts as a large on-line used car yard.  Currently the MySQL database 
holding the cars is added too / edited / deleted by one person employed for 
the job - but we hope to expand to allow the Dealers themselves admin 
rights to their on-line cars.

I have begun development of a Dealer Admin area - but have a couple of 
questions regarding this:

1)  Would any sort of Table Locking be needed for this -  for example if 
two people were trying to update the same car, at the same time etc etc..
2)  If yes, is there any on-line documentation on this?
3)  What other problems could arise if this was implemented?

Thanks all

Tom Peck


-- 
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]

RE: [PHP-DB] MySQL database transfer

[Matt Williams]

> and how would you move an entire database from a windows environment
> to a linux environment?

mysqldump db_name > c:/db.sql

from the command prompt

M@

-- 
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]

Re: [PHP-DB] MySQL database transfer

[Cameron Metcalf]

and how would you move an entire database from a windows environment
to a linux environment?

I've tried copying my database to disk, from the data folder in windows,
and then moved it to the var/lib/mysql folder in Linux, however mysql is
unable to
find the database tables, when I try to open up the database in the
Linux environment..

any suggestions?


Cameron


> To contact the list administrators, e-mail: [EMAIL PROTECTED]

Andrew Apold wrote:
> 
> At 03:24 AM 2/22/01 -, Sridhar Ranganathan wrote:
> >Hi
> >
> >I have mysql on linux and windows on the same machine. How do i transfer
> >data between them??
> 
> use mysql dump to create a script, .sql file, and execute it on the other one.
> 
> =
> "To dwell within Samsara, however, is to
>  be subject to the works of those mighty
>  among dreamers."
> 
>  - Mahasamatman, in Zelazny's "Lord of Light"
> 
> Andrew Apold
> 
> --
> 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]

-- 
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]

Re: [PHP-DB] MySQL database transfer

[Andrew Apold]

At 03:24 AM 2/22/01 -, Sridhar Ranganathan wrote:
>Hi
>
>I have mysql on linux and windows on the same machine. How do i transfer 
>data between them??

use mysql dump to create a script, .sql file, and execute it on the other one.


=
"To dwell within Samsara, however, is to
 be subject to the works of those mighty
 among dreamers."

 - Mahasamatman, in Zelazny's "Lord of Light"

Andrew Apold


-- 
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]

[PHP-DB] MySQL database transfer

[Sridhar Ranganathan]

Hi

I have mysql on linux and windows on the same machine. How do i transfer 
data between them??

Thanks in advance
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-- 
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]

[PHP-DB] mySQL Database Update

[dmalcolm]

I have a mySQL data base up and running on Win2k.  I access it with
PHP4.0.4pl1 and they all work and play together just fine.

The Problem:
The data contained in the mySQL database comes from a FoxPro DBF file.
Initial data migration was accomplished with dbtool.  About once a month
I need to move new data from the DBF file to the mySQL database.  I need
suggestions for how to do this the easiest way.  Do I 'drop' the
existing database and build it fresh?  Seems there should be something
better, like a dbtool update function or at least an append function
from someone.  Or do I just need to bite the bullet and roll my own PHP
script for updating?

Thanks in advance for anyone willing to help.

DM


-- 
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]

[PHP-DB] MySQL Database Design

[Ben Cairns]

If was to create a table in a database with 19 Fields, and define them all 
as a BLOB, even though some of them may only hold a max of 10 characters.

What would be the implications of this?

-- Ben Cairns - Head Of Technical Operations
intasept.COM
Tel: 01332 365333
Fax: 01332 346010
E-Mail: [EMAIL PROTECTED]
Web: http://www.intasept.com

"MAKING sense of
the INFORMATION
TECHNOLOGY age
@ WORK.."


-- 
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]

[PHP-DB] mysql database replication

[Cameron Harr]

newer versions of mysql allow for database replication. However the
client (php in this case) needs to be aware that all read requests can
go to slaves or masters. However all write request must go to the
master. is there a way to set this up in PHP?

thanks
nate

-- 
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]