PHP - Bidding System, When 2 Users Bid At The Same Time? What To Do? Suggestions

I need some help with my commenting system. at the moment the code is like this:

<div id="pagepannel">
                <div id="ptop_small">Comments</div>
                <div id="pbottom_small">
          <p>
            <?php 
//
if ($allow_comments == "no") {
?>
          </p>
          <p>No Posting comments here!!!</p>
          <p>&nbsp;</p>
          <p>&nbsp;</p>
          <p>
            <?php } else ?>
          </p>
          <p>
            <?php 
  $sql = "SELECT comment_id, blog_id, posted_by, comment, stamp, email, type FROM jscrgaming_newscomments WHERE blog_id='$blog_id'  ORDER BY comment_id DESC";
$result = mysql_query($sql) or die('Error : ' . mysql_error()); 
      while(list($comment_id, $blog_id_co, $username, $comment, $stamp, $email, $type) = mysql_fetch_array($result, MYSQL_NUM))
{ 
if ($type == 'user'){
?>
          </p>
          <table width="95%" border="0" cellpadding="0" cellspacing="0" class="full_border">
            <tr>
              <td width="75" id="avatar"></td>
              <td><span class="capitalize"><a href="userinfo.php?user=<? echo $username ?>"><strong><? echo $username ?></strong></a></span><strong> posted</strong>: <? echo stripslashes($comment) ?></td>
            </tr>
            <tr>
              <td colspan="2" bgcolor="#CAE4FF" class="date"><? echo $stamp ?>&nbsp;</td>
            </tr>
          </table>
          <p>&nbsp;</p>
          <p>
            <? } 
else{
?>
          </p>
          <table width="95%" border="0" cellpadding="0" cellspacing="0" class="full_border">
            <tr>
              <td><strong> <? echo $username ?>posted</strong>: <? echo stripslashes($comment) ?></td>
            </tr>
            <tr>
              <td bgcolor="#CAE4FF" class="smalltext"><? echo $stamp ?>:: User Was Guest</td>
            </tr>
          </table>
          <p>&nbsp;</p>
          <p>
            <? } }?>
          </p>
          <p>
            <?php 
//
if ($allow_comments == "restricted") {

/**
 * User has already logged in, so display relavent links, including
 * a link to the admin center if the user is an administrator.
 */
if($session->logged_in){?>
          </p>
          <form id="form3" name="form3" method="post" action="user/admin/blog/comment_system/user.php">
            <p>&nbsp;</p>
            <table width="95%" border="0" align="center" cellspacing="2" class="full_border">
              <tr>
                <td colspan="2">You are commenting as <?php echo $session->username;?></td>
              </tr>
              <tr>
                <td width="75">Message</td>
                <td><textarea name="co_comment" cols="30" id="textfield10"></textarea></td>
              </tr>
              <tr>
                <td width="75"><span class="header">
                  <input name="co_username" type="hidden" id="co_username" value="<?php echo $session->username;?>" />
                  <input name="co_blog_id" type="hidden" id="co_blog_id" value="<?php echo $blog_id ?>" />
                </span></td>
                <td><label>
                  <input type="submit" class="blog_button" value=" Post " />
                </label></td>
              </tr>
              <tr>
                <td>&nbsp;</td>
                <td class="smalltext">only 200 charaters can be used</td>
              </tr>
            </table>
          </form>
          <p>&nbsp; </p>
          <p>
            <? } else {?>
          </p>
          <p>&nbsp;</p>
          <table width="95%" border="0" align="center" cellspacing="2" class="full_border">
            <tr>
              <td width="75"><span class="capitalize">Name</span></td>
              <td><label>
                <input name="textfield5" type="text" disabled="disabled" id="textfield5" size="35" />
              </label></td>
            </tr>
            <tr>
              <td width="75">Email</td>
              <td><input name="textfield5" type="text" disabled="disabled" id="textfield6" size="35" /></td>
            </tr>
            <tr>
              <td width="75">Message</td>
              <td><textarea name="textfield5" cols="30" disabled="disabled" id="textfield7">You need to be logged in to comment.</textarea></td>
            </tr>
            <tr>
              <td width="75">&nbsp;</td>
              <td><label>
                <input type="button" class="blog_button" value=" Post " />
              </label></td>
            </tr>
          </table>
          <p>&nbsp;</p>
          <p>
            <?php } } else { 
  if($session->logged_in){?>
          </p>
          <form id="form2" name="form2" method="post" action="user/admin/blog/comment_system/user.php">
            <p>&nbsp;</p>
            <table width="95%" border="0" align="center" cellspacing="2" class="full_border">
              <tr>
                <td colspan="2">You are commenting as <?php echo $session->username;?></td>
              </tr>
              <tr>
                <td width="75">Message</td>
                <td><textarea name="co_comment" cols="30" id="textfield8"></textarea></td>
              </tr>
              <tr>
                <td width="75"><input name="co_username" type="hidden" id="co_username" value="<?php echo $session->username;?>" />
                  <input name="co_blog_id" type="hidden" id="co_blog_id" value="<?php echo $blog_id ?>" /></td>
                <td><label>
                  <input type="submit" class="blog_button" value=" Post " />
                </label></td>
              </tr>
              <tr>
                <td>&nbsp;</td>
                <td><span class="smalltext">only 200 charaters can be used</span></td>
              </tr>
            </table>
          </form>
          <p>&nbsp; </p>
          <p>
            <? } else { ?>
          </p>
          <form id="form1" name="form1" method="post" action="user/admin/blog/comment_system/guest.php">
            <p>&nbsp; </p>
            <table width="95%" border="0" align="center" cellspacing="2" class="full_border">
              <tr>
                <td width="75"><span class="capitalize">Name</span></td>
                <td><label>
                  <input name="co_username" type="text" id="co_username" size="35" />
                </label></td>
              </tr>
              <tr>
                <td width="75">Email</td>
                <td><input name="guest_email" type="text" id="guest_email" size="35" /></td>
              </tr>
              <tr>
                <td width="75">Message</td>
                <td><textarea name="co_comment" cols="30" id="co_comment"></textarea></td>
              </tr>
              <tr>
                <td width="75">Spam</td>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td colspan="2" align="center"><? require_once('user/captcha/recaptchalib.php');
$publickey = "6Ld_W7sSAAAAAPNTLWrUJLEClFpSSPu1d1Ry5zNR"; // you got this from the signup page
echo recaptcha_get_html($publickey); ?></td>
              </tr>
              <tr>
                <td colspan="2" align="right"><span class="smalltext">only 200 charaters can be used</span>
                  <input name="co_blog_id" type="hidden" id="co_blog_id" value="<?php echo $blog_id ?>" />
                  <input type="submit" class="blog_button" value=" Post " /></td>
              </tr>
            </table>
          </form>
          <p>&nbsp; </p>
          <p>
            <? } } ?>
          </p>
<p>&nbsp;</p>
                  <div></div>
                </div>
              </div>


I, know its a bit messy but lets me see it and design it in Dreamweaver

Any way, for the comment system for users, I want it to show their avatar as well, which is stored in the users table. How would one do this.

I did think of it submitting the avatar along with the post but then it wouldnt update if the user would to change their avatars :\

Any helps???

I have a Yahtzee system

Code: [Select]
session_start();
$_SESSION['Yahtzee']['totaltime'] =time();
echo $_SESSION['Yahtzee']['totaltime'];
Now, Long STORY Short when somone finishes playing the Yahtzee, I update there username with the score they had, and I want to update how long they have been playing, and it will be for "Total Time Playing globally" no matter how many games.

If I do this session and echo it out, it echo's out the time, but I need it to echo out seconds instead so I can just add that to my totaltime field in my database each time they finished a game.

I have dynamic images that have the "Like" button, it's basically like a wishlist. The way I want it to work is that when a user is not logged in, the 'Like' button will navigate them to a login popup (which I already made). 

Hi, i am thinking of creating a text based game mmorpg using php/mysql etc... I know that a lot of these types of games use a tick based system, but i want it to be realtime, the only game i cna find that uses this is Torn, does anyone know how they make it realtime? I know that ticks can be controlled by cronjobs, but how about realtime?

The problem is that the game might involve the player building a house, in a tick based system it could be easy to manage by saying the house will take 3 ticks to complete, but i want the house to be like in 10 minutes of 32 minutes, how can i do this. Someone said to check whenever the player next logs in to check if the house has finished and then say it has been built, but seeing as it is an mmorpg it could affect everyones gameplay, not just the person building it, so this will not work.

Thanks and sorry if this is a bit confusing.

hello dear php-experts


i run opensuse 13-2 and i am very very happy

the time does not get displayed correct.

it falls back to UTC all day. What can i   do.

i have had  look at the documents here

https://en.opensuse....uring_the_clock
https://tr.opensuse....T_Date_and_Time

how to set up correct to the local time  - note i live in GERMANY near francfurt
 

Hi.

How to implement twitter like real-time sharing system?

So that is like, if my friend(following person) write a message, it also appear on my wall(page).

1. Is it hard?

2. What language used for it? PHP?

3. Is there any source about it?

Thanks.

Hi everyone...

I would like to implement a questionnaire/survey system that has only two Answers (Yes /No).

Basically, this questionnaire system will be widely used on Mobile Phones.

It will be looking something like this below: http://awardwinningfjords.com/2009/06/16/iphone-style-checkboxes.html

Lets say a user selects a response as No (Using the above slider button for a question). That response should be recorded in the database with User Details + Time Stamp.

Also, I would like to generate a report for each question (Responses of Multiple Users) and a report at a User Level for the entire questionnaire/survey (s).

Can some one guide me the fastest & easiest way to achieve this? I'm a new learner of PHP.

Regards
Sandeep

Hello   I am trying to work out how many regular users I have to my site and how long those users tend to be users..   So, I have a table that logs every time a user visits my site and logs in, it stores the date / time as a unix timestamp and it logs their user id.   I started by getting the id's of any user who logs in more than 5 times in a specified period, but now I want to extend that...  

 
SELECT userID as user, count(userID) as logins FROM login_history where timestamp > UNIX_TIMESTAMP('2014-06-01 00:00:00') and timestamp < UNIX_TIMESTAMP('2014-07-01 00:00:00') group by user having logins > 5;
 

I just discovered that I have a major security flaw with my website.
Anyone who logs in to the website can easily access other users information as well as delete and edit other users information just by changing the ID variable in the address bar.
I have user ID Session started on these pages but still people can do anything they like with other users information just by editing the address bar.
For example if your logged in in the address bar of www.mywebsite.com/delete_mystuff.php?id=5 and change the "5" say to a "9" then you will have access to user#9 information.

Every important page that I have has this code:
Code: [Select]
 session_start();

if (!isset($_SESSION['user_id'])) {
// Start defining the URL.
         $url = 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']);
// Check for a trailing slash.
         if ((substr($url, -1) == '/') OR (substr($url, -1) == '\\') ) {
         $url = substr ($url, 0, -1); // Chop off the slash.
}
// Add the page.
$url .= '/index.php';
ob_end_clean(); // Delete the buffer.
header("Location: $url");
exit(); // Quit the script.
} else {
                //Else If Logged In Run The Script

if((isset($_GET['id'])) && (is_numeric($_GET['id']))) {
         $id = (int) $_GET['id'];
} elseif ((isset($_POST['id'])) && (is_numeric($_POST['id']))) {
         $id = (int) $_POST['id'];
} else {
         echo ' No valid ID found, passed in url or form element';
        
         exit();
}



What am I doing wrong?
Please help if you know how to correct this.

Many thanks in advance.

hello dear PHP-Fans - greetings to you - and a happy new year!!


i set up a WAMP-System on my openSuse 11.4 system.  In order to learn as much as i can bout PHP i want to do some tests and write some scripts.

Well the WAMP is allready up and running.  Now i try to give the writing access to the folder

mkdir /srv/www/

where the php-scripts should go in...

i want  to give write permission to all to all files in /srv/www

As root I generally:

mkdir /srv/www/
chown <webmaster usrername> /srv/www/

/srv/www/ should be readable and traversable by all, but only writeable by it's owner (the user designated as the webmaster.)

can i do this like mentioned above,...

Love to hear from you

greetings
db1

what i want is to upload my informations to database when i press the submit button.
but if any field is empty it should show a text that all fields are required but in the same page(up or down to the form).
However with this code my database is not working>informations are not send to the database.
why?Any sggesstions?

Code: [Select]
<?php 
// Start a session for error reporting
session_start();
//Connect to database
require("includes/connect_to_mysql.php");

//check if the button is pressed
if(isset($_POST['submit'])){
// Check to see if the type of file uploaded is a valid image type
function is_valid_type($file)
{
// This is an array that holds all the valid image MIME types
$valid_types = array("image/jpg", "image/jpeg", "image/bmp", "image/gif", "image/png");


if (in_array($file['type'], $valid_types))
return 1;
    return 0;
}
// This variable is the path to the image folder where all the images are going to be stored
// Note that there is a trailing forward slash
$TARGET_PATH = "upload_form_images/";

// Get our POSTed variables
$name = $_POST['name'];
$surname = $_POST['surname'];
$email = $_POST['email'];
$city = $_POST['city'];
$details = $_POST['details'];
$price = $_POST['price'];
$image = $_FILES['image'];

// Sanitize our inputs
$name = mysql_real_escape_string($name);
$surname = mysql_real_escape_string($surname);
$email = mysql_real_escape_string($email);
$city = mysql_real_escape_string($city);
$details = mysql_real_escape_string($details);
$price = mysql_real_escape_string($price);
$image['name'] = mysql_real_escape_string($image['name']);

// Build our target path full string.  This is where the file will be moved do
// i.e.  images/picture.jpg
$TARGET_PATH .= $image['name'];

// Make sure all the fields from the form have inputs
if ( $name == "" || $surname == "" || $email == "" || $city == ""  || $details == "" || $price == ""|| $image['name'] == "" )
{
$_SESSION['error'] = "Te gjithe fushat duhet plotesuar";
echo "Te gjithe fushat duhet plotesuar";
header("Location: upload_form.php");
exit;
}

// Check to make sure that our file is actually an image
// You check the file type instead of the extension because the extension can easily be faked
if (!is_valid_type($image))
{
$_SESSION['error'] = "Fotografite duhet te jene te formateve jpg, jpeg, bmp, gif, ose png";
header("Location: upload_form.php");
exit;
}

// Here we check to see if a file with that name already exists
// You could get past filename problems by appending a timestamp to the filename and then continuing
if (file_exists($TARGET_PATH))
{
$_SESSION['error'] = "Ju lutem nderroni emrin e fotos.";
header("Location: upload_form.php");
exit;
}

/*
// See if that product name is an identical match to another product in the system
$sql = mysql_query("SELECT id FROM upload_form WHERE name='$name' LIMIT 1");
$productMatch = mysql_num_rows($sql); // count the output amount
    if ($productMatch > 0) {
$_SESSION['error'] = 'Ju lutem nderroni emrin sepse egziston ne databaze';
header("Location: upload_form.php");
exit();
}
*/

// Lets attempt to move the file from its temporary directory to its new home
if (move_uploaded_file($image['tmp_name'], $TARGET_PATH))
{
// NOTE: This is where a lot of people make mistakes.
// We are *not* putting the image into the database; we are putting a reference to the file's location on the server
$sql = "insert into people (name, surname, email, city, details, price, filename) values ('$name', '$surname', '$email', '$city', '$details',  '$price', '" . $image['name'] . "')";
$result = mysql_query($sql) or die ("Futja e te dhenave ne databaze DESHTOI: " . mysql_error());
echo "Shtimi i te dhenave u krye me SUKSES";
exit;
}
else
{
// A common cause of file moving failures is because of bad permissions on the directory attempting to be written to
// Make sure you chmod the directory to be writeable
$_SESSION['error'] = "Shtimi i te dhenave NUK u krye me Sukses.  Ju lutem provoni perseri";
header("Location: upload_form.php");
exit;
}
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
<title>Qiraja.com</title>
<link rel="stylesheet" href="css/style.css" type="text/css" media="all" />
<!--[if lte IE 6]><link rel="stylesheet" href="css/ie6.css" type="text/css" media="all" /><![endif]-->
<!--[if IE]><style type="text/css" media="screen"> #navigation ul li a em { top:32px; } </style><![endif]-->


</head>
<body>

<!-- Header -->
<div id="header">
<div class="shell">

<!-- Logo -->
<h1 id="logo"><a href="#">Company Name</a></h1>
<!-- End Logo -->

<!-- Navigation -->
<div id="navigation">

<ul>
    <li><a href="#">Prishtine<span><em></em></span></a></li>
    <li><a href="#">Prizren<span><em></em></span></a></li>
<li><a href="#">Ferizaj<span><em></em></span></a></li>
    <li><a href="#">Peje<span><em></em></span></a></li>
<li><a href="#">Mitrovice<span><em></em></span></a></li>
<li><a href="#">Gjilan<span><em></em></span></a></li>
    <li class="last"><a href="#">Gjakove<span><em></em></span></a></li>

</ul>
</div> 
</div>
</div>


<div id="slider">
<div class="shell">

<!-- Slides -->
<div class="slides">
<ul>
<!-- Slide -->
    <li>
               
               
<form action="upload_form.php" enctype="multipart/form-data" name="myForm" id="myform" method="post">
    <table width="90%" border="0" cellspacing="0" cellpadding="6">
      <tr>
        <td width="20%" align="center">Name</td>
        <td width="80%"><label>
          <input name="name" type="text" id="name" size="25" />
        </label></td>
      </tr>
      <tr>
        <td align="center">Surname</td>
        <td><label>
          <input name="surname" type="text" id="surname" size="25" />
        </label></td>
      </tr>
       <tr>
        <td align="center">Email</td>
        <td><label>
          <input name="email" type="text" id="email" size="25" />
        </label></td>
      </tr>
      <tr>
        <td align="center">City</td>
        <td><select name="city" id="city">
        <option value=""></option>
          <option value="Prishtine">Prishtine</option>
          <option value="Prizren">Prizren</option>
          <option value="Ferizaj">Ferizaj</option>
          <option value="Peje">Peje</option>
          <option value="Mitrovice">Mitrovice</option>
          <option value="Gjilan">Gjilan</option>
          <option value="Gjakove">Gjakove</option>
          </select></td>
      </tr>
      <tr>
        <td align="center">Cmimi</td>
        <td><label>
          <input name="price" type="text" id="price" size="10" />
          &euro;
        </label></td>
      </tr>
      <tr>
        <td align="center">Fotografite</td>
        <td><label>
          <input type="file" name="image" id="image" />
        </label></td>
      </tr>     
      <tr>
        <td>&nbsp;</td>
        <td align="right"><label>
        <input type="hidden" name="MAX_FILE_SIZE" value="100000" />
          <input type="submit" name="submit" id="submit" value="Shto te dhenat" />
        </label></td>
      </tr>
    </table>
    </form>

    </li>
    <!-- End Slide -->
   
    <!-- Slide -->
    <li>
    <div class="slide-info">
    <h2><span>Reklamo</span> Shtepine</h2>
    <p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam arcu ligula, faucibus eu imperdiet eu, bibendum sit amet augue. Sed turpis sem, interdum sit amet egestas a, mattis non libero. Suspendisse tristique nisi sed justo accumsan vel mattis nulla fermentum. Etiam varius est id mi fermentum aliquam.</p>
    <p>Quisque quis vestibulum turpis. Sed venenatis ipsum laoreet elit pulvinar vitae pharetra massa dignissim. Curabitur ligula sapien, auctor ut porttitor a, ultricies lobortis dui. Suspendisse lacinia tellus a diam rutrum rhoncus. </p>

<a href="#" class="more">read more</a></p>
    </div>
    <span class="slide-image image1"></span>
    </li>
    <!-- End Slide -->
   
    <!-- Slide -->
    <li>
    <div class="slide-info">
    <h2><span>Reklamo</span> Apartmanin</h2>
    <p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam arcu ligula, faucibus eu imperdiet eu, bibendum sit amet augue. Sed turpis sem, interdum sit amet egestas a, mattis non libero. Suspendisse tristique nisi sed justo accumsan vel mattis nulla fermentum. Etiam varius est id mi fermentum aliquam.</p>
    <p>Quisque quis vestibulum turpis. Sed venenatis ipsum laoreet elit pulvinar vitae pharetra massa dignissim. Curabitur ligula sapien, auctor ut porttitor a, ultricies lobortis dui. Suspendisse lacinia tellus a diam rutrum rhoncus. </p>

<a href="#" class="more">read more</a></p>
    </div>
    <span class="slide-image image1"></span>
    </li>
<!-- End Slide -->
   
    </ul>
</div>
<!-- End Slides -->

</div>
</div>
<!-- End Slider -->

<!-- Slider Nav -->
<div id="slider-navigation">
<div class="shell">
<ul>
    <li><a href="index.php" class="active">Kthehu ne fillim<strong>Home</strong><em class="ico1"></em></a></li>
    <li><a href="upload_form.php">Shto<strong>Upload</strong><em class="ico2"></em></a></li>
    <li class="last"><a href="contact_form.php">Kontakti<strong>Contact</strong><em class="ico3"></em></a></li>
</ul>
</div>
</div>
<!-- End Slider Nav -->

<!-- Main -->
<div id="main">
<div class="shell">

<!-- Cols -->
<div class="cols">
<div class="cl">&nbsp;</div>

<!-- Col -->
<div class="col">
<h3>Sed Turpis sem</h3>
<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam arcu ligula, faucibus eu imperdiet eu, bibendum sit amet augue. Sed turpis sem, interdum sit amet egestas a, mattis non libero.<br /><a href="#" class="more">read more</a></p>
<p>Suspendisse tristique nisi sed justo accumsan vel mattis nulla fermentum. Etiam varius est id mi fermentum aliquam. <br /><a href="#" class="more">read more</a></p>
</div>
<!-- End Col -->

<!-- Col -->
<div class="col">
<h3>Ligula amet augue</h3>
<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam arcu ligula, faucibus eu imperdiet eu, bibendum sit amet augue. <br /><a href="#" class="more">read more</a></p>
<p>Sed turpis sem, interdum sit amet egestas a, mattis non libero. Suspendisse tristique nisi sed justo accumsan vel mattis nulla fermentum. Etiam varius est id mi fermentum aliquam. <br /><a href="#" class="more">read more</a></p>
</div>
<!-- End Col -->

<!-- Col -->
<div class="col col-last">
<h3>Ligula amet augue</h3>
<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam arcu ligula, faucibus eu imperdiet eu, bibendum sit amet augue. <br /><a href="#" class="more">read more</a></p>
<p>Sed turpis sem, interdum sit amet egestas a, mattis non libero. Suspendisse tristique nisi sed justo accumsan vel mattis nulla fermentum. Etiam varius est id mi fermentum aliquam. <br /><a href="#" class="more">read more</a></p>
</div>
<!-- End Col -->

<div class="cl">&nbsp;</div>
</div>
<!-- End Cols -->

</div>
</div>


</body>
</html>

Hi

I was playing with a poll, but for some reasons it won't email me(the bottom most part). Where did I go wrong?

Also any suggestions on how to improve this?

Thanks your the best guys!


<?php
include('config.php');
$name = strip_tags($_POST['name']);
$email = $_POST['email'];
$qst_id=strip_tags($_POST['qst_id']);
//if no ajax
$opt = strip_tags($_POST['opt']);
$s_id = $_SERVER['REMOTE_ADDR'];

//validate email 
if (!preg_match('/^.+@.+\..{2,3}$/',$email));
{
$email = 'email was blocked';
}
if (strlen($name) >= 50)
{
$name = 'name was blocked';
}


if ($opt == '')
{
$vote ="no";
}
elseif (($opt=='Yes') || ($opt=='No'))
{
$qt=mysql_query("insert into plus_poll_ans(s_id,qst_id,opt) values('".$s_id."','".$qst_id."','".$opt."')");
}
else
{
$vote = "no";
}

echo "<font size='2' face='Verdana' color='#000000' style='font-size:1.2em;'> Declaration of Faith</font>";

$qst_id=1; // change this to change the poll 

/* Find out the question first */
$fg=mysql_query("select qst from plus_poll where qst_id='".$qst_id."'");
$row=mysql_fetch_object($fg);

echo "<br><b><br>$row->qst</b><br>"; // display the question
/* for percentage calculation we will find out the total number
 of answers ( options submitted ) given by the visitors */
$rt=mysql_num_rows(mysql_query("select ans_id from plus_poll_ans where qst_id='".$qst_id."'"));


/* Find out the answers and display the graph */
$query="select count(*) as no,qst,plus_poll_ans.opt from plus_poll,plus_poll_ans where plus_poll.qst_id=plus_poll_ans.qst_id and plus_poll.qst_id='".$qst_id."' group by opt desc ";
$rs=mysql_query($query);

//count the answers by yes or no
$count= "SELECT opt, count(opt) FROM plus_poll_ans GROUP BY opt desc"; 
$result = mysql_query($count) or die(mysql_error());

//separate the results
while($row = mysql_fetch_array($result)){
$total_opt[] = $row['count(opt)'];
}

// Print out result
echo "<table cellpadding='0' cellspacing='0' border='0' width='100%' >";

$i = 0;
while($noticia = mysql_fetch_array($rs)){
 echo "<tr>
    <td width='5%' bgcolor='#F1F1F1'>&nbsp;<font size='1' face='Verdana' color='#000000'>$noticia[opt]</font></td>";
$width2=$noticia['no'] *10 ; /// change here the multiplicaiton factor //////////
$ct=($noticia[no]/$rt)*100;
$ct=sprintf ("%01.2f", $ct); // number formating 

echo "    <td width='20%' bgcolor='#F1F1F1'>&nbsp;<font size='1' face='Verdana' color='#000000'>($ct %)</font></td><td width='60%' align='left' bgcolor='#F1F1F1'>&nbsp;<img src='graph.jpg' height=10 width=$width2>";
 echo "</td><td width='15%' align='right'>";
 echo "<font size='1' face='Verdana' color='#000000'>".$total_opt[$i];
 echo " votes";
 echo "</font></td>";
 echo  "</tr>";
 echo "<tr>
    <td  bgcolor='#ffffff' colspan=2>"; 
 echo "</td>";
 echo "</tr>";
 $i=$i+1;
}
echo "<tr><td></td><td></td><td><font size='1' face='Verdana' color='#000000'>Total Votes:</font></td><td align='right'>";
//count the total votes
$count = 'select count(ans_id) from plus_poll_ans';
$count = mysql_query($count);
$count = mysql_fetch_array($count);
$total_count = $count['count(ans_id)'];

echo "<font size='1' face='Verdana' color='#000000'>".$total_count." votes</font>";
echo "</td></tr>";
echo "</table>";
echo "</font>";


if ($vote!='no')
{
//email
$to = 'person1@example.com, person2@example.com';
$subject = 'Someone just made a declaration of faith';
$message = "Someone from the ip address ".$s_id;
// 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";
$headers .= 'From: Vote Detector <website@example.com>'. "\r\n";
if ($name!='')
{
$message = $message." with the name ".$name;
}
if ($email!='')
{
$message = $message." with email ".$email;
}
$message = $message." voted "."yes<br/>";
$message = $message."total number of people who declared their faith: ".$total_count." people<br/>";
$message = $message."with a total of ".$total_opt[0]." people saying yes";
$message = $message." and a total of ".$total_opt[1]." people saying no<br/>";
mail($to, $subject, $message, $headers);
}

?>

This topic has been moved to Miscellaneous.

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

How to do #3 by a PHP page instead? mainly so
that there wouldn't be a need to
export the sql after doing #2 then
import it into the online phpmyadmin(#3)

#1. Convert database from foxpro to sql
#2. Change some fields in the sql table
#3. Upload to phpmyadmin

Is it possible to create a code to export
from the server and then import the sql online?

like by making use of mysql_fetch_array() and insert into

I'm getting a '500 Internal Server' and 'Premature end of script headers..' errors in the process of uploading a file. This occurs consistently with files > 2MB but also (very occasionally) w/ smaller files. The target directories are beneath the web root folder, so I don't think it's a permissions issue.

I've set the following in my php5.ini:
post_max_size = 8M,
upload_max_filesize = 8M
max_input_time = 360
max_execution_time = 360

Trace code/logging reveals that the error occurs even before my upload code is entered (which uses (move_uploaded_file()).  So what would cause that?

Any suggestions on how to debug this are very much appreciated!