Re: PHP, MYSQL and persistant authentication
Hi , u can try this one out http://www.zend.com/zend/tut/tutorial-delin4.php Regards Eric === Kamara Eric Rukidi Mpuuga Computer Frontiers International Plot 32 Lumumba Avenue P.O Box 12510,Kampala Tel :256-41-340417/71 Mob :256-71-190856 Email:[EMAIL PROTECTED] Web :http://www.cfi.co.ug On Sat, 14 Jun 2003, sgannon60 wrote: Hi, Does anyone know of a good tutorial on setting up a login page, and passing the login primary key to other pages so that other tables will be able to refernce the unique login thanks steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: changing mysqld deamon ownership.
[admin admin]$ ps auxw | grep mysqld root 11073 0.0 0.1 1672 824 pts/0S01:12 0:00 sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/ Presumably the root on line one shows it's running as root? this paragraph in the book is extremely sketchy. What this line shows is that the script(in this case /usr/bin/safe_mysqld) that starts the mysql daemon is run by root but that the server is running as the user mysql. === Kamara Eric Rukidi Mpuuga Computer Frontiers International Plot 32 Lumumba Avenue P.O Box 12510,Kampala Tel :256-41-340417/71 Email:[EMAIL PROTECTED] Web :http://www.cfi.co.ug -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: changing mysqld deamon ownership.
Yeah...I don't think you need to make any changes.. On Fri, 30 May 2003, 2Hosts.com wrote: Thanks Kamara, So does that mean I don't need to change anything? [admin admin]$ ps auxw | grep mysqld root 11073 0.0 0.1 1672 824 pts/0S01:12 0:00 sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/ Presumably the root on line one shows it's running as root? this paragraph in the book is extremely sketchy. What this line shows is that the script(in this case /usr/bin/safe_mysqld) that starts the mysql daemon is run by root but that the server is running as the user mysql. === Kamara Eric Rukidi Mpuuga Computer Frontiers International Plot 32 Lumumba Avenue P.O Box 12510,Kampala Tel :256-41-340417/71 Email:[EMAIL PROTECTED] Web :http://www.cfi.co.ug -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Examples needed of MYSQl/PHP update, delete scripts and relevantforms
Hi Scott, Can you please explicitly state what you want to be done otherwise it seems that all you need to do is get the records from the database,display them to the user and include something like a checkbox or radio button that the user can select to show the records he wants deleted. Then all your script will have to do is check if the checkbox is checked and then delete those records with a simple sql query. Regards, Eric === Kamara Eric Rukidi Mpuuga Computer Frontiers International Plot 32 Lumumba Avenue P.O Box 12510,Kampala Tel :256-41-340417/71 Email:[EMAIL PROTECTED] Web :http://www.cfi.co.ug On Fri, 21 Feb 2003, Scott wrote: I am looking for a set of examples of the relevant form pages and the php backends that connect to eitehr a YSQL or MSSQl database where the user can select certain records and then delete or update them. I ma having a nightmare designing one and examples always help me. Does anyone know of any or any websites that show them. I have been searching on google to no avail so far. Scott - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to Import from tab delimited text file?
Hi Taurel, You can use a perl script to do that work for you.A sample is given below code #!/usr/local/bin/perl use DBI; #These are the configuration variables $host =host on which mysql is running; $uname = database user; $pword = user password pass; $dbase = database name; #Connect to the database $dbh = DBI-connect(DBI:mysql:database=$dbase;host=$host,$uname,$pword); #Open the file that has the data and loop thru the file getting the data open (FILE,'/path/to/tab delimited/textfile'); while (FILE) { ($field1,$field2)=split (/\t/,$line); $sql = INSERT into tbl_name $result=$dbh-prepare($sql); $result-execute(); } /code The same piece of code should work with an excel file. the variables $field1 and $field2 can be increased in number according to the number of fields in your text file. This is the simplest way that I can think of though there might be another method. Regards, Eric === Kamara Eric Rukidi Mpuuga Computer Frontiers International Plot 32 Lumumba Avenue P.O Box 12510,Kampala Tel :256-41-340417/71 Email:[EMAIL PROTECTED] Web :http://www.cfi.co.ug On Thu, 20 Feb 2003, Inandjo Taurel wrote: hi, i'd like to have the syntax to import in a mysql table from a tab delimited text file, and also the same thing from an excel file. Thanx _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: List of Tables
Hi, Have u thought of sending an sql query like show tables and then looking at what it returns? Eric On Thu, 20 Feb 2003, Jeff Pearson wrote: I am writing a vb.net application to do some db management on MySQL. Ive got it pretty far but am at a point where I am stuck. I know with php there is a list tables function. Does anyone know of a way to list the tables of a given database outside of php? Any help would be GREATLY appreciated. Jeff Pearson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Deleting a database in Mysql
Hi Calvin, Just do drop database db_name Regards, Eric On Wed, 5 Feb 2003, Calvin Lam wrote: Hi, I am a newbie with this and I need help with Mysql How can I delete a database in Mysql thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: encrypted password
On Tue, 4 Feb 2003, Jianping Zhu wrote: I have mysql in a redhat machine. I need to use mysql do user authentication to a website. I have a table like following. +--+--+ | username | passwd | +--+--+ | jianping | jian1830 | | chichi | jian1830 | +--+--+ I want the passwd field not to be plain text but encrypted. how can i do that? Thanks. use the following sql syntax when creating a user INSERT into tbl_name (username,password) values ('user',PASSWORD('passwd')); and when authenticating the user you can do something like SELECT username from tbl_name where passwd=PASSWORD('$pass'); and in this case $pass is the variable holding the password entered on the webpage. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards, Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Assigning different hosts
On Tue, 4 Feb 2003, Mike Blezien wrote: Hello all, I want to change some of our database host settings to allow for other host connection other then the default 'localhost' setting. what is the proper way to assign a different host to connect to, like an IP address or something like mysql.somedomain.com,..etc.. If you are reffering to connecting to the database on the commandline,then i suggest you try mysql -u username -p -h hostname that should get you to the remote host Regards, Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: newbie question
Hi Derek, No it doesn't take alot of techy knowledge, time or trouble to run MySQL on windows...Just download it and install and it will be ready to run.Infact installation on a Windows sytem should be easier than on *nix. Regards, Eric === Kamara Eric Rukidi Mpuuga Computer Frontiers International Plot 32 Lumumba Avenue P.O Box 12510,Kampala Tel :256-41-340417/71 Email:[EMAIL PROTECTED] Web :http://www.cfi.co.ug On Tue, 4 Feb 2003, Derek Parkinson wrote: I'm thinking of setting up a bulletin board for a system with Windows 2000 OS. Most of the good, affordable BB software uses MySQL databases. Is it possible/practical to run MySQL on Windows OS? Does it take a lot of techy knowledge, time trouble? Help appreciated, Derek. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql, PHP and Javascript
Hi Steve, You can definitely mix javascript and PHP in the same script so long as you follow the correct syntax for each language.There is no way out here really...if you want to include javascript in your scripts then you have to learn it:-) unless you want to hire someone to do it for you... Regards, Eric On Fri, 31 Jan 2003, Steve Davies wrote: Hi All Is it possible to mix javascript and PHP in the same script?? I have a number of web based apps written in PHP/MySql and while they are functionally pretty good they are aesthetically garbage. I'll like to pretty up the interfaces with rollovers etc, but haven't got time to learn JS properly especially if I have to completly re-write the functionality. Any help greatly appreciated Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Writing a database program in GNU C++ using MySQL.
Hi Prabu, From my own experience I'd say that PHP is the best option since it can be compiled with MySQL support and you will find that accessing the database is very easy. Regards, Eric On Wed, 29 Jan 2003, Prabu Subroto wrote: Dear my friends, My boss wants a database application running on linux machine without XWindows. Is it easy to make the connection to MySQL with GNU C++ . Is perl better then GNU C++ in this case? How is Jave ? TAC. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql
On Sun, 19 Jan 2003, M A wrote: HI i am new to mysql.. i have just installed the source code under /user/local/mysql but the commnads don't work unless i have ./ infront of the command for example: mysqladmin won't work unless its written ./mysqladmin. please let me know if i am doing something wrong Thanks Have you tried putting /usr/local/mysql in your search path?add /usr/local/mysql/bin to the line that has PATH in the file /etc/profile or something similar Eric _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL PHP
Hello Ryan, Did u compile PHP with mysql support enabled?as in did your configure line have something like this ./configure --with-mysql=/path/to/mysql? Regards, Eric === Kamara Eric Rukidi Mpuuga Computer Frontiers International Plot 32 Lumumba Avenue P.O Box 12510,Kampala Tel :256-41-340417/71 Email:[EMAIL PROTECTED] Web :http://www.cfi.co.ug On Sat, 18 Jan 2003, Ryan McDougall wrote: hello all, I'm posting on 2 lists because I'm not sure were the problem is, so I'm hoping that some one can help me out. I'm running a stock RH8 machine running amongst other things MySQL 3.23.52-3, Apache 2.0, PHP 4.2.2-8.0.5 When I try a simple php script that is this (sensitive information changed to protect me): html headtitleMy PHP test file/title/head body ?php $link = mysql_connect (localhost, user, password) or die (Could not connect); print (Connected successfully); $query = SELECT * FROM who; $result = mysql_db_query (mcdougrsMedia, $query) or die (Query failed); ? /body /html The page produces the following output: Fatal error: Call to undefined function: mysql_connect() in /home/username/public_html/testing.php on line 5 Can you guys see what is wrong... or if there is other information that is needed that isn't there please let me know and I will post whatever information is needed to fix it. TIA, Ryan __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php