torontob

Hi everyone, I have a php script that does pings of my network and writes data to MySQL. What is the best tool (open-source/free) out there to use to graph this data. I can work/google my way through PHP but I am not expert so something easy and not much complicated would be appreciated. At the same, I am pinging every minute so I want an accurate and good quality graphs to show on the monitor. This is for a Network Operations Center and eventually will be shown 24/7 on real-time basis. I have seen and like RRDTool graphs but I am wondering what else is available. Currently looking at jpgraph as well but I am not sure if it's made for network data graphics. You can suggest something really simple to start and some more beautiful and feature-rich ones down the list. I highly appreciate expert opinions. Thanks

Hi everyone, Rather than re-inventing something that might already exists, I am asking the community if you know of any site where tons of php scripts or already coded program are available for download? I don't mean to be lazy but rather working on a bigger project and it saves lots of time to put in together the simple parts from who have already coded it. I am sure that somewhere out there someone has coded something really really nice in php/html that queries a database and displays selected fields. I am looking to impress myself so please forward me to any and all codes that are available as open-source out there for my mentioned need. Thanks

Anything guys? Thanks

Thanks Gabroar. And security was indeed my next question because mysql password is plain text. Or maybe someone gets create or if there is a hole in php or browser and appends some other variables to the end of the URL and now they can read the whole database. Is that possible? Has it happened before? Or is php file totally hidden to the users eye all the time? Credit in this case only refers to Balance field but you are right and there are some other sensitive information stored in the same database such as usernames/passwords in plaint text. Thanksm Bruce

Perfect! Amazing. Thank you very much. Here is my sample code: PHP: <?php $con = mysql_connect("localhost","username","password"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("mya2billing", $con); $result = mysql_query("SELECT * FROM cc_card WHERE username='12345671234'"); while($row = mysql_fetch_array($result)) { echo $row['credit'] . " " . $row['id']; echo "<br />"; } ?> This works fine and pulls up "credit" and "id" based on WHERE username=12345671234 but what can I replace that username value to in order to be able to do something like this: http://my.site.com/balance.php?username=99999 so that then I can pull balance on username 99999. My method is static and hooked up to only username=12345671234 now. Thanks again

Hi Guys, I am new to php but have done programs in C, Basic, etc... I have a mysql database with a field named Balance which keeps the balance for customer accounts. I want to be able to provide the customers with option to check balance by simply inputing this into their browser: http://my.website.com/balance.php?acountnumber=12121212 and I want balance.php to now go to MySQL and retreive the balance number corresponding to account number 12121212 and display on the screen. Can you please guide me on how to do this? Some snippets of the code would greate help. Also is my URL format using "?" and "=" sign right? Thanks again