AdamCox9

Hello, I just released a first version of a cryptocurrency trading platform that I wrote in PHP. It is open source and there is potential for developers to build their own bots for the platform and sell them or just for use. I'm looking for developers to contribute to the platform and expand it to cover all the major exchanges and all the functionality they offer. My github repository is: https://github.com/AdamCox9/nickelbot/ My first post of it was on bitcointalk forum: https://bitcointalk.org/index.php?topic=1420693.0

I have a DB where I was not checking for duplicate entries. Now I am. But, I have many duplicate posts (spam) inside my DB. Is there an easy way to remove all the duplicate entries for one field from the DB?

<?php // Make a MySQL Connection $query = "SELECT type, MAX(price) FROM products GROUP BY type"; $result = mysql_query($query) or die(mysql_error()); // Print out result while($row = mysql_fetch_array($result)){ echo "The most expensive ". $row['type']. " is $" .$row['MAX(price)']; echo "<br />"; } ?> Here is a sample. This is found at: http://www.tizag.com/mysqlTutorial/mysqlmax.php

I would appreciate some feedback on my new website: Random Thoughts Thanks! Both criticism & complements are greatly appreciated!

What are the best methods to optimize Apache for a large number of users?

Depending on what version of MySQL version, using this before inserting the variable should let you put HTML into the DB: $html = "<b><div>etc...</div></b>"; $html = mysql_real_escape_string($html,$conn); And then just insert the $html variable into the DB as usual. This should work.

What are the best methods to optimize my MySQL to handle a lot of hits? I was discussing my issues here with somebody: http://www.phpfreaks.com/forums/index.php/topic,186392.0.html in the PHP help section, but this might be the appropriate place to get started. I was thinking about trying to set up the Master/Slave and using a couple of servers, but I'm not sure if I have the time for that. I may be wrong though. How complicated is it to set up Master/Slaves and/or use more than one server. Does anybody know any good places to get started on optimizing my system? I have about 20K-30K hits a day to the DB and about 2/3 of them are inserts/updates and 1/3 are read onlys. Also, could someone give me an estimate on how long it would take to learn & to setup all of this. I'm very familiar with the basics for SQL & DB. Any suggestions would be greatly appreciated.

You have to send out the headers BEFORE displaying anything else even a echo " "; Try using this if you have already displayed output: <META HTTP-EQUIV=\"refresh\" content=\"2; URL=index.php\"> ";

engine=innodb It could also be the 3rd party APIs I am using that make requests and wait for responses during the execution of the script. But, I absolutely can't do nothing about that. I've been doing a mysql_dump and saving the data to disk after about 75K entries. That helps a very lot. I think that is def part of the problem.

I'm reading and checking a value in the DB to decide if to update with 2 queries. query1 = select count... ... if ( mysql_num_rows < x ) query2 = update....

There are probably 20-30K Queries a day and approximately 2/3's of them are inserting/updating. The data is constantly being inserted/updated. I read that I should not use indexes if that is the case because the DB will have to reindex it every time it changes which could make it take more time. I'm running it on a pretty fast dedicated linux server. How do I find out the specs on the hardware that you need? Thanks for your response!

True. I didn't even think of that. I usually see that their is a field to enter old password and then new password and a field to verify new password. That is the standard I see on the popular sites.

hmm... It should put the values in it and bleep them out also. I'm not sure. See what this displays: $password = "valuefromDB"; <input type="password" value="$password" name="password"> do a print_r($_RESULT); to see what value is there.

That is scientific notation. 340 = 3.4E2 3400 = 3.4E3 34000 = 3.4E4 340000 = 3.4E5 ie: it is to the power of 10. Use sprintf to translate it: http://us3.php.net/sprintf

You may want to prefill the fields in the forms with the data that is already in the DB. That is usually how it is done for profiles & such.