PHP - Adding A Foreach To A Whole Php Page

This topic has been moved to Application Frameworks.

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

Hi everybody. I am new to PHP and trying to alter a wordpress site. I am using a plugin called backend restrictor and it is a blanket restrictor of all backend functions except profile. I want to add some more urls other than the profile.php page to be allowed but I can't get it right. Can anybody assist?

Code: [Select]
add_action('admin_init', 'bur_plugin_enforceRestriction');

function bur_plugin_enforceRestriction() {
global $current_user;
if (current_user_can('manage_options')) { }
else{
$pageURL = 'http';
if ($_SERVER["HTTPS"] == "on") {$pageURL .= "s";}
$pageURL .= "://";
if ($_SERVER["SERVER_PORT"] != "80"):
$pageURL .= $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"];
else:
$pageURL .= $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"];
endif;

// allowed path(s)
if ($pageURL == get_bloginfo('wpurl')."/wp-admin/profile.php"){

}else{
header("Location:".get_bloginfo('url')."/");


}
}
}

?>

Hi everyone,

The website I am working on is http://teemagroup.com/puyafolder and I have a global navigation with a drop down menu.

What I want to do is on the right side have a PHP code to pull sub-pages under the drop down menu that its in. I don't quite know how to write it.

For example everything under "Client Services" would go on the right side of that page. You know, to make it locally available instead of a drop down. And this code would work with all other pages. It would just pull what's under that page.

I've added some files for you if you need it. This is done in wordpress if you wanted to know.

I have an 'I agree' button on this page https://www.setstuffrentals.com/credit-card-authorization/

 

I basically need the button to redirect to another web page after a customer hits 'I agree'. I don't know PHP much. Can someone help step by step, please?

Hi All.

I have been really struggling with this for a while! When a URL loads I wish to load with parameters entered & those parameters entered on a page but cannot get my head round it. Any help will be much appretiated...

So when a user navigates to www.test.com/page.php I wish to to actually pull back www.test.com/page.php?term=&submit=Go

Any help will be really really appretiated.

I just added a user log on for a site I am building using PHP.  I used a simple session based system for this. I can log on just fine. What I am looking for is a way to pass on in ht session what rank a user is so some links/pages will only show for the admin or the super user but not the normal user. I rank the users as Admin 1, superuser 2, and user 3.

This is what I have for the session in my header that allows you to be logged in.
Code: [Select]
<?
session_start();
if(!session_is_registered(myusername)){
header("location:login.php");
}
?>

Here is what I have that starts the session
Code: [Select]

//Connection stuff

$query="SELECT * FROM user WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($query);

$count=mysql_num_rows($result);

if($count==1){

session_register("myusername");
session_register("mypassword");
header("location:index.php");
}
else {
echo "Wrong Username or Password";
}

ob_end_flush();
?>

Hi iam currently writing some code for my website and i have a number of records that i simply want to display in a table format, i have done this in a while loop and it works well, however i only want to display a maximum of 10 records per page as my div needs to be a fixed height and was wondering how i could include a next button that would act as like a page number. The thing is at any given point there could be from 1 record to display to 500, so i need a way of allowing the user to quickly navigate to the other records. How can i do this without using mulitple pages.

Hope this makes sense.

Heres my code

Code: [Select]
<?php echo"<table width='100%' border='1' align='center'><tr><th>Referal Name</th><th>Amount Received</tr>";
while ($row = mysql_fetch_array($sql_info))
{
extract($row);
echo "<tr><td align='center'>".$username."</td><td align='center'>".$cumulative_referral."</td></tr>";
}
echo "</table>";


?>
Thanks for your help

I am looking to add a comment area to pages that are created with data that is pulled off of a database. I am looking for something like the forums on this site, but not as complex. I was thinking about attempting to use a text file to hold the comments for each ID number that is in my database and then displaying those comments when the ID number is called. I'm not sure how I would go about making a function that would search if there was a text file for that ID number and if not to create one. I'm not even sure if this is the best way to go about it but I know if I put all the comments into a database it will get rather large rather quickly. Any pointers and good tutorials would be welcome.

Sorry if it sounds as if this post is rambling, I think I need to step away from the computer for a bit.

Thanks

hope someone can help me out here, stuck on this page...
This page shows the details of the listing they had just clicked on on the previous page. this part works
If the person logged in is the person who is looking at the page, the email section does not show. this part works
However, the part I cannot get to work, is when the logged in user types their email message and clicks send email. at this point the details of listing stop showing
please SOMEONE HELP ME
thanks in advance, i hope
Code: [Select]
<?php
  // Start the session
  require_once('startsession.php');

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

  require_once('connectvars.php');

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

if(isset($_POST['submit'])){
 $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); 

  // Retrieve the user data from MySQL
  $query1 = 'SELECT email FROM ob_user WHERE username="' . $user_name . '"';
  $data1 = mysqli_query($dbc, $query1);
  $row1 = mysqli_fetch_array($data1);
  
  $email = $row1['email'];
  
 $to = $email;
 $subject = 'OurBazzar response to' . $subject . '';
 $body = $_POST['email'];
 $headers = 'From: caleb.jordan.flax@gmail.com';
 if (mail($to, $subject, $body, $headers)) {
   echo("<p>Message sent!</p>");
  } else {
   echo("<p>Message delivery failed...</p>");
  }
  end();
}



  if (isset($_GET['listing_id']) && isset($_GET['subject']) && isset($_GET['description']) && isset($_GET['price']) && isset($_GET['date']) && isset($_GET['city']) && isset($_GET['state']) && isset($_GET['user_id']) && isset($_GET['category_id'])) {
  
    // Grab the score data from the GET
    $listing_id = $_GET['listing_id'];
    $title = $_GET['subject'];
    $description = $_GET['description'];
    $price = $_GET['price'];
    $date = $_GET['date'];
$city = $_GET['city'];
    $state = $_GET['state'];
    $userid = $_GET['user_id'];
    $categoryid = $_GET['category_id'];

  }

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

  // Retrieve the user data from MySQL
  $query = 'SELECT username FROM ob_user WHERE user_id="' . $userid . '"';
  $data = mysqli_query($dbc, $query);
  $row = mysqli_fetch_array($data);

  $query1 = 'SELECT name FROM ob_category WHERE category_id="' . $categoryid . '"';
  $data1 = mysqli_query($dbc, $query1);
  $row1 = mysqli_fetch_array($data1); 
  
$user_name = $row['username'];
$category_name = $row1['name']; 

echo '<table>';
echo '<tr><td colspan="2"><strong>' . $title . '</strong></td></tr>';
echo '<tr><td>Created by: </td><td>' . $user_name . '</td></tr>';
echo '<tr><td>Date created: </td><td>' . $date . '</td></tr>';
echo '<tr><td>Location: </td><td>' . $city . ', ' . $state . '</td></tr>';
echo '<tr><td>Category: </td><td>' . $category_name . '</td></tr>';
echo '<tr><td>Description: </td><td>' . $description . '</td></tr>';
echo '</table>'; 

if ((isset($_SESSION['username'])) && ($_SESSION['username'] != $user_name)) {

?>

<br />
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<fieldset>
<legend>Send Email to <?php echo $user_name; ?></legend>
<label for="email">Message: </label>
<input type="text" name="email" /><br />
<input type="submit" value="Send Email" name="submit">
</fieldset>

<?php

}
require_once('footer.php');
?>

Here is my add driver button

Hi Guy's,

I've recoded allot with 3 scripts i had to my disposal. I've fixed 95% and i'm proud allready, but stuck at the following code. It does'nt execute any errors and refreshes the page without uploading the picture to the desired folder. Also folders are'nt created. I've turned on error reporting at level -1, but those errors i fixed.

Can you please help me out?

note: this is a partial code of a tiny usermanagement 'cms'.

Code: [Select]
<?php
//action: add picture for user -----------------------------------------------------------------------------
if (isset($_GET['editpic']) && isset($_GET['id'])) {
$id = (int) $_GET['id'];
if ($id == 0) {
die("Invalid ID provided.");
}
$sql = "SELECT username FROM `users` WHERE `id`='".$_GET['id']."'";
$res = mysql_query($sql) or die(mysql_error());
//execution when completed the add picture form and pressed submit button ---------------------
if (isset($_POST['addPic'])) {

$row = mysql_fetch_assoc($res);

$title = protect($_POST['title']);

if(!$title)
{
echo "<script language=\"Javascript\" type=\"text/javascript\">
alert(\"You must choose a title for your picture!\")
document.location.href='profilecp.php'</script>";

}

$target = $row['username'];
if(!is_dir($target)) @mkdir($target);
$target = $target . '/pics';

if(!is_dir($target)) @mkdir($target);

$target = $target."/".basename($_FILES['pics']['name']) ;
$size = $_FILES['pics']['size'];
$pic = $_FILES['pics']['name'];
$type = $_FILES['pics']['type'];

$sql2= "INSERT INTO `user_photos` (`profile_id`,`title`,`size`,`type`,`reference`)
VALUES ('".$_GET['id']."','$title','$size','$type','$pic'); ";

$res2 = mysql_query($sql2) or die(mysql_error());

if(move_uploaded_file($_FILES['pics']['tmp_name'], $target))
{
echo "<script language=\"Javascript\" type=\"text/javascript\">
alert(\"Your picture has been uploaded\")
document.location.href='profilecp.php'</script>";
}
else
{
echo "<script language=\"Javascript\" type=\"text/javascript\">
alert(\"There was an error, try again\")
document.location.href='profilecp.php'</script>";
}


$target2 = $row['username'];
$target2 = $target2 . '/pics';
$target2 = $target2 . '/thumbs';
if(!is_dir($target2)) @mkdir($target2);
$target2 = $target2."/".basename($_FILES['pics']['name']) ;
createthumb($target,$target2,150,150);

}


<!-----------------------ADD PICTURES-----------------------//-->

<div class="dividerp">
<form enctype="multipart/form-data" method="POST" action="administrator.php?editpic&amp;id=<?php echo $id;?>"><br/>
<strong>Upload Pictures</strong><br/><br/>

<div class="formElm">
<label for="title">Title</label>
<input id="title" type="text" name="title" maxlength="32"><br/>
</div>

<div class="formElm">
<label for="file">File</label>
<input id="file" type="file" name="pics" maxlength="255"><br/>
</div>

<input type="submit" name="picAdd" value="Add">
</form>
</div>

</div>
</body>
</html>
}?>

and the mysql tables:

Code: [Select]
CREATE TABLE `users` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`first` VARCHAR( 32 ) NOT NULL ,
`last` VARCHAR( 32 ) NOT NULL ,
`username` VARCHAR(32) NOT NULL,
`password` VARCHAR(255) NOT NULL,
`email` VARCHAR(255) NOT NULL,
`about` TEXT NOT NULL,
`level` int(4) default '1'
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;
Code: [Select]
CREATE TABLE `user_photos` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`profile_id` INT NOT NULL ,
`title` VARCHAR( 128 ) NOT NULL ,
`size` INT NOT NULL ,
`type` VARCHAR( 128 ) NOT NULL ,
`reference` VARCHAR( 255 ) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;
Best regards,

Martijn

I'm not sure if the title explains it very well, but here is an image of it. I am trying to figure out how to access the option selected (equal, not equal, etc.), along with its input box, for each column (the checkboxes on the right) selected. The purpose of this is to allow a non-programming administrator user to create a custom query to access information. I can find out which checkboxes are selected no problem, but finding the accompanying drop-down option and input box is difficult for me. How do I do this?

If you have a suggestion on how to change it, I'm very open. Thank you in advance!



Code: [Select]
if(!isset($_POST['submit']))
{
echo "
<form method='post'>
<table>
 <tr>
  <td valign='top'>SELECT</td>
  <td valign='top'>
   <table>";
 
// LIST ALL COLUMNS IN A TABLE
$result = mysql_query("SELECT * FROM table_name") or die(mysql_error());
$rowcount=mysql_num_rows($result);
$y=mysql_num_fields($result);
for ($x=0; $x<$y; $x++)
{ echo "
    <tr>
<td>
  <input type='checkbox' name='fields[]' value='".mysql_field_name($result, $x)."'>".mysql_field_name($result, $x)."
     </td>
</tr>"; }
 
   echo "
   </table>
  </td>
  <td valign='top'>FROM allocations</td>
  <td valign='top'>WHERE</td>
  <td>
   <table>";
   
// LIST ALL COLUMNS IN A TABLE
$result = mysql_query("SELECT * FROM table_name") or die(mysql_error());
$rowcount=mysql_num_rows($result);
$y=mysql_num_fields($result);
for ($x=0; $x<$y; $x++)
{ echo "
    <tr>
<td>
  <input type='checkbox' name='column[]' value='".mysql_field_name($result, $x)."'>".mysql_field_name($result, $x)."
</td>
<td>
  <select name='operator[]'>
          <option value='='>equals</option>
          <option value='<>'>does not equal</option>
          <option value='>'>greater than</option>
          <option value='<'>less than</option>
          <option value='>='>greater than or equal to</option>
          <option value='<='>less than or equal to</option>
          <option value='LIKE'>is like</option>
         </select>
</td>
     <td><input type='text' name='criteria[]'></td>
</tr>"; }

   echo "
   </table>
  </td>
  <td valign='top'><input type='submit' value='Process Query' name='submit' class='submit'></td>
 </tr>
</table>
</form>";
}
else
{
 echo "<b>Fields to edit:</b> ";
foreach ($_POST['fields'] as $fields) {
echo $fields,", ";
}

 echo "<br><br>";
 echo "<b>Columns to query:</b> ";
foreach ($_POST['column'] as $columns) {
echo $columns," HERE IS THE SPOT, ";
}
}

Quesion: Show each movie in the database on its own page, and give the user links in a "page 1, Page 2, Page 3" - type navigation system. Hint: Use LIMIT to control which movie is on which page. I have provided 3 files: 1st: configure DB, 2nd: insert data, 3rd: my code for the question. I would appreciate the help. I am a noob by the way.

First set up everything for DB:

<?php
//connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//create the main database if it doesn't already exist
$query = 'CREATE DATABASE IF NOT EXISTS moviesite';
mysql_query($query, $db) or die(mysql_error($db));

//make sure our recently created database is the active one
mysql_select_db('moviesite', $db) or die(mysql_error($db));

//create the movie table
$query = 'CREATE TABLE movie (
        movie_id        INTEGER UNSIGNED  NOT NULL AUTO_INCREMENT,
        movie_name      VARCHAR(255)      NOT NULL,
        movie_type      TINYINT           NOT NULL DEFAULT 0,
        movie_year      SMALLINT UNSIGNED NOT NULL DEFAULT 0,
        movie_leadactor INTEGER UNSIGNED  NOT NULL DEFAULT 0,
        movie_director  INTEGER UNSIGNED  NOT NULL DEFAULT 0,

        PRIMARY KEY (movie_id),
        KEY movie_type (movie_type, movie_year)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die (mysql_error($db));

//create the movietype table
$query = 'CREATE TABLE movietype (
        movietype_id    TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
        movietype_label VARCHAR(100)     NOT NULL,
        PRIMARY KEY (movietype_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

//create the people table
$query = 'CREATE TABLE people (
        people_id         INTEGER UNSIGNED    NOT NULL AUTO_INCREMENT,
        people_fullname   VARCHAR(255)        NOT NULL,
        people_isactor    TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
        people_isdirector TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,

        PRIMARY KEY (people_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Movie database successfully created!';
?>



********************************************************************
***********************************************************************

second file to load info into DB:



<?php
// connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//make sure you're using the correct database
mysql_select_db('moviesite', $db) or die(mysql_error($db));

// insert data into the movie table
$query = 'INSERT INTO movie
        (movie_id, movie_name, movie_type, movie_year, movie_leadactor,
        movie_director)
    VALUES
        (1, "Bruce Almighty", 5, 2003, 1, 2),
        (2, "Office Space", 5, 1999, 5, 6),
        (3, "Grand Canyon", 2, 1991, 4, 3)';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the movietype table
$query = 'INSERT INTO movietype
        (movietype_id, movietype_label)
    VALUES
        (1,"Sci Fi"),
        (2, "Drama"),
        (3, "Adventure"),
        (4, "War"),
        (5, "Comedy"),
        (6, "Horror"),
        (7, "Action"),
        (8, "Kids")';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the people table
$query  = 'INSERT INTO people
        (people_id, people_fullname, people_isactor, people_isdirector)
    VALUES
        (1, "Jim Carrey", 1, 0),
        (2, "Tom Shadyac", 0, 1),
        (3, "Lawrence Kasdan", 0, 1),
        (4, "Kevin Kline", 1, 0),
        (5, "Ron Livingston", 1, 0),
        (6, "Mike Judge", 0, 1)';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Data inserted successfully!';
?>



**************************************************************
****************************************************************

MY CODE FOR THE QUESTION:


<?php
$db = mysql_connect('localhost', 'root', '000') or
die ('Unable to connect. Check your connection parameters.');

mysql_select_db('moviesite', $db) or die(mysql_error($db));

//get our starting point for the query from the URL
if (isset($_GET['offset'])) {
   $offset = $_GET['offset'];
} else {
   $offset = 0;
}

//get the movie
$query  = 'SELECT
   movie_name, movie_year
FROM
   movie
ORDER BY
   movie_name
LIMIT ' . $offset . ' , 1';
$result = mysql_query($query, $db) or die(mysql_error($db));
$row = mysql_fetch_assoc($result);
?>
<html>
<head>
<title><?php echo $row['movie_name']; ?></title>
</head>
<body>
<table border = "1">
<tr>
<th>Movie Name</th>
<th>Year</th>
</tr><tr>
<td><?php echo $row['movie_name']; ?></td>
<td><?php echo $row['movie_year']; ?></td>
</tr>
</table>
<p>
<a href="page.php?offset=0">Page 1</a>,
<a href="page.php?offset=1">Page 2</a>,
<a href="page.php?offset=2">Page 3</a>
</p>
</body>
</html>

Hi!

When I echo $m below, it will show all selected options fine.
Instead, I want it to show many I selected.

So if I selected 3 in dropdown, I want it to say I selected 3 instead of showing their values.

      $allmaps=$_POST['maps'];
       foreach ($allmaps as $m) { echo 'm = '.$m.''; }

<select name="maps[]" multiple>'.$maps.'</select>

today i programmed my own weight calculator.
one thing i am having a problem is with trying to make it so if a weight is over a certain number, then the shipping price will increase by X.
shipping prices are charged in 20000 gram blocks, so if I have something that is 22000 grams then that will be two blocks. what i need to do is something like (this is a big guess)

Quote

$row3 = 50;
$weighttotal = 22000;
if ($weighttotal > 20000) {
   foreach (20000) {
      $row3 += $row3;}
      }
   }
}


can it be done on php??