PHP - Behavior For Comments Form?

Hello!

I'm trying to dive into Dreamweaver's code so that I can better understand what the heck it's doing in order to modify it to my specific needs.  My PHP book is great, but it just seems like Dreamweaver's code is much more complicated than how I'd write it based on what I've read about PHP (Disclaimer: been with PHP for a week).  It would be incredibly helpful if someone could write comments for each of the lines in terms of what it's doing (the more specific the better).  I appreciate that this is a bit of a tedious question to ask, but it would be really appreciated.

Thank you.

Code: [Select]
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) {
  $insertSQL = sprintf("INSERT INTO users (first_name, last_name, user_type, email, school_id) VALUES (%s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['first_name'], "text"),
                       GetSQLValueString($_POST['last_name'], "text"),
                       GetSQLValueString($_POST['user_type'], "text"),
                       GetSQLValueString($_POST['email'], "text"),
                       GetSQLValueString($_POST['school_id'], "int"));
   
  mysql_select_db($database_connalgebra, $connalgebra);
  $Result1 = mysql_query($insertSQL, $connalgebra) or die(mysql_error());
     

// The code below gives the last autogenerated userid.
$id = mysql_insert_id();
$updateusername = "UPDATE users SET username = CONCAT(first_name, $id) WHERE user_id = $id";
$Result2 = mysql_query($updateusername, $connalgebra) or die(mysql_error());
//

  $insertGoTo = "add_user.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_connalgebra, $connalgebra);
$query_rsSchools = "SELECT school_id, school_state, school_city, school_name, school_country FROM schools ORDER BY school_name ASC";
$rsSchools = mysql_query($query_rsSchools, $connalgebra) or die(mysql_error());
$row_rsSchools = mysql_fetch_assoc($rsSchools);
$totalRows_rsSchools = mysql_num_rows($rsSchools);

Current time when testing was: 1291064453

I run the following: echo date('m/d/y', strtotime('first day', 1291064453));
Expecting: 11/1/10

What I actually get: 11/30/10

Can anyone explain this?

Hi Guys/Gals,

I have a search form that people search for keywords.  Basically and one field and one button form.

When they search for a particular string for example, "white" it's only bringing up one result, but 23 times.  Here's my code:

Code: [Select]
<?php
require("format.php");
//Get the page number for later
$pagenum = $_GET['pagenum'];
 //Here we display stuff if they have submitted the form
if ( $_GET['searching'] == 'yes' )
{ 
//If they stuffed up and didn't search for anything, we show them this 
if ($_GET['find'] == "") 
{ 
//Build the HTML display that will output the page when no search is entered
echo "$noSearch";
} 
//If everything is all good, we connect to the database
mysql_connect("localhost", "******", "******") or die(mysql_error()); 
mysql_select_db("******") or die(mysql_error()); 
//Let's not forget the register globals off crap
$animalID = $_GET['animalID'];
$status = $_GET['status'];
$date = $_GET['date'];
$species = $_GET['species'];
$breed = $_GET['breed'];
$sex = $_GET['sex'];
$primary_colour = $_GET['primary_colour'];
$colour = $_GET['colour'];
$distinctive_traits = $_GET['distinctive_traits'];
$fur_length = $_GET['fur_length'];
$age = $_GET['age'];
$desexed = $_GET['desexed'];
$microchipped = $_GET['microchipped'];
$suburb = $_GET['suburb'];
$pound_area = $_GET['pound_area'];
$contact = $_GET['contact'];
$link = $_GET['link'];
$columns = $_GET['columns'];
$find = $_GET['find'];
$searching = $_GET['searching'];


// We perform a bit of filtering 
$find = strtoupper($find); 
$find = strip_tags($find); 
$find = trim ($find); 
 
//Check to see if there's a page number, if not, set it to 1
if (!(isset($pagenum))) 
{ 
$pagenum = 1; 
} 
//Count the number of results based on the search term
$numresultsSQL = "SELECT *, MATCH(animalID, status, date, species, breed, sex, primary_colour, colour, distinctive_traits, fur_length, age, desexed, microchipped, suburb, pound_area, contact, img_data, notes) AGAINST ('%$find%' IN BOOLEAN MODE) AS score FROM animal_info WHERE MATCH(animalID, status, date, species, breed, sex, primary_colour, colour, distinctive_traits, fur_length, age, desexed, microchipped, suburb, pound_area, contact) AGAINST('%$find%' IN BOOLEAN MODE)"; 
$numresults = mysql_query($numresultsSQL) or die (mysql_error()."<br><br>Encountered when atemptempting to run the following query:<br>$numresultsSQL");
$rows = mysql_num_rows($numresults);
$idForPicture = "SELECT ID FROM animal_info WHERE animalID='$find'";
$idResults = mysql_query($idForPicture) or die (mysql_error()."Couldn't get an ID from the record");
//How many results should be per page?
$page_rows = 1;
//What is the last page number?
$last = ceil($rows/$page_rows); 
//Make sure the page number isn't a negative number or more than the maximum page required
if ($pagenum < 1) 
{ 
$pagenum = 1; 
} 
elseif ($pagenum > $last) 
{ 
$pagenum = $last; 
} 
//Now we search for our search term, in the field the user specified  so we know how many pages to link to at the bottom
$data = "SELECT *, MATCH(id, animalID, status, date, species, breed, sex, primary_colour, colour, distinctive_traits, fur_length, age, desexed, microchipped, suburb, pound_area, contact, img_data, notes) AGAINST ('%$find%' IN BOOLEAN MODE) AS score FROM animal_info WHERE MATCH(animalID, status, date, species, breed, sex, primary_colour, colour, distinctive_traits, fur_length, age, desexed, microchipped, suburb, pound_area, contact) AGAINST('%$find%' IN BOOLEAN MODE) LIMIT 0,1";
$id = $row['id'];
$img_mime = $row['img_mime'];
$content = $row['img_data'];
$results = mysql_query($data) or die(mysql_error());
//edited here
if (mysql_num_rows($results) < 1) {
echo "$noResults";
}
elseif(mysql_num_rows($results) > 0) {
//And we display the results of the search query as long as there is some
while($row = mysql_fetch_array($results))
{ 
//Build the HTML for the results in the table
echo "$resultsHTMLabove";
echo " --Page $pagenum of $last-- <p>";
echo "<br><BR>";
//Here's the table
echo "<table width=\"100%\" border=\"0\" cellspacing=\"5\" cellpadding=\"2\">";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Animal ID</th>";
echo "<td>".$row['animalID']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Status</th>";
echo "<td>".$row['status']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Date</th>";
echo "<td>".$row['date']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Species</th>";
echo "<td>".$row['species']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Breed</th>";
echo "<td>".$row['breed']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Sex</th>";
echo "<td>".$row['sex']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Primary Colour</th>";
echo "<td>".$row['primary_colour']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Colour</th>";
echo "<td>".$row['colour']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Distinctive Traits</th>";
echo "<td>".$row['distinctive_traits']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Fur Length</th>";
echo "<td>".$row['fur_length']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Age</th>";
echo "<td>".$row['age']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Desexed?</th>";
echo "<td>".$row['desexed']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Microchipped?</th>";
echo "<td>".$row['microchipped']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Suburb</th>";
echo "<td>".$row['suburb']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Pound Area</th>";
echo "<td>".$row['pound_area']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Contact</th>";
echo "<td>".$row['contact']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Link</th>";
echo "<td><a href='".$row['link']."' target=_blank >Link to Facebook</a></td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Notes</th>";
echo "<td>".$row['notes']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\" align=\"left\">Photo</th>";
echo "<td>";
echo "<img src=\"getimage.php?id=".$row['ID']."\" width=\"200px\" height=\"150px\" />";
echo "</td>";
echo "</tr>";
echo "</table>";
echo "<BR><BR>";
//Build the navigation
if ($pagenum == 1) 
{
} 
else 
{
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=1&find=$find&columns=$columns&searching=$searching'> <<-First</a> ";
echo " ";
$previous = $pagenum-1;
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous&find=$find&columns=$columns&searching=$searching'> <-Previous</a> ";
} 
//This does the same as above, only checking if we are on the last page, and then generating the Next and Last links
if ($pagenum == $last) 
{
} 
else {
$next = $pagenum+1;
echo " <a href='{$_GET['PHP_SELF']}?pagenum=$next&find=$find&columns=$columns&searching=$searching'>Next -></a> ";
echo " ";
echo " <a href='{$_GET['PHP_SELF']}?pagenum=$last&find=$find&columns=$columns&searching=$searching'>Last ->></a> ";
} 
echo "<br><BR>";
//And we remind them what they searched for 
echo "<b>You searched for:</b> " .$find; 
echo "</div>";
//Build the footer part of the page
echo "$resultsHTMLbelow";
} 
//If there wasn't any results, we say thanks for searching, but we couldn't find anything that was worth showing and ask them to try again
if ($numresults == 0) 
{ 
//Once again, build the HTML output of the page for the "No Search Results" page
echo "$noResultsSearch";
}
}
}
?>

Really confusing to say the least.  Could anyone shed some light?  Any help would be appreciated!

Cheers,

Dave

I'm having a weird issue with any elements that are given a width: 100% or width: auto. If the window is re-sized smaller. It seems to cut a chunk off and wreck hell upon the layout. I thought it was my code so I borrowed a few from tutorials etc with the same results. I've just installed FireFox also, thinking it was a Chrome bug, but that gives the same result too..     http://shanesdomain.byethost32.com/     I might be missing something obvious from lack of sleep, but could anyone assist this? 

body
{
	background: url(../images/background.jpg) no-repeat center center fixed; 
	-webkit-background-size: cover;
	-moz-background-size: cover;
	-o-background-size: cover;
	background-size: cover;
}



#topbar-navigation
{
	width: auto;
	height: 48px;
	background: #080d10;
	position: absolute;
	margin-left: auto;
	margin-right: auto;
	top: 0;
	left: 0;
	right: 0;
	display: inline-block;
	text-align: center;
	border-bottom: 1px solid #262b2f;
	z-index: 1;
}



#adblock-warning
{
	width: auto;
	position: absolute;
	margin-left: auto;
	margin-right: auto;
	top: 0;
	left: 0;
	right: 0;
	background: #344152;
	font-family: 'sinkin_sans400_regular';
	color: #b6b6b6;
	padding-top: 10px;
	padding-bottom: 10px;
	margin-top: 49px;
	text-align: center;
	font-weight: normal;
	font-size: 10px;
	white-space: nowrap; 
}



#maincontainer
{
	width: 960px;
	height: 1000px;
	position: absolute;
	margin-left: auto;
	margin-right: auto;
	margin-top: 150px;
	top: 0;
	left: 0;
	right: 0;
	background: #f2f2f2;
}





.user-icon-notif
{
	height: 20px;
	width: 20px;
	position: absolute;
	margin-left: auto;
	margin-right: auto;
	margin-top: 15px;
	top: 0;
	left: 875px;
	right: 0;
}



.user-register
{
	height: 20px;
	width: 20px;
	position: absolute;
	margin-left: auto;
	margin-right: auto;
	margin-top: 15px;
	top: 0;
	left: 815px;
	right: 0;
	text-decoration: none;
	font-family: 'sinkin_sans400_regular';
	font-size: 11px;
	color: #99a0a8;
}



.user-register:hover
{
	color: #c9c9c9;
}


.user-login
{
	height: 20px;
	width: 20px;
	position: absolute;
	margin-left: auto;
	margin-right: auto;
	margin-top: 15px;
	top: 0;
	left: 700px;
	right: 0;
	text-decoration: none;
	font-family: 'sinkin_sans400_regular';
	font-size: 11px;
	color: #99a0a8;
}



.user-login:hover
{
	color: #c9c9c9;
}

<!DOCTYPE html>

<html>

<head>
		
		
		
	<META HTTP-EQUIV="Content-Type" content="text/html; charset=utf-8">
	<META HTTP-EQUIV="content-language" content="EN">
	<META NAME="Rating" content="General">
	<META NAME="Designer" content="Shane Wilson">
	<META NAME="Keywords" content="Gamer, Community">
	<META NAME="revisit-after" content="7">
	<META NAME="Robots" content="index,follow">
	<META HTTP-EQUIV="Cache-Control" content="no-cache">
	<META HTTP-EQUIV="Expires" content="0">
	<META NAME="Author" content="Shane Wilson">
	
	
		
	<link rel="stylesheet" type="text/css" href="css/index.css">

	
	

</head>

<body>


	<div id="topbar-navigation">
		<a href="register" class="user-register">Register</a>  <a href="login" class="user-login">Login</a>
	</div>
	
	
	
	<div id="maincontainer">
		
	</div>
	
	
	
	
	
	
	
	
	
	<script type="text/javascript" src="http://shanesdomain.byethost32.com/js/advertisement.js"></script>
	
	
	<script type="text/javascript">

		if (document.getElementById("TestAdBlock") == undefined)

		{

			document.write('<div id="adblock-warning">Oops! It looks like you are using AdBlock. We know adverts can be annoying, but in order to keep the site running we have to display them</div>');

		}

	</script>
	

</body>

</html>

Hi guys,

In my connection.php I have:

$db->query("DROP TABLE IF EXISTS mydata") ;

$db->query("CREATE TABLE mydata
(
ID INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
guid INT,
title VARCHAR(100),
body LONGTEXT,
term VARCHAR(100)
)"); 

and my query code :

$myarray = array (
    guid =>  100,
    title => "title test",
    body => "just a test",
    term => "term test",
);

$myplaceholders[] = '(' . implode (", ", array_fill(0, count($myarray), '?')) . ')'; //also tried '(?,?,?,?)'

$mykeys = implode(', ', array_keys($myarray));

array_push($values, ...array_values($myarray)); //also tried $values = array_values($myarray) ;

$res = $db->prepare("INSERT INTO mydata ($mykeys) VALUES " . join(', ', $myplaceholders)) ;

if ($res->execute($values)) {
    echo 'data inserted';
} else {
    echo 'error in query';
}

After executing the code, the table is created but no data is inserted. The strange thing is when I leave the create table statement  out of the connection.php and run the code the data is inserted. Any ideas where I'm going wrong?

Hello.  I could use some advice on the best way to handle my shopping cart.

My website will sell subscriptions along with more traditional items like books, t-shirts, etc.

For subscriptions, I have these business rules...

1.) Only non-members can purchase a "trial subscription".

2.) Once you are a "member", then no more trials for you!

3.) You can purchase multiple subscriptions (e.g. into the future), BUT I only allow you to purchase ONE subscription at a time.  (My system would allow multiple purchases at once, but I don't ant people accidentally signing up for 2 years and then i have to clean things up.  Also, I want the transition from a "trial" to a "full paid" subscription to be clear.)

4.) if I ever offer multiple "trial" offers, then you only get to take advantage of one, and then after that it's on to full paid subscriptions for you - although I will run "promos".

 

Here is the problem...

Nothing stops a non-member (or a member) from adding a "paid" and a "trial" subscription into their shopping cart.  Or multiple "trial" subscriptions.  Or multiple "paid" subscriptions.  (Maybe someone adds a paid subscription on Friday, then the weekend comes, and on Monday they notice the trial subscription offer and add that forgetting about the paid subscription.)

Or maybe someone is trying to "game" things, and adds 3 "trial" subscriptions and tries to check out?!

 

How should my website (gracefully) handle these scenarios?

 

1.) Am I aggressive up front, and prevent people from adding a 2nd subscription to their shopping cart as they shop?

2.) Or do I allow them to go wild while shopping, but then address the issue at checkout?

3.) Should my code be doing the work, or is the onus on the user to go in and clean up their shopping cart?

4.) If I address this issue at checkout, then do I need to add extra functionality to adjust their shopping cart from the checkout page on-the-fly?  Or do I send them back to their actual shopping cart page and make them clean things up there?

5.) What do I do if someone has already added other items to their cart previously (e.g. T-shirts).  Do I handle the "Get this offer" separately hoping to get them signed up ASAP, and then leave the T-shirts in their cart to purchase later?  Or do I handle everything at once?  (If they just have a "trial" subscription and a T-shirt, no worries.  But if they have a "paid" subscription and then add a "trial" subscription and are looking for a quick checkout, then the scenarios/concerns above come into play...)

 

The stuff I was asking about last night is what got me to thinking about all of this.

The flow was supposed to go...  User sees "get one month for $1" on the home page, clicks the button, gets a trail-offer details paid, clicks "Get this offer", and wah-lah, they are on the checkout page!  But if they already have things in their cart or maybe click the offer button 10 times, then things get messier.

My concern is that converting a user to a paid member is the #1 goal, and I don't want other things to get in the way, whether that is a complicated checkout or things getting distracted purchasing other things like T-shirts!  At the same time, if you want to buy multiple things, all the better as long as you follow my business rules.

 

So what's the best way to not be a pain to shoppers, but to maintain the rules I mention above?

 

Edited September 9, 2020 by requinix
edited at author's request

Hey, been banging my head against the wall for a couple of hours now.
There is an If () in the code that is driving me crazy because it is not behaving like I expect it to..


foreach ( $types as $type ) {
    if ( !isset( $type->modclass ) or !isset( $type->typestr ) ) {
        debugging( 'Incorrect activity type in ' . $modname );
        continue;
    }
    $var = (string)$type->type;
    if ( $var != 'assignment&type=online' ) {

        print '<br/>' . $var . '<br/>';
        
        if ( $type->modclass == MOD_CLASS_RESOURCE ) {
            $resources[$type->type] = $type->typestr;
        } else {
            $activities[$type->type] = $type->typestr;
        }
    }
}


results in...

Code: [Select]
label

resource&type=text

resource&type=html

resource&type=file

resource&type=directory

resource&type=ims

assignment_group_start

assignment&type=upload

assignment&type=online

assignment&type=uploadsingle

assignment&type=offline

assignment_group_end

 

Notice the assignment&type=online in the output... I'm just about ready to give up as to why it is still outputting $var when it is clearly equal to the compared string?

Any ideas?

I am trying to force the "default" behavior in the Switch statement below.

Why does having a "0" trigger the first Switch statement and not the last one??


switch (0){
/* switch ($resultsCode){ */
// Insert Succeeded.
case 'ACCOUNT_MEMBER_ACCT_CREATED':
echo '<h1>Member Account Created</h1>';
echo '<p>Congratulations!</p>
<p>Your account has been created, and a confirmation e-mail sent to: "' . $email . '"</p>
<p>Please click on the link in that e-mail to activate your account.</p>';
break;

// Insert Failed.
case 'ACCOUNT_MEMBER_ACCT_FAILED':
echo '<h1>Account Creation Failed</h1>';
echo '<p>You could not be registered due to a system error.</p>';
echo '<p>Please contact the System Administrator.</p>';
break;

// Default Error.
default:
echo '<h1>Error</h1>';
echo '<p>Oops!  A system error has occurred.  Please try again.</p>';
echo '<ul class="button2">
<li>
<a class="testButton" href="' . BASE_URL . 'members/create_account.php">Create Account</a>
</li>
</ul>';
break;
}



Debbie

Hi all,

I have another uestion. I am currently working with an XML document that has some comments in it that need to stay however it is messing up my parser that I am working on. How can I get around this issue and make the php parser ignore the comments? here is a snippet of the code I am working on.

php
Code: [Select]
//open XML file containing data for current slide

$currentslidefilepath = "slides/xml/";
$currentslidefilepath .= $slides[$currentslide];
$currentSlideXml = simplexml_load_file($currentslidefilepath); 

XML
Quote

<!-- there are some comments here -->

<Basic>
         <another>some data</another>
</Basic>

Hey guys not sure if this is the right spot for this 100% but I hope it is.

 I have a website that I'm making for a class project and I would like it to be a Movie Review type site. What I want to happen is that a person searches for the movie, and once if they find the movie it goes to another page saying if it was found or not. And if it was found information of the movie would come up. I made a comment section for people to be able to post what they thought about the movie. (It doesn't work yet but it should be up soon)

But anyway how would I make it so like say a person searches for "avatar" and the movie pops up with the information, that the review is for avatar and only avatar. Then next they search for Lord of the rings, and only lord of the rings reviews pop up?

And just to let ya know I'm not a super coder with this stuff and I am using dreamweaver cs5 to do a lot of the coding. Any and all help would be appreciated.

What does this code do/mean?

 /*
 * @the vars array
 * @access private
 */


TomTees

I have one small question about comments.

say you have a code like this

Code: [Select]
<?php 

$lol = 1;
$rofl = 2;
$lmao = 3;
// Above are my variable's 

echo 'this does not get executed because the apostrophy in the comment acts as the start';

?>

Now if I wrote this code the apostrophe in variable acts as a quote and does not end until it meets another to end it. Why does this do that? I thought that when you start a comment that whole line gets ignored. 

Could this possible be happening because of my text editor( I use textpad )? If so could you recommend a good text editor, thanks.

Hello,

I have built a blog in php but. On each article in the blog people are able to comment.

I would now like to build a system where people can vote on the comment up/down with Ajax.

In my comments database I have a table that looks like this:

id / article_id / user_id / dateposted / comment    / voteup / votedown

I would like it to look like this:


Any ideas how I can do this? Tutorials online?

Thanks a million

Hi all,

I've got a news table as such;

  `id` int(255) NOT NULL auto_increment,
  `title` mediumtext NOT NULL,
  `postedby` mediumtext NOT NULL,
  `text` mediumtext NOT NULL,
  `brief` mediumtext NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `image` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)

I was wondering in PHP how would i be able to add comments to the news?

i.e

Form: Name, IP (hidden), comments
I'll add the name, ip and comments to the database

But how do i go around adding that into php?

Hi,
i wonna put on my website to ghosts can post comments and registred users, and i made 2 tables ghosts and users, now i need method to save ghosts on that table, but how to save them with uniq number?
I tried session_id, but it works bad, when someone comment it write in db his session_id, but after some time, when someone else comment, it can get his session_id, or no ?