Jump to content

king.oslo

Members
  • Posts

    81
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

king.oslo's Achievements

Member

Member (2/5)

0

Reputation

  1. Sorry about quoting myself for no reason. why what? M
  2. http://www.embeddedarm.com/documentation/ts-7260-datasheet.pdf 1W!
  3. Found this really cool SBC: http://www.igep-platform.com/index.php?option=com_content&view=article&id=46&Itemid=55 It is like 4W, so it is useless, because I was hoping for less than 2W! Your help would be greatly appreciated. Thanks.M
  4. Hello there! I am going to have a server running, preferably for weeks without recharging from a regular 12V battery, in the back of a car. The server will output a digital dashboard that can be accessed via wi-fi to the driver with an iPhone or Blackberry. Time to be creative! So my question is: What is the absolute least power consuming gadget + router that can: - take input from a microcontroller (temp sensor etc data) through a port, and save it to a db or file that php server can output to - serve a simple php website (what the website is like, will follow) through a wireless access point? Any funky ideas? Thanks. Marius
  5. Hello, On my VPS, most of the php files that are requested, i.e. index.php are returned to the client as interpreted php code (ie HTML, for example). However, in a few directories, when a clients requests a file, i.e. database.php, the actual php-code is returned (where database username and password are present) which is a major issue!!!! How can I change this so that the server returns interpreted php-code, not raw php code? Very greatful for quick replies! Thanks, Kind regards, Marius
  6. Thanks, briefly, without taking too much of your time, which advantages would I get by following this advice? Thanks.M
  7. What kind of hardware should I look at to do this?M
  8. Ideally, I'd like a server to connect DIRECTLY to all the clients via WiFi without a router or switch. Then i would like an app to be available to all clients.M
  9. Hello, Is it possible to use a server to serve the entire wlan? If so, how is it done? Thanks, Marius
  10. Hello there, What is a sensible way to get the resistance from a temperature sensor circut to use in a web application? Thank you. Kind regards, Marius
  11. Good morning, I have this class saved in "class_lib/db.php": <?php class DBManager { protected $_connection; private $_type; function __construct($db, $host, $username, $password) { $this->_type = $db; if ($this->_type == 'mysql') { $this->_connection = mysql_connect($host, $username, $password); mysql_query('SET NAMES UTF8'); mysql_query('SET CHARACTER_SET utf8'); } } function dbRead($query) { if ($this->_type == 'mysql') { $resultat = mysql_query($query, $this->_connection); for ($i = 0; $i < mysql_num_rows($resultat); $i++) { $array[$i] = mysql_fetch_array($resultat, MYSQL_ASSOC); } } return $array; } function dbWrite($query) { if ($this->_type == 'mysql') { $sql = mysql_query($query); } } } I also have this instantiation: <?php include_once('class_lib/db.php'); $DBManager = new DBManager('mysql', 'host.example.com', 'xxxxxxxx', 'xxxxxxxxxxxx'); print '<pre>'; print_r($DBManager -> dbRead('SELECT * FROM db.table')); print '</pre>'; I get this error: "Fatal error: Cannot access empty property in /home/category/class_lib/db.php on line 9" Notice: i only get the error if I try and include the class from a separate file. If I copy the class to the view, I get no error. The question: Why?
  12. Hello, I have made this query: SELECT DISTINCT tmp.id FROM ( SELECT id FROM database.table_index WHERE unixTimestamp > 1266793200 UNION SELECT id FROM database.table_truser WHERE unixTimestamp > 1266793200 UNION SELECT id FROM database.table_undies WHERE unixTimestamp > 1266793200 UNION SELECT id FROM database.table_about_product WHERE unixTimestamp > 1266793200 UNION SELECT id FROM database.table_cart_2 WHERE unixTimestamp > 1266793200 UNION SELECT id FROM database.table_dirty WHERE unixTimestamp > 1266793200 UNION SELECT id FROM database.table_faq WHERE unixTimestamp > 1266793200 UNION SELECT id FROM database.table_final WHERE unixTimestamp > 1266793200 UNION SELECT id FROM database.table_gtbill_postpay WHERE unixTimestamp > 1266793200 UNION SELECT id FROM database.table_lek WHERE unixTimestamp > 1266793200 UNION SELECT id FROM database.table_pool_product WHERE unixTimestamp > 1266793200 UNION SELECT id FROM database.table_custompay WHERE unixTimestamp > 1266793200 UNION SELECT id FROM database.table_send WHERE unixTimestamp > 1266793200 UNION SELECT id FROM database.table_send_bank WHERE unixTimestamp > 1266793200 UNION SELECT id FROM database.table_send_order WHERE unixTimestamp > 1266793200 UNION SELECT id FROM database.table_tnc WHERE unixTimestamp > 1266793200 ) AS tmp WHERE id IN ( SELECT id FROM database.table_index WHERE unixTimestamp < 1266793200 UNION SELECT id FROM database.table_truser WHERE unixTimestamp < 1266793200 UNION SELECT id FROM database.table_undies WHERE unixTimestamp < 1266793200 UNION SELECT id FROM database.table_about_product WHERE unixTimestamp < 1266793200 UNION SELECT id FROM database.table_cart_2 WHERE unixTimestamp < 1266793200 UNION SELECT id FROM database.table_dirty WHERE unixTimestamp < 1266793200 UNION SELECT id FROM database.table_faq WHERE unixTimestamp < 1266793200 UNION SELECT id FROM database.table_final WHERE unixTimestamp < 1266793200 UNION SELECT id FROM database.table_gtbill_postpay WHERE unixTimestamp < 1266793200 UNION SELECT id FROM database.table_lek WHERE unixTimestamp < 1266793200 UNION SELECT id FROM database.table_pool_product WHERE unixTimestamp < 1266793200 UNION SELECT id FROM database.table_custompay WHERE unixTimestamp < 1266793200 UNION SELECT id FROM database.table_send WHERE unixTimestamp < 1266793200 UNION SELECT id FROM database.table_send_bank WHERE unixTimestamp < 1266793200 UNION SELECT id FROM database.table_send_order WHERE unixTimestamp < 1266793200 UNION SELECT id FROM database.table_tnc WHERE unixTimestamp < 1266793200 ) Each table has identical structure: Field Type id int(10) unixTimestamp int(20) THE QUESTION: ---------------------- When it executes, it is very slow (14 sec), returning about 50 rows. I figured there must be a better way to make this query that is faster and better? Thanks, Marius
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.