PHP - Investors Application Script

I have made a script that reads values from MySQL database and "Echo" them.  When I run the script the variables from the DB are printed on the page as they should be. 

Now I want to make those variables accessible to my C++ application to read.  I am using WinInet functions to communicate with the script. 

Can somebody explain to me what I have to do in my php script be able to access the variables directly.

The below script gets the value $var = $_GET['Version']; that is sent from my C++ app.  It then reads from the DB table the Version number entered in the table.  Then compares the version number from my C++ app to the DB version number.   Now I want to make the Version Number from the DB accessible to my C++ app.  I want to be able to get the exact value stored in: $row['VersionNumber']; with my C++ app.

<?php
$dbhost = 'host';
$dbuser = 'dbusername';
$dbpass = 'dbpass';

mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');
$dbname = 'MyDbsName';
mysql_select_db($dbname);
$query = mysql_query("SELECT * FROM Users");
$var = $_GET['Version'];
while($row = mysql_fetch_array($query))
{
    if($var == $row['VersionNumber'])
    {
    echo $row['VersionNumber'];
    }
}
?>

Hello, I am slightly nervous about posting this because I am almost completely new to php, I have a few introductory books on the subject which I am working through at the moment as well as some reference books but I am still getting through the basics of it all.
I recently downloaded a login script, which allows a user to login and also allows the protection of some pages if users are not logged in.
This script was a free one from easykiss123. it comes with other .php files and I have given them all a look over and I get the general idea of what's going on for the most part, and I THINK as I keep reading my books I will understand everything even more. However, what I really want to do right now is make it so a website would know which user is logged on, and then use this information elsewhere.
For example if a particular user logged on and submitted something, I would like obviously the submission to be recorded but also the id of the user that submitted it, at the moment with this code, I do not think that is possible, however I could be wrong.
I am looking for any pointers or a nudge in the right direction or link to a tutorial of how I would go about this, anything that may help.
I think I would be storing the user ID in a global  variable that can be used throughout the site, but again I am not sure.
Thanks in advance for any help, I have included both the login script and the script used for protecting pages, as its already freely available online I see no issue with posting snippits of it here since the source has been referenced.


Code: [Select]
<?php # Script 16.8 - login.php
// This is the login page for the site.

require_once ('includes/config.inc.php'); 
$page_title = 'Login';
include ('includes/header.html');

if (isset($_POST['submitted'])) {
require_once (MYSQL);

// Validate the email address:
if (!empty($_POST['email'])) {
$e = mysqli_real_escape_string ($dbc, $_POST['email']);
} else {
$e = FALSE;
echo '<p class="error">You forgot to enter your email address!</p>';
}

// Validate the password:
if (!empty($_POST['pass'])) {
$p = mysqli_real_escape_string ($dbc, $_POST['pass']);
} else {
$p = FALSE;
echo '<p class="error">You forgot to enter your password!</p>';
}

if ($e && $p) { // If everything's OK.

// Query the database:
$q = "SELECT user_id, first_name, user_level FROM users WHERE (email='$e' AND pass=SHA1('$p')) AND active IS NULL";
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

if (@mysqli_num_rows($r) == 1) { // A match was made.

// Register the values & redirect:
$_SESSION = mysqli_fetch_array ($r, MYSQLI_ASSOC); 
mysqli_free_result($r);
mysqli_close($dbc);

$url = BASE_URL . 'index.php'; // Define the URL:
ob_end_clean(); // Delete the buffer.
header("Location: $url");
exit(); // Quit the script.

} else { // No match was made.
echo '<p class="error">Either the email address and password entered do not match those on file or you have not yet activated your account.</p>';
}

} else { // If everything wasn't OK.
echo '<p class="error">Please try again.</p>';
}

mysqli_close($dbc);

} // End of SUBMIT conditional.
?>

<h1>Login</h1>
<p>Your browser must allow cookies in order to log in.</p>
<form action="login.php" method="post">
<fieldset>
<p><b>Email Address:</b> <input type="text" name="email" size="20" maxlength="40" /></p>
<p><b>Password:</b> <input type="password" name="pass" size="20" maxlength="20" /></p>
<div align="center"><input type="submit" name="submit" value="Login" /></div>
<input type="hidden" name="submitted" value="TRUE" />
</fieldset>
</form>

<?php // Include the HTML footer.
include ('includes/footer.html');
?>
Code: [Select]
<?php 
require_once ('includes/config.inc.php'); 
$page_title = 'YOUR PAGE TITLE GOES HERE';

// Start output buffering:
ob_start();

// Initialize a session:
session_start();

// Check for a $page_title value:
if (!isset($page_title)) {
$page_title = 'User Registration';
}

// If no first_name session variable exists, redirect the user:
if (!isset($_SESSION['first_name'])) {

$url = BASE_URL . 'index.php'; // Define the URL.
ob_end_clean(); // Delete the buffer.
header("Location: $url");
exit(); // Quit the script.

}
?>
Code: [Select]
<?php // Flush the buffered output.
ob_end_flush();
?>

Hi,
I need a small help. Here is my situation.

I am using a MVC application (e.g. Joomla or Drupal) which has a .htaccess redirect rule that all requests are passed through index.php file. That's normal and this is my main application. Now I installed another application within the application folder structure. What I want do do here is to allow opening the third party application URLs after one logged into my main application.

Can anybody provide me some pointers to do the same? Please let me know if you need any further information on this. Any solution irrespective of framework will work.

Thanks!
Anupam

Hi all, this is my first time on this forum!

I have a background with HTML and CSS but have recently started a Masters in Computer Science hoping to come out of it with the tools to get a job with PHP development.

Our first assignment has somewhat 'thrown me in the deep end' as we have to construct a search engine that indexes the words of a number of documents and rank them using the TF*IDF algorithm along with the log rule associated with Information retrieval.

I am completely new to PHP so the past week has been something of a crash course - This is the code I have so far:
Code: [Select]
<?php 

$filename = 'airlines.txt';
$fp = fopen( $filename, 'r' ); 
    $file_contents = fread( $fp, filesize( $filename ) ); 
    fclose( $fp ); 

//$new_contents = ereg_replace("[^A-Za-z0-9]", "", $file_contents);

/*$file_contents = trim($file_contents); 
    $file_contents = preg_replace('/\h+/', ' ', $file_contents); 
    $file_contents = preg_replace('/\v{3,}/', PHP_EOL.PHP_EOL, $file_contents); */

$pat[0] = "/^\s+/";
$pat[1] = "/\s{2,}/";
$pat[2] = "/\s+\$/";
$rep[0] = "";
$rep[1] = " ";
$rep[2] = "";

$new_contents = preg_replace("/[^A-Za-z0-9\s\s+]/","",$file_contents);
$new_contents = preg_replace($pat,$rep,$new_contents);
//preg_replace('~\s{2,}~', ' ', $text);

$commonWords = array('a','able','about','above'........and another few hundreds cut out of this not to hurt your eyes!);


$lines = explode ( "\n", $new_contents);
$lines2 = implode (" ", $lines);
$words = explode ( " ", $lines2 );

$useful_words = array_diff( $words, $commonWords );

/*for($i = 0; $i < count($lines); $i++) {
echo "Piece $i = $lines[$i] <br />";
}*/

for($i = 0; $i < count($useful_words); $i++) {
echo "Words $i = $useful_words[$i] <br />";
}

  
//$arr=array("blah1","blah2","blah3");
file_put_contents("demo2.txt",implode(" ",$useful_words));

//$file_c = file_get_contents("demo.txt");
//$colms = explode(",",trim($file_c));
//print_r($colms);

//echo $lines[2];
?>
I've got to the stage where that strips out most of the stop words when the final array is printed, but they have been replaced with spaces or something that I have not come acoss because as you may see I had a bit of trouble originally stripping the punctuation marks.

I'm hoping someone can point me in the direction as to how to organise the words I have left after the stripping of stop words which are of no use during the search.  I need to store those words into another array and index them which says how many times they appear in that document.

I've come across the function array array_count_values ( array $input ) on the manual but I'm not sure about the best way to use it.

I've attached the files I've used if that helps.

Any help would be greatly appreciated!