PHP, MySQL, Joomla, Wordpress and other CMSes as well as CSS, jScript, jQuery related tested & trusted references links will be posted here for every PHP enthusiasts references. Enjoy
Search This Blog
Friday, October 26, 2012
Monday, October 22, 2012
PHP : Array to MySQL Table
I knew there has to be some way to simplify whole big process of INSERTing FORM DATA into SQL Table in less time.
3. There is one more things that is to remove "submit" button field
Finally, I worked my way out today for my client Yellow Cab Airport Taxi
Here is How?
1. Collect all form data into an array$flds = $_POST;2. Check Every form data has been collected in ARRAY
print_r($flds);If things are fine...
3. There is one more things that is to remove "submit" button field
Count Total # of Arrays $carray = count($flds);4. Remove "Submit" Array:
array_splice($flds,$carray);5. If you want to add few fields with default values -- the put them in form HIDDEN FIELDS or Try this to add MANUALLY:
$flds["new_field"] = "new_field_value";5. Write a Function to extract values from array and insert into MySQL Table
function mysql_insert_array($table, $data) { foreach ($data as $field=>$value) { $fields[] = '`' . $field . '`'; $values[] = "'" . mysql_real_escape_string($value) . "'"; } $field_list = join(',', $fields); $value_list = join(', ', $values); $query = mysql_query("INSERT INTO `" . $table . "` (" . $field_list . ") VALUES (" . $value_list . ")") or die('Error in Inserting from ARRAY : ' . mysql_error()); return $query; }6. FINAL NAIL to Good Old Frame for "Wall of Fame" :
mysql_insert_array("tablename",$flds);Note: This function can be used without hesitation anywhere, where there is no 2nd table or cross table data storage. Copy code BINDAAS-ly...
Wow!!!! That's Called Music...
It is shameful, even after 8 years into PHP. Never used it. Although the concept was there at cornor of my mind for very longtime (about 5 years) --> That $_POST is an ARRAY ITSELF.Finally, I worked my way out today for my client Yellow Cab Airport Taxi
Hope you like it...
Saturday, October 20, 2012
PHP Checkbox values to ARRAY and to UL LI list
I've been trying lately to store selected checkbox values to an Array and show them in UL and LI lists.
Here is how???
if(isset($_POST["csubmit"])){ print_r($_POST['fleet']); $arr = $_POST['fleet']; echo '
- ';
foreach($arr as $key => $value):
echo '
- ' . ucwords($value) . ' '; endforeach; echo '
PHP Assign Checkbox Values to Array and to a Standard Variable
Oh Boy! I've banged my head, kicked mouse - cursed unfriendliness of these coding syntax and finally found a way.
What about it???
--- I Have 10 Checkboxes
--- Where only selected Checkbox values need to stored into an ARRAY
Once Checkbox values stored into an Array
--- Assign those values to a Standard PHP Variable
Here is HOW for your references:
Wow! That's Simple isn't it??? Yeh, You Bet... ----------------------------------------------------- Bay Area Taxi
Labels:
array,
checkbox,
checkbox to array to variable,
php
Monday, October 15, 2012
Review Soda PDF 3D Reader - Do Not Download
My suggestion : DO NOT INSTALL -- Soda PDF 3D Reader.
I couldn't believe my self that, Soda PDF 3D Reader --> consumed 23 GB installation data space in my c:\Documents and Settings\user\Application Data\PDF Software\
All the time I was wondering What is filling up my C: Drive.
I don't know, whether this people sitting in my c: drive or using my space in "cloud".
My suggestion is NOT TO INSTALL. Beware of them.
nGinX - New Light Weight Web Server
nGinX - pronounced as Engine-X, a new kid on the block of Web Servers, also being touted as "Lightest" Weight Web Server of its kind currently available for download for free.
About nGinX
nginx [engine x] is an HTTP and reverse proxy server, as well as a mail proxy server, written by Igor Sysoev. For a long time, it has been running on many heavily loaded Russian sites including Yandex, Mail.Ru, VKontakte, and Rambler. According to Netcraft nginx served or proxied 11.48% busiest sites in August 2012. Here are some of the success stories: Netflix, Wordpress.com, FastMail.FM.
- Easy, flexible and logical configuration.
- Ability to reconfigure and upgrade NGINX instances on-the-fly, without dropping user requests.
- Application request routing via FastCGI, uwsgi or SCGI protocols; NGINX can also serve static content directly from storage for additional performance optimization.
- The only software tested that was capable of reliably handling over 10,000 request per second of live traffic to WordPress applications from a single server.
- NGINX’s memory and CPU footprints are minimal, and predictable. After switching to NGINX the CPU usage on the load balancing servers dropped three times.
- Can handle over 10,000 simultaneous IMAP, POP, Web,SSL & SMTP connections with a basic Configuration
Taxi Website Designer
Labels:
download,
light web server,
light weight,
nginx,
web server
Monday, October 8, 2012
Google MAP API : Auto Complete Example
Google Map API V3 - Auto Complete Examples
Many a times you have to provide a City Name Auto Complete tools / Input Textbox to avoid of user typing their city name mis-spelled.
Here is how:
Auto Complete : Example
Our new Fare Calculator for A Hospital Transportation - The Best Fare Calculator
Many a times you have to provide a City Name Auto Complete tools / Input Textbox to avoid of user typing their city name mis-spelled.
Here is how:
Auto Complete : Example
Our new Fare Calculator for A Hospital Transportation - The Best Fare Calculator
Saturday, October 6, 2012
Google MAP API V3 - Detect Geo Location based on IP Address
Using Google MAP API V3 -- Detect Geo Location Based on visitor's IP Address.
Example : Google MAP V3 Link --- View Source Code
-------------------------------------------
Our New Website : http://www.taxiinsanjose.com
Example : Google MAP V3 Link --- View Source Code
-------------------------------------------
Our New Website : http://www.taxiinsanjose.com
Subscribe to:
Posts (Atom)