[PHP-DB] parse error in create statement.
HI, Whats the error in this code. $sqlstmt= CREATE USER .$adduser. PROFILE DEFAULT IDENTIFIED BY .$addpass. DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON USERS ACCOUNT UNLOCK; GRANT CREATE TABLE TO .$adduser. GRANT CREATE TRIGGER TO .$adduser GRANT CONNECT TO .$adduser;. any suggestions. - Yahoo! Messenger NEW - crystal clear PC to PCcalling worldwide with voicemail
Re: [PHP-DB] parse error in create statement.
Check your placement of all the '.' for a start. raz On 6/14/05, babu [EMAIL PROTECTED] wrote: HI, Whats the error in this code. $sqlstmt= CREATE USER .$adduser. PROFILE DEFAULT IDENTIFIED BY .$addpass. DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON USERS ACCOUNT UNLOCK; GRANT CREATE TABLE TO .$adduser. GRANT CREATE TRIGGER TO .$adduser GRANT CONNECT TO .$adduser;. any suggestions. - Yahoo! Messenger NEW - crystal clear PC to PCcalling worldwide with voicemail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] parse error in create statement.
Also, correct me if I'm wrong, but this needs to be split into two seperate query strings and executed seperately... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] parse error in create statement.
$sqlstmt= CREATE USER .$adduser. PROFILE DEFAULT IDENTIFIED BY .$addpass. DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON USERS ACCOUNT UNLOCK; GRANT CREATE TABLE TO .$adduser. GRANT CREATE TRIGGER TO .$adduser. GRANT CONNECT TO .$adduser.; for the .'s
Re: [PHP-DB] parse error in create statement.
Missing a . in the line before the last quote GRANT CREATE TRIGGER TO .$adduser $sqlstmt= CREATE USER .$adduser. PROFILE DEFAULT IDENTIFIED BY .$addpass. DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON USERS ACCOUNT UNLOCK; GRANT CREATE TABLE TO .$adduser. GRANT CREATE TRIGGER TO .$adduser. GRANT CONNECT TO .$adduser;. bastien From: Chris Ramsay [EMAIL PROTECTED] Reply-To: Chris Ramsay [EMAIL PROTECTED] To: babu [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: Re: [PHP-DB] parse error in create statement. Date: Tue, 14 Jun 2005 10:56:24 +0100 Check your placement of all the '.' for a start. raz On 6/14/05, babu [EMAIL PROTECTED] wrote: HI, Whats the error in this code. $sqlstmt= CREATE USER .$adduser. PROFILE DEFAULT IDENTIFIED BY .$addpass. DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON USERS ACCOUNT UNLOCK; GRANT CREATE TABLE TO .$adduser. GRANT CREATE TRIGGER TO .$adduser GRANT CONNECT TO .$adduser;. any suggestions. - Yahoo! Messenger NEW - crystal clear PC to PCcalling worldwide with voicemail -- 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] RE : Subject: Com 1
From: Nandar [EMAIL PROTECTED] To: php-db@lists.php.net Message-ID: [EMAIL PROTECTED] Date: Tue, 14 Jun 2005 10:01:59 +0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary==_NextPart_000_0007_01C570C8.1A876C60 Subject: Com 1 Hi,. any one to know, how to send ascci file to com1 port from php ?? thx, nandar $ascii_file_data='This is my test data'; // Your temp directory : Acquire filename handle $tmpdir=C:\temp\; $filename=tempnam($tmpdir,file_prefix_); // Write data to file $fp=fopen($filename); fwrite($fp, $ascii_file_data); fclose($fp); // Send file contents to COM1 $command=type .$filename. com1; exec($command, $result); // Remove temp file fclose($filename); unlink($filename); See also Output redirection in DOS : http://zone.ni.com/devzone/conceptd.nsf/webmain/822FA8FC01C3C0C086256A7100546D8E Cheers - Neil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Security and MYSQL databases
Hello. Simple question. An SSL server and a standard a shared MYSQL server that I have with my hosts. If I am to set up a shopping cart system, is this a secure way of handling credit card details. What is the best way of receiving the details? I assume an email is not a good way as these can be intercepted. Is MYSQL secure enough in this way? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Security and MYSQL databases
You should never [almost never ever] store cc details from your users. Integrate a 3rd party payment processor into your site and process the payments immediately. It will cut down on fraud and chargebacks by the users. Its also more secure since the cc details are not stored on your machine. What you get back is a payment confirmation number which you can store in your systemto reord that payment was approved...and if you don't get one, you know immediately its been disallowed so you can stop the process at that point. The issues against it are: 1. its not completely secure. You don't have direct control of the server and therefore can't assure yourself that the system is locked down tight and kept updated. 2. Your db may not be secure enough 3. Your code may allow for holes that allow hackers to gain access to the data. 4. The liability for your business, should your data become compromised. Don't say it can't happen. Ask Playboy.com. Hackers access 8million accounts and had all the details. If you can't use a 3rd party processor, then you still shouldn't store the data on the server, but send an encrypted email (using pgp) to yourself with the account / order details for processing. But I strongly recommend using a 3rd party processor. Bastien From: I. Gray [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Security and MYSQL databases Date: Tue, 14 Jun 2005 14:36:50 +0100 Hello. Simple question. An SSL server and a standard a shared MYSQL server that I have with my hosts. If I am to set up a shopping cart system, is this a secure way of handling credit card details. What is the best way of receiving the details? I assume an email is not a good way as these can be intercepted. Is MYSQL secure enough in this way? -- 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] Security and MYSQL databases
Thanks, I kind of suspected this, but it's good to be told. I wouldn't want to like to think my CC details were held on some database somewhere where it can get hacked into. Apart from paypal are there any other 3rd party payment processors that anyone recommends? I think we're perhaps going a little off topic here, so sorry. Bastien Koert wrote: You should never [almost never ever] store cc details from your users. Integrate a 3rd party payment processor into your site and process the payments immediately. It will cut down on fraud and chargebacks by the users. Its also more secure since the cc details are not stored on your machine. What you get back is a payment confirmation number which you can store in your systemto reord that payment was approved...and if you don't get one, you know immediately its been disallowed so you can stop the process at that point. The issues against it are: 1. its not completely secure. You don't have direct control of the server and therefore can't assure yourself that the system is locked down tight and kept updated. 2. Your db may not be secure enough 3. Your code may allow for holes that allow hackers to gain access to the data. 4. The liability for your business, should your data become compromised. Don't say it can't happen. Ask Playboy.com. Hackers access 8million accounts and had all the details. If you can't use a 3rd party processor, then you still shouldn't store the data on the server, but send an encrypted email (using pgp) to yourself with the account / order details for processing. But I strongly recommend using a 3rd party processor. Bastien From: I. Gray [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Security and MYSQL databases Date: Tue, 14 Jun 2005 14:36:50 +0100 Hello. Simple question. An SSL server and a standard a shared MYSQL server that I have with my hosts. If I am to set up a shopping cart system, is this a secure way of handling credit card details. What is the best way of receiving the details? I assume an email is not a good way as these can be intercepted. Is MYSQL secure enough in this way? -- 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] Strange MySQL Problem
I'm am having the hardest time getting PHP to connect to MySQL. From a command line I can say 'mysql -u root -p' and connect with no problems. From within my PHP script if I say $_connection = mysql_connect('localhost', 'root', 'password') or die(mysql_error()); I get: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) Everytime. Running MySQL 3.28.58 on Fedora Core 3 with PHP 4.3.9. Any ideas? -brian Brian D. McGrew { [EMAIL PROTECTED] || [EMAIL PROTECTED] } --- YOU! Off my planet!
Re: [PHP-DB] Strange MySQL Problem. .
Brian D. McGrew wrote: I'm am having the hardest time getting PHP to connect to MySQL. From a command line I can say 'mysql -u root -p' and connect with no problems. [snip] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) what do you get with: mysql -u root -p -S/var/lib/mysql/mysql.sock chances are you need to tell php where your mysql socket is (through php.ini). cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Postgres Bytea Field + Adodb
Hi, someone can helpme with inserting a binary data (from a file) to a Postgres Database with the ByteA field, i'm using the ADOdb class. THX -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysqldump but exclude one table
Hello everyone, I've a reader for sometime now, the best db list ever got into. Well, I'd like to mysqldump a certain database, but with skipping one table, is it possible? Thanx - Yahoo! Mail Stay connected, organized, and protected. Take the tour
Re: [PHP-DB] mysqldump but exclude one table. .
Hassan wrote: Hello everyone, I've a reader for sometime now, the best db list ever got into. Well, I'd like to mysqldump a certain database, but with skipping one table, is it possible? [snip] from mysqldump --help --ignore-table=name Do not dump the specified table. To specify more than one table to ignore, use the directive multiple times, once for each table. Each table must be specified with both database and table names, e.g. --ignore-table=database.table forgotten, but found using mysqldump --help | grep table and some quick scanning - docs are your friend :) cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysqldump but exclude one table. .
C:\mysqldump --version mysqldump Ver 9.09 Distrib 4.0.16, for Win95/Win98 (i32) C:\mysqldump --help | grep table STDIN 6 Dumping definition and data mysql database or table STDIN 7 Usage: mysqldump [OPTIONS] database [tables] STDIN 22--add-drop-tableAdd a 'drop table' before each create. STDIN 31In this case no tables are given. All name arguments are STDIN 41-K, --disable-keys '/*!4 ALTER TABLE tb_name DISABLE KEYS */; and STDIN 42'/*!4 ALTER TABLE tb_name ENABLE KEYS */; will be put STDIN 54-x, --first-slave Locks all tables across all databases. STDIN 61-l, --lock-tables Lock all tables for read. STDIN 65--no-autocommit Wrap tables with autocommit/commit statements. STDIN 67Dump all tables in single transaction to get consistent STDIN 68snapshot. Mutually exclusive with --lock-tables. STDIN 74Don't write table creation info. STDIN 80--opt Same as --add-drop-table --add-locks --all --quick STDIN 81--extended-insert --lock-tables --disable-keys STDIN 88-Q, --quote-names Quote table and column names with a ` STDIN 94-T, --tab=name Creates tab separated textfile for each table to given STDIN 98--tablesOverrides option --databases (-B). STDIN 112 add-drop-tableFALSE STDIN 132 lock-tables FALSE C:\mysqldump --help | grep ignore nada. Ummm. What version are you using, Martin? David
Re: [PHP-DB] mysqldump but exclude one table. .. .
[EMAIL PROTECTED] wrote: C:\mysqldump --version mysqldump Ver 9.09 Distrib 4.0.16, for Win95/Win98 (i32) [snip] Ummm. What version are you using, Martin? David fairly fresh I'm afraid. mysqldump Ver 10.9 Distrib 4.1.9, for pc-linux-gnu (i686) your grep generates... interesting... output :) Useful, but I hope its not default. A quick search on mysql's site isn't giving any indication when this was added - though there is mention of some replication flags with ignore-tables in 4.0.15 - since you're 4.0.16 I'm guessing that's not when it was added. Your other options are to expressly state the tables you want dumped mysqldump [OPTIONS] database [tables] the old fashioned way. You can get listings of the database through php and just have an `ignore` array that skips them when building the dump command. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php