PHP - What To Do With My Php Code Base?

Hello First of all thanks for your help in advance. I build a members website and can use HTML but seem to be going round in circles with php.
So Ive made a page that allows users to input there details and register this DOES Work and adds the data to a mysql data base. However I would like when they click register it sends them a email to confirm there info and at the same time send myself one so I can check there details. this is the link http://www.asian-travel-club.co.uk/php/files/register.htm
Once this is done I would like to be able to see on a admin page that has a username and password  to allow me to active and deactive there members. I know this would need a button added this is where I get lost. the link to the admin page ive made is http://www.asian-travel-club.co.uk/php/files/admin/ Then once i actived them they will recive an auto activtion email .

I dont seem to be able to see data from the Database on mysql but i can interact with it.
As one you register if you try to log in it say that the username and passwodr is incorrect. I TAKE IT IS BECAUSE THE USER DOES NOT HAVE PERMISSION> how do i do this? Any way if you go to forot password page it allows you to enter data and on submittion it chz the database and then sends you an email with your username and password attached. This is the link to the password recover page.
http://www.asian-travel-club.co.uk/php/files/password_recover.php

this is what is in my config.php

<?php

define('DB_SERVER', ''); // database server/host

define('DB_USER', ''); // database username

define('DB_PASS', ''); // database password

define('DB_NAME', ''); // database name
?>

Please help if you can

Hi

Hopefully someone can help me. My knowledge of PHP doesnt go any further than looking at identifying areas of code and copy and paste - as basic as you get!

Basically i have a php script installed that produces an RSS feed for me to use with google base. There is a little problem were it does not pull the sale price(known as special)  into googlebase and it will instead show the original price. I have identified what needs to be changed but i dont know the correct syntax.


I somehow need to get something similar to the following IF ELSE into the code below (this is taken from the same php script that shows the special price on the actual rss feed)

foreach ($product_data as $result) {
   $special = $model_catalog_product->getProductSpecial($result['product_id']);
   if ($special) {
      $price = $special;
   } else {
      $price = $result['price'];
   }
   if ($useTax) {
      $price = $currency->format($tax->calculate($price, $result['tax_class_id'], $config->get('config_tax')), $currency->getCode());
   } else {
      $price = $currency->format($price, $currency->getCode());
   }


The code below is were i need the If Else inserted.


<?php foreach ($products as $product) { ?>
   <item>
        <title><?php echo htmlspecialchars($product['name'], ENT_QUOTES, 'utf-8'); ?></title>
        <g:brand><?php echo htmlspecialchars($product['brand'], ENT_QUOTES, 'utf-8'); ?></g:brand>
      <g:condition>new</g:condition>
      <g:product_type><?php echo $taxonomy; ?></g:product_type>
        <description><?php echo htmlspecialchars($product['desc'], ENT_QUOTES, 'utf-8'); ?></description>
        <link><?php echo str_replace('&', '&amp;', $product['href']); ?></link>
        <pubDate><?php echo $product['add_date']; ?></pubDate>
        <!--guid isPermaLink="true"><?php echo $product['href']; ?></guid-->
        <g:id><?php echo (int)$product['id']; ?></g:id>
      <!--g:upc><?php echo sprintf("%012s", $product['id']); ?></g:upc-->
        <g:image_link><?php echo $product['thumb']; ?></g:image_link>
      <!--g:expiration_date>2010-01-01</g:expiration_date-->
      <g:price><?php echo $product['price']; ?></g:price>
      <g:mpn><?php echo htmlspecialchars($product['model'], ENT_QUOTES, 'utf-8'); ?></g:mpn>
      <g:weight><?php echo $product['weight']; ?></g:weight>
      <g:currency><?php echo $config->get('config_currency'); ?></g:currency>
   </item>
<?php } ?>


The <g:price> is what googlebase reads to get the price of the product. The problem seems to be that there is no if else statement here to output the special price if there is one.


Any help would be greatly appreciated, i tired emailing the developer but i have been ignored and as you can see i'm pretty clueless 

i have php code,

<?php

include ("connect.php");
$selecteddate = $_POST['sdate'];
$sql1 = "select date from game1";
$query1 = mysql_query($sql1) or die(mysql_error());
while($row = mysql_fetch_assoc($query1))
{
$rowdate = $row['date'];
// problem here i this while loop only compare my latest last value in
database. i want a code here which search all the data in "date" field.
}
if($selecteddate == $rowdate)
{
echo "Date already Exists";
}

else
{
// form insertion data code here which i have and working fine
}
SHINSTAR is online now Add to SHINSTAR's Reputation Report Post      Edit/Delete Message

My goal was to create a constant that could be included on the pages, that no matter where it was located in the structure, would be able to find the template files, css, images, etc.  using the following code:

Code: [Select]
if($_SERVER['HTTP_HOST'] == "localhost"){
    define('SITEURL', 'http://' . $_SERVER['HTTP_HOST']);
    define('SITEPATH', $_SERVER['DOCUMENT_ROOT']);
    define('CSS', $_SERVER['DOCUMENT_ROOT'] . '/css/');
    define('IMAGES', $_SERVER['DOCUMENT_ROOT'] . '/images/');
}
else{
    define('SITEURL', 'http://' . $_SERVER['HTTP_HOST']);
    define('SITEPATH', $_SERVER['DOCUMENT_ROOT']);
    define('TEMPLATE', $_SERVER['DOCUMENT_ROOT'] . '/incs/template/');
    define('CSS', $_SERVER['DOCUMENT_ROOT'] . '/css/');
    define('IMAGES', $_SERVER['DOCUMENT_ROOT'] . '/images/');
}

I put the above in a variables.php file that is in the includes folder (named incs) and I call it using the typical include statement.

The problem is that when I use the constant to grab the CSS file, its not working when using:

Code: [Select]
<link rel="stylesheet" href="<?php echo CSS . "template.css" ?>" type="text/css" media="screen" />

I can view the page source and it has the path right, but I cannot figure out how to get it to actually pull in the css file.  I know the echo command is not correct, at least I dont think it is, but have not been able to figure out any other way.

Also, is there a better way to define the constants to the file locations and have it automatically detect whether its on the test server or production and then be able to reference those locations no matter where it is in the structure?

i have just sent the last 4 hours trying to connect to the msql database here is the to sets of code i i'm using

<?php
$db_host = "host";
$db_usernamen = "username";
$db_pass = "password"
$db_name = "database name";

mysql_connect("$db_host","$db_username","$db_pass") or die ("couldnot connect to mysql");
mysql_select_db("db_name") or die ("no database");
?>

this code i'm using to connect to the database

<?php
require "connect_to_mysql.php";

echo "<h1>success in database connection! happy coding</h1>";
?>
and i have used this one as a quick test.

i have up loaded the the two codes to the sever however when i opened the web site to test it all i get is a blank screen. i have looked at a number of codes like this one and i can't see anything wrong with the code. i have uploaded the codes three times just in case the files had been corrupt while uploading have every this has not work

if anyone can help i would be very greatful

ok let say i pull a video from youtube if i post the info into the textarea and pass it into SQL the data/text has then  been change some words have been change or deleted
i know that it's happening before it makes it into the SQL and i know there is a way to make it work just dont know how
i know there is a  way bc if u was to edit your SQL base using phpmyadmin it works fine they use a textarea and a few other things but cant tell just what they are doing to make it work praying someone know a fast way to make it work

would think it would be like a onSubmit change all html codes (< > any other) into some other code then change back later before they get put into SQL but not sure how to do this

im not the best with php if u dont mind can you give me more info ? lol if not then meh i will work with whatever i can get lol
looked all over the net for this with no luck ty you for your time

Hi ,

 Presently we are preparing an excel for download report by querying to data base.
 We are querying to DB and looping through each result row and writing to excel.
for 2lacs data its  too much time.

I found the time taken max in DB query and processing the DB data .
Ant way I can make it faster ?

Any parallel processing I can apply to get it faster......I expecting Huge data report in future.

 

hi all ,,

I have a table : test (id , name , title , area , city)

and I want from user to insert more than one record ..

I made the script but I don't know there are better than this code ..


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>My test</title>
</head>
<body>
<table align="center" width="70%">
<tr>
<form action="<?php $_SERVER['PHP_SELF']?>?>" method="get">


<?php
if($_GET['submit']){
$con = mysql_connect("localhost","root","");
$db = mysql_select_db("test",$con);
for($i = 1 ; $i < 10 ; $i++){
$name = $_GET['name'.$i];
$title = $_GET['title'.$i];
$area = $_GET['area'.$i];
$city = $_GET['city'.$i];
$sql = "INSERT INTO `test`.`test` (`title` ,`name` ,`area` ,`city`)VALUES ( '$name', '$title', '$area', '$city');";
$query = mysql_query($sql , $con);

}
}else { 
$con = mysql_connect("localhost","root","");
$db = mysql_select_db("test",$con) or die (mysql_error());
echo '<tr><td>Name</td><td>Title</td><td>Area</td><td>City</td></tr>';
for ($i = 1 ; $i < 10 ; $i++){
echo '<tr><td><input type="text" name="title'.$i.'" /></td>
 <td><input type="text" name="name'.$i.'" /></td>
<td><input type="text" name="area'.$i.'" /></td>
<td><input type="text" name="city'.$i.'" /></td></tr>
<br />

';
}
echo '<tr><td colspan="4"><input type="submit" name="submit" value="submit" /></td></tr>';


}
?>
</form>
</tr>
</table>
</body>
</html>



I wait you to advise me and I want your opinion ..

than you very much ..

 

in my php PDO system im have to use finger print reader for user input. i cannot find any codes related to that. im using suprema finger print reader. please suggest me solutions. thanks

Hi everyone,

Here's the part of the script I think is wrong :

<?php
include "util/log.php";
include "util/connect.php";

if (loggedin() == $NO)
{   
   header("Location: login.php");
   exit();
}

else if (isset($_GET["p"]))
{
   $udata = explode("-", $_COOKIE["log"]);
   $query = "SELECT * FROM l_users WHERE user='$udata[0]'";
   $usrsql = mysql_query($query) or handledberror(mysql_error());
   $usrdata = mysql_fetch_array($usrsql);
   switch ($_GET["p"])
   {
      case "delete":
         include "util/linkfunc.php";
         if (isset($_GET['id'])) delete_link($_GET['id']);
         else delete_all();
         $CONTENT = "pages/urls.php";
      break;
      case "approve":
         include "util/approve.php";
         $CONTENT = "pages/approve.php";
      break;
      case "urlview":
      case "add":
      case "edit":
         include "pages/modify.php";
         $CONTENT = "pages/edit.php";
      break;
      case "reset":
         include "util/linkfunc.php";
         if (isset($_GET['id'])) reset_link($_GET['id']);
         else reset_all();
         $CONTENT = "pages/urls.php";
      break;
      case "urls":
      default:
      $CONTENT = "pages/urls.php";
   }
}
else
{
   $udata = explode("-", $_COOKIE["log"]);
   $query = "SELECT * FROM l_users WHERE user='$udata[0]'";
   $usrsql = mysql_query($query) or handledberror(mysql_error());
   $usrdata = mysql_fetch_array($usrsql);
   $CONTENT = "pages/urls.php";
}

?>
<html>
<head><title>EzyLinkExpire :: Member's Area</title><head>
<body bgcolor="#1D2B60" link=#CCFFFF vlink=#CCFFFF>

<table align="center"  cellspacing="0" width=90% bgcolor="white" bordercolordark="black" bordercolorlight="black">
    <tr>
      <td bgcolor="#1D2B60"> <img src="images/logo.gif"  border="0"></td>
      <td valign=top bgcolor="#1D2B60" align=right><font color="white" size="1" face="Verdana">Welcome <? print $usrdata["fname"] . " ". $usrdata["lname"]; ?>!<br>User Since: <? print date("F d Y",$usrdata["since"]); ?><br>Server Time:<? print date("r"); ?><br><a href="login.php?a=logout" color=#CCFFFF>Click Here To Logout</a><br><a href="members.php" color=#CCFFFF>Click Here To Goto the Main Page</a></font></td>
   </tr>
   <tr><td colspan=2 height=14 bgcolor="#1D2B60"></td></tr>
   <tr>
        <td width="100%" height="100%" colspan=2 bgcolor="white" bordercolordark="black" align="center" bordercolorlight="black" border=1 valign="top">
           <br><? include $CONTENT; ?><br><br>
        </td>
    </tr>
</table>
</body>

<style type="text/css">
table.t  {border: thin solid #000000; background-color: #FFFFFF}
td.th {border: thin solid #000000; background-color:#FFFFFF; font-style: bold 12px; text-align:center; font-size: 12px; font-weight:bold}
td.t  {border: thin solid #000000; background-color:#FFFFFF; font-style: bold 12px; text-align:center; font-size: 12px; font-weight:bold}
td.te  {border: thin solid #000000; background-color:#FFFFFF;  text-align:center; }
td.ac1 {border: thin solid #000000; background-color:#FFFFFF;  text-align:left; }
td.ac2 {border: thin solid #000000; background-color:#FFFFFF;  text-align:left; }
a.t {color: #3366FF}
a.msg {color: #3366FF}
font.msg {font-style: bold 12px;  font-size: 12px; font-weight:bold}
</style>
<script language='javascript'>
function deleteconfirm()
{
   if (confirm("Are you sure you want to delete all links?"))
      document.location = "members.php?p=delete";
}
function resetconfirm()
{
   if (confirm("Are you sure you want to reset the hit count for all links?"))
      document.location = "members.php?p=reset";
}

</script>
</html>

Thank you,
Sylvain

This topic has been moved to MySQL Help.

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

Hey Guys. I am trying to write to an HTML and attach that file for an efax API. One of the file types they accept is HTML, but it has to be in a <base> tag format. I am a little confused on how to do that. I tried to use fopen with the base tag but it didn't seem to work for me. I got the following error   Warning: fopen(<base a href='96401.html'></base>) [function.fopen]: failed to open stream: No such file or directory   Ideally what I am trying to accomplish is creating a file that just says 96401.html.   Below is the code that I have tried it with. Any help would be really appreciated!!!

$orderFile = "<base a href='".$id.".html'></base>"; // File name to be created. order id is used as a file name e.g. 123456.html
	//$fh = fopen($orderFile, 'w') or die("can't open file"); // Create and Save the writeable File
	//fwrite($fh, $order_information); // Write email contents to created file.

This topic has been moved to mod_rewrite.

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

hello sir,

            i  have to connect database to my live server using 

<?php

define('DB_HOST', 'localhost');
define('DB_NAME', 'oop_pdo_crud');
define('DB_USER', 'root');
define('DB_PASS', '');

?>

or 

 

This is for band website for its event listings. The main event page list everything fine, but once selecting the "Details" link which activates the switch event. Its no longer showing anything. When I had one event in the data base it worked fine, but now I have 3 events in the database and now its not working.

Page can be viewed he http://184.66.66.169/ffy/event.php

Code: [Select]
<?php
 //Event Code Here

$eventid = (isset($_GET["id"])) ? intval($_GET["id"]) : 0;

switch($_GET["list"]=='true')
{
case "0":
if($_GET["id"]== $eventid)
{

$result = mysql_query("SELECT * FROM event ORDER by eventdate DESC");
if (!$result) {
   die("query failed: " . msql_error());
}

while ($row = mysql_fetch_array($result)) {
list($id, $eventdate, $header, $description, $image, $location) = $row;
$description = nl2br($description);
$eventdate = date("M j, Y",strtotime("$eventdate"));

print('
<table width="680" border="0" cellpadding="14" cellspacing="0">
 <tr>
 <td>
<div class="myFont"><font size="+1" color="#4e8baf">'.$eventdate.' - </font><font size="+1"><b>'.$header.'</b></font></div>
<font size="-2" color="#CCCCCC"><a href="event.php?list=true&eventid='.$id.'">Details</a></font><br />
<hr color="#FFFFFF" width="100" align="left" size="1">
</td>
</tr>
  </table>
');

}}
break;
case "true":
if($_GET["id"]==$eventid)
{

$resultd = mysql_query("SELECT * FROM event WHERE id=$eventid LIMIT 1");
if (!$resultd) {
   die("query failed: " . msql_error());
}

while ($row = mysql_fetch_array($resultd)) {
list($id, $eventdate, $header, $description, $image, $location) = $row;
$description = nl2br($description);
$eventdate = date("M j, Y",strtotime("$eventdate"));
print('
<table width="680" border="0" cellpadding="14" cellspacing="0">
 <tr>
 <td>
<div class="myFont"><font size="+1" color="#4e8baf">'.$eventdate.' - </font><font size="+1"><b>'.$header.'</b></font></div>
'.$description.'<br />
<hr color="#FFFFFF" width="100" align="left" size="1">
<center>
'.$location.'
</center>
</td>
</tr>
  </table>
');

}
break;
}}

?>