per1os Posted April 13, 2007 Share Posted April 13, 2007 <?php session_start(); include('db_con.php'); $tack_id = $_SESSION['track_id']; $track_name = $_SESSION['track_name']; ?> Would be more appropriate as you set the session values on the login page, this is where you call the session values. Than print $track_id to print the id. If this is confusing let me know. Link to comment https://forums.phpfreaks.com/topic/46639-solved-why-isnt-php-seeing-the-database/page/2/#findComment-228874 Share on other sites More sharing options...
matthewst Posted April 16, 2007 Author Share Posted April 16, 2007 I'm Stumped(not that that is hard to do) Once logged in my users are presented with a "control panel" where they can select a predefined web templet. New users of course won't have style yet. Any ideas? Notice: Undefined variable: set_style_id in /Library/Tenon/WebServer/WebSites/admin/rest_site_creation/home.php on line 50 <?php session_start(); error_reporting(E_ALL); function copyr($source, $dest) { // Simple copy for a file if (is_file($source)) { return copy($source, $dest); } // Make destination directory if (!is_dir($dest)) { mkdir($dest); } // Loop through the folder $dir = dir($source); while (false !== $entry = $dir->read()) { // Skip pointers if ($entry == '.' || $entry == '..') { continue; } // Deep copy directories if ($dest !== "$source/$entry") { copyr("$source/$entry", "$dest/$entry"); } } // Clean up $dir->close(); return true; } //INCLUDES include('id.php'); include('db_con.php'); //CHECK LOGIN VS ID if ($track_id!=$_SESSION['track_id']){ echo '<script type="text/javascript"> location="index.php" </script>'; } //******HERE IS THE PROBLEM*************************************** if ($set_style_id!=""){ //**************************************************************** //GET SITE PATH $get_root_folder=mysql_query("SELECT root_folder FROM rest_filesystem WHERE rest_id='$id'",$db_link); $row=mysql_fetch_array($get_root_folder); $root_folder=$row['root_folder']; $root_folder_css=($root_folder."/css"); $root_folder_img=($root_folder."/images"); //GET THEME PATHS $get_theme_path=mysql_query("SELECT css_doc FROM styles WHERE style_id='$set_style_id'",$db_link); $row=mysql_fetch_array($get_theme_path); $theme_path=$row['css_doc']; $theme_path_css=($theme_path."CSS"); $theme_path_img=($theme_path."IMAGES"); $index_file=($theme_path."live_index.php"); copyr($theme_path_css, $root_folder_css); copyr($theme_path_img, $root_folder_img); //CHECK MYSQL FOR ALL PAGES AND NAMES - COPY: //copy($index_file, $root_folder."/index.php"); //TO ALL FILE NAMES CONTAINED //AND PUT IN PAGE ID WHERE IT'S SUPPOSED TO GO $getpages = mysql_query("SELECT cust_id, pg_id, pg_name, pg_addr FROM rest_pages where cust_id=$id", $db_link); while($row = mysql_fetch_array($getpages)) { $row['pg_id'] != ""; copy($index_file, $root_folder."/".$row['pg_addr']); $page_id=$row['pg_id']; $fh = fopen($root_folder."/".$row['pg_addr'], 'r+') or die("can't open file"); $stringData = '<?php $page_id='. $page_id.';'; fwrite($fh, $stringData); fclose($fh); } } ?> <html> <head> <meta http-equiv="content-type" content="text/html;charset=iso-8859-1"> <meta name="generator" content="Adobe GoLive 5"> <title>Admin Page :: Home</title> </head> <body bgcolor="#ffffff"> <div align="center"> <font face="Verdana, Arial, Helvetica, sans-serif">Welcome to your administration panel ID: <? echo "$track_id"; ?><br> <br> <br> <table border="0" cellpadding="0" cellspacing="2" width="180"> <tr height="19"> <td colspan="2" height="19"> <div align="center"> <font size="3"><b>Actions:</b></font></div> </td> </tr> <tr> <td>Select Theme:</td> <td><a href="themes.php">Link</a></td> </tr> <tr> <td>Upload Images:</td> <td><a href="images.php">Link</a></td> </tr> <tr> <td>Manage Pages:</td> <td><a href="pages.php">Link</a></td> </tr> <tr> <td>Change Content:</td> <td><a href="content.php">Link</a></td> </tr> <tr> <td>View Page:</td> <td><a href="../">Link</a></td> </tr> <tr> <td colspan="2"> <div align="center"> </div> </td> </tr> </table> </font></div> </body> </html> I've attached the styles table of my database [attachment deleted by admin] Link to comment https://forums.phpfreaks.com/topic/46639-solved-why-isnt-php-seeing-the-database/page/2/#findComment-230387 Share on other sites More sharing options...
matthewst Posted April 16, 2007 Author Share Posted April 16, 2007 I just noticed that after I login with a new user the links on the "control panel" (home.php) all take me to index.php which doesn't exist. When I use an existing user the links take me to the correct pages. I'm completely lost. Link to comment https://forums.phpfreaks.com/topic/46639-solved-why-isnt-php-seeing-the-database/page/2/#findComment-230421 Share on other sites More sharing options...
matthewst Posted April 16, 2007 Author Share Posted April 16, 2007 I'm also having trouble with my image upload and viewing page. images.php: <?php session_start(); //INCLUDES include('id.php'); include('db_con.php'); //CHECK LOGIN VS ID if ($id!=$_SESSION['track_id']){ echo '<script type="text/javascript"> location="index.php" </script>'; } //GET SITE PATH $get_root_folder=mysql_query("SELECT root_folder FROM rest_filesystem WHERE rest_id='$id'",$db_link); $row=mysql_fetch_array($get_root_folder); $root_folder=$row['root_folder']; $root_folder_img=($root_folder."/images"); if($submit) { //BEGIN PICTURE UPLOAD CODE________________________________________________________________________________* //user defined variables $abpath=($root_folder_img); //Absolute path to where images are uploaded. No trailing slash $sizelim = "no"; //Do you want size limit, yes or no $size = "2500000"; //What do you want size limited to be if there is one //all image types to upload $cert1 = "image/pjpeg"; //Jpeg type 1 $cert2 = "image/jpeg"; //Jpeg type 2 $cert3 = "image/gif"; //Gif type $cert4 = "image/png"; //PNG type $log = ""; //==================================================================begin upload 1=============================================================== //checks if file exists if ($img1_name == "") { $log .= "No file selected for upload 1<br>"; } if ($img1_name != "") { $image1nameext = $img1_name; if ($image1nameext!=""){ //Checks if file is an image if (($img1_type == $cert1) or ($img1_type == $cert2) or ($img1_type == $cert3) or ($img1_type == $cert4) or($img1_type == $cert5)) { if (($img1_type == $cert1) or ($img1_type == $cert2) or ($img1_type == $cert3) or ($img1_type == $cert4)) { if (($img1_type == $cert1) or ($img1_type == $cert2) or ($img1_type == $cert3)) { if (($img1_type == $cert1) or ($img1_type == $cert2)) { } if ($img1_type == $cert3) { } if ($img1_type == $cert4) { } if ($img1_type == $cert3) { } } } @copy($img1, "$abpath/$image1nameext") or $log .= "Couldn't copy file 1 to server - it may be too large, or the transfer may have been disrupted<br>"; if (file_exists("$abpath/$image1nameext")) { $log .= "File 1 was uploaded<br>It can be embedded by typing:<br><font size='-2' face='Verdana, Arial, Helvetica, sans-serif'> <img src="images/$image1nameext"></font><br>into any content area.<br><br>"; } } else { $log .= "File 1 is not an image$img1_name<br>"; } } } //==================================================================begin upload 2=============================================================== //checks if file exists if ($img2_name == "") { $log .= "No file selected for upload 2<br>"; } if ($img2_name != "") { $image2nameext = $img2_name; if ($image2nameext!=""){ //Checks if file is an image if (($img2_type == $cert1) or ($img2_type == $cert2) or ($img2_type == $cert3) or ($img2_type == $cert4) or($img2_type == $cert5)) { if (($img2_type == $cert1) or ($img2_type == $cert2) or ($img2_type == $cert3) or ($img2_type == $cert4)) { if (($img2_type == $cert1) or ($img2_type == $cert2) or ($img2_type == $cert3)) { if (($img2_type == $cert1) or ($img2_type == $cert2)) { } if ($img2_type == $cert3) { } if ($img2_type == $cert4) { } if ($img2_type == $cert3) { } } } @copy($img2, "$abpath/$image2nameext") or $log .= "Couldn't copy file 2 to server - it may be too large, or the transfer may have been disrupted<br>"; if (file_exists("$abpath/$image2nameext")) { $log .= "File 2 was uploaded<br>It can be embedded by typing:<br><font size='-2' face='Verdana, Arial, Helvetica, sans-serif'> <img src="images/$image2nameext"></font><br>into any content area.<br><br>"; } } else { $log .= "File 2 is not an image$img1_name<br>"; } } } //==================================================================begin upload 3=============================================================== //checks if file exists if ($img3_name == "") { $log .= "No file selected for upload 3<br>"; } if ($img3_name != "") { $image3nameext = $img3_name; if ($image1nameext!=""){ //Checks if file is an image if (($img3_type == $cert1) or ($img3_type == $cert2) or ($img3_type == $cert3) or ($img3_type == $cert4) or($img3_type == $cert5)) { if (($img3_type == $cert1) or ($img3_type == $cert2) or ($img3_type == $cert3) or ($img3_type == $cert4)) { if (($img3_type == $cert1) or ($img3_type == $cert2) or ($img3_type == $cert3)) { if (($img3_type == $cert1) or ($img3_type == $cert2)) { } if ($img3_type == $cert3) { } if ($img3_type == $cert4) { } if ($img3_type == $cert3) { } } } @copy($img3, "$abpath/$image3nameext") or $log .= "Couldn't copy file 3 to server - it may be too large, or the transfer may have been disrupted<br>"; if (file_exists("$abpath/$image3nameext")) { $log .= "File 3 was uploaded<br>It can be embedded by typing:<br><font size='-2' face='Verdana, Arial, Helvetica, sans-serif'> <img src="images/$image3nameext"></font><br>into any content area.<br><br>"; } } else { $log .= "File 3 is not an image$img3_name<br>"; } } } //==================================================================begin upload 4=============================================================== //checks if file exists if ($img4_name == "") { $log .= "No file selected for upload 4<br>"; } if ($img4_name != "") { $image4nameext = $img4_name; if ($image4nameext!=""){ //Checks if file is an image if (($img4_type == $cert1) or ($img4_type == $cert2) or ($img4_type == $cert3) or ($img4_type == $cert4) or($img4_type == $cert5)) { if (($img4_type == $cert1) or ($img4_type == $cert2) or ($img4_type == $cert3) or ($img4_type == $cert4)) { if (($img4_type == $cert1) or ($img4_type == $cert2) or ($img4_type == $cert3)) { if (($img4_type == $cert1) or ($img4_type == $cert2)) { } if ($img4_type == $cert3) { } if ($img4_type == $cert4) { } if ($img4_type == $cert3) { } } } @copy($img4, "$abpath/$image4nameext") or $log .= "Couldn't copy file 4 to server - it may be too large, or the transfer may have been disrupted<br>"; if (file_exists("$abpath/$image4nameext")) { $log .= "File 4 was uploaded<br>It can be embedded by typing:<br><font size='-2' face='Verdana, Arial, Helvetica, sans-serif'> <img src="images/$image4nameext"></font><br>into any content area.<br><br>"; } } else { $log .= "File 4 is not an image$img4_name<br>"; } } } //==================================================================begin upload 5=============================================================== //checks if file exists if ($img5_name == "") { $log .= "No file selected for upload 5<br>"; } if ($img5_name != "") { $image5nameext = $img5_name; if ($image5nameext!=""){ //Checks if file is an image if (($img5_type == $cert1) or ($img5_type == $cert2) or ($img5_type == $cert3) or ($img5_type == $cert4) or($img5_type == $cert5)) { if (($img5_type == $cert1) or ($img5_type == $cert2) or ($img5_type == $cert3) or ($img5_type == $cert4)) { if (($img5_type == $cert1) or ($img5_type == $cert2) or ($img5_type == $cert3)) { if (($img5_type == $cert1) or ($img5_type == $cert2)) { } if ($img5_type == $cert3) { } if ($img5_type == $cert4) { } if ($img5_type == $cert3) { } } } @copy($img5, "$abpath/$image5nameext") or $log .= "Couldn't copy file 5 to server - it may be too large, or the transfer may have been disrupted<br>"; if (file_exists("$abpath/$image5nameext")) { $log .= "File 5 was uploaded<br>It can be embedded by typing:<br><font size='-2' face='Verdana, Arial, Helvetica, sans-serif'> <img src="images/$image5nameext"></font><br>into any content area.<br><br>"; } } else { $log .= "File 5 is not an image$img5_name<br>"; } } } //END PICTURE UPLOAD CODE__________________________________________________________________________________* } ?> <html> <head> <meta http-equiv="content-type" content="text/html;charset=iso-8859-1"> <meta name="generator" content="Adobe GoLive 5"> <title>Admin Page :: Images</title> </head> <body bgcolor="#ffffff"> <div align="center"> <font face="Verdana, Arial, Helvetica, sans-serif">Welcome to your administration panel ID: <? echo "$track_id"; ?><br> <? echo $log; ?><br> <br> <table border="0" cellpadding="0" cellspacing="2" width="600"> <form action="<?=$PHP_SELF;?>" method="post" enctype="multipart/form-data" name="FormName"> <tr height="19"> <td colspan="2" height="19"> <div align="center"> <font size="3"><b>Upload New Pictures:</b></font></div> </td> </tr> <tr> <td valign="top" width="150"><b>You may upload up to five pictures at a time.<input type="hidden" value="<?=$project;?>" name="project"><input type="hidden" value="hiddenValue" name="hiddenName"></b></td> <td> <p>Pictures to upload:<br> <input type=file name=img1 size=30><br> <input type=file name=img2 size=30><br> <input type=file name=img3 size=30><br> <input type=file name=img4 size=30><br> <input type=file name=img5 size=30><br> </p> </td> </tr> <tr> <td colspan="2"> <div align="center"> <input type="submit" name="submit" value="Upload"></div> </td> </tr> </form> </table> </font><font face="Verdana, Arial, Helvetica, sans-serif"><br> <?php $mydir = ("$root_folder/images"); //$mydir = dir("rest/MattsBBQ_603/images") ?><br> </font><font face="Verdana, Arial, Helvetica, sans-serif"> <table width="650" border="0" cellspacing="2" cellpadding="0"> <tr> <td colspan="3" align="center"><b>Your Pictures:</b><br> <font size="-2">Click to enlarge.</font></td> </tr> <?php while(($file = $mydir->read()) !== false) { if($file==".") { }else{ if($file==".."){ }else{ if($file==".DS_Store"){ }else{ echo "<tr><td align='center'>$file</td></tr><tr><td align='center'><a href='../images/$file' target='_blank'><img width='150' border='0' src='../images/$file'></a></td></tr><tr><td align='center'><img src="images/$file"></td></tr>"; } } } } $mydir->close();?> </table> <br> </font><font face="Verdana, Arial, Helvetica, sans-serif"><br> <a href="home.php">Admin Home</a></font></div> </body> </html> It keeps giving me this error: Fatal error: Call to a member function read() on a non-object in /Library/Tenon/WebServer/WebSites/admin/rest_site_creation/images.php on line 324 line 324 is: <?php while(($file = $mydir->read()) !== false) { php is greate but i'm going to go punch myself in the groin for a little while. it's less painful. Link to comment https://forums.phpfreaks.com/topic/46639-solved-why-isnt-php-seeing-the-database/page/2/#findComment-230693 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.