How to optimize My Sql access from PHP code.?
483252
If this code is rather static, you can write a utility procedure to dump the query output to a .php file. Then pages that need the query data can simply use the include statement to load the page.  You can run this utility every minute, day, week, whatever is proper for your situation.\n\nIf the data changes based on other data on the web page and you are just doing multiple round trips to the server to refresh your lists, then create the form as a page and load it using AJAX calls.  This way the whole page doesn't have to reload as the drop boxes are updating.\n\nFinally, as in the second situation where you have a form that requires the drop boxes to change based on the user input, you can dump all the data to page and manipulate it using javascript.  I have found creating a page with 500 rows of data takes the same time as one with 10 rows.  It wastes bandwidth, but making these decisions is why you get paid the big bucks.
828970
dim db as database\ndim rs as recordset\ndim strSQL as string\ndim strA as string\ndim strB as string\ndim strC as string\n\nset db = currentDB\n\nstrSQL = "Select fieldA, fieldB, fieldC from Table1 where FieldD = fieldvalue"\n\nset rs = db.openrecordset(strSQL, dbOpenDynaSet)\n\nif not rs.EOF then\nstrA = rs!fieldA\nstrB = rs!fieldB\nstrC = rs!fieldC\n\nend if
1101440
Hi,\nI am database programmer and use MS Access and SQl and others. Give a detailed example what you exactly want to do. Then I will tell you the design. I never designed a database wrong until now, hehe.\n\nA very important tip for you! If you want later export the database to SQL do NOT use the export wizzard of Access. This wizzard does not work and cost only time. Use the Import Wizzard in SQL. This wizzard works. \n\nNice greetings\nFranky
350481
If you want to keeps your costs low.  Then you'll probably be using PHP and MySQL, or possibly Postgres.  The last two are the database programs to store your data.
55523
You will have to use some scripting language, \nI advise you to use PHP with MySQL. \nBut also there are a LOT of created sollutions. Just look out for login script or even you can try with some CMS like Joomla, Mambo, PHPnuke, XOOPS ........ witch already have implemented loging feature.
511879
Perhaps it's a security thing...? I don't know asp, but in php it can mess up that kind of thing with security, or if you're literally interpreting the input, or if your code is just plain bad...
107495
Hello. It's free application which enhance the performance of your PHP scripts. It increases runtime performance up to 40%.
683039
=======\nPHP\n=======\nYou can get a 1,000 page PHP Manual here:\n\nhttp://meysoft.com/support/phpmanual.pdf\n\nYou might prefer the on-line manual here:\n\nhttp://www.php.net/manual/en/\n\nI like the on-line version better because there are a lot of coding examples that have been contributed by users.\n\n=====\nMySQL\n=====\nYou can get a PDF manual here:\n\nhttp://downloads.mysql.com/docs/refman-4.1-en.pdf\n\nGood luck and don't forget to pick the best answer!
1060571
Do you get an exception error?\n \nI would need to see the SQL statement to see what is wrong with it. If it is executing the query, but you dont see the changes, then there is something wrong with the SQL statement.
18196
1. Read everything you can at php.net\n2. Install the Apache-PHP-MySQL trio of open source software on your PC, configured for PHP programming (go here: http://mpcon.org/apacheguide/index.php )\n3. Download sample scripts (like displaying the current date and time, etc...) to learn by example
393030
See the reference below.  The documentation has some examples. \nFailing that MySQL has a C API which you could use from C++.
598111
You can use PHP and read/write to a MySQL Database.\n\nHere is one good tutorial:\nhttp://webmonkey.wired.com/webmonkey/programming/php/tutorials/tutorial4.html\n\nIf you need additional help you can email me,\neoffice4u@gmail.com
799600
Use either Access or MySQL. 1000 records is very small, you do not need to pay the $thousands for MS SQL or Oracle. Access can definitely handle 1000 records.\n\nOne nice thing about Access is that it enables you to create forms. So people can input data using a visual form, and the data goes into the database. Also, Access offers a GUI for creating your database tables. MySQL does not offer these capabilities, but its main plus is that it is free. I would question what the other guy said about how powerful it is, though. It is definitely a lot weaker than Oracle or MS SQL, BUT for your needs it should be fine.\n\nEither Access or MySQL will work fine for Web programming too if you want to connect your db to an online Web site.
858387
What platform: PHP or ASP.NET?\nDo you have support for database? If so, which kind: Access, MS-SQL, MySQL?\n\nUPDATE:\n\nThe script is complete and ready for use.\n\nhttp://www.dougv.com/blog/2006/11/26/a-simple-php-script-mysql-too-to-track-radio-station-song-requests/
207382
The PHP docs are quite good and include examples:\n\nhttp://www.php.net/manual/en
1007349
add a hidden field\n<input type="hidden" name="num_inputs" value="how_many_inputs_you_have">\n\nthen when submitted\n$i = 1;\n$sSql = "INSERT INTO table (name, age) VALUES";\nwhile ($i < $num_inputs) {\nif ($_POST[$name.$i] != "" && $_POST[$age.$i] != "") {\n$sSql .= "('".$_POST[$name.$i]."' , '".$_POST[$age.$i]."')";\n$i++;\n}\n}\nexecute query here\n\n$name.$i would get evaluated to name1, name2 etc, and if statement checks if both of them are empty. operation .= means "stick whats on the right to whatever was in left variable"
1002503
I hate the darn things. I have one in my name and it's a real pain.\n\nApplications written in SQL have a real problem with them too and usually error out if you include one.\n\n\nOther than that it's just plain lazy.