Re: [PHP-DB] Is it possible to access MySQL table on server A from server B?

2003-10-08 Thread ramki
even if the domain name expired, most likely you will be able to access the
site database using the ip address. but just that you have to give / have
permissions to connect from the new domain or ip.

Also, if you can login to the server with ftp, i guess you can ssh / telnet
to server and take a mysql_dump (backup).

You can write a ftp code in php. get all the source code in the old server
and write it in the new server.


-ramki
- Original Message -
From: "Trisha" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 12:23 PM
Subject: [PHP-DB] Is it possible to access MySQL table on server A from
server B?


> Someone let me use their extra web space so I would have a
> banner-free place to put my site. After their domain name expired,
> they didn't re-register it, and didn't let me know ahead of time. I
> wasn't thinking properly, so I had not created a backup of any of the
> tables in my database.
>
> I have purchased my own domain now, and am wondering if there is any
> kind of code I can execute from my current domain to copy or back up
> the tables from the old domain. I believe the database has not yet
> been deleted, since my user account has not been deleted, and all of
> the files I've uploaded through FTP are still intact. I've sent
> several e-mails to the company that was providing the shared hosting
> package, but did not receive any response, so I don't think they will
> help in any way.
>
> If anyone could me know if accessing the database on the old server
> from the new server is possible and how to do it, or if I'm just
> plain old SOL, I would greatly appreciate it.
>
> Thanks in advance  :)
>
> Trisha
>
> __
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
>
> --
> 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] Is it possible to access MySQL table on server A from server B?

2003-10-07 Thread Trisha
Someone let me use their extra web space so I would have a
banner-free place to put my site. After their domain name expired,
they didn't re-register it, and didn't let me know ahead of time. I
wasn't thinking properly, so I had not created a backup of any of the
tables in my database. 

I have purchased my own domain now, and am wondering if there is any
kind of code I can execute from my current domain to copy or back up
the tables from the old domain. I believe the database has not yet
been deleted, since my user account has not been deleted, and all of
the files I've uploaded through FTP are still intact. I've sent
several e-mails to the company that was providing the shared hosting
package, but did not receive any response, so I don't think they will
help in any way. 

If anyone could me know if accessing the database on the old server
from the new server is possible and how to do it, or if I'm just
plain old SOL, I would greatly appreciate it. 

Thanks in advance  :)

Trisha

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

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



Re: [PHP-DB] Is it possible to open a .txt file into a recordset for validation?

2003-09-08 Thread John W. Holmes
[EMAIL PROTECTED] wrote:

Want to allow users to upload .txt file and then loop
through it's contents to validate and reject/accept
based on results.
Is this possible?
Got any links, code, etc?
Yes.

http://us2.php.net/manual/en/features.file-upload.php

and then

http://us2.php.net/manual/en/ref.filesystem.php

specifically

http://us2.php.net/manual/en/function.fopen.php

--
---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

php|architect: The Magazine for PHP Professionals – www.phparch.com

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


[PHP-DB] Is it possible to open a .txt file into a recordset for validation?

2003-09-08 Thread karen97214
Want to allow users to upload .txt file and then loop
through it's contents to validate and reject/accept
based on results.

Is this possible?
Got any links, code, etc?

Thanks

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

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



[PHP-DB] is it possible to upload (binary) files to a mysql database?

2002-06-18 Thread Sander Peters

Hello,

Is it possible to upload binary files to a mysql database?
I can't figure it out. This is what I did:

I made a form like this:



Send this file: 



My SQL Query is like this:
INSERT INTO ALBUMS ('file') VALUES '$attachment'
The field FILE is a type BLOB field.

The  first result I got in the database whas the tempdir+tempfile.
After that I choosed to ad $attachment_name into the database.
But only the filename is stored in the database. Is it not possible to store
files into the database?

What I did now in the script  is copying the file $attachment_name to a
share on the local network so that everyone can access files uploaded by
users.
This is not the meaning of it all, it should be stored in the database.

Can somebody help me with this?

Please reply me at: mailto:[EMAIL PROTECTED] (my e-mail at work)

Thanks in advance.

Sander Peters



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




Re: [PHP-DB] Is it possible ?

2002-02-16 Thread Kodrik

On Saturday 16 February 2002 07:35 pm, you wrote:
> Is it possible to get the AUTO-INCREMENTed ID's value while doing an INSERT
> and have the value INSERTed to another table in the same FORM ?
>
> Raju

mysql_query("insert whatever");

$insertid=mysql_last_insert();

Then you use this value for your other insert.



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




[PHP-DB] Is it possible ?

2002-02-16 Thread CK Raju

Is it possible to get the AUTO-INCREMENTed ID's value while doing an INSERT 
and have the value INSERTed to another table in the same FORM ?

Raju



** Message from InterScan E-Mail VirusWall NT **

** No virus found in attached file noname.htm

This is a virus free message scanned by Zyberway
* End of message ***




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