php - Most efficient method to store MYSQL options and values in database -

-

i'm hitting dead best practice storing large amount of options , values in mysql database , assigning them properties. way (example real estate) create table called "pool" have auto increment value id , varchar store value, in case "above ground" , row "in-ground". in property table have column "has_pool" proper id value "pool" table assigned. problem hundreds of options (fireplace, water view, etc) each property, number of database tables large, fast , left joins become out of control on front side.

can point me in right direction on best practice populate new values property attributes , keep query count down minimum? feel there simple solution research far has not made apparent me. thank you!

one way create 'options' table 4 columns: id, menuid, value

create table called menus, 2 fields; id , name.

add menu names (pool, fireplace etc.) menus table, , add possible values options table, including id of menu related to.


Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more