PHP - Moved: Coding Strategy

This topic has been moved to PHP Applications.

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

Hello,   I'm starting using class and have a question for you guys :    Let's consider a class "customer". I want to code a search tool. Where should I put my search function ? Within the customer class ? In another "search" class ? Other solution ?   Thanks for help !

Hi,

I was asked to create an app, wherein, the user may enter the email addresses of people manually, and it auto generates a random key.
now this key will be used access such pages e.g

proposal.test.com/ppc
proposal.test.com/seo
proposal.test.com/design

so using the key for example =>  Sa22asdf 
it should appear like this

proposal.test.com/ppc/Sa22asdf
proposal.test.com/seo/Sa22asdf
proposal.test.com/design/Sa22asdf


without the unique key generated during the input of email address, the URL mentioned shouldn't be accessed by anyone..
now my question is, how to approach this thing in PHP ?

I have done the input for email address and generation of random keys., but i don't know yet what to do or how to do the
securing of pages using those keys  ? 

am currently building the cart system of a product, now there is this part wherein, the non-logged-in OR logged-in user should also be able to see the items that he/she viewed, how to do that?., am not asking for code snippets , just give me some ideas/hints/strategies/tips that may help me get the big picture on how to do this thing and proceed coding.

This topic has been moved to Miscellaneous.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to PHP Freelancing.

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

Hi guys,

What techniques do you use to process, validate, and then show errors on your forms.

Do you set an "action" to the same form and then handle errors somewhere?
Do you use a separate script to process validation?
What standards do you apply for the position of the error messages?
Do you alter the "look" of any fields in errors (make them red for example)?

Do you have a good standard strategy that can be applied for all forms in a re-usable fashion? Perhaps using functions?

I am looking for a robust, user friendly (and coder friendly come to that) solution to this frequently encountered situation.

Many thanks for any help.

S

This topic has been moved to Editor Help (Dreamweaver, Zend, etc).

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

I am wondering if there is an easier / better way to keep my development and test databases in synch.   When I develop, I may add tables or fields to existing tables. When I upload from the development server to the test server I can check and make sure that I include all of the programs that I have edited by using the filesystems last modified date. However, I keep track of new and changed tables in MYSQL manually. Is there an easy way, that I am just missing, to see last modified dates for tables within a db? Is there some other strategy I should be using. I hate missing a table and having the test server give errors on code I debugged once on the development server.

Hello,

I'm working on a very simple strategy based game site (mainly to expand my knowledge).

What I basically want it to do is, you send a solider to an area which takes, say 20 seconds. After 20 seconds, he battles for 30 seconds, and then arrived back home which takes another 20 seconds.

All the user is going to be seeing is a 'status' echo'ed text saying "Arriving in 00:??", "Battle Over in 00:??", and "Home in 00:??".

So its just using a time counter. But what makes it more complicated, is that I want the time progress to be saved (datebase), so say I have to wait 50 seconds, I can sign off, go on another computer, sign in and still see my timer going down according to the time that has just passed.

So, what I've done so far is, have 4 variables:

$realTime - Holds the actual time in seconds.
$waitingTime - Holds how long I need to wait. (this is stored in my DB)
$differenceTime - Difference between real time and my waiting time. (loaded from my DB)
$soliderProgress - Progress of the solider, so: Arriving, Battle ... (stored on DB)


Code: [Select]
$realTime = date("s");

//soliderProgress is 'Starting' by default
if(soliderProgress == "Starting"){
   //solider is moving to area
   $differenceTime = $realTime + $waitingTime;
   $SQL = ("UPDATE users SET differenceTime='$differenceTime' WHERE username='$username'");
   soliderProgress = "Arriving";
   $SQL = ("UPDATE users SET soliderProgress='$soliderProgress' WHERE username='$username'");
}

if(soliderProgress == "Arriving"){
   echo "Arriving to area";
   if($realTime >= $differenceTime){
      //timer is complete
      soliderProgress = "Battle";
      $SQL = ("UPDATE users SET soliderProgress='$soliderProgress' WHERE username='$username'");
   }
}

This kind of works, but sometimes my $differenceTime is higher than 60 which messes it up, and also the timer isn't live ... so I have to keep refreshing the page

I am refactoring entire collective scattered SQL from my legacy codebase, and into separate classes, and looking for some structure to put it into.

Right now I have folders effectively called `DataFromDB` - contains classes that accepts whatever parameters are given, and returns pure data back to the user `DAO` - Data Access Object, which takes that raw data from DB and makes sense out of it and prepares it for consumption by the model/business logic layer objects. That is:

    - src (folder)
      |- DAO (folder)
        | - ProductADAO (classes - take data in, return consumable objects out)
        | - ProductBDAO
        | - ...
        | - ProductZDAO
      |- DataFromDB (folder)
        | - ProductAData (classes - contain methods to query pure result sets from DB)
        | - ProductBData
        | - ...
        | - ProductZData

Whenever I need to make a new SQL or refactor an old one I do this: What is this SQL doing?  Is it operating on `SomeObjectX`?  If yes, find/create class called `ObjectX`, and add a method to it, extracting pure data from DB, put it into `DataFromDB` folder. Write the `DAO` object if needed to transform data into a consumable object. Use the object as is in my code. Does this look like a good strategy?  Is there a better one?   My problem with this one is that before (now) all the SQL is tightly coupled and is included into the multiple business classes.  Using the above strategy will mean I am to be creating many many classes, a lot of classes, most likely one for every few SQL statements.    The pros is that it seems like I will achieve a level of code modularity that I wanted.

Hello guys it's me again. I have not posted a question in awhile so I am glad to be on PHPFreaks again. Anyways here is my question,

I have simple "Filter By" or "Refine By" script I am developing. It's foundation is primarily database (MySQL) and does not use XML or other table files. This script simply add's filtered array ("objects") to the url as the customer filters his/her search. An example,

$attributeCodes("processor_type","color","memory"); // These arrays are defined and built from the database on the time of the request. So they are automatically updated.

The above array is used in an if/and/or statement to look for these attribute codes. If it finds it and it has a value it then refines the MySQL query to look for products with the said attribute code.

Now that we have the basics out there of how it works I am at the part where it confuses me.

I give the user the ability to filter his/her search, however I want the user to be able to remove these filters separately if wanted.

So for example the customer filters,

Domain.com/search/productsearch.php?catId=112&processor_type=AMD&memory=2gb

The customer does not need the memory filter and wishes to remove that specific item or vice-verse he/she does not want to search by processor_type. How is it that I can remove specifically one attribute and its value from the URL? So the url will then look like,

Domain.com/search/productsearch.php?catID=112&processor_type=AMD or
Domain.com/search/productsearch.php?catID=112&memory=2gb

Any help would be great. Or if you have any suggestions on a different method to filter by attributes products. Suggestions and criticism are welcome. Please do not be shy or modest when it comes to giving me advice as I am trying to learn efficiently.

- Travis

 So I put this in the wrong place so ill try again,
I need to write a code to add the price of five items with a subtotal, with tax, and then a grand total.
What is the best way to do this?
Every way I have tried isnt working
  PLEASEEEEEE HELP!!!
Using crimson editor

I am self taught and am trying very hard to get a log in page to work.
The way i want it to work is that when they log in it uses a url stored in the database for their account. But i am having some much trouble working out a code that works and this is all i got:
<?php
include ('connection.php');

$username=$_POST['username5'];
$password=$_POST['password5'];

      $query="SELECT password FROM merchants WHERE username = '$_POST(username5)'";
if ($password == $query)
{
$url = "SELECT url FROM merchants WHERE username = '$_POST(username5)'";
header("Location: $url");
}
else
{
echo urgh
}
?>