how to change CSS styles dynamically using php/Mysql..i want to create themes that are unique to each user?

Question

i want to change the color scheme of my webpage...so i have given the color picker and other tools in my website and i store those values of color in a MySql database..

but i cannot figure out how can i apply those styles values from a mysql database to a css or an html file..

for example:

the color value stored by user-1 in the database is :#ffffff and the other value by user-2 is:#000000

how can i get these values to be applied in css every time the user logs-in.. i.e, when user-1 logs-in i want the body background to be #ffffff and for iser-2 i want it to be #000000

Could you edit your question to tell us a little more about the site and how/why your users will change their styles? — Matt Kantor
– Matt Kantor, Commented May 1, 2013 at 4:42
Should user be able to define any color or is it just a few colors to choose from? — bestprogrammerintheworld
– bestprogrammerintheworld, Commented May 1, 2013 at 4:54

Eddie Jaoude · Accepted Answer · 2013-05-01 04:49:01Z

2

There are various ways this can be done. 1. Convert your CSS to PHP, i.e. CSS is generated, but everything can be dynamic - probably overkill for a few colours 2. Overwrite the styles in the stylesheet

The simplest way, probably not the best though is number 2, over write the style after the stylesheet with the new colour.

i.e (sudo code)

<html><head>
....
<style ... src="..." />
<style>
// from db
#custom { background: #<?php echo $colour; ?> }
</style>

etc

answered May 1, 2013 at 4:49

Eddie Jaoude

1,71815 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

halfer · Accepted Answer · 2015-08-18 08:00:21Z

1

It is better you use your JavaScript to change the style between PHP tags.

For example:

if($response){

    echo "<script>
        $('#matter_table').css('display', 'block');
    </script>";
}
else{

    echo "<script>
        $('#matter_table').css('display', 'none');
    </script>";
}

edited Aug 18, 2015 at 8:00

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Aug 18, 2015 at 7:55

Bakhtawar Gill

4395 silver badges16 bronze badges

Comments

Amish Shabani · Accepted Answer · 2015-01-22 18:57:24Z

0

I use this trick :

I create a dynamicss.php file and in it use :

$color = '#6b82a2';
$css = <<<HERE

body{
    font-family:Arial, Helvetica, sans-serif;
    background-color : $color ;
    background-image: url("../img/texture.png");
}

HERE;

$bytes = file_put_contents('css/mainCss.css',$css);

you can load your variables and then use in hereDoc.

answered Jan 22, 2015 at 18:57

Amish Shabani

7592 gold badges16 silver badges38 bronze badges

2 Comments

Mike Over a year ago

In general I like the idea behind this approach. But if this appends the css every time a visitor hits a page on your site your css file would get unruly in a hurry. I'd almost rather use your technique but set the content-type to css and call dynamiccss.php as a second stylesheet, loaded after the first.

Amish Shabani Over a year ago

Thanks for your comment, Yes! it is better

halfer · Accepted Answer · 2015-08-18 08:01:39Z

0

You can achieve this by following steps:

Make your website template flexible if user change one style it should reflect on all theme.
When user logged in you can fetch that user theme color from db and you can store it on session or any other possible way.
```
e.g : $themecolor = '#000000';
```

Pass that theme color to body background inline style

e.g : style = "background-color : <?php echo $themecolor; ?>"

edited Aug 18, 2015 at 8:01

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered May 1, 2013 at 4:51

Roopendra

7,75716 gold badges72 silver badges95 bronze badges

Collectives™ on Stack Overflow

how to change CSS styles dynamically using php/Mysql..i want to create themes that are unique to each user?

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related