[SOLVED] Quick Questions PHP

[Ell20]

Hi,

 

Can you use PHP and/or MySQL in CSS?

 

If so how is this done?

 

Thanks

[monkeytooth]

.....

 

Possible: Yes

How-to: Same way you would making any other site..

[Grant Holmes]

More details?

 

CSS can control how PHP appears on a page. CSS will not control MySQL. you could use values from a MySQL database in CSS.

 

What are you trying to do?

[Ell20]

I have tried to query the database in the normal way and for some reason its not working:

 

<?php 
header("Content-type: text/css");
require_once ('mysql_connect.php');
include_once ('includes/functions.php');
$id = $_SESSION['club_id'];

$query = "SELECT * FROM club WHERE club_id = '$id'";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

$bgcolour = $row['bgcolour'];
$textcolour = $row['textcolour'];
?>

body {
color: <?=$textcolour?>;
background-color: <?=$bgcolour?>;
}

 

Can you see anything wrong with this?

 

Thanks

[papaface]

Should be:

<?php 
header("Content-type: text/css");
require_once ('mysql_connect.php');
include_once ('includes/functions.php');
$id = $_SESSION['club_id'];

$query = "SELECT * FROM club WHERE club_id = '$id'";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

$bgcolour = $row['bgcolour'];
$textcolour = $row['textcolour'];
?>
body {
color: <?php echo $textcolour; ?>;
background-color: <?php echo $bgcolour; ?>;
}

[Ell20]

Sorry if im being blind but I cant see anything differences between mine and your code?

 

Thanks

[trq]

Your code uses <?= while papaface's used the more common <?php echo

[Ell20]

It still dosent like it for some reason.

 

In the database I have stored: '#999999' as bgcolor and '#ffffff' as text color.

 

Thanks

[trq]

Well, lets firstly make sure your query works before trying to use its result. This is always good practice.

 

<?php

session_start();

header("Content-type: text/css");
require_once ('mysql_connect.php');
include_once ('includes/functions.php');

$id = $_SESSION['club_id'];

$query = "SELECT * FROM club WHERE club_id = '$id' LIMIT 1";
if ($result = mysql_query($query)) {
  if (mysql_num_rows($result)) {
    $row = mysql_fetch_assoc($result);
    $bgcolour = $row['bgcolour'];
    $textcolour = $row['textcolour'];
  } else {
    echo "No record found";
  }
} else {
  echo Query failed " . mysql_error();
}
?>
body {
  color: <?php echo $textcolour; ?>;
  background-color: <?php echo $bgcolour; ?>;
}

 

I also noticed you where missing a call to session_start().

[Ell20]

That dosent work either, no message displayed either.

 

Is the possible reason for this that on the php page header.html is called, header.html then calls the CSS?

 

The reason there is no session_start() is because the header.html includes this, which is included on every page.

 

Thanks

[trq]

The reason there is no session_start() is because the header.html includes this, which is included on every page.

 

Is your server configured to handle html as php? By the way... what file extension is on the code you have posted? *.php ?

[Ell20]

The reason there is no session_start() is because the header.html includes this, which is included on every page.

 

Is your server configured to handle html as php? By the way... what file extension is on the code you have posted? *.php ?

 

I have no idea, before I attempted to make the changes to the CSS it was working fine.

 

The code I have posted is newcss.php.

 

Thanks

[trq]

php won't work in a html file by default. But yeah, if your css doc has the php extension, I see no reason why its not working. Add this to the top.

 

<?php error_reporting(E_ALL) ; ini_set('display_errors','1'); ?>

[Ell20]

Still nothing, no errors, the page is white with no CSS at all.

 

This is annoying!!

[Ken2k7]

thorpe missed a quote.

 

<?php

session_start();

header("Content-type: text/css");
require_once ('mysql_connect.php');
include_once ('includes/functions.php');

$id = $_SESSION['club_id'];

$query = "SELECT * FROM club WHERE club_id = '$id' LIMIT 1";
if ($result = mysql_query($query)) {
  if (mysql_num_rows($result)) {
    $row = mysql_fetch_assoc($result);
    $bgcolour = $row['bgcolour'];
    $textcolour = $row['textcolour'];
  } else {
    echo "No record found";
  }
} else {
  echo "Query failed " . mysql_error();
}
?>
body {
  color: <?php echo $textcolour; ?>;
  background-color: <?php echo $bgcolour; ?>;
}

[Ell20]

Thanks Ken, but still no luck.

 

To answer a previous question about the php being used in html.

 

I think it must work because when I set say $bgcolour = '#fffff';

 

Then use echo in the CSS it works, its just when I attempt to get a value from the database that its just going white with no CSS at all.

 

Thanks

[Ken2k7]

Well you just have to have the file extension .php.

 

You can use HTML in a .php file like so:

<?php
// woot! some php codes 
?>
<b> hi </b>

See? All I did was close out the PHP and just use HTML or CSS. As long as the file extension is php, it should be fine.

 

[Ell20]

Yeah I understand that I was just refering to a question which thorpe asked.

 

I have done this on my pages but it still dosent seem to like it!

 

Thanks

[Ken2k7]

If by not work, do you mean the variables are empty? Because I think that's the case. Can you page source the page and find that part of the CSS and copy and paste it here? In firefox, you just press Ctrl+U, in IE, you go to Edit and Page Source. (I think, not sure since I don't use IE)

[Ell20]

If by not work, do you mean the variables are empty? Because I think that's the case. Can you page source the page and find that part of the CSS and copy and paste it here? In firefox, you just press Ctrl+U, in IE, you go to Edit and Page Source. (I think, not sure since I don't use IE)

 

I dont see how the variables can be empty as I have manually placed them in the database.

 

CSS dosent show up in page source, all I can see is this:

<link media="screen" href="/includes/newcss.php" rel="stylesheet" type="text/css" />

 

Thanks

[Ken2k7]

Then look inside that link

[Ell20]

I went to: /includes/newcss.php

 

And I found this:

 

<br />

<b>Warning</b>:  require_once(mysql_connect.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in <b>/home/mysport/public_html/includes/newcss.php</b> on line <b>3</b><br />

<br />

<b>Fatal error</b>:  require_once() [<a href='function.require'>function.require</a>]: Failed opening required 'mysql_connect.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in <b>/home/mysport/public_html/includes/newcss.php</b> on line <b>3</b><br />

[Ken2k7]

Uh oh, that's not good.

 

What's your includes/newcss.php file?

[Ell20]

Its this file I have been working on, which I am hoping to take values from the database and put them into the CSS.

 

Thanks

 

 

[Ken2k7]

Is mysql_connect.php a file on the directory?