如何使用PHP / MySQL管理SVG的填充颜色？

Question

I have a USA map in SVG format. I need each state to be filled with a color depending on a color hex value stored for the state in a MySQL file that gets populated by users via a PHP form.

To further explain, in my php program that displays the USA map as an SVG, here is my initial code where, for illustrative purposes here only, I have hard-coded the first state, Alaska, to be red:

$(document).ready(function() {
  $('#map').usmap({
  stateSpecificStyles': { 'AK' : {fill: '#f00'}
},

etc, ...repeat for each state...

and what I'd like to do is replace the "fill: '#f00" with the color value stored in the hex color field on the MySQL record for AK.

So, my question is:

How do I pass the color hex value stored in the MySQL record for a state to the SVG object for that state and thus be able to apply the fill color for it?

Answer 1

I think the problem is that you are missing some quotes around the colour. Instead of:

$('#map').usmap({ 'stateSpecificStyles': { 'AK' : {fill: <?php echo '#f00'; ?>} } });

try:

$('#map').usmap({ 'stateSpecificStyles': { 'AK' : {fill: '<?php echo '#f00'; ?>'} } });