PHP - Urgent Help Please!!!!!!

Please help me with this:
with this code i have only fetched out the subjects and i need to fetch out value for the following too from the database
1. GRADE
2. Contious Assessment:
3. Exam Scores:
4. Exam Scores
5. Weighted Average:
6. Last Term Cummulative:
7. Cumulative  (c+d)/2:
8. Comment:
but now i can only get the foreach work for subject alone..


$l=mysql_query("SELECT * FROM result WHERE school_id='$id' AND student_reg_id='$st'") or die (mysql_error());

if (mysql_num_rows($l) > 0)
         {
         while ($row = mysql_fetch_array($l))
               {//
               $pwrlist[$row['ajax_result_id']]=$row['subject'];
               //$
               }
         $numpwr = count($pwrlist);
         $thresh = 3;
         $maxcols = 18;
         $cols = min($maxcols, (ceil(count($pwrlist)/$thresh)));
         $percol = ceil(count($pwrlist)/$cols);
         $powerchk = '';
         $i = 0;
         foreach ($pwrlist as $id => $pwr)
                  {
                  if (($i>0) && ($i%$percol == 0))
                        {
                $powerchk .= "</td>\n<td valign='top'>";//echo "<br>";
                        }
                        
                        
                  $powerchk .= " <table width='280px' class='hovertable'>
                  
                <tr>
                  <td width='251px' height='34' align='left' valign='middle' bgcolor='#D6DFEB'><span class='style19'><font size=2px>$pwr</font></span></td>
                  <td width='19px' align='left' valign='middle' bgcolor='#D6DFEB'><span class='style1'>GRADE:</span></td>
                  <td width='20px' align='left' valign='middle' bgcolor='#FFFFFF'><span class='style13'>B3</span></td>
                </tr>
                <tr>
                  <td height='34' colspan='3' align='left' valign='top' bgcolor='#FFFFFF'><span class='style20'>&raquo; (a) Contious Assessment: 80<br />
                    &raquo; (b) Exam Scores: 90<br />
                    &raquo; (c) Weighted Average: 168<br />
                    &raquo; (d) Last Term Cummulative: 78<br />
                    &raquo; (e) Cumulative  (c+d)/2: 123 </span></td>
                </tr>
                <tr>
                  <td height='20' colspan='3' align='left' valign='top' bgcolor='#FFFFFF'><span class='style17'>Comment: His is a responsible boy</span></td>
                </tr>
            </table><br>\n";
                  $i++;
                  }
      
         }

This topic has been moved to Miscellaneous.

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

Hello dear friends  ,

I'm under attack huge attack from spam bots and i need your help

1) i've a form with input text and input submit
2) no way to add html cause using js banned any < or > ..ect
3) the spam attack now post html code but it stored into database after automatically  < and > removed as i mention in (2) okay

add to your note i can't add captcha cuase my website for kids 

Now please allow me to explain this idea and let me know if it ture or there is another way else more simple

1) i will add hidden input with value shows "IP Number Of Poster"

2) by that way i will know the IP of the spammer

3) i will use php and mysql to create database table and store the IPs of spamming i collect so that when that spammer hit my website again , will not be able to view input form.

What do you think ! is it right or bad solution or is there any any way

the bad idea is that spam is not sure human cause it is stupid and post something meaningless and not ture and fake urls like this

Code: [Select]
theuzgfnpbmi, [url=http://gdtuaemvkpif.com/]gdtuaemvkpif[/url], [link=http://rsxtnszcpceq.com/]rsxtnszcpceq[/link], http://awpfgwtvqkdm.com/" theuzgfnpbmi, [url=http://gdtuaemvkpif.com/]gdtuaemvkpif[/url], [link=http://rsxtnszcpceq.com/]rsxtnszcpceq[/link], http://awpfgwtvqkdm.com/"
please help if you have any suggestion or method how to stop such spammers

thank you so much 

hi for all
am installing php security user mangement but i got some errors during install am using xampp 1.7.7 for windows but when i runed the script for the first time i got this message
Warning: require_once(C:/xampp/htdocs/xampp/psumthemes/shared.js.php) [function.require-once]: failed to open stream: No such file or directory in C:\xampp\htdocs\xampp\psum\index.php on line 20Fatal error: require_once() [function.require]: Failed opening required 'C:/xampp/htdocs/xampp/psumthemes/shared.js.php' (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\xampp\psum\index.php on line 20()

any ideas please my document root is C:/xampp/htdocs

What is all dependent on PHP? I mean lets say I removed echo from phps source code. Then I add function my_echo() which is the exact same code basically, what all would I need to update to allow my_echo() to be implemented correctly   Obviously I would need to modify every one of my php scripts on my webserver to replace echo with my_echo, but is there anything else?   I know i could just append my_echo to phps source, or modify the echo function itself, but this is conceptually and thats not the actual process I'm looking for right now.   Any insight would be greatly appreciated!

I have a shopping cart on my website with some minor errors. When you refresh the page it adds an extra quantity to the item when it shouldn't.

Any help the code is below.

$cart = $_SESSION['cart'];
$action = $_GET['action'];
switch ($action) {
case 'add':
if ($cart) {
$cart .= ','.$_GET['id'];
} else {
$cart = $_GET['id'];
}
break;
case 'delete':
if ($cart) {
$items = explode(',',$cart);
$newcart = '';
foreach ($items as $item) {
if ($_GET['id'] != $item) {
if ($newcart != '') {
$newcart .= ','.$item;
} else {
$newcart = $item;
}
}
}
$cart = $newcart;
}
break;
case 'update':
if ($cart) {
$newcart = '';
foreach ($_POST as $key=>$value) {
if (stristr($key,'qty')) {
$id = str_replace('qty','',$key);
$items = ($newcart != '') ? explode(',',$newcart) : explode(',',$cart);
$newcart = '';
foreach ($items as $item) {
if ($id != $item) {
if ($newcart != '') {
$newcart .= ','.$item;
} else {
$newcart = $item;
}
}
}
for ($i=1;$i<=$value;$i++) {
if ($newcart != '') {
$newcart .= ','.$id;
} else {
$newcart = $id;
}
}
}
}
}
$cart = $newcart;
break;
}
$_SESSION['cart'] = $cart;

Hey, I need a bit of help replacing some variables in a string. I know its done with preg_replace.

Here is the string:

Code: [Select]
Header 1 <|header 2|> header 3 <b>header 4</b>
I would like to get ONLY <|header 2|> from the above string. But "header 2" is variable so please its useless if the preg_replace isn't flexible to find whatever word is in there regardless.

Thanks you.

hello guys
I need little help bro,
I want to make application in which i want this
look,
I am from a company where we have over 12 companies license and all are those is renew after every year.
so i want to make a application which will inform us 1 month before expireing their license.
Mean if any company license is expire on 12 June, our application give us notification on 12 May.
Could you please help me how can I do this?
Thanks and regards

This website has been great so far. Whenever I post a question, I get answer within few minutes. I have another question today related to PHP pagination.

My search page basically allows users to view users others users in a specific country. Basically, there is are two html drop downs on the search page. First one allows you to select gender (male or female) and other one allows you to select country. After the search button is pressed, it displays all the usernames of males in that country.

my search page's url looks something like: Code: [Select]
http://localhost/search.php?gender=Male&country=Canada&searchbutton=Search[/b]

I want to add pagination to this script. the search form has method=GET and 3 input options. one is gender and the other one is country and the last one is pageNum which is hidden. how can i add pagination to this???

Basically, I have a series of radio buttons (wanted checkboxes) were people select either Latte, Mocha or Cappuccino.  I have included a hidden field for a price and using that to bring in the prices and add them up.

Code: [Select]
   <label for"Latte">Latte <br />&#8364; 2.15</label> <br />
             <input type="radio" name="coffee" id="Latte" value="Latte">
             <input name="LattePrice" type="hidden" value="2.15">
                           
                            </p>
                                     <p>
         <label>Mocha  <br /> &#8364; 2.25</label>  <br />
             <input type="radio" name="coffee" id="Mocha" value="Mocha">
                <input name="MochaPrice" type="hidden" value="2.25">
                           
                            </p>
                                     <p>
       <label>Cappucino <br />  &#8364;2.35</label> <br />
             <input type="radio" name="coffee" id="Cappucino" value="Cappucino">
                           <input name="CappPrice" type="hidden" value="2.35">   
                            </p>

The next section they choose the size they want Small, Medium or Large.

Code: [Select]
<p>   <label for="latteSmall">Small </label><img src="images/latte.png" alt="Small Latte" width="36" height="36">
<input type="radio" name="size" id="LatteSmall" value="Small">
<input name="SizePrice" type="hidden" value="0.00">
 </p>

<p>   <label for="LatteMedium">Medium <br /> + &#8364; 0.25 </label>&nbsp;<img src="images/latte.png" alt="Medium Latte" width="42" height="42">&nbsp;
<input type="radio" name="size" id="LatteMedium" value="Medium"> <input name="SizePrice" type="hidden" value="0.25">
</p>
<p>   <label for="latteLarge">Large <br /> + &#8364; 0.45 </label>&nbsp;<img src="images/latte.png" alt="Large Latte" width="49" height="49">&nbsp;
<input type="radio" name="size" id="LatteLarge" value="Large">
<input name="SizePrice" type="hidden" value="0.45">
</p>
I chose radio buttons to limit the users choice to one coffee and one size to make life easier (for myself).  Ideally I wanted to use checkboxes but I could not get the php working.

So basically,  If Latte is selected echo it and the size. 

Code: [Select]
echo "Hi ". $name. ", " . "here is your order:" . "<br /> <br />";

echo "<strong>" . "Coffee:" . "</strong>" . "<br />" . $size . " " . $coffee . "<br /><br />";
That works fine but the pricing is coming out wrong as I was using:

Code: [Select]
if ($coffee == "Latte")
{
$TotalCoffeePrice = $LattePrice + $SizePrice;
echo "&#8364; " . $TotalCoffeePrice . "<br /> <br />";
}
 elseif ($coffee == "Mocha") {
$TotalCoffeePrice = $MochaPrice + $SizePrice;
echo "&#8364; " . $TotalCoffeePrice . "<br /> <br />";
 }
 elseif ($coffee == "Cappucino") {
$TotalCoffeePrice = $CappPrice + $SizePrice;
echo "&#8364; " . $TotalCoffeePrice . "<br /> <br />";
 }
What is happening here is if you select Latte and then Small it was adding Small, Medium and Large prices to the Latte.  So instead of 2.15 I was getting 2.80 or something like that.  Obviously when I recognised this I tried an array but that just went arseways!!


Also, at the end of the php I was hoping to total up everything that they chose with:

Code: [Select]
$TotalPrice = ($TotalCoffeePrice + $SizePrice + $MuffinPrice + $SamboPrice);

echo "<strong>" . "Total Price:" . "</strong>" . "<br />" . "&#8364; " .$TotalPrice .  "<br /><br />";
However, this was giving a total of 9.80 even when nothing was selected!

I am building a simple search engine script for my website which allows users to search for electronic devices that we have in our database.

Here is the HTML code.
Code: [Select]
<form name="search" action="search.php" method="get">
<input type="text" name="query" size="50" />
<input type="submit" name="submit" value="Search" />
</form>

Here is the PHP code.

<?php

error_reporting(0);

include 'config.php';

mysql_connect("localhost", "root", "password") or die(mysql_error());
mysql_select_db("maindatabase") or die(mysql_error());

// get the data from the form
$search_query = $_GET['query'];

// mysql query
$query = mysql_query("SELECT * FROM `products` WHERE productName LIKE '%$search_query%'");
$count_rows = mysql_num_rows($query);

echo "Results found: " . $count_rows;

?>


Here is the problem:

Whenever I enter  a single keyword in the search, the search brings some results. BUT, whenever I enter multiple keywords, the search brings 0 rows. For example:

I have a product called Sony Bravia Television 42 inches - 1080p HD in my database. When type "sony" in the search and press the search button, I only get 1 row as the result. But when I enter "sony television" in the seach, I get 0 row results. Why is that? What can I do to fix this problem? I want to return results that contain all the keywords that the search query had. Just like any search engine: Google, Yahoo, etc.

Ok all I need some help with this. I have been stuck for two days. Basically I have a form that asks a registrant their gender and age, then my script spits out a list of race categories they qualify for. The situation calls for the registrant to be able to register for any category YOUNGER than them, but not older.

Screen Shot #1 shows my database setup (this can be changed if you have any better ideas...) that holds the race category information.

Here is the sql statement I am using to pull a female racer information, where $race_age is their submitted age.

"SELECT * from counts where female=1 and $race_age < age_end and $race_age > age_start"

This works, but doesn't pull any categories YOUNGER Than their age.

I'm stumpped Thanks for any help in advance.

hey

ive got a page that lists a users bank accounts...when the user chooses to update an account it goes to a new page where they can edit the details...when it goes to this new page it takes the user's ID and the account ID with it in the URL (http://localhost/oswp/bank/updateaccounts.php?id=34&cid=1)

so i know these variables are correctly being transferred.

now when the user has made their changes and clicked the update button it should update the database and then re-locate back to the original page listing all accounts...to get back to this page and show the correct accounts for that user i thaught i needed to take the ID from the URL...give it a variable...and use it in the URL back to the original page. so for example the variable and update sql and re-locate code would look like this.


$cid = $_GET['cid'];

//updating the table
$result=mysql_query("UPDATE accounts SET accno='$accno', pin='$pin', type='$type', name='$balance', balance='$balance', active='$active' WHERE accid=$id");

header("location:accounts.php?id=$cid");


however currently when the user clicks update and it tries to relocate back to the original page its not getting the variable in the URL.
(http://localhost/oswp/bank/accounts.php?id=)

and im getting the errors:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\uni\oswp\assignment\bank\accounts.php on line 26
's bank accounts


Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\uni\oswp\assignment\bank\accounts.php on line 30

basically saying its expected a number up in the URL and its not finding one...but i dont know why...any ideas please its quite urgent.

here is the relevant code for this section:

Accounts.php:
<a href="adminlogout.php">Logout</a><br />
<?php
$id = $_GET['id'];
if(!isset($_SESSION['myusername'])) {
header("location:adminlogin.php");
}
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$db = 'bank';

$conn = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($db);
$result = mysql_query("SELECT * FROM customer WHERE cusid=$id");
$row2 = mysql_fetch_array($result);
echo $row2['name'] . "'s bank accounts" . "<br><br>";
$result2 = mysql_query("SELECT * FROM accounts WHERE cusid=$id");
echo "<form method='post' action='accounts.php?id=$id'>";
while($row = mysql_fetch_array($result2))
{
echo "<input type='hidden' value='$row[accid]' name='accid'>" . $row['accno'] . $row['name'] . $row['type'] . $row['balance'] . $row['active'] . "<a href='updateaccount.php?id=$row[accid]&cid=$id'>Update</a>" . "<br>";
}
echo "</form>";
?>


updateaccounts.php:
$id = $_GET['id'];
$cid = $_GET['cid'];
if(!isset($_SESSION['myusername'])) {
header("location:adminlogin.php");
}
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$db = 'bank';

$conn = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($db);

if(isset($_POST['update']))
{
$accno=$_POST['accno'];
$pin=$_POST['pin'];
$type=$_POST['type'];
$name=$_POST['name'];
$balance=$_POST['balance'];
$active=$_POST['active'];
// checking empty fields
//if item field is empty
if(empty($accno))
{
echo "<font color='red'>account number field is empty.</font><br/>";
}
elseif(empty($pin))
{
echo "<font color='red'>pin field is empty.</font><br/>";
}
elseif(empty($type))
{
echo "<font color='red'>account type field is empty.</font><br/>";
}
elseif(empty($name))
{
echo "<font color='red'>account name field is empty.</font><br/>";
}
elseif(empty($balance))
{
echo "<font color='red'>balance field is empty.</font><br/>";
}
elseif(empty($active))
{
echo "<font color='red'>active field is empty.</font><br/>";
}

else
{
//updating the table
$result=mysql_query("UPDATE accounts SET accno='$accno', pin='$pin', type='$type', name='$balance', balance='$balance', active='$active' WHERE accid=$id");
header("location:accounts.php?id=$cid");
}
}

I have an array and I'd like to find the most popular value in the array. example.

$arr = array(1,1,1,1,2,2,3,4,5,5,5,5,5,5,5,3,4,198,10293,1,2);

I would like only display 5 please.

Ok my input is an array.
$episode_number = array('2','99'...'004');

where "..." is any amount of values.

My aim is to take these values and format them so that they ALWAYS have 3 characters in them by adding Zero's to the beginning. So 2 will become 002 and 99 will become 099 and  004 will remain 004.
 I have attempted my code he

   for($i=0; $i<$numberlinks; $i++) {
$thecount = strlen($episode_number[i]);
if($thecount == '1'){
$episode_number[i] == '00'.$episode_number[i].'';
} elseif($thecount == '2'){
$episode_number[i] == '0'.$episode_number[i].'';
} else {
$episode_number[i] == $episode_number[i];
}
echo $episode_number[i].'<br />';

}
The above output is 2 <br /> tags. But when i add on osme code to it:

for($i=0; $i<$numberlinks; $i++) {
$thecount = strlen($episode_number[i]);
if($thecount == '1'){
$episode_number[i] == '00'.$episode_number[i].'';
} elseif($thecount == '2'){
$episode_number[i] == '0'.$episode_number[i].'';
} else {
$episode_number[i] == $episode_number[i];
}
echo $episode_number[i].'<br />';

}
 $query2[] = ("INSERT INTO episodes (anime_id,anime, username, userid, episode_name, episode_number, manga_chapter_link, moderated) VALUES ('".$anime_id[$i]."', '".$anime[$i]."', '".$username."', '".$userid."', '".clean($episode_name[$i])."', '".clean($episode_number[$i])."', '".clean($manga_chapter_link[$i])."','1')");
}
foreach ($query2 as $query){
mysql_query($query) or die (mysql_error());
echo "<span style='color:green'>Added sucessfully <b>Episode ".++$one."</b> </span><br/>";
} 


the output is the input, ie, 02 remains 02 and not 002. can anyone help me or give me a method that works?