CSS in PHP with mysql

Question

I have little problem with connection style.php to db

<?php
$servername = "localhost";
$username = "root";
$password = "";
$conn = new mysqli($servername, $username, $password);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
    header("Content-type: text/css; charset: UTF-8");
   $Color = "#000000";
   $Test = "#555000";
?>
#header {
   background-color: <?php echo $Test; ?>;
   width: 500px;
   height: 500px;
}
a{
    color: <?php echo $Color; ?>;
}

this code is working perfectly. and when i do something like this:

<?php
    header("Content-type: text/css; charset: UTF-8");
   $Color = "#000000";
   $Test = "#555000";
?>
#header {
   background-color: <?php echo $Test; ?>;
   width: 500px;
   height: 500px;
}
a{
    color: <?php echo $Color; ?>;
}

here #header{} this won't work but a{} will work. can i somehow make it work?

done any basic debugging, like hitting the url for both versions directly? It's possible that the db version is outputting something\ BEFORE the css stuff kicks in, so the generated output is foo#header, instead of just #header. — Marc B
– Marc B, Commented Oct 3, 2016 at 19:00

Dave · Accepted Answer · 2016-10-03 19:03:31Z

2

If you want generate CSS from PHP use it in .php file like this:

<html>
<body>
<?php
   $Color = "#000000";
   $Test = "#555000";
?>
<style>
#header {
   background-color: <?php echo $Test; ?>;
   width: 500px;
   height: 500px;
}
a{
    color: <?php echo $Color; ?>;
}
</style>
</body>
</html>

Do not use it in .css file. You can also generate new .css file from .php file with fopen() and fwrite() PHP functions and then just with meta tag include it into webpage.

Creating .css file from PHP

<?php
$Color = "#000000";
$Test = "#555000";
$css = '#header {
    background-color: '.$Test.';
    width: 500px;
    height: 500px;
}
a {
    color: '.$Color.';
}';

$myfile  = fopen("generated_style.css", "w") or die("Unable to open file!"); // Open file
fwrite($myfile, $css); // Write CSS
fclose($myfile); // Close file
?>

edited Oct 3, 2016 at 19:03

answered Oct 3, 2016 at 18:49

Dave

2,9202 gold badges19 silver badges28 bronze badges

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

2 Comments

Govind Rai Over a year ago

Hey dave, could you expand (provide a mini example of generating a css file) on your answer?

Dave Over a year ago

Edited answer @GovindRai

Collectives™ on Stack Overflow

CSS in PHP with mysql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related