PHP - Difficulty And Where Best To Start?

Hi, I have a form that I want to allow users to be able to add specific links, some are set types (domains) and just require the iser to enter the link, however, one is for whatever they wish and they must enter a name to describe it.

Now im going to enter it into a database with the following columns:

USER_ID || LINK_URL || LINK_TYPE || LINK_NAME

Link name is optional (only needed if the link type is their own custom one), the link types are ID's related to a table of link types (facebook, twitter etc).

Now I'm assuming that to differentiate the form elements for insertion into the database I would need to have a hidden form element with the type ID inside? However I don't really know how to go on from here.


A small version of the form would be

<input type="text" name="facebook_link" />
<input type="hidden" name="facebook_id value="1" />

<input type="text" name="twitter_link" />
<input type="hidden" name="twitter_id value="2" />

<input type="text" name="own_site" />
<input type="text" name="own_site_description" />
<input type="hidden name="own_site_id" value="3" />


However, I'm assuming this is wrong because I'll need to enter everything into an array won't I? I just can't get my head round it to out put thi results into a foreach statement.


Can anybody help me please?

I'm having a problem with (what I'm almost certain is) variable scope, maybe you can help...

So I've got a parent class that, among other things, gets the name of the filepath, explodes this filepath, checks for files with names that mirror that filepath (without the slashes of course), and includes them if they exist:



class ParentClass {

  public $RootFolder;
  public $PageSections;

  function __construct() {
global $root_folder;
$this->RootFolder = $root_folder;
//get all directory names...
$cleanse = $this->RootFolder;
$pagepath = str_replace($cleanse, '', dirname($_SERVER['PHP_SELF']));
$this->PageSections = explode('/', $pagepath);
  }

  function RequireIfExists ($sections, $root_folder, $file_name, $file_type) {
foreach ($sections as $i){
if (isset($o)) {
$i = $o."/".$i;
}
$file = $root_folder.$i."/".$file_name.$file_type;
if (file_exists($_SERVER['DOCUMENT_ROOT'].$file)) {
require ($_SERVER['DOCUMENT_ROOT'].$file);
echo "<!--".$file." included -->"; //temporary measure to ensure that the file is at least being called.
}
$o = $i;
}
  }
// so, excuting the function
// $this->RequireIfExists($this->PageSections, $this->RootFolder, "sectionvars", ".php");
// on some/sub/folder/index.php
// will look for somesectionvars.php, somesubsecitonvars.php & somesubfoldersectionvars.php
// and include whichever ones exist.
}

Then there is a child class that utilizes this function, and successfully requires the file. I know the file is coming through because the echo statement on the page shows up in the code, but I cannot get the variables to pass through?


<?php
class HtmlHead extends PageBlock{
public $PageKeywords;
public $PageDescription;
public $PageStyles;
public $PageScripts;
//------------------------
public $SectionKeywords;
public $SectionDescription;
//------------------------
public $SiteKeywords;
public $SiteDescription;
public $SiteStyles;
public $SiteScripts;
//------------------------
public $CatchAll;

  function __construct() {
parent::__construct();
//$this->RequireIfExists($this->PageSections, $this->RootFolder, "sectionvars", ".php");  //I have tried calling the function here with no luck
global $site_description, $site_keywords, $section_description, $section_keywords, $xyz; //also made sure to global the variables from the required page
$this->SiteDescription = $site_description;
$this->SiteKeywords = $site_keywords;
$this->SectionDescription = $section_description;
$this->SectionKeywords = $section_keywords;
$this->PageDescription = $page_description;
$this->PageKeywords = $page_keywords;
  }

function Constructor() {
$this->RequireIfExists($this->PageSections, $this->RootFolder, "sectionvars", ".php"); //Tried calling the function here as well, no luck
global $xyz; //global'd the var i want
echo "\n<meta http-equiv='Content-Type' content='text/html; charset=UTF-8' />";
echo "\n<!--Sec Keywords are".$xyz."-->"; //Tried to echo the var...
//------------------------Rest of code...
}
}


And here is the page that is being required...


<?php
echo "<!-- 1234 1234 1234 1234 -->"; //test measure to see if/where file is including
$section_keywords = "red, secondary";
$section_description = "this is the red section description";
$xyz = "1234"; //test Var to see if there was a naming conflict with the above two..
?>


What am I overlooking this time?   

Hello,   I recently posted here about an issue I was having with my database orientated products page.   I have now run into another problem where say if, /db.php was typed or /db.php?p=IDoNotExist was typed, it returns blank.   I have in my code the desired content to be displayed, but it just doesn't seem to want to make a show.   I was also wondering if it is possible to show different content for whatever the URL is, so for no parameter, the content about the products, and a non existent one, maybe "Product not found"?   Here is my code:

<?php
	$db=mysql_connect  ("localhost", "webwibco_charlie",  "Hello123") or die ('I cannot connect to the database  because: ' . mysql_error()); 
	$mydb=mysql_select_db("webwibco_products"); 

	include("header.php");

	$status = htmlspecialchars( @$_GET ['p'] );

	if ($status == "floorpuzzles") {

		     echo "<h1>Our Floor Puzzles</h1>";
		$sql="SELECT  ID, Name, Tags, Description, Category FROM products WHERE Category LIKE '%" . FloorPuzzles .  "%'"; 
		$result=mysql_query($sql); 
		while($row=mysql_fetch_array($result)){ 
			$Name  =$row['Name'];
			$ID  =$row['ID']; 
			$Description  =$row['Description'];  
			echo "<div class=\"box\">";
			echo "<h1>$Name</h1>";
			echo "<div class=\"floorbox\"><a href=\"?p=$ID\"><img src=\"images/products/catalogue/big/floorpuzzles/$ID.jpg\" class=\"small\"></a></div>";
			echo "<h2>$Description</h2>";
			echo "</div>";
		}
?>
<?
}else{



	if ($status == $_GET["p"]) {
		$sql="SELECT  ID, Name, Tags, Description, Pieces, Size, Barcode, Category FROM products WHERE ID = '" . $_GET['p'] .  "'";   
		$result=mysql_query($sql);   
		while($row=mysql_fetch_array($result)){  
			$Name  =$row['Name'];
			$ID  =$row['ID']; 
			$Description  =$row['Description']; 
			$Pieces  =$row['Pieces']; 
			$Size  =$row['Size']; 
			$Barcode  =$row['Barcode'];   
			echo "<div class=\"1\">";
			echo "<h1>$Name</h1>";
			echo "<div class=\"bigbox\">";
			echo "<div class=\"floorbox\"><img src=\"images/products/catalogue/big/floorpuzzles/$ID.jpg\" class=\"big\"></div>";
			echo "</div>";
			echo "</div>";
			echo "<div class=\"2\">";
			echo "<p>Puzzle Pieces: $Pieces</p>
				  <p>Puzzle Size: $Size</p>
				  <p>Barcode: $Barcode</p>";
			echo "</div>"; 
		} 
		}else{
?>
<?
			echo"<h1>Our Products</h1>
				<p>Our jigsaw puzzles are hand cut by skilled craftsmen and therefore each one is unique with self-correcting pieces. There is a strict quality control process at all stages by our highly experienced staff. The puzzles are durable and provide fun and excitement, enhancing learning and a child’s development.<p>
				<p>All of our jigsaws are made using materials from sustainable resources grown in managed forests. Where possible we support companies in the UK and source our components locally, most of our suppliers are in the East Midlands, many in Derbyshire and Nottinghamshire. We keep packaging to a minimum and take our environmental and ethical responsibilities very seriously.</p>
				<p>Reducing waste and recycling was a way of life for us before it became fashionable. We are constantly searching for new ideas and consult teachers when developing our jigsaws, which are often used within the national curriculum.</p> 
				<p>As well as making our own range, we manufacture for leading suppliers to the education market. Check for \"Made in Britain\" and it is probably made by us.</p>
				<p>We have a wide variety of products available for viewing, from classic floor puzzles to innovative inset trays. You can take a look at all our products on this page, simply use the navigation buttons to your left.</p>";

				
				}}

include("footer.php");
?>

The final echo is what I wish to be displayed on the URL without or with an invalid parameter.   Here is my site URL: http://www.webwib.co...saws/search.php (note that only the "Floor Puzzles" category has content within it).   Thank you in advance for assistance.

On my website I currently have it set up so that each user can pick there "avatar" (little picture or icon)
Each user has the same choices but they all can pick different ones.

I want to make it where they can upload their own picture and have a custom avatar.

Where Should I start?

Hello everyone,

I have started PHP not so long ago and I must admit that this whole world is quite confusing. On the internet, we can find everything... A link saying that we should press A and not B, another saying that A must not be pressed and B shoud etc. When looking on the web to learn about PHP, I often find myself more confused at the end of the day than at the beginning of the day.

So I would like to know, with all you've learned in the past years, what would be the best advice you could give to a newbie who's been assigned on a big project and who wants to learn PHP properly ?

Would you tell him to use a templating system ?
Would you tell him to use a PHP framework ?
Would you tell him to use a caching system to store some data ?
What else should be taken in consideration ?

PS: Flexibility is a must for this project

Thanks !

ive been looking around and every tutorial information i get is to show  data in two fields linked now my problem is i have a table with multiple fields adnd need to show it  in one list   to give you an idea of what im talking about   Table is like this Winner       2nd   place    3rd place     3rd place2 player a       player b         player c      player d player h       player f          player e       player g   now what i need to know what  to look for is to get it so that  the list would be like this   Player a player b player c player d player e player f player g player h   looking for something to work from any help on what in php i should look for to accomplish this i would be greatly appreciated

Sometimes my mailserver craps out and I need to restart it.  Since RDP is blocked at my current company, I was hoping to simply make a button on a password protected webpage to start it.  This would be a simple button and no user config so as to reduce security risk (hopefully).

I need to do something like:

echo exec('net start abc');

This works if I use 'whoami' or 'hostname', but not with the 'net' command.

Also, the whoami shows the following:

nt authority\network service

This is using IIS/WIN2003

Hi,

I'm developing an iPhone app that's going to need data from a MySQL database, it's just a simple list of my bands upcoming gigs.

So I understand that I need to build an API - I've found some scripts here and there, I just need some advice as to 'what' I should build...JSON? XML? something else?

I don't know anything about it and cant really find anything that will tell me.

Hopefully, If I can get a good method going I will be able to use it for various other app ideas.


Any suggestions are greatly appreciated.

From where I will get Good Notes ?? which site to refer for cake PHP?

I have been having a coding problem. Went back to the books and came across this bit of information. Can anyone tell me if I should be updating my C drive

Enabling file uploads and sessions. the windows installer designates two folders in your user area as the values for upload_tmp_dir and session.save_path. However, file uploads and sessions won't work unles you create the folders yourself.

In Windows XP go to C:\Documents and Settings\<username>\Local Settings\Temp.

Create a new folder called php, and inside that folder, create two subfolders called upload and session.


Is this information true as it is not set in my computer. Just need to know if this will help my session 

Hi Guys,

I have an events calender which if theres an events it echos a color if blue on the day. I would like to display the start and end dates on the calender in the same way. Example if and events starts 01/01/2012 and ends 03/01/2012.
 
I'm having problems echoing a blue color from 01/01/2012 to 03/01/2012 to indicate the start and end date of the event.
 
The code belows show how I tried to solve the problem, it works but it thinks the event start from the 1st and end on the 3rd of every month which is wrong.

Please show me how I can improve this code or do different to make it work.
Thanks
Code: [Select]
    $todaysDate = date("d/m/Y");
    $dateToCompare = $daystring . '/' . $monthstring . '/' . $year;
    echo "<td align='center' ";
    if($todaysDate == $dateToCompare){
    echo "style='class:red'";
    }else{
    $sqlcount = mysql_query("select * from event where '".$dateToCompare."' >=start_date and '".$dateToCompare."' <=end_date");
    $customerCount = mysql_num_rows($sqlcount); // count the output amount
    while($row = mysql_fetch_assoc($sqlcount)) {
    $start_date = $row['start_date'];
    $end_day = $row['end_day'];
    if($customerCount >= 1){ 
    echo "style='class:blue'";
    }
    }
    }

Hello all.

Is it possible to have a link that can start and stop a service on the web server?  It is a windows 2003 server.

Thanks,
Mike

Hi everyone (sorry for my bad english),