PHP - Make A Script Repeat

Hi guys, It's my first post here, not looking to leech, I'm simply here to learn and develop my skills and any contributes will be greatly appreciated!

Anyways I have made a simple login script, however I would like to make it more secure. However before that, can you please explain to me as to why it is not secure in the first place? A basic explanation so I can understand would be great.   

Then after that, could you please give help as to how I would make this login code more secure?

Thank you very much

Code: [Select]
<?php
   $rowsfound=false;
    if (isset($_GET['frmStudentId']))
    {
           // functions to make performQuery() work correctly
           require_once("dbfunctions.inc.php");
           $query = "SELECT dbStudentId, dbStudentName " .
           " FROM student " .
           " WHERE dbStudentId = '".$_GET['frmStudentId']."'" .
           " AND dbPassword = '".$_GET['frmPassword']."'";
           $result = performQuery($query);
           if(count($result) > 0)
           {
           $rowsfound=true; // allow login
           }
           }
// code continues by generating appropriate response ...

Seems to be a basic question, but I couldn't find an answer nor figure it out on my own.

Basically I have a script that takes out specific data out of the database, the script works on its own, now I just need a way to make the user execute it with a link or a button.

Example:
Category: [Smileys] - [Category2] - [Category3] - etc.

As soon as the user clicks on [Smileys] all data in the database which contains the word smileys in the category field gets selected and outputted as a list.

Again the script works, I just need to be able to execute it with a button.

If I understood it correctly I have to run the script by adding a
if (isset($_POST['Smileys'])) {
in front of the script.

But how do I build the connection with the text link?

Happy New Year, folks!

I am having an issue that's been dragging my life for quite some time. I am creating a website for my church maranatha.tv

The site's Menu and Content are pulled from a MySQL database I created. As far as this goes, everything is fine; content is pulled from my database with no issues.

My problem is as follow:
I am including an online bible, which is a third party script I downloaded. This scripts comes with its own database, which I have installed for use in my web server. I used Include() to include the index.php file of the online bible script, from its folder. I just don't know if this the right way to do it.

Of course, this script has its own folder and a set of files which makes up the entire bible script. I use an if condition so that when the user clicks on the menu button BIBLE, the script's index.php file is included instead of text from my database. This way of adding the third party script is rendering some unwanted results such as layout distortion (which I don't care at this point), broken links (main issue), and links (although broken) are sent to new pages, instead of staying within my site's CONTENT page template.

I need to find a way to make my script more modular so everything renders as intended. Here's my content function:
Code: [Select]
function content(){

// DETERMINE which page ID to USE in our query below ********************

if (!isset($_GET['jesusid'])) {

$pageid = '1';

} else {
$pageid = preg_replace('#[^0-9]#i', '', $_GET['jesusid']);} // filter everything but numbers for security)
//preg_replace($pattern, $replacement, $string);//preg_replace() Function structure

// Query the body section for the proper page
$query = mysql_query ("SELECT body_text,title,linklabel, author FROM content WHERE id = '$pageid' LIMIT 1 ") or die (mysql_error()); 

while ($row = mysql_fetch_array($query)) {

echo ucwords($row['title']).' por ';

echo '<b>'.$row['author']. '</b><br>';
        echo ucwords($row['body_text']);

//Add Bible Script
if (ucwords($row['title'])=='Biblia') //use row title -- UPPERCASED word
   {
     include ('bible/__WINDOWS/search.php');
   }

 }
}

?>
Just click on the BIBLE button, and then on any link within that page and you will see what I mean. I am still learning PHP and I don't have any background integrating third party scripts to an existing PHP website. I hope someone can help me.

Thanks in advance for your assistance.

Hello !   How I can make a script of my PHP code to work even if my website is not running   Can I make this with php ? 

I have searched this forum and the web, but I haven't been able to find a good answer.

I'm interested in the best way (especially some working code snippet, hopefully!) to make a script stop when a limit (either number of rows or time limit or whatever) is reached, call itself and pass some variables to itself via sessions/cookies or $_REQUEST, and then resume where it left off the last time. Does anybody know a way to do this that works reliably in most (all?) environments? Any code that uses header(), output buffering, AJAX, or anything else, that is proven to work?

What I want to do is make a generic script that accepts a (very large) local flat file as a data source, processes the contents and outputs the results either to another local flat file or to another application using the latter's routines. The result isn't necessarily going to be imported into MySQL (so no, LOAD DATA INFILE isn't applicable here).

An example I can think of is processing a CSV file (say, about 100,000 records), converting it on-the-fly and importing the results into WordPress by calling WP's functions to do the actual import. Again, this is just an example. I can write all input, processing and output functions, it's just the best way to restart and resume the script that I'm asking about.

BigDump is another script that does this, but it seems to use AJAX to restart itself. I wouldn't mind using AJAX/jQuery/whatever; in that case, I'd just need some working drop-in code, since my JavaScript/AJAX knowledge isn't very good, to say the least. Nevertheless, I'd rather prefer pure PHP, just in case the user has JavaScript disabled.

Sorry for the long post and thanks in advance!

I know it needs a for loop, but i don't know where in the code i should be putting it?

Code: [Select]
function check_input($value)
{
// Stripslashes
if (get_magic_quotes_gpc())
  {
  $value = stripslashes($value);
  }
// Quote if not a number
if (!is_numeric($value))
  {
  $value = "'" . mysql_real_escape_string($value) . "'";
  }
return $value;
}

$_POST = array_map('check_input', $_POST);

$sql="INSERT INTO testimonials (CustomerName, Town, Testimonial, SortOrder, Images)
VALUES
({$_POST['customername']}, {$_POST['town']}, {$_POST['testimonial']}, {$_POST['sort_order']}, '$imgname'

)";

}
if (!mysql_query($sql,$con))
  {
  die("<br>Query: $sql<br>Error: " . mysql_error() . '<br>');
  }
echo "<p align=center><b>1 testimonial added</b></p>";

mysql_close($con);


Thanks in Advance,
Steve

In one of my servers when ever I call sleep or usleep functions my script sleeps and never wakes up,
Any suggestion on what can cause the issue?
my php -v output:
Code: [Select]
PHP 5.2.17 (cli) (built: Jan 24 2012 20:49:48)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies
    with the ionCube PHP Loader v4.0.12, Copyright (c) 2002-2011, by ionCube Ltd.

hi, is there a way to tell php to do a process again?
example:

Code: [Select]
$draft_number=rand(1, 15);

if($draft_number == 5){
START OVER AT TOP
} else {
$sql1 = "UPDATE names SET draft = '$draft_number' WHERE id = '$uid'";
$result1 = mysql_query($sql1) or die('Error, Check you fields and try again.');
}

I have a script that opens up a CSV file and outputs to a table for testing. It ultimately inserts into a MySQL but the code below literally duplicates every third row consistently. I'm 95% sure its in the "WHILE" area.  Is there enough code here for someone to point out an error. If not I can put the code up live and if you want a fee for fixing just PM me please.

Code: [Select]
$fp = fopen("residential-data.csv", "r");
$listings=-1;
function getZip($full)
{
$pieces = explode(' ', $full);
$zip = explode('(', $pieces[count($pieces)-1]);
$zip = explode(')', $zip[1]);
return $zip[0];
}

$pre="";
while (($data = fgets($fp,4096)) !== FALSE)
{
$data=str_replace("\r\n","",$data);
if(trim($data)=="" or substr($data,strlen($data)-1,1)!='"' or substr($data,strlen($data)-2,2)==',"')
{
$pre.=$data;
}

I have this code which checks for the word "Big Ben" and if it's not there it outputs some html. I want t be able to make another statement to also check for the word "London Tower" and if it's not there then to check for the word "Canary Wharf",

So far I've only managed one statement without the code breaking, how do I add the others in as well.

<?php $astacker=get_post_meta($post->ID, 'thesite', true); if ( $astacker == [b]'Big Ben'[/b]) { ?>
<?php include(TEMPLATEPATH."/feedsgrabstack.php");?>
<?php }else { ?>
<div id="splitter"><div class="clear">
<a href="<?php echo get_post_meta($post->ID, "linktosource", true);?>">Click Here To View Answers</a> <span style="float:right;"><a href="#related">See Related Questions</a></div></div>
<?php } ?>

Hi Everyone, could anyone tell me why this only shows one record.
There is at least four that will match the query.

case 'jayzquotes';
 echo '<table border="0" cellspacing="0" cellpadding="2"><tr><td><h1>Jay-Z Quotes</h1></td></tr></table><br>';

 
 echo '<table width="600" border="0" cellspacing="0" cellpadding="2">';
  
  $result = mysql_query("SELECT * FROM quotes WHERE artist LIKE 'J%' and approved = 'y'")
or die(mysql_error()); 

$count = mysql_num_rows ($result );
while($row=mysql_fetch_array($result)){

  
$resultb = mysql_query("SELECT * FROM comments WHERE quoteid=".$row['quoteid']."")
or die(mysql_error()); 
while($link=mysql_fetch_array($resultb)){

$date = $row[date];
$user = $row[user];
$email = $row[email];
$artist = $row[artist];
$song = $row[song];
$quote = stripslashes($row[quote]);
$quoteid = $row[quoteid];
$votes = $row[votes];

 
echo '
<tr>
  <td width="424"><strong>Date Submitted:</strong><span class="red"> '.$date.'</span></td>
  <td width="156" align="right"><strong>Total Votes</strong> (<span class="red">'.$votes.'</span>)</td>
  </tr>
<tr>
  <td colspan="2"><strong>Quote submitted by:</strong><span class="red"> '.$user.' </span>- <span class="red"><a href="mailto:'.$email.'">'.$email.'</a> </span></td>
  </tr>
<tr>
  <td colspan="2"><strong>Artist:</strong> <span class="red">'.$artist.' </span></td>
  </tr>
<tr>
  <td colspan="2"><strong>Song name:</strong> <span class="red">'.$song.' </span></td>
  </tr>
<tr>
  <td colspan="2"><strong>Quote:</strong><hr></td>
  </tr>
<tr>
    <td colspan="2">'.$quote.'</td>
    </tr>
<tr>
  <td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="5" class="quotefooter">
    <tr>
      <td><strong>(<span class="dark">'.$countb.'</span>) Comments: View / Edit Comments</strong></td>
      <td align="center"><strong><a href="index.php?action=editquote&quoteid='.$quoteid.'" target="_self">Edit Quote</a></strong></td>
      <td align="center"><strong><a href="index.php?action=deletequote&quoteid='.$quoteid.'">Delete Quote</a></strong></td>
        </tr>
      </table><br><hr></td>
  </tr>
';
  }
}
echo '</table>';
echo '<strong>Total Results</strong><span class="red"> '.$count.'</span>';

break;

hey guys   Doing last bit of site now and after doing full testing I found 1 little bug that I don't like

I created an appointment section with a table to display resuilts from mysql, works great, but add more than 1 appiontment and its almost adding a whole new page

See attachment for pic

Heres the code for the table

<?php  echo '<h2>Customer Appointments</h2>'; ?>
</span></div><table width="1248" border="3" align="center">
  <tr class="new">
           <td width="116" class="re" style="text-align: center"><strong>Date Booked</strong></td>
           <td width="96" class="re" style="text-align: center"><strong class="table">Time Booked</strong></td>
           <td width="823" class="re" style="text-align: center"><strong class="table">Notes</strong></td>
  </tr>
         <?php do { ?>
           <tr class="table">
             <td class="re" style="text-align: center; color: #FFF;"><?php echo $row['datebooked']; ?></td>
             <td class="re" style="text-align: center"><?php echo $row['timebooked']; ?></td>
             <td class="re" style="text-align: center"><?php echo $row['notes']; ?></td>
  </tr>
           <?php } while ($row = mysql_fetch_assoc($Recordset1)); ?>
</table>
          <span class="re">
          <?php

Is there anyway I can make the Titles: Date Booked, Time Booked, Notes and have all results showing directly underneath? Attached Files  success.JPG   31.29KB   0 downloads

i want to fetch contributors in adding certain articles... so its like

select contributors from table where id=id

the table looks like this.

title                contributor
----------------------------------
art1                me
art2                me
art3                you
art4                me
art5                you

I then need to echo the contributors... what do i do so that it echoes one name only once, no duplicates... thanks. I tried searching google but im not sure about my keywords

How do you make php code repeat for a certain amount of times. I am only new to php and I am trying to make the code below repeat 6 times instead of repeating all the matching elements in the database. From my other coding experience I would use a for loop but as I am new to php I am not really sure how to implement the for and while loops together. I was trying to add an integer that incremented until it hit 6 and then would exit the while loop but I couldn't get it to work. This is probably a simple problem and any help would be appricated. Thanks.

Code: [Select]
<?php
$subject_set = mysql_query("Select * FROM movies WHERE media = 'Movies' ORDER BY dateadded DESC", $connection);
if (!$subject_set){
die("Database connection failed: " . mysql_error());
}
        while ($subject = mysql_fetch_array($subject_set)){?>
          <div class="par_element">
            <div class="repeat_horizontal">
              <div class="repeat_hor_picture">
              <a href="<?=$subject['link']?>"> <img src=" <?=$subject['picture']?>" /></a>
              </div>
              <a href=" <?=$subject['link']?>"><?= $subject['title']?>.</a>
            </div>
           <?php } ?>