PHP - Please Help Me With Mysql Coding!!!

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
 

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

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. 

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 ..

I'm trying to update a field in my MySQL but instead of updating this makes the field BLANK.

my code:
$SomeVar = $_POST['finco'];
mysql_query("UPDATE  c_applicants SET streetz='$cts' WHERE username = '".$SomeVar."'");

$result = mysql_query($query);

How can I get it so the following work:

echo utf8_decode($xml->healings[0]->$xmla[0]->descrip[0]);     // NOT work
echo utf8_decode($xmlb);     // NOT work


<?php
  $xml    = simplexml_load_file('extra.xml');
  $xmla   = "test";
  $xmlb  = "$xml->healings[0]->".$xmla."[0]->descrip[0]";

  echo utf8_decode($xml->healings[0]->test[0]->descrip[0]);        // works

  echo utf8_decode($xml->healings[0]->$xmla[0]->descrip[0]);     // NOT work

  echo utf8_decode($xmlb);     // NOT work
 
?>

    <?php

$Title=$_POST['title'];
$Price=$_POST['price'];
$Author=$_POST['author'];
$con=mysqli_connect('localhost','root') or die("not connected");
mysqli_select_db($con,'BRM_DB');
$query="INSERT INTO book(title,Price,Author)values('$Title',$Price,'$Author')";
$result=mysqli_query($con,$query);
mysqli_close($con);
    ?>
<!DOCTYPE html>
<html>
<head>
<title>Insertion</title>
</head>
<body>
<h1>Book Record Management</h1>
<p>
<?php
if($result==1)
    {
    echo ("Record inserted");
    }
    else 
    { 
    echo ("insertion failed");
    }
    ?>
</p>
<a href="insertform.php">click here</a>
</body>
</html>

why it gives "insertion failed" as a result?

 

 

<?php require_once('Connections/check_mag.php'); ?>
what goes wrong with that code and when i push a link for another post in my page nothing changes? where is the wrong plzzzzz help i cant understand im looking for this for 5 days and i cant find the mistake pllzzzzzzzz heellp . if you write your cooment please give me details because i cant understand very well everything thanx for everythin:)






<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;   
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_check_mag, $check_mag);
$query_getArchives = "SELECT DISTINCT DATE_FORMAT(news.updated, '%M %Y') AS archive,  DATE_FORMAT(news.updated, '%Y-%m') AS link FROM news ORDER BY news.updated DESC ";
$getArchives = mysql_query($query_getArchives, $check_mag) or die(mysql_error());
$row_getArchives = mysql_fetch_assoc($getArchives);
$totalRows_getArchives = mysql_num_rows($getArchives);

mysql_select_db($database_check_mag, $check_mag);
$query_getRecent = "SELECT news.post_id, news.title FROM news ORDER BY news.updated DESC LIMIT 10 ";
$getRecent = mysql_query($query_getRecent, $check_mag) or die(mysql_error());
$row_getRecent = mysql_fetch_assoc($getRecent);
$totalRows_getRecent = mysql_num_rows($getRecent);

mysql_select_db($database_check_mag, $check_mag);
$query_getDisplay = "SELECT news.title, news.blog_entry,  DATE_FORMAT(news.updated, '%M %e, %Y') AS formatted FROM news ORDER BY news.updated DESC LIMIT 2 ";
$getDisplay = mysql_query($query_getDisplay, $check_mag) or die(mysql_error());
$row_getDisplay = mysql_fetch_assoc($getDisplay);
$totalRows_getDisplay = mysql_num_rows($getDisplay);

$var1_getdisplay2 = "-1";
if (isset($_GET['archive'])) {
  $var1_getdisplay2 = $_GET['archive'];

$query_getdisplay = sprintf("SELECT news.title, news.blog_entry, DATE_FORMAT(news.updated, '%%M %%e, %%Y') AS formatted FROM news WHERE DATE_FORMAT(news.updated, '%%Y-%%m') = %s ORDER BY news.updated DESC ", GetSQLValueString($var1_getdisplay2, "text"));

}elseif (isset($_GET['post_id'])) {
  $var2_getdisplay3 = $_GET['post_id'];

$query_getdisplay= sprintf("SELECT news.title, news.blog_entry, DATE_FORMAT(news.updated, '%%M %%e, %%Y') AS formatted FROM news WHERE news.post_id = %s ", GetSQLValueString($var2_getdisplay3, "int"));
}else{
$query_getDisplay = "SELECT news.title, news.blog_entry,  DATE_FORMAT(news.updated, '%M %e, %Y') AS formatted FROM news ORDER BY news.updated DESC LIMIT 2 ";}
$getDisplay = mysql_query($query_getDisplay, $check_mag) or die(mysql_error());
$row_getDisplay = mysql_fetch_assoc($getDisplay);
$totalRows_getDisplay = mysql_num_rows($getDisplay);

?>
<!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"><!-- InstanceBegin template="/Templates/totemp.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="robots" content="index, follow" />
  <meta name="keywords" content="Σύλλογος Ηπειρωτών Πιερίας,Χορευτικός Σύλλογος,Χορός,Χορευτής,Ήπειρος,SYLLOGOS HPIROTON PIERIAS,pieria,ΠΙΕΡΙΑ" />
  <meta name="description" content="Σύλλογος Ηπειρωτών Πιερίας,Χορευτικός Σύλλογος,Χορός,Χορευτής,Ήπειρος,SYLLOGOS HPIROTON PIERIAS,pieria,ΠΙΕΡΙΑ" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Check Magazine</title>
<!-- InstanceEndEditable -->
<link href="styles/check_cs5.css" rel="stylesheet" type="text/css" />
<link href="styles/check_menu.css" rel="stylesheet" type="text/css" />
<!-- InstanceBeginEditable name="head" -->
<!-- InstanceEndEditable -->
</head>

<body>
<!-- DO NOT MOVE! The following AllWebMenus linking code section must always be placed right AFTER the BODY tag-->
<!-- ******** BEGIN ALLWEBMENUS CODE FOR menu ******** -->
<script type="text/javascript">var MenuLinkedBy="AllWebMenus [4]",awmMenuName="menu",awmBN="798";awmAltUrl="";</script><script charset="UTF-8" src="menu.js" type="text/javascript"></script><script type="text/javascript">awmBuildMenu();</script>
<!-- ******** END ALLWEBMENUS CODE FOR menu ******** -->

<div id="container">
  <h1>Check Magazine: Fashion and Lifestyle</h1>
  <div id="eikona"><img src="images/silogos.jpg" width="1211" height="134" alt="silogos" /></div>
  <div id="bara">
    <p>&nbsp;</p>
  </div>
  <!-- InstanceBeginEditable name="EditRegion3" -->
  <div id="blog">
    <p>&nbsp;</p>
    <div id="archive">
      <h3>Archives</h3>
      <ul><?php do{?>
        <li><a href="news1.php">
          <a href="news1.php"><?php echo $row_getArchives['archive'];?></a><a></li>
        <?php } while ($row_getArchives=mysql_fetch_assoc($getArchives));?>
      </ul>
    </div>
    <div id="recent">
      <h3>RECENT</h3>
      <ul>
      <?php do { ?>
        <li><a href="news1.php?post_id=<?php echo $row_getRecent['post_id']; ?>"><?php echo $row_getRecent['title']; ?></a></li>
        <?php } while ($row_getRecent = mysql_fetch_assoc($getRecent)); ?>
      </ul>
    </div>
    <div id="blog_posts">
      <?php do { ?>
        <h2><?php echo $row_getDisplay['title']; ?></h2>
        <p>Uploaded on <?php echo $row_getDisplay['formatted']; ?></p>
        <p><?php echo nl2br($row_getDisplay['blog_entry']); ?></p>
        <?php } while ($row_getDisplay = mysql_fetch_assoc($getDisplay)); ?>
    </div>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
  </div>
  <!-- InstanceEndEditable -->
  <p>&nbsp;</p>
</div>
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($getArchives);

mysql_free_result($getRecent);

mysql_free_result($getDisplay);


?>

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);
}
?>

 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

Could some one please guide me to a possible script to accomplish this task....

I want to pull and display two separate things that are in two separate places and display them as one link on a page. I have figured out how to display the data to a page and also how to display the files to a page separately but need to accomplish this and join the 3 things together.

I have a library table in the database that stores the product_code and product_name
example:

pk-pen(product_code) traditional fountain pen(product_name) ---- (this is where I need to get the data from)

Then I have a folder on the server that is called library that has the pdf files in it. Each pdf file has the same name as the product_code that is in the database.
example:
pk-pen_ins.pdf

What I need to accomplish is grabbing the product_code and product_name for the database and then go to the folder on the server and add the correct pdf file with that data and display it as a link on a page for customers to download. bee struggling with this and pasted code that i have to do each task separately but cant seem to get it all in one script to do the above. I understand that this could be asking for a lot here but I am new to this and would be forever in debt to your kindness. Thanks on this in advance

Hi All

I am fairly new to the PHP world so please excuse my ignorance. (I am trying!)

Basically I bought a commercially available PHP script and created my own script to work alongside the bought one.  What happened then is that the developers of the script I bought released a new version of the software. My script no longer works and is throwing up the following error

PHP Fatal error:  Using $this when not in object context in C:\wamp\www\classifieds\system\core\System.php on line 175

I've worked out that the  script fails on this line, in the new version of the software.

$dbhost = System::getSystemSettings('DBHOST');

On review of the commercial script's coding, I noticed that where the old version used the syntax above, the new version uses a syntax as shown below

$this->appContext->getSystemSettings('DBHOST');

So I went and modified my script (mismatched.php) to read as follows

$dbhost = $this->appContext->getSystemSettings('DBHOST');

But im now getting the following errors

PHP Parse error:  syntax error, unexpected T_REQUIRE_ONCE, expecting T_FUNCTION in C:\wamp\www\classifieds\admin\mismatched.php on line 5

I'd appreciate any ideas you may have that could help me get my script (mismatched.php) working again.
Thanks again
Ali

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");;
}
?>

I have 4 files like attached....

if i clicked on index.php content-1 link... that open templet.php and body load with content-1.txt

please helpme

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]