PHP - Single Navigation File

I have created a css menu for the top of my site that is included on each page with a php include.  What I am wanting to do now is create the side menu options for each page from the one file.

Each page will have different links side links based on what section of the site you are in however I want to administer them all from one php file if that is possible.  I'm quite new to php and am not sure if I can even do this.  Any ideas on how this can be done?

I know it needs a for loop, but i don't know where in the code i should be putting it?

Code: [Select]
function check_input($value)
{
// Stripslashes
if (get_magic_quotes_gpc())
  {
  $value = stripslashes($value);
  }
// Quote if not a number
if (!is_numeric($value))
  {
  $value = "'" . mysql_real_escape_string($value) . "'";
  }
return $value;
}

$_POST = array_map('check_input', $_POST);

$sql="INSERT INTO testimonials (CustomerName, Town, Testimonial, SortOrder, Images)
VALUES
({$_POST['customername']}, {$_POST['town']}, {$_POST['testimonial']}, {$_POST['sort_order']}, '$imgname'

)";

}
if (!mysql_query($sql,$con))
  {
  die("<br>Query: $sql<br>Error: " . mysql_error() . '<br>');
  }
echo "<p align=center><b>1 testimonial added</b></p>";

mysql_close($con);


Thanks in Advance,
Steve

I'm ok with PHP but probably not half as good as some of you guys on here.

I am basically trying to find a way to grab a line from a huge and I mean huge text file.... its basically a list of keywords I want to call by line number but without preferably going through them all before I get to that line.....otherwise couldmcrash my server obviously.

At the moment im using this

Code: [Select]
$lines = file('http://www.mysite.com/keywords.txt');

// Loop through our array, show HTML source as HTML source; and line numbers too.
foreach ($lines as $line_num => $line) {
echo "$line_num";
}
This works but im sure theres gotta be a better way of doing to save on usuage because this is putting the whole file into the memory and if I can simply say to php give me line number 97, would umm RULE....

Hope you guys can come up with a solution as your much smarter than me ty

Hey all,

I am building a simple cms. I have a posts table and I have an images table. A post has many images and images has a foreign key to the posts table. So when a user edits, updates, creates, and deletes a post, they affect the images related to the post. Sometimes a post can have more than one image, like three images. Hence I rendered this in the view (note that I am using a datamapper that converts tables to objects and fields to key/value pairs):

Code: [Select]
foreach($records as $post){
echo form_open_multipart("homes/update/$post->id"); //File uploads require a multipart form. Default form handling uses the application/x-www-form-urlencoded content type. Multipart forms use the multipart/form-data encoding. //this is critical to pass the id as part of the action attribute of the form, so we can use our params hash to target the id to update the specific record
 
  echo label('Update Title');
echo form_input('title',$post->title);
echo label('Update Body');
echo form_textarea('body',$post->body);

  $images = $post->images->include_join_fields()->get();
if(!is_null($images->image_file_name)){ 
  echo label('Update Images');
foreach($images as $image){
echo form_upload('image_file_name',$image->image_file_name); 
}
}

}
echo form_submit('submit','Update');
The above line of code will render a few input file types. The problem occurs during posting to my update method. It is looking for one parameter from the input file field and so if I upload three different images, it will only look for one and write only one to database:

Code: [Select]
$field_name = 'image_file_name';
  if ( ! $this->upload->do_upload($field_name)){
  $error = array('error' => $this->upload->display_errors());
echo $error['error'];
// redirect('homes/edit');
  }
else {
  $data = array('upload_data' => $this->upload->data());
$image_file_name = $data['upload_data']['file_name'];

Is it possible to do wht I am trying to do? Should I only have on input file type per form submission or is that I need to fix the code to accomodate for multiple submissions by creating an array of sorts?

Thanks for response.

Selected navigation on include file.

Hi all

I can't think how to do this or even if it's possible so I'm hoping someone can help.

I have a simple example here to illustrate.

http://www.ttmt.org.uk/three.php

It's just four linked pages with a heading and a navigation. The navigation has an id="selected" in the <a> tag for that page that changes the color of that link to show you are on that page - very basic.

I wanted the put the navigation on the pages with an include file.

Code: [Select]
<?php
include("php/includes/nav.php");
?>

and have the code for the nav in nav.php

nav.php
Code: [Select]
<ul id="nav">
  <li><a href="index.php">Home</a></li>
  <li><a href="one.php">One</a></li>
  <li><a href="two.php">Two</a></li>
  <li><a href="three.php">Three</a></li>
</ul>


My problem is how can I add the id="selected" to the different links for the different pages if I'm including the navigation code?

Hope this makes sense and someone can help. Any help would be greatly appreciated.

Hi,

I have a file structure for all my files on my website that works fine for the most part. The basic layout would be something similar to the following.

- root folder
    - sub_folder1
         - folder1
         - folder2
    -sub_folder2
         - folder1
         - folder2
Each of the folders would contain relative .php files carrying out specific functions etc. The issue I am having is as follows. If I am on a webpage that is located in either of the folder1/folder2 folders, and I need to redirect somebody to a file located in the root folder, I am not able to do this without the page not being displayed correctly.

On the file located in the folder1 folder, I have a <? php include("page1.php");?> which works fine. Trying to access a file to redirect to from this folder, I have tried,
 <? php include("../page1.php");?>, but this only bring me up one level,  <? php include("../../page1.php");?> which I think is wrong anyway, and doesn't work, and also  <? php include("./page1.php");?>, again does not work.

Does anyone know if it is possible to get the file from the subfolders to access a file located directly in the root?

Sorry if I'm not being clear explaining the layout etc.

Thanks.

PHP script return 20 UL LIST values like,

< ul >

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T

< /ul >

How to display UL LIST into row wise 5 columns like

A B C D
E F G H
I J K L
M N O P
Q R S T (20 ITEMS)

Edited December 7, 2019 by aveeva

Hello:

I have a question. I use to - when I was doing Classic ASP - make a single navigation file to include all aspects of site navigation.

I'm trying to do that now in PHP, but keep getting errors. Can some set me straight (I am assuming what I want to do can be done in PHP).

I have my myNav.php file (in an "include" subfolder):
Code: [Select]
<?php

function showLinks()

<script type="text/javascript" src="include/spNewWindow.js"></script>

<script type="text/javascript" src="include/openSesame.js"></script>

<link rel="stylesheet" type="text/css" href="include/StyleSheet.css" />

?>



<?php

function showTopMenu()

<a href="#">Link 1</a><br />

<a href="#">Link 2</a><br />

<a href="#">Link 3</a><br />

?>

This is the myPage.php I am trying to pull it in to:
Code: [Select]
<?php include('include/myNav.php'); ?>

<html>
<head>

<title></title>

<?php echo $showLinks; ?>

</head>

<body>

<div id="myMenu">

<?php echo $showTopMenu; ?>

</div>

... REST OF SITE, ETC ...



</body>

</html>

However, this is not working at all.

I have figured out how to make files for each individual aspect - Menu, Footer, META tags, etc - but I would like to do this with one file as shown above.

Is this possible?

Thanks!

Hi, I've been scratching my head for a while now about how to do this, I'm relatively new to php and mysql and perhaps foolishly taking on creating a user area for a website.  I have everything else working, all of my register account functions and confirmations and all of the login scripts etc. 

I have created a profile page which returns various information to the user (this bit works fine) and I've got some nice show/hide toggles running with some javascript/css but my intention is to allow the user to change thier information (e-mail address, contact phone number and also whether they are subscribed to the e-mail list), it also displays any support tickets or messages.

So after the long intro, here's what I'm struggling with...  I have a form in a visibility toggled <div> which submits a 'change_email' script, so a user wants to change their e-mail, clicks on change, the <div> appears, they bang in the new e-mail and hit submit.

My php script appears to work (because it doesn't throw up any errors), until you realise that actually it's not updated the record in the db...

I'm using mysql_query("UPDATE users SET email='$new_email' WHERE username='$user'");

Do I need to setup variables for all of the information in the db (name, username, password, email, contno etc etc) and include them in the command to get it to work or should that just pick the correct record and then update it? If that is the case is there a way I can include 'blank' variables so I don't have to set them all up...

e.g.  mysql_query("UPDATE users SET user='',password='',email='$new_email', etc WHERE username='$user'");

Many thanks in anticipation

Hi,

I am am looking to develop further the code below. This code allows me to display a left navigation bar with Main Links and then if you click a Main link, that link is listed first in the list and its' submenu appears below. For the majority of links in the navigation bar this is fine. But for about 2 of the Main links this basic navigation is not suitable.

I need the navigation for 2 of the links to offer more depth. So, for example, if you click Accessories in:

Shoes
Trousers
Shirts
Accessories

Looks like this if Accessories is clicked:

Accessories
Belts
Cuff Links
Wallets
Shoes
Trousers
Shirts

Looks like this if belts is clicked (Main link name changed and submenu changed):

Accessories - Belts
Brown leather
Black Leather
Multicolour Designs
All casual
All formal
Shoes
Trousers
Shirts

Looks like this is Brown Leather is clicked:

Brown Leather Belts
Armani Brown Leather Belt 32"
Armani Brown Leather Belt 34"
Hugo Boss Brown Leather Belt 32"
Hugo Boss Brown Leather Belt 34"
Shoes
Trousers
Shirts


Currently the code does not allow for this depth in the navigation bar. Any ideas how it could be done? Do I need additional tables for each subcategory. How do I ensure the category clicked does not appear in the rest of the navigation bar, as in the code I have at the moment?

Currently the code is:


$res = mysql_query("SELECT * FROM categories");
while($row = mysql_fetch_array($res)) {
  $cats[$row['categoryid']] = $row['categoryname'];
}
if(isset($_GET['category'])) {
 $selcat = $_GET['category'];
}
if(isset($_GET['product'])) {
 $prod_info = mysql_fetch_array(mysql_query("SELECT * FROM products WHERE productid = ".$_GET['product']));
 //Prod_Info now gets stored for use in the main display.
 $selcat = $prod_info['categoryid'];
}
if(isset($selcat)) {
  echo "<a href='categorylist.php?category=".$selcat."'>".$cats[$selcat]."</a>";
  unset($cats[$selcat]); //Gets rid of it for later.
  $res = mysql_query("SELECT productid,name FROM products WHERE categoryid = ".$selcat);
  while($row = mysql_fetch_array($res)) {
   echo "<a href='product.php?product=".$row['productid']."'>".$row['name']."</a>";
  }
}
foreach($cats AS $key => $cat)  {
  echo "<a href='categoryview.php?category=".$key."'>".$cat."</a>";
}



Thank you for looking at this post,

Matt.

So I'm rebuilding an existing joomla component in laravel and this time I want to get it right. Hopefully my explanation is not too complicated.   I have this situation:   I have an order. The order has many products. The product has many parameters in the form of input fields such as radio, select list and text (think of color, size, engraving, logo select). An order also has some parameters such as address etc.   My question is how I should structure this considering the following:   1. The parameters of either an order itself or a product can change from time to time. Sometimes I need to add several fields for a certain amount of time. 2. Each product has 1 or more production pages (production steps) where some of the parameters set by the order need to be visible. Each production step has its own set of parameters (3d model, logo file). This means that the step1 page should show its own parameters INCLUDING a predetermined set of product parameters. So the columns could look like this: color - engraving - logo select - 3d model - logo file. 3. Each production page lists all the products belonging to that step. 4. Each product can belong to 1 or more production steps. 5. A product is only visible at 1 step at a time. The steps have a specific ordering.   A little note: it's not a usual webshop, but rather we sell custom sports products. Currently we have 3 products where 1 product has 2 production steps and another has 3 production steps.   Don't get me wrong, I have a working application for this, but currently it's just a database mess. The application kept growing as per bosses request so thinking it through was not possible  at the time.

How to pull just I record of a column out of the 20 columns? This is not showing the results.

$SomeVar = 'pets';
$query =  "SELECT field1 FROM db1 WHERE id1 = '".$SomeVar."'";
$results=mysql_query($link);

echo $link;

Hi,

I'm trying to delete a string that's single quoted. From: Cyto's to Cyto, but doesn't work. It works when I add 's to the string with stripslashes, but I can't seem to delete a quote from a string.
Does someone know how?

My $_post code:
Code: [Select]
$name=mysql_real_escape_string(stripslashes($_POST["ename"]));
Cheers

Hi,  learning as I go here, and I appreciate the help in advance ..

I have some working php code that retrieves sql results using php.  I assign the resutls to an array by doing this

$bobreport = array();
while ($row=db2_fetch_array($querystmt)) {
   array_push($bobreport, $row);
}

i can then write the rows of returned data after some column headers using this...

foreach ($bobreport as $value) {

echo "<tr><td>$value[0]</td><td>$value[1] .....

}

The particular report I'm working on now has a redundant date and time in every row that I omit in the foreach loop because I just want to show it once above the table somewhere.  This doesn't seem to work in accomplishing that...

echo "This data was updated ".$bobreport[0][9]." at ".$bobreport[0][10] ;

All I seem to get in the report is "This data was updated at".

Please help.

Greetings,

I'm trying to execute a shell command with a user-supplied password as input.  The password may contain apostrophes and and virtually any other character.  Unfortunately, when using escapeshellarg(), the password argument is interpreted as two separate arguments, as escapeshellarg() will handle apostrophes (single quotes) by breaking out of the already quoted text and using a backslash escape.


$password = escapeshellarg("ex'ample!%");  // The password will actually be supplied by an HTML form.

$command = ('echo '.$password);

echo "$command";

// Returns 'ex'\''ample!%'


Does anyone have any input on how to accomplish what I'm trying to do?  I'd like to allow obscure passwords without disallowing specific characters, while still being "safe" in passing the information to a shell command.  Double quotes would work for passing single quotes, but I'm afraid I might break other characters there.

Thanks.