Ekate

All right, thank you very much, BR, Ekate

Thanks a lot, I just have to move the project from MySQL to Postgre... One more stupid question if you don't mind, if I have class and a lot of functions, and every funcrion looks like this getId, will I have to declare this variable $db_handle as global for every function, or there is another smart way? Thank you, BR, Ekate

Hello, I'm getting the following error when I'm running the script: Warning: pg_exec(): supplied argument is not a valid PostgreSQL link resource My code: function getId() { $serial=$this->serial_number; $result= pg_exec($db_handle,"select id from gifts where serial_number = '$serial';") or die('Query failed.'.pg_last_error()); ///Error message ///points to this line if (pg_numrows($result) == 1) {return pg_result($result,0,'id');}else {return 'Error';}; } Could you please point me why? Thank you, BR, Ekate

Actually I've never worked with Perl

Hello,dear experts I'm just wondering if I can do it using PHP. I have the network and RFID reader switched to every computer. I need to get the information from RFID reader, The question is if it is possible to get the information from the serial ports of remote computers using PHP ? Because PHP is the interpret language and actually it executes on the Server, or I misunderstood smth? Best regards, Ekate

Hello,dear experts I have the following problem I'm trying to connect to the database on my laptop from my working machine. So,I have MySQL 5 and I did all this kind of access settings,I mean grant and so on and after that FLUSH PRIVILEGES But when I'm trying to connect I'm getting an error...I just can't connect I switched off the Firewall and still don't know what is the problem If I try to run this command: telnet myLaptopIP 3306 I get the following error message : Could not open connection to the host on port 3306:Connection failed Any ideas? Thank you in advance, best regards

I need to estimate the amount of data transmission. Like how many kbytes of data I transfer and get back during the query execution

Hello,dear experts I'm sorry for silly question,but I need to estimate the amount of data I sent to the MYSQL server and obtain. Like I send the SQL query to the MySQL Server,the Server solves task and give me the answer like several rows from the tables which I than load to my application.And I need to estimate the amount of data I get. Thank you in advance, Ekate

I'm doing the client application using PHP-Gtk2, through this application user can connect to the MySQL,can upload and get some data. But I use temporary tables in it,and that's why I'm asking about possibility to handle the rights for dropping the temporary tables... Thank you in advance

Hello,dear experts! I have this kind of silly question for you. If my client application creates and drops the temporary table how can I manage this when I assign the rights for the user when he connects to the database.I mean I don't want to allow the user create and drop the tables,but if he needs to create and drop the temporary it means that I should allow to do it on the database level and of course it doesn't suit me,'cause with this rights my user can do some bad things with my database... Could you please give me some advises Thank you in advance, best regards, Ekate

Thank you very much for your opinion,I really very appreciate it. So,recently I'm doing some coding work using php-gtk2,it's new experience for me... I want believe that everything will be ok and I'll do my project soon. Again,thank you very much, all the best regards

as I correctly understood you need to insert data in two tables or not insert nothing. Probably in this case you can use transaction. the sequence is following: begin transaction tr_name insert into table1... insert into table2... commit transaction tr_name you should check the syntax of transactions in MySQL

All clients have access to the same database.I just need to react somehow on database changing. I know that I can reload the client every certain time,but I'm wondering about reaction on the database changing.I mean if one client upload something it should be immediately reflected on other clients,but I don't want to force all clients reload every certain time. Thank you Best regards

Hello, probably I'm asking stupid question,but... If I have several running clients and one of them is making changes in the database. How can I obtain these changes automatically in other clients? Thank you in advance, Best regards

Thank for all of you, so I guess that the problem is solved