PHP - Wanting To Know If I Am Going The Right Way With My Coding Style?

onkeydown="this.style.fontStyle='normal';"

How can I add color: #000; to this?

Thanks,  

Background:
I'm comparing 2 styles of Ajax:
1.) "jquery style"
2.) "ActiveXObject Microsoft.XMLHTTP style"

Question:
Is one better (faster, more cross-browser compliant) than the other?

My experience:
Both seem equally fast. The Microsoft style is a bit longer, but I don't have to load jquery.js to my page!

Code Examples:

Jquery style on my PHP page:

function getInfo(ProductNumber){
$.ajax({
url:'Ajax-PHP-Page.php?ProductNumber='+ProductNumber,
success: function(html) {
document.getElementById("my_div").value = '';
document.getElementById("my_div").value = html;
}
});
}

Microsoft style on my PHP page:

function getInfo(ProductNumber) {
        if (window.XMLHttpRequest) {
            // code for IE7+, Firefox, Chrome, Opera, Safari
            xmlhttp = new XMLHttpRequest();
        } else {
            // code for IE6, IE5
            xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
        }
        xmlhttp.onreadystatechange = function() {
            if (this.readyState == 4 && this.status == 200) {
                document.getElementById("my_div").value = this.responseText;
            }
        };
    xmlhttp.open("GET","Ajax-PHP-Page.php?ProductNumber="+ProductNumber,true);
  xmlhttp.send();
}

Thank you!!

Edited May 5, 2020 by StevenOliver

this doesn't work. Please help fix this.


$result1=mysql_query("SELECT * FROM applicants WHERE username = '$user' AND status = 'PendingXCD'");
if(mysql_num_rows($result1)) {
$login = "&err=In progress.";
echo($login);
}
else {
$result=mysql_query("SELECT * FROM  comp WHERE username = '$user' AND password ='$pass'");
if(mysql_num_rows ($result) == 0) {
$login = "&err=Please retry.";
echo($login);
} else {
$row = mysql_fetch_array($result);
$user=$row['user'];
$pass=$row['pass'];
$login = "$user=" . $user . "$pass=" . $pass . "&err=Successful.";
echo($login);
}
?>

I have a sql statement w/c suppose to output only those records w/c has a name of seller.
But, it keeps showing all the records.

Code: [Select]
<?php
session_start();  
if(isset($_SESSION['name']) || ($_SESSION['contact']) || ($_SESSION['address']) ) {
ini_set('display_errors', 0);

$name =  $_SESSION['name'];
$contact = $_SESSION['contact'];
$address = $_SESSION['address'];

?>

<div id="apDiv1">
  <?php


echo "Name : $name";
echo "</br>";
echo "Name : $contact";
echo "</br>";
echo "Name : $address";

?>
<div id="apDiv2">
<?php
$host="localhost"; 
$username="root"; 
$password="";
$db_name="feedbackdb";


mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");


$sql="SELECT * FROM Feedbacks WHERE Seller = $name";
$result=mysql_query($sql);
echo "<table border=\"5\" width=\"600\" >";
echo "<tr><th>Feedbacks</th><th>From</th><th> To </th>";
    if(mysql_num_rows($result)) 
    { 
    while($row = mysql_fetch_assoc($result)) 
    { 
echo "<tr><td>";
    echo "" .$row['Feedback']."<br></td>";
echo "<td>".$row['From']."<br></td>";
echo "<td>".$row['Seller']."<br></td>";
echo "</tr>";
   } 

}
    else {
    echo "<tr><td align=\"center\"> No Feedback</td></tr>";  
    } 



?></div>


</div>


<?php 
}
else {
header("location:loginpage.php");;
}
?>

Hi I am beginning the first stages of a tumble log and am having some trouble, this works.
<?php

$connection = @mysql_connect('localhost','admin','asdf');
if(!$connection)
(
die('Could not connect to the server!' .mysql_error())
)

?>

but if I add the following I get an error:

<?php

$connection = @mysql_connect('localhost','admin','asdf');
if(!$connection)
(
die('Could not connect to the server!' .mysql_error())
)


if(!mysql_select_db('tumblelog'))
(
die('Could not connect to database')
)


?>

This is the error:
  Quote

Parse error: syntax error, unexpected T_IF in E:\AppServ\www\tumblelog\database.php on line 10




I also tried this to solve the problem:
<?php

$connection = @mysql_connect('localhost','admin','glock123');
if(!$connection)
(
die('Could not connect to the server!' .mysql_error())
)

$db = mysql_select_db('tumblelog'))
if(!$db)
(
die('nope')
)


?>

that only gives me this error: Quote

Parse error: syntax error, unexpected T_VARIABLE in E:\AppServ\www\tumblelog\database.php on line 9

I'm unable to update the table. Could someone tell me why?

$dfield1 = mysql_real_escape_string($field1);
$dfield2 = mysql_real_escape_string($field2);
$dfield3 = mysql_real_escape_string($field3);
$dfield4 = mysql_real_escape_string($field4);

$result =sprintf("SELECT * FROM db1 WHERE username ='%s'", $dfield1);
$resultf = mysql_query($result);
if (mysql_num_rows ($resultf) > 0){
$register = "&err=Not Available. Retry.";
echo($register);
} else {

mysql_query("INSERT INTO db1 (name, birthday, street, phone) VALUES ('$dfield1', '$dfield2', '$dfield3', '$dfield4')");
$register = "Successful.";
echo($register);
}

Hi

I need some help.

I have a page which will show all the result based on the user sign in.
And it will show something like this
ID     | Event Start Date     | Event End Date     | Event Details
1         19-11-2011              20-11-2011            View Event Details
The view event details is a link so when I click on the link, it will link me to the next page (eventDetails.php?id=1)

And at eventDetails.php?id=1 page, it would requires user to input whether they will be attending or not and will they be bringing their friend along then submit the form.

When I submit, how do I pass all the data from eventDetails.php?id=1 page to confirmation.php page (after submitting)?

You might want to refer to the attached coding. All the 2 php pages are working fine but when submit to confirmation.php page, the data are not post over so I didn't attach the confirmation.php page.

Thanks
Ben Chew

[attachment deleted by admin]

Im making an E-learning system that when Student registers the Teacher will approve..
So i've got here a code that outputs all those who registered via Checkbox.

Code: [Select]
<form name="formapprove" method="POST" action="valval3.php" >
<div id="apDiv12"><input type="image" src="images/Approve.png" name="approve" value="approve" width="170" height="35" border="0" >
</div>
  <div id="apDiv11">
  <input type="image" src="images/reject.png" name="reject" width="170" height="35" border="0" value="reject">
</div>
  <div id="apDiv14">';
$host="localhost";
$username="root";
$password="";
$db_name="dbreg";
$tbl_name="account";

mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
echo "<table border=\"5\" width=\"400\" >";
echo "<tr><th>List of Student to be approve</th>";
    if(mysql_num_rows($result))
    {
    while($row = mysql_fetch_assoc($result))
    {
echo "<tr><td>";
    echo "<input type='checkbox' name='list[]' value='".$row['Username']."'>".$row['famname'].",".$row['gname']. ",".$row['mname']. ".<br/></td>";
    echo "</tr></input>";
   }

}
    else {
    echo "<tr><td align=\"center\"> No Student to be Approve / Reject </td></tr>"; 
    }

echo'

</form>

Then the file "valval3.php" will be the one that will save the variables in my database..

Code: [Select]
<?php
session_start();  
if(isset($_SESSION['uname2']) || ($_SESSION['section'])){
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
  

if(isset($_POST['approve_x'], $_POST['approve_y'])) {

mysql_select_db("dbreg", $con);
$uname = $_SESSION['uname2'];
$sec = $_SESSION['section'];

$sql="SELECT * FROM account where sec='$sec'";
$result=mysql_query($sql);
if(mysql_num_rows($result)) 
    { 
    while($row = mysql_fetch_assoc($result)) 
    { 
$fullname = "" .$row['famname']. ", " .$row['gname']. " " .$row['mname']. ".";
}



foreach ($_POST['list'] as $checkbox)
{
$sql="SELECT * FROM account WHERE sec='$sec'";
}

$result=mysql_query($sql);
if(mysql_num_rows($result)) 
    { 
    while($row = mysql_fetch_assoc($result)) 
    { 
    $username = $row['Username'];
$password = $row['Password'];
$gname = $row['gname'];
$mname = $row['mname'];
$famname = $row['famname'];
$sec = $row['sec'];
$studnum = $row['studnum'];
$fullname = "" .$row['famname']. ", " .$row['gname']. " " .$row['mname']. ".";

$username = stripslashes($username);
$password = stripslashes($password);
$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);

$gname = stripslashes($gname);
$famname = stripslashes($famname);
$gname = mysql_real_escape_string($gname);
$famname = mysql_real_escape_string($famname);

$mname = stripslashes($mname);
$mname = mysql_real_escape_string($mname);


foreach ($_POST['list'] as $checkbox)
{
mysql_query("INSERT INTO dbaccount (Username, Password, gname, famname, mname, sec, studnum, fullname)
VALUES ('$username', '$password', '$gname', '$famname', '$mname', '$sec',  '$studnum', '$checkbox')") or die(mysql_error);

mysql_query("DELETE FROM account WHERE sec='$sec'") or die(mysql_error);
}

echo '<script type="text/javascript">
{alert("Approved!");}
</script>'; 
echo '<meta http-equiv="REFRESH" content="0;url=approvereject2.php">';
mysql_close($con);
}
}
else {
echo '<meta http-equiv="REFRESH" content="0;url=approvereject2.php">';
}
}elseif(isset($_POST['reject_x'], $_POST['reject'])) {


mysql_select_db("dbreg", $con);


foreach ($_POST['list'] as $checkbox)
{
$sql="SELECT * FROM account WHERE sec='$sec'";
}

$result=mysql_query($sql);

if(mysql_num_rows($result)) 
    { 

foreach ($_POST['list'] as $checkbox)
{
mysql_query("DELETE FROM account WHERE sec='$sec'") or die(mysql_error);
}


echo '<script type="text/javascript">
{alert("Rejected!");}
</script>'; 
echo '<meta http-equiv="REFRESH" content="0;url=approvereject2.php">';
}

 else {    echo '<meta http-equiv="REFRESH" content="0;url=approvereject2.php">';
 }

}  else {    echo '<meta http-equiv="REFRESH" content="0;url=approvereject2.php">';
}
}
}
else {
header("location:failunautho.php");;
}
?>

 
I tested my codes. Its only working if theres only 1 user registered ( which means one checkbox would appear in page)
But when i tested to have 3 users registered and not yet approve, There would be an error saying..

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 49


Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 49
$username = mysql_real_escape_string($username); <-- line #49



Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 50

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 50
$password = mysql_real_escape_string($password); <-line #50

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 54

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 54

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 55

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 55

$gname = mysql_real_escape_string($gname); <-line #54
$famname = mysql_real_escape_string($famname); <-line# 55

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 58

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 58
mname = mysql_real_escape_string($mname); <-line #58

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 64

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 64
mysql_error
VALUES ('$username', '$password', '$gname', '$famname', '$mname', '$sec',  '$studnum', '$checkbox')") or die(mysql_error) <-line #64


Then still it saves 3 variables.. but all the same.
Hope Someone could help me ..

Hello,

My wife wants to set up a PHP Powered Demerit System at her school. I have basic PHP and MySQL skills.

Basically she wants a web interface where a student logs in with Student Number and Password.

Demerits and merits accrue to the students as below:
Coming late to school, 1 Demerit
Handing an assignment late, 2 Demerits
No Demerits in 3 months equals 1 Merit assigned
Student suspended after 6 / more Demerits
Parent / Gaurdian emailed

The student will see the table below once logged in:
Student Name
Student ID   Date                    Action                        Demerit   Merit           Total
A123           2012/02/26   Late Sign In                 1           0           1
                   2012/02/28   Late Assignment         1           0           2
                   2012/05/29   3 month Merit earned    0           1           1
                   2012/06/08   Late Assignment         2           0           3
                   2012/06/10   Late Assignment         2           0           5
                   2012/06/12   Late Assignment         2           0           7
                                                                                              Student suspended
                                                                                              Send email to parent/gaurdian
                     
I would really appreciate any help you can offer in terms of what PHP code to include in the HTML doc as well as how many MySQL Tables to setup as well as where to store which data?

Thanks,
Ishvir

 So I put this in the wrong place so ill try again,
I need to write a code to add the price of five items with a subtotal, with tax, and then a grand total.
What is the best way to do this?
Every way I have tried isnt working
  PLEASEEEEEE HELP!!!
Using crimson editor

Is there a way i can make a php code for making a lesson then upload to my made system?
Im newbie here. so basically,  i need to make an e-learning system that lets the user make a lesson then upload it so that other user can view their made lesson..  Someone help me pls. 

I have a small mp3 script and its running accurately ...i want to check the mp3 URL before playing it whether  the mp3 link active or broken ....how to check the link is active or broken in php


thanks
 

Hello guys it's me again. I have not posted a question in awhile so I am glad to be on PHPFreaks again. Anyways here is my question,

I have simple "Filter By" or "Refine By" script I am developing. It's foundation is primarily database (MySQL) and does not use XML or other table files. This script simply add's filtered array ("objects") to the url as the customer filters his/her search. An example,

$attributeCodes("processor_type","color","memory"); // These arrays are defined and built from the database on the time of the request. So they are automatically updated.

The above array is used in an if/and/or statement to look for these attribute codes. If it finds it and it has a value it then refines the MySQL query to look for products with the said attribute code.

Now that we have the basics out there of how it works I am at the part where it confuses me.

I give the user the ability to filter his/her search, however I want the user to be able to remove these filters separately if wanted.

So for example the customer filters,

Domain.com/search/productsearch.php?catId=112&processor_type=AMD&memory=2gb

The customer does not need the memory filter and wishes to remove that specific item or vice-verse he/she does not want to search by processor_type. How is it that I can remove specifically one attribute and its value from the URL? So the url will then look like,

Domain.com/search/productsearch.php?catID=112&processor_type=AMD or
Domain.com/search/productsearch.php?catID=112&memory=2gb

Any help would be great. Or if you have any suggestions on a different method to filter by attributes products. Suggestions and criticism are welcome. Please do not be shy or modest when it comes to giving me advice as I am trying to learn efficiently.

- Travis

Hai everbody;

I am finishing my site to open for public but before i have a small problem!



Actually I am using SMF forum software!  I need this help very urgently ! Just need to add login (logout) & register in the template menu!! Please guys try to help me out !!

I will join the index_template.php file for you to make the correction !
(sorry for my bad english)

Thank You a LOT in advance
Daya