Jump to content

Need help with this script


smiddies.co.uk

Recommended Posts

i think this is in the right section please excuse me if its not

 

please help me with this script it will not work and i dont know why, but when i submit the data then it saves it but doesnt bring up a page,

 

but heres the code

 

<?
include"../config.php";

	$qData = "select * from `settings` where `ID` = '1'";
	$rData = mysql_query($qData) or die(mysql_error());
	if(mysql_num_rows($rData) == '0')
	{
		echo "<br><center><b>No record found in database.</b></center>";
	}
			else
	{
	$aData = mysql_fetch_array($rData);
if(isset($_POST[Are]))
{
$Website_Name 				= $_POST[Website_Name];
$Website_Address 				= $_POST[Website_Address];
$Email_Address 				= $_POST[Email_Address];
$Title 				= $_POST[Title];
$Description 				= $_POST[Description];
$Background_Color 				= $_POST[background_Color];
$Title_Text_Color 				= $_POST[Title_Text_Color];
$Description_Text_Color 				= $_POST[Description_Text_Color];
$Other_Text_Color 				= $_POST[Other_Text_Color];
$Hyperlink_Color 				= $_POST[Hyperlink_Color];
$Visited_Link_Color 				= $_POST[Visited_Link_Color];
$bordcolour					=$_POST[bordcolour];
$Layout_Settings 				= $_POST[Layout_Settings];
$Columns_per_Page 				= $_POST[Columns_per_Page];
$Rows_per_Page 				= $_POST[Rows_per_Page];
$Thumbnail_Image_width_height 				= $_POST[Thumbnail_Image_width_height];
$Thumb_Size 				= $_POST[Thumb_Size];
$Space_between_thumbs 				= $_POST[space_between_thumbs];
$Other_Settings 				= $_POST[Other_Settings];
$Display_File_name 				= $_POST[Display_File_name];
$Sort_File 				= $_POST[sort_File];
$Show_full_sized_image 				= $_POST[show_full_sized_image];
$Popup_windowx 				= $_POST[Popup_windowx];
$Popup_windowy 				= $_POST[Popup_windowy];
$Popup_window 				= "$Popup_windowx x $Popup_windowy";
$Footer_Message 				= $_POST[Footer_Message];
$t					= time();







$q1 = "update `settings` set
`Website_Name` 				= '$Website_Name' ,
`Website_Address` 				= '$Website_Address' ,
`Email_Address` 				= '$Email_Address' ,
`Title` 				= '$Title' ,
`Description` 				= '$Description' ,
`Background_Color` 				= '$Background_Color' ,
`Title_Text_Color` 				= '$Title_Text_Color' ,
`Description_Text_Color` 				= '$Description_Text_Color' ,
`Other_Text_Color` 				= '$Other_Text_Color' ,
`Hyperlink_Color` 				= '$Hyperlink_Color' ,
`Visited_Link_Color` 				= '$Visited_Link_Color' ,
`bordcolour`					= '$bordcolour' ,
`Layout_Settings` 				= '$Layout_Settings' ,
`Columns_per_Page` 				= '$Columns_per_Page' ,
`Rows_per_Page` 				= '$Rows_per_Page' ,
`Thumbnail_Image_width_height` 				= '$Thumbnail_Image_width_height' ,
`Thumb_Size` 				= '$Thumb_Size' ,
`Space_between_thumbs` 				= '$Space_between_thumbs' ,
`Other_Settings` 				= '$Other_Settings' ,
`Display_File_name` 				= '$Display_File_name' ,
`Sort_File` 				= '$Sort_File' ,
`Show_full_sized_image` 				= '$Show_full_sized_image' ,
`Popup_window` 				= '$Popup_window' ,
`Footer_Message` 				= '$Footer_Message'
where `ID` 				= '1'";
mysql_query($q1) or die(mysql_error());

header("location:settings.php");
}
else
{
include("header.php");
echo "<h1>Settings</h1>";




if($aData[Thumbnail_Image_width_height] == Width)
{
$CheckedThumbnail_Image_width_height0 = "checked";
}
elseif($aData[Thumbnail_Image_width_height] == Height)
{
$CheckedThumbnail_Image_width_height1 = "checked";
}

if($aData[Display_File_name] == Yes)
{
$CheckedDisplay_File_name0 = "checked";
}
elseif($aData[Display_File_name] == No)
{
$CheckedDisplay_File_name1 = "checked";
}

if($aData[show_full_sized_image] == Yes)
{
$CheckedShow_full_sized_image0 = "checked";
}
elseif($aData[show_full_sized_image] == No)
{
$CheckedShow_full_sized_image1 = "checked";
}


$WidthHeight = explode(" x ","$aData[Popup_window]");


?>



			<script language="JavaScript">
			function settings(theForm)
			{

			  if (theForm.Website_Name.value == "")
			  {
			    alert("Please enter your Website Name.");
			    theForm.Website_Name.focus();
			    return (false);
			  }
			  
			  if (theForm.Website_Address.value == "")
			  {
			    alert("Please enter your Website Address.");
			    theForm.Website_Address.focus();
			    return (false);
			  }
			  
			  if (theForm.Email_Address.value == "")
			  {
			    alert("Please enter your Email Address.");
			    theForm.Email_Address.focus();
			    return (false);
			  }
			  
		var checkEmail = "@.";
		var checkStr = theForm.Email_Address.value;
		var EmailValid = false;
		var EmailAt = false;
		var EmailPeriod = false;
		for (i = 0;  i < checkStr.length;  i++)
		{
		ch = checkStr.charAt(i);
		for (j = 0;  j < checkEmail.length;  j++)
		{
		if (ch == checkEmail.charAt(j) && ch == "@")
		EmailAt = true;
		if (ch == checkEmail.charAt(j) && ch == ".")
		EmailPeriod = true;
	  if (EmailAt && EmailPeriod)
	break;
  if (j == checkEmail.length)
	break;
	}

	if (EmailAt && EmailPeriod)
	{
	EmailValid = true
	break;
	}
	}
	if (!EmailValid)
	{
	alert("Please enter Valid Email Address");
	theForm.Email_Address.focus();
	return (false);
	}

			  if (theForm.Title.value == "")
			  {
			    alert("Please enter your Title.");
			    theForm.Title.focus();
			    return (false);
			  }
			  
			  if (theForm.Description.value == "")
			  {
			    alert("Please enter your Description.");
			    theForm.Description.focus();
			    return (false);
			  }
			  
			  if (theForm.Background_Color.value == "")
			  {
			    alert("Please enter your Background Color.");
			    theForm.Background_Color.focus();
			    return (false);
			  }
			  
			  if (theForm.Title_Text_Color.value == "")
			  {
			    alert("Please enter your Title Text Color.");
			    theForm.Title_Text_Color.focus();
			    return (false);
			  }
			  
			  if (theForm.Description_Text_Color.value == "")
			  {
			    alert("Please enter your Description Text Color.");
			    theForm.Description_Text_Color.focus();
			    return (false);
			  }
			  
			  if (theForm.Other_Text_Color.value == "")
			  {
			    alert("Please enter your Other Text Colour.");
			    theForm.Other_Text_Color.focus();
			    return (false);
			  }
			  
			  if (theForm.Hyperlink_Color.value == "")
			  {
			    alert("Please enter your Hyperlink Colour.");
			    theForm.Hyperlink_Color.focus();
			    return (false);
			  }
			  
			  if (theForm.Visited_Link_Color.value == "")
			  {
			    alert("Please enter your Visited Link Colour.");
			    theForm.Visited_Link_Color.focus();
			    return (false);
			  }
			  if (theForm.bordcolour == "")
			  {
			    alert("Please enter the Table border Colour.");
			    theForm.bordcolour.focus();
			    return (false);
			  }
			  
			  if (theForm.Columns_per_Page.value == "")
			  {
			    alert("Please enter your Columns per Page.");
			    theForm.Columns_per_Page.focus();
			    return (false);
			  }
			  
			  if (theForm.Rows_per_Page.value == "")
			  {
			    alert("Please enter your Rows per Page.");
			    theForm.Rows_per_Page.focus();
			    return (false);
			  }
			  
			  if (theForm.Space_between_thumbs.value == "")
			  {
			    alert("Please enter your Space between thumbs.");
			    theForm.Space_between_thumbs.focus();
			    return (false);
			  }
			  
			  if (theForm.Popup_windowx.value == "")
			  {
			    alert("Please enter your Popup windowx.");
			    theForm.Popup_windowx.focus();
			    return (false);
			  }
			  
			  if (theForm.Popup_windowy.value == "")
			  {
			    alert("Please enter your Popup windowy.");
			    theForm.Popup_windowy.focus();
			    return (false);
			  }
			  
			  if (theForm.Footer_Message.value == "")
			  {
			    alert("Please enter your Footer Message.");
			    theForm.Footer_Message.focus();
			    return (false);
			  }
			  }
			</script>
This is where you can change the desing of the page. Simply click pick and choose the colour. Easy
<form name="form1" method="POST" enctype="multipart/form-data" action="settings.php" onsubmit="return settings(this)">
<hr />
<center>
  <strong> Do Not Edit Below this unless you need to  </strong>
</center>
<table border="0" width="600">
<tr>
<td width="252">Website Name:</td>
<td width="549"><input type="text" name="Website_Name" size="25" value="<?=$aData[Website_Name]?>" maxlength="150"></td>
</tr>

<tr>
<td width="252">Website Address:</td>
<td width="549"><input type="text" name="Website_Address" size="25" value="<?=$aData[Website_Address]?>" maxlength="150"></td>
</tr>

<tr>
<td width="252">Email Address:</td>
<td width="549"><input type="text" name="Email_Address" size="25" value="<?=$aData[Email_Address]?>" maxlength="150"></td>
</tr>
</table>
<hr />
<center>
  <strong>Can Edit below this</strong>
</center>
<table border="0" width="600">
<tr>
<td width="252">Title:</td>
<td width="549"><input type="text" name="Title" size="25" value="<?=$aData[Title]?>" maxlength="150"></td>
</tr>

<tr>
<td width="252">Description:</td>
<td width="549"><input type="text" name="Description" size="25" value="<?=$aData[Description]?>" maxlength="150"></td>
</tr>

<tr>
<td width="252">Background Colour:</td>
<td width="549"><input type="text" name="Background_Color" size="8" value="<?=$aData[background_Color]?>" id="Background_Color" maxlength="7"> <a href="javascript: openPallete('Background_Color', 0, true)">Pick!</a></td>
</tr>

<tr>
<td width="252">Title Text Colour:</td>
<td width="549"><input type="text" name="Title_Text_Color" size="8" value="<?=$aData[Title_Text_Color]?>" id="Title_Text_Color" maxlength="7"> <a href="javascript: openPallete('Title_Text_Color', 0, true)">Pick!</a></td>
</tr>

<tr>
<td width="252">Description Text Colour:</td>
<td width="549"><input type="text" name="Description_Text_Color" size="8" value="<?=$aData[Description_Text_Color]?>" id="Description_Text_Color" maxlength="7"> <a href="javascript: openPallete('Description_Text_Color', 0, true)">Pick!</a></td>
</tr>

<tr>
<td width="252">Other Text Colour:</td>
<td width="549"><input type="text" name="Other_Text_Color" size="8" value="<?=$aData[Other_Text_Color]?>" id="Other_Text_Color" maxlength="7"> <a href="javascript: openPallete('Other_Text_Color', 0, true)">Pick!</a></td>
</tr>

<tr>
<td width="252">Hyperlink Colour:</td>
<td width="549"><input type="text" name="Hyperlink_Color" size="8" value="<?=$aData[Hyperlink_Color]?>" id="Hyperlink_Color" maxlength="7"> <a href="javascript: openPallete('Hyperlink_Color', 0, true)">Pick!</a></td>
</tr>

<tr>
<td width="252">Visited Link Colour:</td>
<td width="549"><input type="text" name="Visited_Link_Color" size="8" value="<?=$aData[Visited_Link_Color]?>" id="Visited_Link_Color" maxlength="7"> <a href="javascript: openPallete('Visited_Link_Color', 0, true)">Pick!</a></td>
bordcolour</tr>
<tr>
<td width="252">Table border Colour:</td>
<td width="549"><input type="text" name="bordcolour" size="8" value="<?=$aData[bordcolour]?>" id="bordcolour" maxlength="7"> <a href="javascript: openPallete('bordcolour', 0, true)">Pick!</a></td>
</tr>
</table>
<p>
<hr />
<center>
  <strong>Do Not Edit Below this unless you need to  </strong>
</center>
</p>
<table border="0" width="600">
<tr>
<td width="252">Columns per Page:</td>
<td width="549"><input type="text" name="Columns_per_Page" size="5" value="<?=$aData[Columns_per_Page]?>" maxlength="5"></td>
</tr>

<tr>
<td width="252">Rows per Page:</td>
<td width="549"><input type="text" name="Rows_per_Page" size="5" value="<?=$aData[Rows_per_Page]?>" maxlength="5"></td>
</tr>

<tr>
<td width="252">Thumbnail Image width height:</td>
<td width="549"><input type="radio" value="Width" name="Thumbnail_Image_width_height" <?=$CheckedThumbnail_Image_width_height0?>> Width
<input type="radio" value="Height" name="Thumbnail_Image_width_height" <?=$CheckedThumbnail_Image_width_height1?>> Height </td>
</tr>

<tr>
<td width="252">Thumb Size:</td>
<td width="549"><input type="text" name="Thumb_Size" size="5" value="<?=$aData[Thumb_Size]?>" maxlength="7"></td>
</tr>


<tr>
<td width="252">Space between thumbs:</td>
<td width="549"><input type="text" name="Space_between_thumbs" size="5" value="<?=$aData[space_between_thumbs]?>" maxlength="7"></td>
</tr>



<tr>
<td width="252">Display File name:</td>
<td width="549"><input type="radio" value="Yes" name="Display_File_name" <?=$CheckedDisplay_File_name0?>> Yes
<input type="radio" value="No" name="Display_File_name" <?=$CheckedDisplay_File_name1?>> No </td>
</tr>

<tr>
<td width="252">Sort File:</td>
<td width="549"><select size="1" name="Sort_File">
<option value="<?=$aData[sort_File]?>"><?=$aData[sort_File]?></option>
<option value="Title">Title</option>
<option value="Lastest">Lastest</option>
<option value="Viewed">Viewed</option>
</select></td>
</tr>

<tr>
<td width="252">Show full sized image in pop up:</td>
<td width="549"><input type="radio" value="Yes" name="Show_full_sized_image" <?=$CheckedShow_full_sized_image0?>> Yes
<input type="radio" value="No" name="Show_full_sized_image" <?=$CheckedShow_full_sized_image1?>> No </td>
</tr>

<tr>
<td width="252">Popup window Size:</td>
<td width="549"><input type="text" name="Popup_windowx" size="3" value="<?=$WidthHeight[0]?>" maxlength="15"> x <input type="text" name="Popup_windowy" size="3" value="<?=$WidthHeight[1]?>" maxlength="15"></td>
</tr>

<tr>
<td width="252">Footer Message:</td>
<td width="549"><input type="text" name="Footer_Message" size="25" value="<?=$aData[Footer_Message]?>" maxlength="255"></td>
</tr>

    <tr> 
      <td width="252"> </td>
      <td width="549"> </td>
    </tr>
    <tr> 
      <td width="252"> </td>
      <td width="549"><input type="submit" value="Save Changes" name="Are"></td>
    </tr>
</table>
</form>

<?
include("footer.php");
}
}
?>

 

please reply to [email protected]

Link to comment
https://forums.phpfreaks.com/topic/69394-need-help-with-this-script/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.