PHP - How To Determine The Last Item In An Array That Is Being Looped Help!

I have a script that seems to work well to insert a bookmark into a users database when he/she is logged into the system but I am having a hard time figuring out how I would go about making a work-a-round for having an item selected before being logged in, and inserted after they have logged in or registered.

For example, I would like a user to be able to select an Item to add to bookmark whether that user is logged in/registered or not and if they are not, they would be greeted with a login/registration form and after successful login the add bookmark script would be initiated on the item previously selected.

What I've got this far:

Simple form to add bookmark:

<form name="bm_table" action="add_bms.php" method="post">
<input type="text" name="new_url" value="http://" />
<input type="submit" value="Add Bookmark"/>
</form>


Then I have the add bookmark script:

BEGIN php

$new_url = $_POST['new_url'];

try {
    check_valid_user();  //cannot get past this part since it ends the script....code below
    if (!filled_out($_POST)) {
      throw new Exception('Form not completely filled out.');
    }
    // check URL format
    if (strstr($new_url, 'http://') === false) {
       $new_url = 'http://'.$new_url;
    }

    // check URL is valid
    if (!(@fopen($new_url, 'r'))) {
      throw new Exception('Not a valid URL.');
    }

    // try to add bm
    add_bm($new_url);
    echo 'Bookmark added.';

    // get the bookmarks this user has saved
    if ($url_array = get_user_urls($_SESSION['valid_user'])) {
      display_user_urls($url_array);
    }
  }
  catch (Exception $e) {
    echo $e->getMessage();
  }

END php


Checking valid user - the portion I cannot get past in the above script:


function check_valid_user() {
// see if somebody is logged in and notify them if not
  if (isset($_SESSION['valid_user']))  {
      echo "Logged in as ".$_SESSION['valid_user'].".<br />";
  } else {
     // they are not logged in
     do_html_heading('Problem:');
     echo 'You are not logged in.<br />';
     do_html_url('login.php', 'Login');
     do_html_footer();
     exit;
  }
}



How would I go about modifying the script so that a user could fill in the form (later it would be a link...obviously they probably wouldn't be filling in a form that is log-in specific - but same concept I think)

Thanks in advance for the help!

tec4

Hi there,

I think this is a big question but I'd appretiate any help you can provide!!
I have a list of items and subitems in a table that looks like this:

id    parent_id    title 1    0    House Chores 2    1    Take Out Trash 3    1    Clean Room 4    0    Grocery List 5    4    Eggs 6    4    Produce 7    6    Lettuce 8    6    Tomato 9    4    Milk
I want to display it like this:

(+) House Chores:
       > Take Out Trash
       > Clean Room

(+) Grocery List:
       > Eggs
       (+) Produce
            > Letutce
           > Tomato
       > Milk

 
So basically each entry in the table has an unique id and also a parent id if it's nested inside another item.
I "sort of" got it figured out in one way, but it doesnt really allow for nested subgroups. I'd like to know how would y'all PHP freaks to this

Also taking suggestions for the javascript code to expand/collapse the tree !!

Thank you!

I'm trying to figure out how to add up all the $qty_total that exist into an overall total.

I hope I'm not oversimplifying my example..

I have this: $qty_total = $qty_insert * $d['workshop_price'];

$qty_insert loops several times and I want:

$overall_total = $qty_total + qty_total + ...however many..

Hi,

I want to loop out data from DB in <input> and change and update several posts at the same time.
Can you give me a short example, how <input> and maybe foreach could look like?

Thanks

I cannot get this INSERT to work. Not records are being added to the sys_city_dev table. No query errors are being thrown.

I am simply trying to add ALL records from all_illinois to sys_city_dev and Mid should have be add as 11 in all inserts. city_name of course will be field city_name from all_illinois.

Here is my code:

$query = "SELECT * FROM all_illinois";
      if ($results = mysqli_query($cxn, $query))
        {
          $row_cnt = mysqli_num_rows($results);
          echo $row_cnt . " Total Records in Query.<br /><br />";
          if (mysqli_num_rows($results))
            {
              while ($rows = mysqli_fetch_array($results))
                {
                  echo $rows['city_name'] . "<br />";
                  $mid_id = '11';
                  $insert_city_query = "INSERT INTO sys_city_dev (ID, Mid, cityName, forder, disdplay, cid) VALUES
(' ','" . $mid_id . "','" . $rows['city_name'] . "', '', '','')";
                  if (!$insert_city_query)
                      exit(mysql_error());
                }
            }
        }

Here is my insert table structure and 5 records dump:

--
-- Table structure for table `sys_city_dev`
--

CREATE TABLE IF NOT EXISTS `sys_city_dev` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Mid` int(11) NOT NULL DEFAULT '0',
  `cityName` varchar(30) NOT NULL DEFAULT '',
  `forder` int(4) NOT NULL DEFAULT '0',
  `disdplay` int(4) NOT NULL DEFAULT '0',
  `cid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=113970 ;

--
-- Dumping data for table `sys_city_dev`
--

INSERT INTO `sys_city_dev` (`ID`, `Mid`, `cityName`, `forder`, `disdplay`, `cid`) VALUES
(84010, 1, 'Dothan', 0, 0, 0),
(84011, 1, 'Alabaster', 0, 0, 0),
(84012, 1, 'Birmingham', 0, 0, 0),
(84013, 2, 'Flagstaff', 0, 0, 0),
(84014, 1, 'Auburn', 0, 0, 0);


And the all_illinois dump w/ 5 records:

--
-- Table structure for table `all_illinois`
--

CREATE TABLE IF NOT EXISTS `all_illinois` (
  `state_id` varchar(255) NOT NULL,
  `city_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `all_illinois`
--

INSERT INTO `all_illinois` (`state_id`, `city_name`) VALUES
('135', 'Abingdon'),
('135', 'Adair'),
('135', 'Addieville'),
('135', 'Addison'),
('135', 'Adrian');

Hi all, Im really struggling to build an update multiple records form, Ive built my table which calls all data i need from the db in a looped region which works fine I just cant understand how to then input these back into the table in the correct rows, if this makes sense? Ive been reading this tutorial but Its not very informative its more of a copy and paste http://www.phpeasystep.com/mysql/10.html

Code: [Select]
$new_array2=array_diff($my_array,$itemIds);

$updatedb = mysql_query("UPDATE content_type_ads SET field_expire_value = '666' WHERE $new_array2 = field_item_id_value");
"$new_array2" has only 12 digit numbers for each item in the array, and I want to match them to the "field_item_id_value" field in the table, updating the "field_expire_value" field for the record where they match.  I know I am close because the UPDATE code works before I add the WHERE statement (it of course adds '666' to EVERY field, but for a noobie it's a start!).

Well I am looking to change this url

Code: [Select]
http://website.com/product.php?Item=2369
to

Code: [Select]
http://website.com/product.php?Item=Item-Name

Heres a snip of the code that handles that.

<?php include_once('mysql_connect.php');$id = (int)$_GET['Item'];?>()

any help would be appreciated.

All,
I have a zip code and for example the zip code is 01101. How can I determine if the first character in this is a zero?

Thanks in advance.

This may sound funny, but I'm not sure what I was trying to get this code to do...
Code: [Select]
        <!-- Find Current Page Name -->
        <?php
          $page = basename($_SERVER['REQUEST_URI']);
echo '<p>$page = ' . $page . '</p>';
//          if ($page == '') {
          if (($page == '/')||($page == '')||($page == 'index.php')){
            $page = "index.php";
echo '<p>You are on the Home Page.</p>';
          }else{
echo '<p>You are on Some Other Page.</p>';
}

What I mean by that is I'm not understanding why I chose...
Code: [Select]
          if ($page == '') {

and then...
Code: [Select]
          if (($page == '/')||($page == '')){

and then...
Code: [Select]
          if (($page == '/')||($page == '')||($page == 'index.php')){


Why would I get those different results from basename($_SERVER['REQUEST_URI'])??

And what should I expect locally on my Laptop with a Virtual Host set up (e.g. "http://local.debbie/index.php") versus using a Test Site (e.g. "http://www.doubledee.byethost2.com/") versus a real site (e.g. "www.debbie.com")?!

Hope I'm making some sense here...


Debbie

I have a table that I must be populated based on a check box selection. The maximum selection is 5, however, there are more then 10 choices. For example: Here is a choice of 10 different (checkbox) options that the user can select from:

1. Coke
2. Root Beer
3. Pepsi
4. Dr. Pepper
5. Sprite
6. 7up
7. Cream Soda
8. Club Soda
9. Water
10. Milk

I've already managed to limit the users selection to only 5. My issue is determining which of the checkboxese were actually selected so that I can correctly place them in my database.

The first thing to do is create variables from all the checkboxes:

$coke = $_POST['coke'];
$rootbeer = $_POST['rootbeer'];
$pepsi = $_POST['pepsi'];
$drpepper = $_POST['drpepper'];
etc. etc.

Now that I have all 10 selections as variables from a submitted form how can I determine which ones are empty (or which ones have values) so that I can then save them to the database respectively?

Am currently using this code, and actually thinking about it should split the query to an include in order to allow for other database drivers, on the chance we may decide to ditch the old MySQL. But I digress from the question.

Code: [Select]
include($lib."dbconfig.php");

$q = 'SELECT * FROM file WHERE this = "'.$that'";
$result = mysql_query($q);

if (mysql_num_rows($result) > 0)

If the query doesn't pick up a row I'm getting this error yo,

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\webpages\*\*\admin.php on line 553

So what would be a better way of testing if the query was successful? 

I am pulling records from a mysql db.   

Example Output:

Team A=  Our Team
Team b = An opponent team
Team A score = 7
Team B score = 8

Team A = Our Team
Team b = Another Opponent
Team A score = 3
Team B score = 1


What I need now is to add ONE more output, which is whether this is a "WIN" or a "LOSS".

Should I add a field into the table that calc's this?    If so, how?   Please be specific.

Or, should I use php to compare Team A score vs Team B score PER every record and then insert this new variable into the output.    If so, how do I create a new variable value for every single output in the table?


I know ultimately that this is a IF THEN type of calc, but can't quite figure out how specifically.   

Please be specific.

Thanks

I have a Unique Constraint setup on (emailAddress and pin) to allow multiple email addresses be the same and multiple pins but not the same emailAddress and pin value together (unique(emailAddress, pin))

Anyway, I am trying to generate a pin through a random seed, but I can't get my code to work properly to test if the combination already exists.

Here is the chunk that does not work:

Code: [Select]

$tries = 0;
$foundRows=0;
do {
$pin=null;
$tries++;
$pin = str_pad(rand(0,9), 4, "0", STR_PAD_LEFT);


$stmt = $dbh->prepare("SELECT COUNT(*) FROM ajax WHERE emailAddress=:email AND pin=:pin LIMIT 1");
if ($stmt->bindParam(':email', $email, PDO::PARAM_STR) &&
$stmt->bindParam(':pin', $pin, PDO::PARAM_INT)) {
$stmt->execute();
$foundRows = $dbh->query("SELECT FOUND_ROWS()")->fetchColumn();
echo "<br />$foundRows<br />";
} else {
die ("<p>Could not bind to data verification</p>");
}
} while ($foundRows > 0);


This is always returning $foundRows=0 so always exiting the loop, and giving me a constraint error.

Any ideas? Maybe a better way to do this?

My uploader allows the following file formats:

jpg
pdf
gif
png

I tested that if someone was to name a file configure.php.jpg, my uploader allows it to upload

I want to do a check to see if the user has 2 extensions, and if so it will not allow them to upload.

I was thinking of just checking if the file name has two "." (dots) in the name. What function could I use to do this?

Or .. is there a better way?