Need help with mysql and php please :)

[iJoe]

Hey,

I have started making nexdana so that it runs from a mysql database. All is going well except pages with php in arn't working.

I don't really know how this works, I only know how to add / edit pages within the database as Calon set it up for me :)

An example of a page not working is this... http://www.nexdana.com/v3/index_new.php?pageId=7

As you can see the php bits at the top and bottom arn't working

If anyone can help it would be much appreciated :)

Thanks

Joe

[Excellent1]

Your code isn't being properly closed off somewhere. Post it?

[Fehm]

Nice bubble shift game, glad youve got it sorted =]

[Decode]

You need to post the code or no one will know what's wrong with it :P

[Dentafrice]

Your code isn't being properly closed off somewhere. Post it?

That's not what is wrong.

Are you echoing it all out, or doing sort of a "template system"?

If not.. it looks like it doesn't have PHP installed on your server.. as it's being executed as HTML and not PHP.

[Calon]

Since when could you execute PHP from MySQL Rows? :S

[iJoe]

Since when could you execute PHP from MySQL Rows? :S

I don't know..... if I had known you can't, i would have stuck with iframes................................ :(

[Dentafrice]

You can exec it, using eval(). Just wouldn't recommend it.

[iJoe]

I'll have to stick with iframes then :P

[Decode]

I'll have to stick with iframes then :P

Iframes are tacky, this code should act like an Iframe.

INDEX.PHP


The top of your layout code will go here
<?php
$p = addslashes( $_GET['page'] );
if( isset ( $p ) ) {
$p = "/content/" . $p . ".php";
if( file_exists ( $p ) {
include( $p );
}
else {
include( "404.php" );
}
}
else {
$p = "/content/indexpage.html";
include( $p );
}
?>
The bottom of your layout code will go here


To use it you just go to index.php?p=pagename and it would include yoursite.com/content/pagename.php

[iJoe]

Thanks :) I'll try that out tomorrow +rep

edit: will that code just work with php pages?

[Decode]

Yeah it will, I will modify the code a bit so it can do html as well.



<?php
$p = addslashes( $_GET['page'] );
if( isset ( $p ) ) {
if ( isset ( $_GET['html'] ) ) {
$p = "/content/" . $p . ".html";
}
else {
$p = "/content/" . $p . ".php";
}
if( file_exists ( $p ) {
include( $p );
}
else {
include( "404.php" ); //Page that is displayed if the file doesnt exist
}
}
else {
$p = "/content/indexpage.php"; //Put the URL to your old homepage that was in the iframe here
include( $p );
}
?>


If a page is .php you do yoursite.com/index.php?page=games and it will include yoursite.com/content/games.php. If its a HTML page you want to include you do yoursite.com/index.php?page=games&html= and it would include yoursite.com/content/games.html.

So all links around your site would need to be done like <a href="http://yoursite.com/index.php?page=a"></a>.

[iJoe]

Getting an error for some reason :S


Parse error: syntax error, unexpected '{' in /home/nexdana/public_html/v3/erm.php on line 10

Using your code above

[Decode]

<?php
$p = addslashes( $_GET['page'] );
if( isset ( $p ) ) {
if ( isset ( $_GET['html'] ) ) {
$p = "/content/" . $p . ".html";
}
else {
$p = "/content/" . $p . ".php";
}
if( file_exists ( $p ) ) {
include( $p );
}
else {
include( "404.php" ); //Page that is displayed if the file doesnt exist
}
}
else {
$p = "/content/indexpage.php"; //Put the URL to your old homepage that was in the iframe here
include( $p );
}
?>

[iJoe]

Hmm, now it is saying no pages exist :( http://www.nexdana.com/v3/erm.php


<?php
$p = addslashes( $_GET['page'] );
if( isset ( $p ) ) {
if ( isset ( $_GET['html'] ) ) {
$p = "http://www.nexdana.com/v3/" . $p . ".html";
}
else {
$p = "http://www.nexdana.com/v3/" . $p . ".php";
}
if( file_exists ( $p ) ) {
include( $p );
}
else {
include( "404.php" ); //Page that is displayed if the file doesnt exist
}
}
else {
$p = "http://www.nexdana.com/v3/home.html"; //Put the URL to your old homepage that was in the iframe here
include( $p );
}
?>

I can't see whats wrong :S

[Decode]

<?php
$p = addslashes( $_GET['page'] );
if( $p != "" ) {
if ( isset ( $_GET['html'] ) ) {
$p = "http://www.nexdana.com/v3/" . $p . ".html";
}
else {
$p = "http://www.nexdana.com/v3/" . $p . ".php";
}
if( file_exists ( $p ) ) {
include( $p );
}
else {
include( "404.php" ); //Page that is displayed if the file doesnt exist
}
}
else {
$p = "http://www.nexdana.com/v3/home.html"; //Put the URL to your old homepage that was in the iframe here
include( $p );
}
?>


Sorry :P I was tired yesterday when I wrote this.

[iJoe]

I think it might be me now, still not working :S

Am I right in thinking that http://www.nexdana.com/v3/contact.php should show if I use the url http://www.nexdana.com/v3/erm.php?page=contact ?

It's still saying the pages don't exist

Thanks for your patience by the way :)