PHP - Plugins Theory, How Can I Allow People To Add Plugins To My Script?

I have created a system that uses an API to drop utility data into MSQL Server 2008.  Once the data is in the db, a web app can query the data to create electric bills.  Currently we are working with only one customer but are entertaining expansion and want to approach the growth from the best possible angle.     Considering that all data is the same type of data but comes from different customers and sources, would it be best to maintain 1 database with all of the utility meter data streaming to it or would it be best to have a new data base with each customer?     Also, assuming we keep it all in the same database, would it be best (assuming we are secure) to have all the individual customers data go to the same tables or have separate tables for separate customers.    I'm pretty certain I know the answer but I'm a novice so that means nothing.     Thank you for any help with this issue.
Edited by Butterbean, 18 November 2014 - 11:28 AM.

Hey guys,
I have been programming for a while and I want to know what sort of design patterns I should look into when making a game?
For example what design pattern is best for:
Database management
User management
Forum management
Etc
I can only think of singleton or factory (for user/forum)
I am reasonably new to OOP, but would like to learn it properly, so I thought creating a simple program such as rock-paper-siccors would work to be able to expand it eventually, and hopefully it will teach me reusable code practice.

This topic has been moved to Application Design.

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

I have an audio mix submitting form on my website. The first part of the form takes the details from the user and inserts a new row in the first table 'mix', auto incrementing to generate a mix_id primary key.

The second part then uses a series of check boxes  to select which genres the mix contains and a foreach for the resulting array to insert, into the 2nd table 'genres_for_mix', a new row for each genre id (foreign key for the genres table) that is selected and the mix_id that it concerns.

Now I'm starting to think this is a bad way to do this because:

1. I don't know how to echo this out when a user edit's the mix to make all the relevant checkboxes selected.
2. When a user deselects a choice, it would be quite long winded to delete the nessesary row.


So instead I'm thinking that it would be much wiser to user the serialise functions to put the array into the database


However, I still don't know how to make the right checkboxes selected when I echo out the edit form. Do I use something like inarray()? If so how?

Also, it's really important that I can query the database for mixes that are associated with a specific genre. Without unserialising the array and therefore echo'ing out all the results, I don't know how to query this. Would I just use a 'WHERE genre_field LIKE 'genre_id'?

Can anyone help me with this please?

Hello,

I am fairly new at php (have been using HTML/CSS for a while but recently learned the php basics). I am building a website to allow clients to schedule through multiple massage therapists and I am struggling with the basic beginings of a scheduler scripts. If  someone can point me towards a tutorial or script that would be great, or answer any of the following questions:

1. What would be the best way to store each therapists weekly schedule (based on monday-sunday with start and end times) and propagate that info. to every day that a client might schedule on?
2. How do i get the day of the week based on the date?
3. How do i display a calendar that lets them choose the date?

Hello everyone!   I'm a web design student who's trying to learn some PHP, JavaScript and stuff! You'll probably find me asking more questions than helping people, apologies in advance!

I'm a developer, I don t know how to think like the consumer? What do they know? What do they want? It s hard in a way to explain something complex in layman s terms, I mean yes it is easy, you take files, put them on the internet, others can view them. Fine. But when they want a website, what should I expect? 

I mean, it seems like I can t ask them to even "draw a design on paper" for me to translate into a website which I prefer. 

Wireframes are nice, like drag and drop, I m looking to build one of those with automatic database creation/ pointing with injection protection. 

Anyway, it does depend on what their business is about, I think their mission statement or goal as a business is what determines the functionality and presentation of the website. 

If you want a website, what do you want? What are you looking for?

Hey all, I've been coding a thing for my website which allows Users to apply for a crew via the Crew Profile Page. The code all works just when the User applys I want the Crew Staff to get a message just to let them know.

I've tryed things of which I though could work but none of them did. I also tryed with a function, witch didn't work but I'm not to sure on Functions at the moment.

My Code so far:

<?php
session_start();
include "includes/config.php";
include "includes/functions.php";
include "includes/bb-codes.php";
logincheck();
$username= $_SESSION['username'];
$viewcrew= $_GET['viewcrew'];

$fetch=mysql_fetch_object(mysql_query("SELECT * FROM crews WHERE name='$viewcrew'"));

$mysql1 = mysql_query("SELECT * FROM `users` WHERE username = '$username'") or die ("Error, Line 13 " . mysql_error()); // Doing User Query
$userfetch = mysql_fetch_object($mysql1); // Getting User Object

$needcrewstaff = mysql_query("SELECT * FROM crews WHERE name='$viewcrew'");

$pleasework = mysql_fetch_object($needcrewstaff);

// Start Send Staff Message Function

function sendstaffmessage(){
$message = "You have an Crew Application. Click <a href='crewapp.php' target='mainFrame'>here</a> to Accept or Decline it!";
if ($pleasework->owner == $username){
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` )
VALUES (
'', '$pleasework->owner', '$username', '$message', '$date', '0', '0', '0'
)");
} 
if ($pleasework->coowner == $username){
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` )
VALUES (
'', '$pleasework->owner', '$username', '$message', '$date', '0', '0', '0'
)");
}
if ($pleasework->underboss == $username){
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` )
VALUES (
'', '$pleasework->underboss', '$username', '$message', '$date', '0', '0', '0'
)");
}
if ($pleasework->recruiter == $username){
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` )
VALUES (
'', '$pleasework->recruiter', '$username', '$message', '$date', '0', '0', '0'
)");
}
if ($pleasework->recruiterone == $username){
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` )
VALUES (
'', '$pleasework->recruiterone', '$username', '$message', '$date', '0', '0', '0'
)");
}
}

// End the Function!

if (strip_tags($_POST['apply'])){
if ($userfetch->crew != "0"){
echo ("You can not Apply for <strong>$viewcrew</strong> when already being in <strong>$get->crew</strong>!");
}else{
sendstaffmessage();
mysql_query("UPDATE users SET crewapp='$viewcrew' WHERE username='$username'");
echo ("$viewcrew Applied for! - Note: If you Apply for a different Crew this App will be Deleted.");
}
}
?>


Is there any way to change my code which will send the Crew Boss etc.. a Message when somebody has applyed?

Thanks for any help.

I have a script where you add an entry into a DB. I want to take everyone from another table in this DB and send the newly added content to them.

My problem is displaying all of the contacts into the $to=   location.

This is what I currently have:

 

<?php

error_reporting(-1);
//-------------email section----------------//

$title = $_POST['title'];
$story = $_POST['story'];
$date = $_POST['date'];


//do { 
//$to = $row_Fake['fake_email'];
//} 
//while($row_Fake = mysql_fetch_assoc($Fake));


while ($row_Fake = mysql_fetch_assoc($Fake)) {  
	$to = $row_Fake['fake_email']; 
} 

//$to = "colinrblambert@gmail.com";


$subject = "New Halnor Update!";

$message = "
<html>
<head>
<title>New Update!</title>


</head>
<body>

<div align='center'>";

//do{ echo $row_Fake['fake_email'].", "; } while($row_Fake = mysql_fetch_assoc($Fake));


//$row['fake_email'];

"We have a new update from ".$date." to share with you !<br /><br />
<table border='0'>
	
	<tr>
	<td valign='top' width='200'><b>".$title."</b></td>
	<td>".nl2br($story)."</td>
	</tr>	
	</table>
	
	
</div>
</body>
</html>
";

$x = 1;
$str = "test";
do{
   $str .= $x;
    $x++;
}while($x<10);

// Always set content-type when sending HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";

// More headers
$headers .= 'From: <admin@website.com>'. "\r\n";
//$headers .= 'Cc: myboss@example.com' . "\r\n";


mail($to,$subject,$message,$headers);


	
  }
  header(sprintf("Location: %s", $insertGoTo));
}

?>

Kind of lost right now. Can someone help?  

I don't even know if this is physically possible due to latency, mechanical, etc...    But, the way my website is planned at the moment, a person submits basic info, hits "Create account" and then is taken to a new page with that basic information and an incremented unique id, based on last unique id entry read from database.    My concern is that if two people or more were making accounts within the same time frame and one person hits "Create account" before another person does, what if the wrong data is pulled? 

The unique ID I guess is the only thing being pulled, if 0, start at 1, whatever    But I wonder if I can temporarily hold data between two webpages before it is stored in the database finally when all fields have been filled.    Thanks for any help / ideas 

and doing sql injections

i have enabled mysql logging and i can find where they did the query, but it only shows the query, it doesn't show what location or what url or how they did it so how can i fix it?

thanks  also lighttpd logs doesn't show...
this sucks

Hi, guys.

I want to present different ads to visitors in different countries.  For example, if a visitor is in Australia, I want him/her to see a different ad from, say, a visitor from the UK. Can this kind of thing be done with PHP? If so, will installing such a code slow down my site?

Any help will be appreciated very much.

Hi All,

not sure if this is a php Q but maybe someone has experience with this.
I use a form for people to add an item to the bulletin board. Sometimes the loading of the page takes very long and people think it didn't work so they click reload and post the item twice. I thought of adding a loading.gif so people know they have to wait. Anyone know how and where to put that in?
Code: [Select]
<?PHP
   if(isset($_POST['submit']))
   {

  if ($_POST['type']<>"") { 

  $poster_id = $_SESSION['id'];
  $ID=$_GET['ID'];
  $short=$_POST['short'];
  $location=$_POST['location'];
  if(isset($_POST['type'])) {
  $type=$_POST['type']; }
  $starthour=$_POST['starthour'];
  $startmin=$_POST['startmin'];
  $endhour=$_POST['endhour'];
  $endmin=$_POST['endmin'];
  $reminders=$_POST['reminders'];
      $reminders=addslashes($reminders);
  if(isset($_POST['view'])) {
  $view=$_POST['view']; }
  if(isset($_POST['val'])) {
$val=$_POST['val']; }
 
  $sql = mysql_query("SELECT * from bl_calender where dateclass='$ID' AND viewable='1'");
  $numrows = mysql_num_rows($sql);
// if the event exists then we want to edit it
if ($numrows > 0){
// only the owner can edit an event
while($row = mysql_fetch_array($sql)){
if($row['poster_id'] == $logOptions_id || $account_type == 'c' ){

      $editcal="update bl_calender set datecotent='$reminders', location='$location', type='$type', starthour='$starthour', startmin='$startmin', endhour='$endhour', endmin='$endmin', short='$short', viewable='$view' where dateclass='$ID'";
      mysql_query($editcal) or die("Could not edit calendar");
          $msgToUser = '<br /><br /><font color="#FF0000">Your event has been updated. Close this window.</font><p></p>';
    include_once 'msgToUser2.php';
} else {  // you are not the owner
$msgToUser = '<br /><br /><font color="#FF0000">Sorry but only the owner can change the event details.<br> Close this window.</font><p></p>';
    include_once 'msgToUser2.php';
   }

         }

}  else {      // it's a new event we want to add

         $createevent="Insert into bl_calender (poster_id, dateclass, starthour, startmin, endhour, endmin, location, type, short, datecotent, viewable ) values ('$poster_id', '$ID', '$starthour', '$startmin',  '$endhour', '$endmin', '$location', '$type', '$short', '$reminders', '1')";
         mysql_query($createevent) or die(mysql_error());

$sql2 = mysql_query("SELECT * FROM myMembers WHERE notification_calendar='1'"); // query the members who want an email
$numrows = mysql_num_rows($sql2);
if ($numrows > 0){
while($row = mysql_fetch_array($sql2)){
if($row['email'] =="") {
$to = $row['email_work'];
} else {
$to = $row['email'];
}
$your_firstname = $row['firstname'];
$your_lastname = $row['lastname'];

// send an email to everyone who wants it
$webmaster = "KAI-DEFAT@minbuza.nl";
$headers = "From: MAAC Webmaster<$webmaster>";
$subject = "A new message has been posted in the MAAC Calendar.";
$message = "Hello $your_firstname $your_lastname, a new event has been posted in the MAAC Calendar.\n";
$message .= "Goto the MAAC website to get the details.\n";
$message .= "Click here to view the Calendar $dyn_www/Web_Intersect/calen.php\n";
// send email
mail($to, $subject, $message, $headers);

}
}

}

$msgToUser = '<br /><br /><font color="#FF0000">Your event has been created, Close this window.</font><p></p>';
    include_once 'msgToUser2.php';

}

?>

Code: [Select]
if ($indovina!=$indovinata) {
 if ($tentativi>=6) {
  echo ("\n<p>Sorry, you hanged yourself. The word you had to guess was: ".$indovina."</p>\n");
 }
 else {
  $scelt = preg_split('//', $scelte, -1, PREG_SPLIT_NO_EMPTY);
  echo ("\n<p>\n");
  foreach ($alfabeto as $lettalf) {
   $contrl = false;
   foreach ($scelt as $lett) {
    if (!strcasecmp ($lettalf, $lett)) {
     $contrl = true;
    }
   }
   if ($contrl) {
    print (' <img src="images/lr_'.$lettalf.'.gif" style="border:0;width:20px;height:20px" alt="'.$lettalf.'" />');
   }
   else {
    print (' <a href="'.$_SERVER['PHP_SELF'].'?letter='.$lettalf.'"><img src="images/lb_'.$lettalf.'.gif" style="border:0;width:20px;height:20px" alt="'.$lettalf.'" /></a>');
   }
   if ($lettalf=='m') echo ("\n <br />");
   echo ("\n");
  }
  echo ("</p>\n");
 }
}
else if ($indovinata){
 echo ("\n<p>Congratulations! You guessed the word.</p>\n");
 $DB->query("UPDATE ibf_members set gold=gold+5
WHERE id = {$ibforums->member['id']}");
}

Look at the bottom, ok so if the person wins the hangman game, it will show "Congrats" but then people will just beable to refresh the page, and that query will run again and again and that person will gain +5 gold each time....we need to fix this!! any help?

My apologize if this should be here since this involves SQL.

My user can register himself ( just an email ) to a mail list.
He will get a mail after that, but the message in the mail should differ:
If there are under 100 people in the DB he should get something like " you are one of the 100 first people ", if there are more then 100 people it should say " sorry, to late ".

I can seem to get it to work so help would be awesome
( ps, I kinda need an anwser fast :s )
Code: [Select]
$sqlInsert = "INSERT INTO j5_maillist (email) VALUES('$email')";

        $sql = "SELECT COUNT(email) FROM j5_maillist AS aantalEmails";
        $result = mysql_query($sql);


        if( mysql_num_rows($result) <= "3" ){
             $message = 'you are one of the 100 first people  ';
    } else {
             $message = 'sorry, to late  ';
}

        $to      = $email;
        $subject = 'Nihonto Appreciation Day';
        $headers  = 'MIME-Version: 1.0' . "\r\n";
        $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

            // Additional headers
        $headers .= 'To: '.$email.'' . "\r\n";
        $headers .= 'From: Nihonto Appreciation Day' . "\r\n";

        mail($to, $subject, $message, $headers);

        return mysql_query($sql);