PHP - Is There A Way That A Css Stylesheet In One Folder Be Linked To Php Scripts...

I have no idea where to start or which board would be the proper place to put this but what I"m attempting to do is integrate this idea with my custom cms I'm making now is that once inside I can take down my site in case I (administrator) wanted to perform some maintenance on my site and have it instead display a custom 404 page. Any ideas on where to start. I tried using my best friend google but he gave me nothing. Maybe a few tutorials of this might help.

Simplified for everyone's sanity and re-posted.   Got a Wordpress Conference theme, lets you enter speakers into a database and assign each one a category/role.

In the settings for the theme, there's a dropdown from which you can select one of the roles you create. Doing so will display all the speakers assigned that role in the footer of the homepage and also populate a stand-alone Speakers page with the same role.

I want to make it so that the footer on the homepage displays one role and the stand-alone speaker page displays another.

Here's the PHP for the Speakers page (identical to the footer PHP)

<?php

/**

 * Template Name: Speakers page

 * Description: Speakers page

 *

 * @package WordPress

 * @subpackage wpconference

 * @since wpconference 0.1

 */


get_header(); ?>


    <div id="primary">

        <div id="content" role="main">

        

        <h1 class='entry-title'><?php the_title(); ?></h1>


            <?php

                global $conf_sched;

                

                $speakers_category = $conf_sched->get_option('speakers-category',-1);

                if($speakers_category !=-1){

                    $speaker = get_term($speakers_category, 'participant-roles');

                    $conf_sched->shortcode_participants(array('role'=>$speaker->slug));    

                }else

                {

                    _e("To be annouced...",'wpconference');

                }

                                        

            ?>

    </div> <!-- #content -->

    </div> <!--  #primary -->

    

    <?php get_footer(); ?>

Here's the HTML for the "dropdown" portion of the settings, where you can see the role categories available. "Speaker" is the default created by the Theme, "whyattend" is the one I made.

<!-- Speakers Category -->

            <tr valign="top"><th scope="row">Speakers Category</th>

                <td>

                    <select name='conf_sched[speakers-category]' id='cat_speakers' class='postform' >

    <option value='-1'>&#38;#8212;</option>

    <option class="level-0" value="2">Speaker</option>

    <option class="level-0" value="17" selected="selected">whyattend</option>

</select>

 <br />

                    <span class="description">Please choose which category is your speakers category. If none is available please go to Participants menu and add a new role speakers</span>

                </td>

            </tr>

I want "whyattend" to show on the Footer and "Speaker" to populate the Speakers page.

Can this be done?

Hi,

I have been told it is possible to use PHP to design a left navigation bar which features a submenu for each link clicked on. So if you click "shoes" in the left navigation bar it will then display all the left navigation bar links but below shoes it might have a sub menu saying "Size 5", "Size 6", "Size 7", "Size 8", "Size 9", "Size 10".

What function in PHP allows me to include submenus? I think I need to define a 'Foreign Key' and use categories but I do not know what function to use to alter the menu depending on what the user clicks/selects??!

Any ideas?

Matt.

Hello:

I am trying to make a StyleSheet updateable from my admin panel, but I'm not sure if what I want to do is possible.

So ...

I have a TEXTAREA in my admin panel that writes to the DB just fine. it has styles like:
Code: [Select]
body
{
margin: 5px 0;
padding: 0;
background-color: #ebe9e6;
background-image: url('../images/Site-BG2.jpg');
background-position: center bottom;
background-repeat: no-repeat;
background-attachment: scroll;

font-family: arial, sans-serif;
font-size: 100%;
line-height: 1.4em;
}
...
Etc...

On the frontend, it writes into the StyleSheet just fine like:
Code: [Select]
<?php
include('myConn.php'); //contains your mysql connection and table selection

$query=mysql_query("SELECT * FROM myStyleSheet") or die("Could not get data from db: ".mysql_error());

while($result=mysql_fetch_array($query))

{

  $myPageData=$result['myPageData'];

}

?>


<?php echo $myPageData; ?>


So, what I want to see is if I can somehow pull the styles onto the page like:
Code: [Select]
<link rel="stylesheet" type="text/css" href="include/StyleSheet.css" />

Now, if I do it as listed above it and look at the code it displays the
Code: [Select]
<?php
include('myConn.php'); //contains your mysql connection and table selection
Etc...

If I do it like
Code: [Select]
<link rel="stylesheet" type="text/css" href="include/StyleSheet.php" />

It displays the styles fine, but the browser doesn't read it as a StyleSheet and therefore the page doesn't get formatted.

So, is there any way to make this work? Anyone have any ideas about this?

The idea is so I can manage the Styles via an admin panel remotely without having to login with web editing software.

Thanks.

Hi,

Can someone why my stylesheet is not working?
Code: [Select]
<?php

header('Content-type: text/html; charset=utf-8');

include 'config.php';
include 'lib.php';

$db = dbConnect();

if (isset($_GET['ip']))
{
$ip = $_GET['ip'];
$longitude = $_GET['long'];
$latitude = $_GET['lat'];

$searches = getSearchesByIP($ip);
$watchUser = true;

}
else
{
$searches = getSearches();
$watchUser = false;
}

dbClose($db);


?>

<html>
<head>
<title>cms</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="inc/css/style.css" />
</head>
<body>

<h1>WTF</h1>

<div id="container">

<?
    if ($watchUser == true)
{?>
<a href=searches.php> See all</a>

<br/>

<table>
<tr>
<th>ip</th>
<td><?=$ip;?></td>
</tr>
<tr>
<th>longitude</th>
<td><?=$longitude;?></td>
</tr>
<tr>
<th>latitude</th>
<td><?=$latitude;?></td>
</tr>

</table>
<?
}
    ?>

<br/>
   
    <table>
    <tr>
        <th>id</th>
        <? if ($watchUser == false) echo "<th>ip</th>"; ?>
        <th>question</th>
        <? if ($watchUser == false) echo "<th>longitude</th>"; ?>
        <? if ($watchUser == false) echo "<th>latitude</th>"; ?>
        </tr>
        <?
foreach($searches as $search) {
?>
            <tr>
              <td><?=$search['id'];?></td>
             
              <? if ($watchUser == false)
              {
              echo "<td> <a href='searches.php?ip=" . $search['userIP'] . "&long=" . $search['longitude'] . "&lat=" . $search['latitude'] . "'>" . $search['userIP'] . "</ a> </td>";
            }
              ?>
             
            <td><?=$search['question'];?></td>
            <? if ($watchUser == false) echo "<td>" . $search['longitude'] . "</td>"; ?>
            <? if ($watchUser == false) echo "<td>" . $search['latitude'] . "</td>"; ?>
          <td><a href="answers.php?id=<?=$search['id'];?>">see answers</a></td>
                <td><a href="inc/php/utils/search-delete.php?id=<?=$search['id'];?>">delete</a></td>
            </tr>
            <?
}
?>

    </table>

</div>
    <a href="search.php">Add new</a>

</body>
</html>
my css file:

a:link {color:#FF0000;}    /* unvisited link */
a:visited {color:#00FF00;} /* visited link */
a:hover {color:#FF00FF;}   /* mouse over link */
a:active {color:#0000FF;}  /* selected link */

/*
table
{
font-family: "Arial";
font-size: 10px;
color:red;
}
*/


table, th, td
{
border:1px solid black;
}

h1 {color:#00ff00;}

Hi, I wanted to know how to link a stylesheet using php specifically for the purpose of loading a different stylesheet when the home page displays. I heard of echoing out the stylesheet but I do not know how. Any help would be appreciated.

HI,
I have a ms-access file which has linked table. The linked table is connected to a ODBC source (e.g MS-SQL or 3rd Party ODBC Driver).
WebPage(php) Apache, connecting to a ODBC DSN of MS-Access, MS-Access is having linked tables. Linked tables as from another ODBC source.
On the PHP Page, When I am trying to connect the ms-access odbc dsn , I am able to connect.
But when I query any of the linked tables, PHP is not able to query and is failing.

Does php has capabilities to read/write to linked tables in ms-access file.
Or it is issue with MS-Access
Or is it I am missing something.

Microsoft says, its an issue of PHP
https://social.msdn....forum=accessdev

Requesting you to please share your feedback

Regards
Rajendra Dewani

Okay the reason I'm doing it this way is because I work locally and then transfer them to the production site.
For some reason, this isn't working even though when I view the page source, it has the right URL, but when it's clicked it goes to a blank page, but when I copy and paste, it goes to the right page.

Anywho, this is what I'm trying:

Code: [Select]
<?php $homeURL = 'localhost:90/Elvonica'; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
        "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<title>Elvonica</title>
<meta http-equiv="content-type" content="text/html;charset=utf-8" />
<link rel="stylesheet" type="text/css" href="<?php echo $homeURL; ?>/template/css/skySpirit.css" />

I didn't plug in the rest to ignore it since it's not part of the problem. It's printing: localhost:90/Elvonica/template/css/skySpirit.css, but when it's clicked, goes to blank page. When it is copied and pasted, it goes to the right page.
I have a feeling you can't include PHP inside a link rel or any sort of that header information.
If anyone could please help me how to do this, I would appreciate it.

FYI:
I did have just template/css/skySpirit.css and it worked until I go into a another directory like forums/index.php. Then it tries to go localhost:90/Elvonica/forums/template/css/skySpirit.css and it's not in there obviously.

Thank you for anything that you can offer!
I know how to do the includes with the dirname(__FILE__).

due to mod_rewrite flaws, i have to give everything an absolute path. somehow though, the stylesheet's absolute path wont work. heres the code:

<link href="C:/xampp/htdocs/lso/style.css" rel="stylesheet" type="text/css" />

the stylesheet is in the lso folder, yet somehow this wont work and no styles are loaded!

This topic has been moved to mod_rewrite.

http://www.phpfreaks.com/forums/index.php?topic=347820.0

why is it that when i try to submit it tells me add a picture but i did added

Code: [Select]
<?php 
//decarling some variables
$msg = "";

//begin if
if($_POST['submitbtn']){

$author = mysql_real_escape_string($_POST['author']);
$date = mysql_real_escape_string($_POST['date']);
$picture = $_FILES['picture']['name'];
$ext = strtolower(substr($name,strpos($name,'.')+1));
$size = $_FILES['picture']['size'];
$maxsize = 200000;
$type = $_FILES['picture']['type'];
$tmp = $_FILES['picture']['tmp_name'];
$review = mysql_real_escape_string($_POST['review']);

$move = "uploads/";

if(isset($author) && !empty($author)){
if(isset($date) && !empty($date)){
if(isset($picture) && !empty($picture)){
if($size <= $maxsize){
if($ext == 'jpg' || $ext == 'jpeg' || $ext == 'png'){
if(move_uploaded_file($tmp,$move.$name)){
if(isset($review) && !empty($review)){
$query = mysql_query(" INSERT INTO reviews ('',author,date,picture,review) VALUES ('',$author,$date,$picture,$review)");
}else
$msg = "Please write a review";
}else
$msg = "Error has happen try again later";
}else
$msg = "Image must be a jpg, jpeg, or png";
}else
$msg = "You must select a smaller image size";
}else
$msg = "Select a picture";
}else
$msg = "Please enter a date";
}else
$msg = "Please fill in the Authors name";
}
//ending the if here
?>

I know this involves MySQL, but it's mostly PHP, so I figured it should go here, forgive me if I posted in the wrong section, though.

Anyway! Let's get down to it. I'd like to combine these two scripts (below). I want the questionnaire script to be a signup requirement in the signup script, and I want it to log the questionnaire into my MySQL database as usual, then prompt the user with a successful sign up.

I'm still really new to PHP and I'm just testing to see if this'll work. How would I go about doing this? Thanks a LOT guys.

Questionnai

<?php
  // Start the session
  require_once('startsession.php');

  // Insert the page header
  $page_title = 'Questionnaire';
  require_once('header.php');

  require_once('appvars.php');
  require_once('connectvars.php');

  // Make sure the user is logged in before going any further.
  if (!isset($_SESSION['user_id'])) 
  {
    echo '<p class="login">Please <a href="login.php">log in</a> to access this page.</p>';
    exit();
  }

  // Show the navigation menu
  require_once('navmenu.php');

  // Connect to the database
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

  // If this user has never answered the questionnaire, insert empty responses into the database
  $query = "SELECT * FROM mismatch_response WHERE user_id = '" . $_SESSION['user_id'] . "'";
  $data = mysqli_query($dbc, $query);
  if (mysqli_num_rows($data) == 0) 
  {
    // First grab the list of topic IDs from the topic table
    $query = "SELECT topic_id FROM mismatch_topic ORDER BY category_id, topic_id";
    $data = mysqli_query($dbc, $query);
    $topicIDs = array();
    while ($row = mysqli_fetch_array($data)) 
{
      array_push($topicIDs, $row['topic_id']);
    }

    // Insert empty response rows into the response table, one per topic
    foreach ($topicIDs as $topic_id) 
{
      $query = "INSERT INTO mismatch_response (user_id, topic_id) VALUES ('" . $_SESSION['user_id']. "', '$topic_id')";
      mysqli_query($dbc, $query);
    }
  }

  // If the questionnaire form has been submitted, write the form responses to the database
  if (isset($_POST['submit'])) 
  {
    // Write the questionnaire response rows to the response table
    foreach ($_POST as $response_id => $response) 
{
      $query = "UPDATE mismatch_response SET response = '$response' WHERE response_id = '$response_id'";
      mysqli_query($dbc, $query);
    }
    echo '<p>Your responses have been saved.</p>';
  }

  // Grab the response data from the database to generate the form
  $query = "SELECT mr.response_id, mr.topic_id, mr.response, " .
    "mt.name AS topic_name, mc.name AS category_name " .
"FROM mismatch_response AS mr " .
"INNER JOIN mismatch_topic AS mt USING (topic_id) " .
"INNER JOIN mismatch_category AS mc USING (category_id) " .
"WHERE mr.user_id = '". $_SESSION['user_id'] . "'";
$data = mysqli_query ($dbc, $query);
$responses = array();
while ($row = mysqli_fetch_array($data)) 
{
  array_push($responses, $row);
}
  
  mysqli_close($dbc);

  // Generate the questionnaire form by looping through the response array
  echo '<form method="post" action="' . $_SERVER['PHP_SELF'] . '">';
  echo '<p>How do you feel about each topic?</p>';
  $category = $responses[0]['category_name'];
  echo '<fieldset><legend>' . $responses[0]['category_name'] . '</legend>';
  foreach ($responses as $response) 
  {
    // Only start a new fieldset if the category has changed
    if ($category != $response['category_name']) 
{
      $category = $response['category_name'];
      echo '</fieldset><fieldset><legend>' . $response['category_name'] . '</legend>';
    }

    // Display the topic form field
    echo '<label ' . ($response['response'] == NULL ? 'class="error"' : '') . ' for="' . $response['response_id'] . '">' . $response['topic_name'] . ':</label>';
    echo '<input type="radio" id="' . $response['response_id'] . '" name="' . $response['response_id'] . '" value="1" ' . ($response['response'] == 1 ? 'checked="checked"' : '') . ' />Love ';
    echo '<input type="radio" id="' . $response['response_id'] . '" name="' . $response['response_id'] . '" value="2" ' . ($response['response'] == 2 ? 'checked="checked"' : '') . ' />Hate<br />';
  }
  echo '</fieldset>';
  echo '<input type="submit" value="Save Questionnaire" name="submit" />';
  echo '</form>';

  // Insert the page footer
  require_once('footer.php');
?>



Signup:
<?php
  // Insert the page header
  $page_title = 'Sign Up';
  require_once('header.php');

  require_once('appvars.php');
  require_once('connectvars.php');

  // Connect to the database
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

  if (isset($_POST['submit'])) {
    // Grab the profile data from the POST
    $username = mysqli_real_escape_string($dbc, trim($_POST['username']));
    $password1 = mysqli_real_escape_string($dbc, trim($_POST['password1']));
    $password2 = mysqli_real_escape_string($dbc, trim($_POST['password2']));

    if (!empty($username) && !empty($password1) && !empty($password2) && ($password1 == $password2)) {
      // Make sure someone isn't already registered using this username
      $query = "SELECT * FROM mismatch_user WHERE username = '$username'";
      $data = mysqli_query($dbc, $query);
      if (mysqli_num_rows($data) == 0) {
        // The username is unique, so insert the data into the database
        $query = "INSERT INTO mismatch_user (username, password, join_date) VALUES ('$username', SHA('$password1'), NOW())";
        mysqli_query($dbc, $query);

        // Confirm success with the user
        echo '<p>Your new account has been successfully created. You\'re now ready to <a href="login.php">log in</a>.</p>';

        mysqli_close($dbc);
        exit();
      }
      else {
        // An account already exists for this username, so display an error message
        echo '<p class="error">An account already exists for this username. Please use a different address.</p>';
        $username = "";
      }
    }
    else {
      echo '<p class="error">You must enter all of the sign-up data, including the desired password twice.</p>';
    }
  }

  mysqli_close($dbc);
?>

  <p>Please enter your username and desired password to sign up to Mismatch.</p>
  <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
    <fieldset>
      <legend>Registration Info</legend>
      <label for="username">Username:</label>
      <input type="text" id="username" name="username" value="<?php if (!empty($username)) echo $username; ?>" /><br />
      <label for="password1">Password:</label>
      <input type="password" id="password1" name="password1" /><br />
      <label for="password2">Password (retype):</label>
      <input type="password" id="password2" name="password2" /><br />
    </fieldset>
    <input type="submit" value="Sign Up" name="submit" />
  </form>

<?php
  // Insert the page footer
  require_once('footer.php');
?>


And here are the pastebins in case you prefer those:

http://pastebin.com/pTXGSMT9 - Questionnaire

http://pastebin.com/28jZhYyY - Signup

Thanks!

Hi, I'm trying to make my game navigation that involves switching div images to navigate in the game world. It is browser based. The first script, the user clicks on the world map to go to "Teardrop Ocean". The second script lets the user press the "further" button or "back" button to navigate within "Teardrop Ocean". My problem is I'm trying to combine the image map navigation with the "further" and "back" navigation. The problem is, I don't know if it's possible since the first world map script involves javascript. Here is the code, any help greatly appreciated Thanks. Derek



This is the code that uses javascript to process a hidden form to use php to output. This is our "world map" link, that should load the "teardrop ocean" image inside the div, which it doesn't do yet here.
Code: [Select]
<?php

$zone='';

if(isset($_POST['checker']) && $_POST['checker'] == 'checked')
{
   echo "it worked !";

$zone="<img src='teardrop.jpg'/>";   
}

if(isset($_POST['back']))
{
$zone='';
}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<form action="aradia.php" method="post" name="mapform" id="mapform">
<input type="hidden" name="checker" value="checked" />
  <div align="left"> <img src="aradia.jpg" width="256" height="328" border="0" usemap="#Map" /></div>
</form>

<map name="Map" id="Map">
   <area shape="rect" coords="5,176,81,249" href="javascript: void(0);" onclick="javascript: document.getElementById('mapform').submit();" />
</map>
<div align="center"><?php echo $zone;?></div>

<form action="aradia.php" method="post" > <input type = "submit" name="back" value="back" /></form>
</body>
</html>

and here is the "Teardrop ocean" navigation, which uses php to navigate forward and backwards in the zone, but can't go back to the world map, or there is no way to yet.

Code: [Select]
/////////////////////////////GAME NAVIGATION AND MONSTER SEARCH CODE NOT FINISHED//////////////////////////////////
 
if(( !isset($_SESSION['current_background']) && !isset($_SESSION['currentMonster'])) OR (! $_POST))
{
    $_SESSION['current_monster'] = 0;
    $_SESSION['current_background'] = 0;
}


if (!isset($_SESSION['background']) && !isset($_SESSION['monster'])) {
  $_SESSION['background'] = array
  (
    "<img src='sundragon_environments/ocean/ocean1_FRAME.jpg'/>",
    "<img src='sundragon_environments/ocean/ocean1_FRAME2.jpg'/>",
   "<img src='sundragon_environments/ocean/ocean1_FRAME3.jpg'/>",
   "<img src='sundragon_environments/ocean/ocean1_FRAME4.jpg'/>",
   "<img src='sundragon_environments/ocean/ocean1_FRAME5.jpg'/>"
  );
 
   $_SESSION['monster'] = array
  (
    "<img src='sundragon_monsters_source/water/goldfish/goldfish.png'/>",
    "<img src='sundragon_monsters_source/water/eel/eel_transp_FRAME.png '/>",
   "<img src='sundragon_monsters_source/water/shark/shark_transp_FRAME.png'/>",
   "<img src='sundragon_monsters_source/water/octalisk/octalisk_transp_FRAME.png'/>",
   "<img src='sundragon_monsters_source/water/teardrop_ocean_protector/teardrop_ocean_protector.png'/>"
  );
 
 
}
if(!isset($_SESSION['current_background']) && !isset($_SESSION['current_monster']))
{

 
$_SESSION['current_monster']=0;

$_SESSION['current_background'] = 0;
}

if(isset($_POST['further']))
{


$_SESSION['current_monster'] = isset($_SESSION['monster'][$_SESSION['current_monster'] + 1]) ? ($_SESSION['current_monster'] + 1) : 0;
$_SESSION['current_background'] = isset($_SESSION['background'][$_SESSION['current_background'] + 1]) ? ($_SESSION['current_background'] + 1) : 0;
}
elseif(isset($_POST['back']))
{
$_SESSION['current_monster'] = isset($_SESSION['monster'][$_SESSION['current_monster'] - 1]) ? ($_SESSION['current_monster'] - 1) : count($_SESSION['monster'])-1;
$_SESSION['current_background'] = isset($_SESSION['background'][$_SESSION['current_background'] - 1]) ? ($_SESSION['current_background'] - 1) : count($_SESSION['background'])-1;
}

$currentBackground=$_SESSION['background'][$_SESSION['current_background']];
$currentMonster=$_SESSION['monster'][$_SESSION['current_monster']];
and I echo out $currentBackground and $currentMonster in the main game div.