Re: [PHP-DB] IMPORT DATA
Hi Jennifer, Please clarify. What exactly do you want to do? MySQL has other utilities like mysqldump (to dump a db to a dbfile) and mysql (to restore a dbfile into a database). Lester At 03:13 PM 5/2/01 +0800, Jennifer Arcino Demeterio wrote: >hello all, > >did anyone know on how to import data from one database to another using >Mysql? > >Thanks -- 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] IMPORT DATA
>did anyone know on how to import data from one database to another using >Mysql? Yes. Take a look at the mysql website (www.mysql.com) you could also browse the archive of their list. This is a FAQ on the mysql.com list, so the answer can be found there. Bye, B. -- 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] PostgreSQL7.1: It's worth to upgrade.
You have forgotton to mention new SQL features such as outer joins. Postgres have been supporting many advanced sql features for a long time those were not supported by other databases. Anuradha On Tue, 24 Apr 2001, Yasuo Ohgaki wrote: > Hello PostgreSQL users, > > I'm testing PostgreSQL 7.1 and PHP4.0.4pl1 on Linux. It's really worth to > upgrade. > > Besides PostgreSQL 7.1 supports any size of text, WAL, many bug fixes, better > pg_dump/restore, etc. PostgreSQL 7.1 can provide more backends on the same box. > A box, which could set to max 70 or less backends, can set upto 3000+ backends. > The box would not be able to handle 3000 db connections, but it is really nice > to have more db connections for web applications. 7.1 also seems much faster > than 7.0.3. Text type with large data can consume a lot of CPU time. BLOB is > suitable to store really large data. > > If you are using Windows, you are better to stay with 7.0. You will see error > message with pg_errormessage() even if there is no errors. Wait or compile > php_pgsql.dll with 7.1 libpq. (I don't have environment to compile it. If anyone > has php_pgsql.dll with 7.1 libpq for PHP4.0.4pl1, could you tell where to get or > send it to me?) > > -- > Yasuo Ohgaki > > > > > -- > 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] How to randomly select data in a field. Please help newbie.
Well the only way to do this properly is a cron job. have a look at http://forums.devshed.com/showthread.php?threadid=13642&forumid=5 hope it helps ""MAX"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 002301c0d2c0$b49b3c00$0300a8c0@cv2">news:002301c0d2c0$b49b3c00$0300a8c0@cv2... > Hi, > I'm newbie from Indonesia. > Your query has helped me to create random text using PHP and MySQL. > Could you please give me an example script for random text, the text changes > in every 24 hours/every 7 o'clock in the morning not after "refresh/reload". > > Thanks for your help. > > Max > Indonesia > > > > - Original Message - > From: "Johannes Janson" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, April 30, 2001 6:56 PM > Subject: Re: [PHP-DB] How to randomly select data in a field. Please help > newbie. > > > > Hi, > > > > you could do the random selection in MysSQL if you use it > > using a query like this. > > SELECT FieldWithURL FROM YourTable ORDER BY RAND() LIMIT 0,1; > > This will give you a random field. If you want more fields you have to > > set different values for the limit. Like LIMIT 0,5 for the first 5 row. > > Just if you don't know the syntax of LIMIT: limit 'StartingPoint', > > 'NumberOfRows' > > > > hope it helps > > Johannes > > > > ""Greg K"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > > 9cfe9n$ggd$[EMAIL PROTECTED]">news:9cfe9n$ggd$[EMAIL PROTECTED]... > > > Can someone explain to me the best way to randomly select data from > field > > > that consist of urls. The fields consist urls that are images of > people. > > I > > > believe I have to setup that field as a array and turn it into a > interger. > > > But I have no experience doing this can someone sort of give me a > example > > on > > > how I would do this . > > > > > > Thank you .. > > > > > > Your Help would be well appreciate it .. > > > > > > > > > > > > > > > > > > -- > > > 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 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-php
hi, I'm a newbie from Italy I use php with mysql and I need to find a way to visualize the difference between two dates. For ex in a row I have column [A] and column [B] [A] 2001-05-02 10:00:00 [B] 2001-05-02 10:01:30 If I use SELECT TIME_FORMAT([B]-[A], '%H:%i:%s') result is 00:01:30 But it's the same if I use SELECT TIME_FORMAT([A]-[B], '%H:%i:%s') why? I need a - (minus)! Thanks -- 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] open foxpro database
I used function dbase_xxx to access foxpro database (.dbf) but it's not work. Here is my code : \n"; } } } ?> Everytime I call this page there's a message : Warning: unable to open database /home/benny/test/employee.dbf in /home/benny/htdocs/foxpro.php on line 2 I used php 4.0.4 and Visual Fox Pro 5.0. Before that I have mounted my foxpro dbf file to my linux in the /home/benny/test directory. Is there anything wrong? Anyone could help me? Regards; Benny. Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.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] Re: [PHP] Emanuel virus
>Once again, if it got passed to any of you, through me, my apologies. I >wouldn't trust my anti-virus software on this, I could find any reference >to it at Symantec. Maybe it has another name? > >Feeling like a leper - Miles Thompson Look for Navidad or W32/Navidad.e I think you should also look for a antivirus product. It's less expensive then reconfigure your system.. A reinstall is a good cleanup though.. Bye, B. -- 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] creating a downloadable file ...
hi, i have a table that is populated from a database. the only problem with it is that the table is quite large. i'd like to give the user to the option to download the file in csv format ... can anybody point me in the right direction ? Steve Brett Internal Development tel: 4251 EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, please delete this message, and notify us immediately. Opinions, conclusions and other information expressed in this message are not given or endorsed by my firm or employer unless otherwise indicated by an authorised representative independently of this message." Egton Medical Information Systems Limited. Registered in England. No 2117205. Registered Office: Park House Mews, 77 Back Lane, Off Broadway, Horsforth, Leeds, LS18 4RF -- 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] Sessions ???
Hi All I have a ? about setting a session. I have a functions.inc file and at the top have put my session statment that looks like this. $topicID comes from my mysql db. What i am trying to do is set the $topicID of my message board so that when a sucessful post has been made the visitor can click on a link that show the right board by topicID. so the link will look like this... http://localhost/forums/view.php?topicID=3 I am banging away trying to make this work Any help in the meantime is as always appreciated Thank You In Advance dave C -- 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] Sessions ???
try
session_register("topidID");
without the $
Steve
> -Original Message-
> From: DC [mailto:[EMAIL PROTECTED]]
> Sent: 02 May 2001 13:54
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Sessions ???
>
>
> Hi All
> I have a ? about setting a session.
>
> I have a functions.inc file and at the top have put my
> session statment that
> looks like this.
>
> session_start();
> session_register("$topidID");
> ?>
>
> $topicID comes from my mysql db.
>
> What i am trying to do is set the $topicID of my message
> board so that when
> a sucessful post has been made the visitor can click on a
> link that show the
> right board by topicID.
>
> so the link will look like this...
>
> http://localhost/forums/view.php?topicID=3
>
> I am banging away trying to make this work
>
> Any help in the meantime is as always appreciated
>
> Thank You In Advance
>
> dave C
>
>
>
> --
> 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] Sessions ???
Dave, What you need to do is make sure that the variable: $topidID is being set to a value first (before you register it you must get it from the table. Once it is set you need to register it as you did BUT WITHOUT the $. So it will say: Make sure that session_start is ALWAYS before any headers in your html page, BUT register does NOT have to be. It can be declared anywhere in the page as long as you have set the value in it already. Also, on every page that will ever access topidID you must have session_start() at the top. But not session_register, as the value has already been registered. HINT: if you want to change the value of topidID just set it's value and then call a register right after you do that. Hope this helps! >>> "DC" <[EMAIL PROTECTED]> 05/02/01 07:53AM >>> Hi All I have a ? about setting a session. I have a functions.inc file and at the top have put my session statment that looks like this. $topicID comes from my mysql db. What i am trying to do is set the $topicID of my message board so that when a sucessful post has been made the visitor can click on a link that show the right board by topicID. so the link will look like this... http://localhost/forums/view.php?topicID=3 I am banging away trying to make this work Any help in the meantime is as always appreciated Thank You In Advance dave C -- 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] Sessions ???
Thanks Steve;
I now have this in a session file in my tmp dir
topicID|s:1:"8";
Now how do i get the link to read http://localhost/forums/view.php?topicID=8
i think its along the lines of
http://localhost/forums/view.php3?PHPSESSIONID?topicID
I am banging away, the 4 books i have on Php are useless when it comes to
session and there usage.
Thanks for the help
Dave C
"Steve Brett" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> try
> session_register("topidID");
>
> without the $
>
> Steve
>
>
> > -Original Message-
> > From: DC [mailto:[EMAIL PROTECTED]]
> > Sent: 02 May 2001 13:54
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] Sessions ???
> >
> >
> > Hi All
> > I have a ? about setting a session.
> >
> > I have a functions.inc file and at the top have put my
> > session statment that
> > looks like this.
> >
> > > session_start();
> > session_register("$topidID");
> > ?>
> >
> > $topicID comes from my mysql db.
> >
> > What i am trying to do is set the $topicID of my message
> > board so that when
> > a sucessful post has been made the visitor can click on a
> > link that show the
> > right board by topicID.
> >
> > so the link will look like this...
> >
> > http://localhost/forums/view.php?topicID=3
> >
> > I am banging away trying to make this work
> >
> > Any help in the meantime is as always appreciated
> >
> > Thank You In Advance
> >
> > dave C
> >
> >
> >
> > --
> > 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 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] Sessions ???
Hola.
Quiero saber que debo hacer para poder conectar a Informix a través
de php4. De antemano, gracias por la ayuda.
John Molano
---Original Message---
From: Angie Tollerson
Date: Wednesday, May
02, 2001 08:26:28
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-DB]
Sessions ???
Dave,What you need to do is make sure that the
variable: $topidID is being set to a value first (before you register it
you must get it from the table. Once it is set you need to register it as
you did BUT WITHOUT the $. So it will
say:session_start();session_register("topidID");?>Make
sure that session_start is ALWAYS before any headers in your html page,
BUT register does NOT have to be. It can be declared anywhere in the page
as long as you have set the value in it already. Also, on every page that
will ever access topidID you must have session_start() at the top. But not
session_register, as the value has already been registered. HINT: if you
want to change the value of topidID just set it's value and then call a
register right after you do that. Hope this
helps!>>> "DC"
<[EMAIL PROTECTED]> 05/02/01 07:53AM
>>>Hi AllI have a ? about setting a session.I
have a functions.inc file and at the top have put my session statment
thatlooks like
this.session_start();session_register("$topidID");?>$topicID
comes from my mysql db.What i am trying to do is set the $topicID
of my message board so that whena sucessful post has been made the
visitor can click on a link that show theright board by
topicID.so the link will look like
this...http://localhost/forums/view.php?topicID=3 I am
banging away trying to make this workAny help in the meantime
is as always appreciatedThank You In Advancedave
C-- 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]
_IncrediMail - Email has finally
evolved - Click
Here
Re: [PHP-DB] Sessions ???
For this operation there is dire need for session management.
And remember the default variable order EGPCS may cause you trouble if
you're sending a put variable across with the same name as a session
variable. Session vars take presidence in the global scope.
http://localhost/forums/view.php?topicID=3
The session var $topicID will override this put variable.
$topicID=session var value //your 3 may not be here.
$HTTP_GET_VARS["topicID"]=3 //you can still find your 3 here.
Session variables are good for maintaining information from one page to the
next, avoiding the need for the client to keep sending the same information
over and over again.
In either event, I recommend useing a different session variable name than
the put variable's name, unless you use $HTTP_GET_VARS/$HTTP_SESSION_VARS
accordingly.
-Joe
""DC"" <[EMAIL PROTECTED]> wrote in message
9covu3$p6g$[EMAIL PROTECTED]">news:9covu3$p6g$[EMAIL PROTECTED]...
> Hi All
> I have a ? about setting a session.
>
> I have a functions.inc file and at the top have put my session statment
that
> looks like this.
>
> session_start();
> session_register("$topidID");
> ?>
>
> $topicID comes from my mysql db.
>
> What i am trying to do is set the $topicID of my message board so that
when
> a sucessful post has been made the visitor can click on a link that show
the
> right board by topicID.
>
> so the link will look like this...
>
> http://localhost/forums/view.php?topicID=3
>
> I am banging away trying to make this work
>
> Any help in the meantime is as always appreciated
>
> Thank You In Advance
>
> dave C
>
>
>
> --
> 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] Sessions ???
when you build the string for the ahref just insert the value of $topidID
like so
echo 'link name here';
Steve
> -Original Message-
> From: DC [mailto:[EMAIL PROTECTED]]
> Sent: 02 May 2001 14:24
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Sessions ???
>
>
> Thanks Steve;
> I now have this in a session file in my tmp dir
>
> topicID|s:1:"8";
>
> Now how do i get the link to read
> http://localhost/forums/view.php?topicID=8
>
> i think its along the lines of
> http://localhost/forums/view.php3?PHPSESSIONID?topicID
>
> I am banging away, the 4 books i have on Php are useless when
> it comes to
> session and there usage.
>
> Thanks for the help
>
> Dave C
>
> "Steve Brett" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > try
> > session_register("topidID");
> >
> > without the $
> >
> > Steve
> >
> >
> > > -Original Message-
> > > From: DC [mailto:[EMAIL PROTECTED]]
> > > Sent: 02 May 2001 13:54
> > > To: [EMAIL PROTECTED]
> > > Subject: [PHP-DB] Sessions ???
> > >
> > >
> > > Hi All
> > > I have a ? about setting a session.
> > >
> > > I have a functions.inc file and at the top have put my
> > > session statment that
> > > looks like this.
> > >
> > > > > session_start();
> > > session_register("$topidID");
> > > ?>
> > >
> > > $topicID comes from my mysql db.
> > >
> > > What i am trying to do is set the $topicID of my message
> > > board so that when
> > > a sucessful post has been made the visitor can click on a
> > > link that show the
> > > right board by topicID.
> > >
> > > so the link will look like this...
> > >
> > > http://localhost/forums/view.php?topicID=3
> > >
> > > I am banging away trying to make this work
> > >
> > > Any help in the meantime is as always appreciated
> > >
> > > Thank You In Advance
> > >
> > > dave C
> > >
> > >
> > >
> > > --
> > > 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 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] Sessions ???
Doh!
I meant there is "NO dire need"
""Joe Brown"" <[EMAIL PROTECTED]> wrote in message
9cp3kv$3hj$[EMAIL PROTECTED]">news:9cp3kv$3hj$[EMAIL PROTECTED]...
> For this operation there is dire need for session management.
>
> And remember the default variable order EGPCS may cause you trouble if
> you're sending a put variable across with the same name as a session
> variable. Session vars take presidence in the global scope.
>
> http://localhost/forums/view.php?topicID=3
>
> The session var $topicID will override this put variable.
>
> $topicID=session var value //your 3 may not be here.
> $HTTP_GET_VARS["topicID"]=3 //you can still find your 3 here.
>
> Session variables are good for maintaining information from one page to
the
> next, avoiding the need for the client to keep sending the same
information
> over and over again.
>
> In either event, I recommend useing a different session variable name than
> the put variable's name, unless you use $HTTP_GET_VARS/$HTTP_SESSION_VARS
> accordingly.
>
> -Joe
>
> ""DC"" <[EMAIL PROTECTED]> wrote in message
> 9covu3$p6g$[EMAIL PROTECTED]">news:9covu3$p6g$[EMAIL PROTECTED]...
> > Hi All
> > I have a ? about setting a session.
> >
> > I have a functions.inc file and at the top have put my session statment
> that
> > looks like this.
> >
> > > session_start();
> > session_register("$topidID");
> > ?>
> >
> > $topicID comes from my mysql db.
> >
> > What i am trying to do is set the $topicID of my message board so that
> when
> > a sucessful post has been made the visitor can click on a link that show
> the
> > right board by topicID.
> >
> > so the link will look like this...
> >
> > http://localhost/forums/view.php?topicID=3
> >
> > I am banging away trying to make this work
> >
> > Any help in the meantime is as always appreciated
> >
> > Thank You In Advance
> >
> > dave C
> >
> >
> >
> > --
> > 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 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] Edit a file from a PHP form
I would like to edit a list from a PHP form. Can someone point me to a good tutorial?? I have walked-through a tutorial that showed me how to successfully pull the contents of text file and display the whole contents. I want to view the contents and then edit a specific line of in a list. So, if I have list of employees and their telephone numbers, I'd like to be able to search the contents and display the employees phone number then allow me to edit the phone number and save it back to the list. I know I can do this with MySQL but I need to keep the source data in a text file. Thanks for any suggestions. -Allen [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] Edit a file from a PHP form
Hmm, Allen, this may be overwhelming , but what you are trying to do would be ideal with XML files and manipulating them with PHP and XSL style sheets. I am doing the exact same thing you are with these technologies. Your XML page looks just like a text file but with tags, like this: C Test Name Colorado D Address Test City Test State Test Zip Test Phone Test Fax Test Name One With multiple entries, then using PHP and XSL style sheets you can grab individual tags and edit them, you can delete a whole "project" or "employee" in your case, add them, SORT them in alphabetical order, numberical..the possibilities are endless. PHP already has a XML and XSL parser built in depending on your server op system you may need to install the dll's for them or compile them. But it is very smooth and fast and not too hard to learn. If you know PHP you are half way there. Hope I haven't confused the issue more. But trying to use PHP get lines and substrings and such in a plain .csv is really inefficient and LIMITED. Tinuviel >>> "Allen May" <[EMAIL PROTECTED]> 05/02/01 09:28AM >>> I would like to edit a list from a PHP form. Can someone point me to a good tutorial?? I have walked-through a tutorial that showed me how to successfully pull the contents of text file and display the whole contents. I want to view the contents and then edit a specific line of in a list. So, if I have list of employees and their telephone numbers, I'd like to be able to search the contents and display the employees phone number then allow me to edit the phone number and save it back to the list. I know I can do this with MySQL but I need to keep the source data in a text file. Thanks for any suggestions. -Allen [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 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] Updating Mysql database from a remote computer
The database is created using a Windows software (Delphi language) which
uses Paradox database. A special module is used to prepare some data from
this database for internet. The program uses "libmySQL.dll" and would
connect directly to server via a dialup line. Instead 'localhost' it would
have the server's IP. It then updates the Mysql database with new data. This
Mysql database is then used only for reading and PHP scripts on homepage
take care of that. I am just wondering if anyone has ever done this and are
there any problems (firewalls...)?
Thanks,
Marko.
""Beau Lebens"" <[EMAIL PROTECTED]> je napisal v sporocilo
[EMAIL PROTECTED]">news:[EMAIL PROTECTED] ...
> if the computer where the writable copy of the database is stored is
> permanently connected to the other one, then you could just create a new
> user for that database using mysqls security features which only has
access
> to read information, no change or delete.
>
> and yes you can connect using an ip, to any database which allows external
> connections (firewalls etc notwithstanding)
>
> // -Original Message-
> // From: Marko Lesnik [mailto:[EMAIL PROTECTED]]
> // Sent: Monday, 30 April 2001 10:40 PM
> // To: [EMAIL PROTECTED]
> // Subject: [PHP-DB] Updating Mysql database from a remote computer
> //
> //
> // The database will be created on a local computer and it only
> // needs to be
> // transferred to the server (it's a read-only database when it's
> // on the net).
> // The problem is that the database itself isn't located in
> // directory, where we
> // could access it with Ftp client and simply owerwrite it with the new
> // version.
> // Is it possible to connect via a IP number instead
> // 'localhost' like this:
> // mysql_connect("100.10.20.30","username","password")
> // and then update record by record. It should be slower but our
> // main interest
> // is to get the data to server. Are there any free servers where
> // this can be
> // tested?
> //
> // Thanks,
> // Marko.
> //
> //
> //
> // --
> // 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 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] odbc_tableprivileges help required
Could someone supply simple examples of how this command works. I am trying
to use it like this -
$conn=odbc_connect("poinv","","");
$result=odbc_tableprivileges($conn,"pt_mstr","%","%");
odbc_result_all($result);
but this returns
Warning: SQL error: , SQL state 0 in SQLTablePrivileges in
/opt/apache/lib/htdocs/poinv/test.php on line 9
Warning: Supplied argument is not a valid ODBC result resource in
/opt/apache/lib/htdocs/poinv/test.php on line 11
So my understanding of this is obviously incorrect
Thanks
Mark
#
Mark Newnham
Application Design Associates, Inc
6021 S.Syracuse Way #302
Englewood, CO 80111, USA
http://www.adacorp.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] pgsql 7.1 build
Hi there, I'm building the new PHP-4.0.5 with support for PostgreSQL 7.1 database and get the following build error: gmake[3]: Entering directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql' /bin/sh /net/clear1/home/rpatters/php-4.0.5/libtool --silent --mode=compile gcc -I. -I/net/clear1/home/rpatters/php-4.0.5/ext/pgsql -I/net/clear1/home/rpatters/php-4.0.5/main -I/net/clear1/home/rpatters/php-4.0.5 -I/net/clear1/home/rpatters/as3/include -I/net/clear1/home/rpatters/php-4.0.5/Zend -I/net/clear1/home/rpatters/php-4.0.5/ext/xml/expat/xmltok -I/net/clear1/home/rpatters/php-4.0.5/ext/xml/expat/xmlparse -I/net/clear1/home/rpatters/php-4.0.5/TSRM -I/net/clear1/home/rpatters/pgsql/include -D_POSIX_PTHREAD_SEMANTICS -D_POSIX_PTHREAD_SEMANTICS -D_REENTRANT -DSUPPORT_UTF8 -DXML_BYTE_ORDER=21 -I../TSRM -g -O2 -c pgsql.c pgsql.c: In function `_notice_handler': pgsql.c:158: warning: passing arg 1 of `php_log_err' discards `const' from pointer target type pgsql.c: In function `_rollback_transactions': pgsql.c:167: `pgsql_globals' undeclared (first use this function) pgsql.c:167: (Each undeclared identifier is reported only once pgsql.c:167: for each function it appears in.) gmake[3]: *** [pgsql.lo] Error 1 gmake[3]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql' gmake[2]: *** [all-recursive] Error 1 gmake[2]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext' gmake: *** [all-recursive] Error 1 Worked ok with PostgreSQL 7.0.3 Any ideas? Thanks, Ron Patterson USA.NET Get free email and a permanent address at http://www.netaddress.com/?N=1 -- 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] How to autoincrement an autoincrementing field (MySQL)?
OK, I give up - I can't find out how to do this. I thought I'd tracked it down in my copy of O'Reilly's 2MySQL and mSQL which says that you put NULL as the value for an autoincrementing, NOT NULL field in an INSERT statement: e.g. INSERT INTO records (record_id, name, etc.) VALUES (NULL, 'Alan', etc.) which is wierd enough. But it doesn't work (not via PHP mysql_query() anyhow) - predictably, I get an error 1048 Column 'record_id' cannot be null. Help please! TIA Alan Hale -- 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] Variable Assignment
All: I am new to PHP and was hoping for some input to what is probably an 'easy' question. The following SQL statement returns 1 row: $sql = "SELECT id, real_name FROM authorization WHERE username='$username' and password='$password'"; All I want to do is assign the results of the field real_name to a variable called $salesperson, but I cannot seem to get it to work. Thanks inadvance for your help, Randy Rankin -- 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] How to autoincrement an autoincrementing field (MySQL)?
What i do is eith not specify the id column or use null as in "" or actually '' in php, this will enter null which the database then just increments the field as it should. Later! -Original Message- From: Alan Hale [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 10:29 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] How to autoincrement an autoincrementing field (MySQL)? OK, I give up - I can't find out how to do this. I thought I'd tracked it down in my copy of O'Reilly's 2MySQL and mSQL which says that you put NULL as the value for an autoincrementing, NOT NULL field in an INSERT statement: e.g. INSERT INTO records (record_id, name, etc.) VALUES (NULL, 'Alan', etc.) which is wierd enough. But it doesn't work (not via PHP mysql_query() anyhow) - predictably, I get an error 1048 Column 'record_id' cannot be null. Help please! TIA Alan Hale -- 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] Re: [[PHP-DB] How to autoincrement an autoincrementing field (MySQL)?]
Insert with a value of zero (0) or don't specify the column at all (uses the default increment). Hope this helps, Ron Patterson USA.NET Alan Hale <[EMAIL PROTECTED]> wrote: > OK, I give up - I can't find out how to do this. I thought I'd tracked > it down in my copy of O'Reilly's 2MySQL and mSQL which says that you put > NULL as the value for an autoincrementing, NOT NULL field in an INSERT > statement: > > e.g. INSERT INTO records (record_id, name, etc.) VALUES (NULL, > 'Alan', etc.) > > which is wierd enough. But it doesn't work (not via PHP mysql_query() > anyhow) - predictably, I get an error 1048 Column 'record_id' cannot be > null. > > Help please! > > TIA > > Alan Hale > > > -- > 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] > Get free email and a permanent address at http://www.netaddress.com/?N=1 -- 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] Re: [[PHP-DB] Variable Assignment]
Assuming this may be MySQL, use a mysql_fetch_object like: $result=mysql_query($sql); $r=mysql_fetch_object($result); echo $r->real_name; Other databases have similar syntax. Hope this helps, Ron Patterson USA.NET "Rankin, Randy" <[EMAIL PROTECTED]> wrote: > All: > > I am new to PHP and was hoping for some input to what is probably an 'easy' > question. > > The following SQL statement returns 1 row: > > $sql = "SELECT id, real_name FROM authorization WHERE username='$username' > and password='$password'"; > > All I want to do is assign the results of the field real_name to a variable > called $salesperson, but I cannot seem to get it to work. > > Thanks inadvance for your help, > > Randy Rankin > > > > > > -- > 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] > Get free email and a permanent address at http://www.netaddress.com/?N=1 -- 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] pear db and pgsql
i'm having a hell of a time figuring out how to connect to a postgresql
database using the pear db abstraction...here's some code snippets:
with mysql (works fine):
require_once('DB.php');
$db = DB::connect("mysql://username:password@localhost/audio");
if (DB::isError($db)) {
print $db->getMessage();
}
$select_query = "SELECT * FROM items";
$result = $db->query($select_query);
while ($row = $result->fetchRow()) {
print "$row[1]";
}
$db->disconnect();
with pgsql (dies with this error:
DB Error: unknown error
Fatal error: Call to undefined function: query() in /path/pg_test.php
on line 8)
require_once('DB.php');
$db = DB::connect("pgsql://username:password@localhost/audio");
if (DB::isError($db)) {
print $db->getMessage();
}
$select_query = "SELECT * FROM items";
$result = $db->query($select_query);
while ($row = $result->fetchRow()) {
print "$row[1]";
}
$db->disconnect();
both databases exist, along with the tables$10 says i'm being dumb, and need to
put the port # someplace on the postgres connect, but i can't seem to put it in the
right place.
tia,
r
--
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] Re: pear db and pgsql
> i'm having a hell of a time figuring out how to connect to a postgresql
> database using the pear db abstraction...here's some code snippets:
RTFM (or a tutorial rather)...hate when people answer their own questions,
but here goes:
> $db = DB::connect("pgsql://username:password@localhost/audio");
change to:
$db = DB::connect("pgsql://username:password@unix+localhost:5432/audio")
makes sensespecify protocol, and such; found good documentation here:
http://vulcanonet.com/soft/?pack=pear_tut
r
--
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] Re: [PHP] MySQL fulltext indices and phrase search
"Jens Kisters" <[EMAIL PROTECTED]> wrote:
> Hi there, is there a possibility to use MySQL's MATCH ... AGAINST to
> look for a string like "foo bar" ?
>
> if i MATCH keyname AGAINST ('foo bar') i get resuts that match foo or
> bar, but not both of them separated by a space.
>
> My guess is that the organization of the index doesn't allow this kind
> of search as it's based on single words , but maybe one of you has a
> better idea than
> to select the rows that contain both and hit those with LIKE '%foo bar%'
Perhaps you should ask on the mysql list.
List-Subscribe:
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.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 fulltext indices and phrase search
Hi there, is there a possibility to use MySQL's MATCH ... AGAINST to
look for a string like "foo bar" ?
if i MATCH keyname AGAINST ('foo bar') i get resuts that match foo or
bar, but not both of them separated by a space.
My guess is that the organization of the index doesn't allow this kind
of search as it's based on single words , but maybe one of you has a
better idea than
to select the rows that contain both and hit those with LIKE '%foo bar%'
--
Grüße aus dem schönen Kleve
Jens Kisters
rosomm et partner
Agentur für neue Medien GmbH
Dienstleistungszentrum am
Weißen Tor - Eingang B
Gocher Landstrasse 2
47551 Kleve / Bedburg-Hau
Telefon: 02821 - 97856-20
Telefax: 02821 - 97856-77
[EMAIL PROTECTED]
http://www.rosomm-partner.de
--
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] Date Ranges
Hi, I'm working on a event calendar and some events span more than one day. I would like to store a date range like 2001-02-05 thru 2001-07-05 so when I do a query for the current day the event would appear for all the days in the range. I hoping someone can point me to some documentation or tutorials on this. Thanks in advance, Mike
RE: [PHP-DB] Date Ranges
if you have a table with a date field, you can write a query that will look something like this: // assuming these dates $start_date = '2001-02-05'; $end_date = '2001-07-05'; // sql query SELECT * FROM events_table WHERE date_field >= '$start_date' AND date_field <= '$end_date'; this would result in all events starting Feb 02, 20001 and ending July 05, 2001 depending on your requirements you can use the following comparison operators: for $start_date: = equal to >= Greater than or equal to > Greater than for $end_date: = equal to <= less than or equal to < less than Hope this helps. -Original Message- From: Mike Baerwolf [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 5:11 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Date Ranges Hi, I'm working on a event calendar and some events span more than one day. I would like to store a date range like 2001-02-05 thru 2001-07-05 so when I do a query for the current day the event would appear for all the days in the range. I hoping someone can point me to some documentation or tutorials on this. Thanks in advance, Mike -- 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] updating database on internet server
I have 2 systems, local and internet. I want my Internet database is updated from local database. How can I make this? Regards; Benny. -- 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] open foxpro database
I used function dbase_xxx to access foxpro database (.dbf) but it's not work. Here is my code : \n"; } } } ?> Everytime I call this page there's a message : Warning: unable to open database /home/benny/test/employee.dbf in /home/benny/htdocs/foxpro.php on line 2 I used php 4.0.4 and Visual Fox Pro 5.0. Before that I have mounted my foxpro dbf file to my linux in the /home/benny/test directory. Is there anything wrong? Anyone could help me? Regards; Benny. -- 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] RE: [PHP] RE: [PHP-DB] open foxpro database:solved
Thank's a lot. I make the employee.dbf free table. And it's work. Regards; Benny. -Original Message- From: Scott Bernard [mailto:[EMAIL PROTECTED]] Sent: 03 Mei 2001 8:44 To: Benny; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP] RE: [PHP-DB] open foxpro database Try it again, but make the employee.dbf free table, or just making it foxplus. -Mensaje original- De: Benny [mailto:[EMAIL PROTECTED]] Enviado el: Miércoles, 02 de Mayo de 2001 07:03 a.m. Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] Asunto: [PHP-DB] open foxpro database I used function dbase_xxx to access foxpro database (.dbf) but it's not work. Here is my code : \n"; } } } ?> Everytime I call this page there's a message : Warning: unable to open database /home/benny/test/employee.dbf in /home/benny/htdocs/foxpro.php on line 2 I used php 4.0.4 and Visual Fox Pro 5.0. Before that I have mounted my foxpro dbf file to my linux in the /home/benny/test directory. Is there anything wrong? Anyone could help me? Regards; Benny. -- 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 General 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] open foxpro database
I used function dbase_xxx to access foxpro database (.dbf) but it's not work. Here is my code : \n"; } } } ?> Everytime I call this page there's a message : Warning: unable to open database /home/benny/test/employee.dbf in /home/benny/htdocs/foxpro.php on line 2 I used php 4.0.4 and Visual Fox Pro 5.0. Before that I have mounted my foxpro dbf file to my linux in the /home/benny/test directory. Is there anything wrong? Anyone could help me? Regards; Benny. -- 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] open foxpro database
Try it again, but make the employee.dbf free table, or just making it foxplus. -Mensaje original- De: Benny [mailto:[EMAIL PROTECTED]] Enviado el: Miércoles, 02 de Mayo de 2001 07:03 a.m. Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] Asunto: [PHP-DB] open foxpro database I used function dbase_xxx to access foxpro database (.dbf) but it's not work. Here is my code : \n"; } } } ?> Everytime I call this page there's a message : Warning: unable to open database /home/benny/test/employee.dbf in /home/benny/htdocs/foxpro.php on line 2 I used php 4.0.4 and Visual Fox Pro 5.0. Before that I have mounted my foxpro dbf file to my linux in the /home/benny/test directory. Is there anything wrong? Anyone could help me? Regards; Benny. -- 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] open foxpro database
Your problem is caused by file name writing (because filename is
case-sensitive). PHP can read any FoxPro's Tables (free tables or databases
tables).
Regards,
Abdul Kadir
- Original Message -
From: "Benny" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 02, 2001 9:12 AM
Subject: [PHP-DB] open foxpro database
> I used function dbase_xxx to access foxpro database (.dbf) but it's not
> work.
> Here is my code :
> if (dbase_open("/home/benny/test/employee.dbf",0)) {
> for ($i=1; $i<=dbase_numrecords($open); $i++) {
> $rec = dbase_get_record($db, $i);
> $nf = dbase_numfields($db);
> for ($j=0; $j < $nf; $j++) {
> print $rec[$j]."\n";
> }
> }
> }
> ?>
> Everytime I call this page there's a message :
> Warning: unable to open database /home/benny/test/employee.dbf in
> /home/benny/htdocs/foxpro.php on line 2
> I used php 4.0.4 and Visual Fox Pro 5.0.
> Before that I have mounted my foxpro dbf file to my linux in the
> /home/benny/test directory.
> Is there anything wrong?
> Anyone could help me?
>
> Regards;
>
> Benny.
>
>
>
> --
> 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] Uploading Images
Hi All I want to upload images to my server and name them as found in my local machine. I am able to upload them using the copy function but the name on the server is not the same on my local machine. How can I go about this Thanks -- 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] pgsql 7.1 build
I haven't built 4.0.5 with PostgreSQL7.1, but I built CVS source with V7.1. Last night, it compiles with warning message. It seems working, not tested. For the time being, how about use latest CVS snapshot? (And report problems, so that we can get stable postgresql module for 4.0.6?) Regards, -- Yasuo Ohgaki "Ron Patterson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi there, I'm building the new PHP-4.0.5 with support for PostgreSQL 7.1 database and get the following build error: gmake[3]: Entering directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql' /bin/sh /net/clear1/home/rpatters/php-4.0.5/libtool --silent --mode=compile gcc -I. -I/net/clear1/home/rpatters/php-4.0.5/ext/pgsql -I/net/clear1/home/rpatters/php-4.0.5/main -I/net/clear1/home/rpatters/php-4.0.5 -I/net/clear1/home/rpatters/as3/include -I/net/clear1/home/rpatters/php-4.0.5/Zend -I/net/clear1/home/rpatters/php-4.0.5/ext/xml/expat/xmltok -I/net/clear1/home/rpatters/php-4.0.5/ext/xml/expat/xmlparse -I/net/clear1/home/rpatters/php-4.0.5/TSRM -I/net/clear1/home/rpatters/pgsql/include -D_POSIX_PTHREAD_SEMANTICS -D_POSIX_PTHREAD_SEMANTICS -D_REENTRANT -DSUPPORT_UTF8 -DXML_BYTE_ORDER=21 -I../TSRM -g -O2 -c pgsql.c pgsql.c: In function `_notice_handler': pgsql.c:158: warning: passing arg 1 of `php_log_err' discards `const' from pointer target type pgsql.c: In function `_rollback_transactions': pgsql.c:167: `pgsql_globals' undeclared (first use this function) pgsql.c:167: (Each undeclared identifier is reported only once pgsql.c:167: for each function it appears in.) gmake[3]: *** [pgsql.lo] Error 1 gmake[3]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql' gmake[2]: *** [all-recursive] Error 1 gmake[2]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext' gmake: *** [all-recursive] Error 1 Worked ok with PostgreSQL 7.0.3 Any ideas? Thanks, Ron Patterson USA.NET Get free email and a permanent address at http://www.netaddress.com/?N=1 -- 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] Migrating from InterBase 4.0 to 6.0
Hi all, I need to migrate a database from InterBase 4.0 to 6.0 . Question is has anybody done this and what are the snafus !! The migration docs for 6.0 only seem to mention migration from 5.0 !! I would imagine a complete export from 4.0 and import into 6.0 would be the way to go. Any suggestions would be appreciated Regards Steve -- --- "Minds are like parachutes, they work best when open" Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- 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] Proxy
I am behind a LAN and i would like to know to use PHP's get_meta_tags function though a proxy. Can someone write me the help or write me the code thanks _ 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]
