PHP - Runing Scripts Automaticaly

I know this involves MySQL, but it's mostly PHP, so I figured it should go here, forgive me if I posted in the wrong section, though.

Anyway! Let's get down to it. I'd like to combine these two scripts (below). I want the questionnaire script to be a signup requirement in the signup script, and I want it to log the questionnaire into my MySQL database as usual, then prompt the user with a successful sign up.

I'm still really new to PHP and I'm just testing to see if this'll work. How would I go about doing this? Thanks a LOT guys.

Questionnai

<?php
  // Start the session
  require_once('startsession.php');

  // Insert the page header
  $page_title = 'Questionnaire';
  require_once('header.php');

  require_once('appvars.php');
  require_once('connectvars.php');

  // Make sure the user is logged in before going any further.
  if (!isset($_SESSION['user_id'])) 
  {
    echo '<p class="login">Please <a href="login.php">log in</a> to access this page.</p>';
    exit();
  }

  // Show the navigation menu
  require_once('navmenu.php');

  // Connect to the database
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

  // If this user has never answered the questionnaire, insert empty responses into the database
  $query = "SELECT * FROM mismatch_response WHERE user_id = '" . $_SESSION['user_id'] . "'";
  $data = mysqli_query($dbc, $query);
  if (mysqli_num_rows($data) == 0) 
  {
    // First grab the list of topic IDs from the topic table
    $query = "SELECT topic_id FROM mismatch_topic ORDER BY category_id, topic_id";
    $data = mysqli_query($dbc, $query);
    $topicIDs = array();
    while ($row = mysqli_fetch_array($data)) 
{
      array_push($topicIDs, $row['topic_id']);
    }

    // Insert empty response rows into the response table, one per topic
    foreach ($topicIDs as $topic_id) 
{
      $query = "INSERT INTO mismatch_response (user_id, topic_id) VALUES ('" . $_SESSION['user_id']. "', '$topic_id')";
      mysqli_query($dbc, $query);
    }
  }

  // If the questionnaire form has been submitted, write the form responses to the database
  if (isset($_POST['submit'])) 
  {
    // Write the questionnaire response rows to the response table
    foreach ($_POST as $response_id => $response) 
{
      $query = "UPDATE mismatch_response SET response = '$response' WHERE response_id = '$response_id'";
      mysqli_query($dbc, $query);
    }
    echo '<p>Your responses have been saved.</p>';
  }

  // Grab the response data from the database to generate the form
  $query = "SELECT mr.response_id, mr.topic_id, mr.response, " .
    "mt.name AS topic_name, mc.name AS category_name " .
"FROM mismatch_response AS mr " .
"INNER JOIN mismatch_topic AS mt USING (topic_id) " .
"INNER JOIN mismatch_category AS mc USING (category_id) " .
"WHERE mr.user_id = '". $_SESSION['user_id'] . "'";
$data = mysqli_query ($dbc, $query);
$responses = array();
while ($row = mysqli_fetch_array($data)) 
{
  array_push($responses, $row);
}
  
  mysqli_close($dbc);

  // Generate the questionnaire form by looping through the response array
  echo '<form method="post" action="' . $_SERVER['PHP_SELF'] . '">';
  echo '<p>How do you feel about each topic?</p>';
  $category = $responses[0]['category_name'];
  echo '<fieldset><legend>' . $responses[0]['category_name'] . '</legend>';
  foreach ($responses as $response) 
  {
    // Only start a new fieldset if the category has changed
    if ($category != $response['category_name']) 
{
      $category = $response['category_name'];
      echo '</fieldset><fieldset><legend>' . $response['category_name'] . '</legend>';
    }

    // Display the topic form field
    echo '<label ' . ($response['response'] == NULL ? 'class="error"' : '') . ' for="' . $response['response_id'] . '">' . $response['topic_name'] . ':</label>';
    echo '<input type="radio" id="' . $response['response_id'] . '" name="' . $response['response_id'] . '" value="1" ' . ($response['response'] == 1 ? 'checked="checked"' : '') . ' />Love ';
    echo '<input type="radio" id="' . $response['response_id'] . '" name="' . $response['response_id'] . '" value="2" ' . ($response['response'] == 2 ? 'checked="checked"' : '') . ' />Hate<br />';
  }
  echo '</fieldset>';
  echo '<input type="submit" value="Save Questionnaire" name="submit" />';
  echo '</form>';

  // Insert the page footer
  require_once('footer.php');
?>



Signup:
<?php
  // Insert the page header
  $page_title = 'Sign Up';
  require_once('header.php');

  require_once('appvars.php');
  require_once('connectvars.php');

  // Connect to the database
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

  if (isset($_POST['submit'])) {
    // Grab the profile data from the POST
    $username = mysqli_real_escape_string($dbc, trim($_POST['username']));
    $password1 = mysqli_real_escape_string($dbc, trim($_POST['password1']));
    $password2 = mysqli_real_escape_string($dbc, trim($_POST['password2']));

    if (!empty($username) && !empty($password1) && !empty($password2) && ($password1 == $password2)) {
      // Make sure someone isn't already registered using this username
      $query = "SELECT * FROM mismatch_user WHERE username = '$username'";
      $data = mysqli_query($dbc, $query);
      if (mysqli_num_rows($data) == 0) {
        // The username is unique, so insert the data into the database
        $query = "INSERT INTO mismatch_user (username, password, join_date) VALUES ('$username', SHA('$password1'), NOW())";
        mysqli_query($dbc, $query);

        // Confirm success with the user
        echo '<p>Your new account has been successfully created. You\'re now ready to <a href="login.php">log in</a>.</p>';

        mysqli_close($dbc);
        exit();
      }
      else {
        // An account already exists for this username, so display an error message
        echo '<p class="error">An account already exists for this username. Please use a different address.</p>';
        $username = "";
      }
    }
    else {
      echo '<p class="error">You must enter all of the sign-up data, including the desired password twice.</p>';
    }
  }

  mysqli_close($dbc);
?>

  <p>Please enter your username and desired password to sign up to Mismatch.</p>
  <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
    <fieldset>
      <legend>Registration Info</legend>
      <label for="username">Username:</label>
      <input type="text" id="username" name="username" value="<?php if (!empty($username)) echo $username; ?>" /><br />
      <label for="password1">Password:</label>
      <input type="password" id="password1" name="password1" /><br />
      <label for="password2">Password (retype):</label>
      <input type="password" id="password2" name="password2" /><br />
    </fieldset>
    <input type="submit" value="Sign Up" name="submit" />
  </form>

<?php
  // Insert the page footer
  require_once('footer.php');
?>


And here are the pastebins in case you prefer those:

http://pastebin.com/pTXGSMT9 - Questionnaire

http://pastebin.com/28jZhYyY - Signup

Thanks!

Hello all,

I have a simple form which ends in

      header( "Location: thankyou.php" );

What I have done on the site so far is to use Ajax to load content into a specific Div which uses the following code

     <a href="javascript:ajaxpage('home.php', 'content-index');"></a>

Is there a way to effectively combine the two together to load the thankyou page (upon pressing submit) into the content-index div?

Thank you in advance

well I was wanting to make scripts to put on my site and then only let a few people use the site by the ip address, what would be the best way to allow only certain people to use the script on the site, based on the ip?

Thanks

Hello.  This is sort of an embarrassing question, but I guess it is something I've never done before.

In the past, whenever I had a command button on a webpage, I used a form and when the user clicked on the button I also just reloaded the same PHP script to process the $_POST request.  (I realize that a lot of people have the form on the 1st page/script, and the have a 2nd page/script to handle the form request, but that always seemed like overkill to me.)

 

With my new problem, I have one web page that has a subscription offer on it, with just some bullet points of why the user should be interested, and then a "Get this offer" button.

When the user chooses this button, what should happen behind the scenes is that I add the ProductID to the shopping cart - which is a database record - and then I redirect to my checkout page.

 

While typing up this thread, maybe I don't have an issue after all?  😕

I guess what i could do on trial-offer.php is have a form surrounding my "Get this offer" button, and when the user submits the form, my trial-offer.php script could add a shopping_cart record in the database and then I could use a re-direct to go to my checkout.php script, right?

 

But to my original question, if I did want to pass the ProductID to my "Checkout.php script, what would be the best way to do that?

Could I still use a $_POST and but just send the form to my other script (i.e. checkout.php)?  (This is the part I was unsure of above!)

Or would I be forced to use a $_GET which i don't really like or trust?

 

First of all, im a newb when it comes to scripting other then html/xhtml/css.

I need a php script that will run through a list of other php scripts and run them. These are stored on a sever inside a folder.

Now the tricky thing is, i would like it to go in some kind of order. Meaning it will not repeat the same php script twice until it runs through all of the scripts. Once it has hit the last script, it starts over.

The main php script will be ran by a cron so it will be automated.

I tried to set up a cron on each script but it is limited funtcion wise (cant state when to start running the first instance of the cron).

Make sense?

All help is appreciated!

Thanks!

Hi   I am working as a PHP developer in my organization. They asked me to integrate several couriers in of our client's website. As i have only 1 year of experience and i am new to this.   Can any one help me by sending me the courier integration scripts in PHP for   1. Blue Dart 2. Delhivery 3. FEDEX 4. ARAMEX 5. GATI   Kindly help me.

Is there a way/function to not only remove <script>, <embed> tags etc but also remove the content within the tags so this:

"
some text
<script>
functionhere();
</script>
some more text
"

to this:
"
some text
some more text
"

In effect remove the whole tag and content within the tags? Havent been able to find anything online that works

Many thanks in advance.
Simon

I have 2 PHP scripts : opendb.php and closedb.php

In opendb.php I have this code :

<?php
session_start();
$conn = mysqli_connect(................................);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
} else {
  echo "DB open.";
  $_SESSION['dbhandler'] = $conn;
}
?>

In closedb.php I have this code :

<?php
session_start();
$conn = $_SESSION['dbhandler']
mysqli_close($conn);
echo "DB closed";
?>
 

When I run opendb.php I get the expexted message "DB Open."

But when running the closedb.php ,   I get an error 500.

I was hoping to be able to pass the Handle, needed to operate in my database, between PHP scripts, by pushing it

into $_SESSION['dbhandler'] , and retreiving it in other scripts.

Is this possible ?

Regards,

 

Martin

so is it impossible if I have a users folder and a messaging folder located in the same folder.

To have a script in the users folder reading from the messaging folder

from a script in the messaging folder i thought i could just do this to read the users folder but apparently not

Code: [Select]
<? require("users/menu.php"); ?>

Hello,
I have three scripts below that I was wondering if someone can look at as a second opinion.

What they all have in common is they are supposed to append data to some tables in my database.  They match the code on all my other scripts but for some reason these particular scripts will not append the data to the files.

This first one...
is supposed to insert the name of the doctor this person uses, and then gets the last ID created and inserts it into another table...no matter what I try, it will not do it.

Code: [Select]
<?php

session_start();
$userid=$_SESSION['userID'];
$firstName=$_SESSION['fname'];
$lastName=$_SESSION['lname'];
$camperID=$_POST['camperID'];
$physicianFName=$_POST['physicianFName'];
$physicianLName=$_POST['physicianLName'];
$physicianSuffix=$_POST['physicianSuffix'];
$practiceName=$_POST['practiceName'];
$physicianAddress1=$_POST['physicianAddress1'];
$physicianAddress2=$_POST['physicianAddress2'];
$physicianAddress3=$_POST['physicianAddress3'];
$physicianCity=$_POST['physicianCity'];
$physicianState=$_POST['physicianState'];
$physicianZip=$_POST['physicianZip'];
$physicianOfficeP=$_POST['physicianOfficeP'];
$physicianOfficeF=$_POST['physicianOfficeF'];
$physicianSpecialty=$_POST['physicianSpecialty'];


echo $camperID. ' ' .$physicianFName. ' ' .$physicianLName;

//htc information and physician

$htcName=$_POST['htcInfo'];
$htcPhysician=$_POST['htcPhysician'];

$con=mysql_connect("xxx.xxx.xxx.xx", "xxx", "xxxx") or die ("cannot connect");
mysql_select_db("testcamp") or die ("cannot select database");

$sql="INSERT INTO Physicians(physicianFName, physicianLName, physicianSuffix, practiceName, physicianAddress1, physicianAddress2, physicianAddress3, physicianCity,
physicianState, physicianZip, physicianOfficeP, physicianOfficeF, physicianSpecialty) VALUES ('$physicianFName', '$physicianLName', '$physicianSuffix', '$physicianAddress1',
'$physicianAddress2', '$physicianAddress3', '$physicianCity', '$physicianState', '$physicianZip', '$physicianOfficeP', '$physicianOfficeF', '$physicianSpecialty')";

$result=mysql_query($sql,$con);
$physicianID=mysql_insert_id();

$sql2="INSERT INTO CamperPhysicianInfo(physicianID, camperID) VALUES ('$physicianID', '$camperID')";
$result2=mysql_query($sql2,$con);

$sql3="INSERT INTO CamperHTCInfo(camperID, htcID) VALUES ('$camperID', '$htcName')";
$result3=mysql_query($sql3,$con);

$sql4="INSERT INTO camperHTCPhysicianInfo(camperID, htcPhysicianID) VALUES ('$camperID', '$htcPhysician')";
$result4=mysql_query($sql4,$con);

?>

This next one...is supposed to enter data into the CamperRegistrations tables and also enter data into another table for a questionaire that was completed on the form previous to this page...same thing no matter what I try will not append data.

Code: [Select]
<?php

$question12=$_POST['question12'];
$question12a=$_POST['question12a'];





session_start();
$userid=$_SESSION['userID'];
$firstName=$_SESSION['fname'];
$lastName=$_SESSION['lname'];

$camperID=$_SESSION['camperID'];


$con=mysql_connect("xxx.xxx.xxx.xx", "xxx", "xxx") or die ("cannot connect");
mysql_select_db("testcamp") or die ("cannot select database");

$sql="INSERT INTO Question12(camperID, question12Answer, teaching) VALUES ('$camperID', '$question12', '$question12a')";
$result=mysql_query($sql,$con);

$date=date("Y-m-d");
$defaultStatus=1;

$sql2="INSERT INTO CamperRegistrations(userID, camperID, registrationDate, registrationStatus) VALUES ('$userid', '$camperID', '$date', '$defaultStatus')";
$result2=mysql_query($sql2,$con);

?>

and then on this same page with this script...
is it possible to carry session information when using HTML links instead of a submit form?

I need the userid to carry to the next page with a link, but it won't do that either...

Any help would be appreciated and thanks in advance for looking.

~jcjst21

I have done some googling, and am surprised that I cannot find any scripts anywhere that will convert a perl script to php!

I have inherited a perl script that is quite large, but everything else on the site is php and I don't have time to either learn perl or go thru it line by line and convert it. At least if it was converted to php I could then fix the bugs for everything that did not work correctly!

Anybody know of any scripts that will do this conversion?

Thanks

I have been been coding in php for about 5/6 years. While at uni I was taught the procedural way, and using all the myql_ functions to do database work. Generally speaking if you google for php coding examples you tend to come across examples using those methods which I now believe are out of date.    In recent years I have learned some MVC, and used some frame works and open source applications (opencart, wordpress etc...)   So im just wondering, these days if you had to write a basic script to get information from a database how would you go about it? or say you were going to make a basic 5 page website with php how would you set it up?   The reason im asking these questions is because I want to get out of bad habits and using outdated methods so rather than write something like the following what would you do?  

$dbh1 = mysql_connect('localhost', 'user', 'password') or die(mysql_error()); //DB connection

mysql_select_db('db_name', $dbh1);//choose correct database

$query = "SELECT * FROM table WHERE something = something";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($result);

echo$row["field"];

How would you set up a basic website (content pages,contact form)?   In the past I have done something this :

request ---> index.php  (get page & content from db) ---> pass info to content.php

As i said im looking to get out of bad habits and essentially get up to scratch on modern day practices for basic projects, using a framework or CMS for such simple things seems like overkill.   Thanks.

Hi, i want to sell php scripts/ready made sites in the near future on clickbank and on my sites and i wanted to know is it necessary to go to a copyrights office to protect my work? and to stop people from selling it? i was thinking to have a license txt file that tells buyer not to sell and etc instead of going to a copyrights office.i understand how copyrights work but i don't know if i can stop the person from selling and claiming my stuff without having ownership proof from the copyrights office. I might sell some stuff that doesn't have restrictions.thanks

Hello,

Can I set the priority on my scripts relating to swap? Something like set_swap(10); would mean that it will be first to go into swap and set_swap(1) means it will go as a last resort and set_swap(5) being the default ?

Kind of like the proc_nice() but for memory ?

Thanks,

David

I am coding a browser game in php/mysql. the economy code needs to run at a regular interval. How can I get my code to run say, every 6/12/24 minutes? I heard of something called a cron job, but im not sure if it is going to be what I need.