PHP - Notice: Use Of Undefined Constant Db_dsn - Assumed 'db_dsn' In /export/soi-50/st

Code: [Select]
$entrantQuery = "SELECT entrantID FROM entrants WHERE Game = $idT";
$entrantResult = mysql_query(entrantQuery);
$entrantRow = mysql_fetch_row(entrantResult);

I have these at the start of my php (after getting $idT), but I get the error
Notice: Use of undefined constant entrantQuery - assumed 'entrantQuery' in C:\Entrants.php on line ..

Notice: Use of undefined constant entrantResult - assumed 'entrantResult' in C:\www\Entrants.php on line..

Ive used this code lots of times before, what am I missing? They are variables that I am defining!

Howdy Fairly new to the whole php scene made some php code which works, but i get the error Notice: Use of undefined constant Yes - assumed 'Yes' in C:\Program Files\EasyPHP-5.3.3\www\htdocs\top.php on line 26, line 26 is the first line code, kind of lost and would appreciate an explanation on how to fix this if possible thanks!

Code: [Select]
<?php if ($players['Banned'] == Yes){ 
echo $players['name']  ?> (BANNED)

<?php } else {?>

<a href="profile.php?id=<?php echo $players['id'] ?>"><?php echo $players['name']  ?>

I am having a problem with some php code that runs on a landing page that queries a database for the content needed to display on the template page from the keywords passed in the url. My issue is that when I tried to add some php code to the template page it reads it fails and returns

Notice: Use of undefined constant tdbd_name - assumed 'tdbd_name' in /var/www/ppcindex.php on line 147 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/ppcindex.php on line 150

If anyone could point me in the right direction it would be much appreciated.

Here is the code from the landing page php





<?php 
// template variables - PLEASE CHANGE 


error_reporting(E_ALL); 
ini_set('display_errors','On'); 
define("TEMPLATE_NAME","ppcindexcontent.php"); // your page templates 
define("FULL_PATH","/var/www/speedppc/"); // true path to your speedPPC install directory 
define("MAX_ROWS",1); // maximum display rows for CSV data - we recommend no more the 100 records 

if(!isset($_GET["CSVID"])){ 
    define("CSVID", "18"); // CSVID of your csv file. leave blank if passing csvid in the url (See README.txt) 
} 
else { 
    define("CSVID", $_GET[csvid], true); 
} 

define("REPLACECHAR", '-'); // this is the replacement character for the custom function replace() 
// include files 
include(FULL_PATH."config.php"); 
include(FULL_PATH."common.php"); 

// variables passed in URL 
$csvkeyword = $_GET['csvkeyword']; 
$seed = $_GET['seed']; 
$expansion = $_GET['expansion']; 
$final = $_GET['final']; 

// connect to DB 
$dbhandle = dbconnect($host, $user, $pass, $db); 


// functions 
function replaceTokens($passedContent) { 
    global $csvkeyword, $seed, $expansion, $final; 
    $tokens = array("[%csvkeyword%]", "[%seed%]", "[%expansion%]", "[%final%]", "[%Csvkeyword%]", "[%Seed%]", "[%Expansion%]", "[%Final%]"); 
    $tokenValues = array(rs($csvkeyword), rs($seed), rs($expansion), rs($final), uc(rs($csvkeyword)), uc(rs($seed)), uc(rs($expansion)), uc(rs($final))); 
    $replacedContent = str_replace($tokens, $tokenValues, $passedContent); 
    return $replacedContent; 
} 

function stripUndefinedTokens($passedContent) { 
    $patterns = '/\[%.*?(%\]|\]|%)/'; 
    $result = preg_replace($patterns, '', $passedContent); 
    return $result; 
} 

function changeCase($passedContent) { 
    $patterns = '/\$.*?\]/'; 
    $string = $passedContent; 
    preg_match_all($patterns, $string, $matches); 
    $uniqueMatches = array_unique($matches[0]);   

    foreach($uniqueMatches as $key => $value) { 
        if(substr($value, 13, 1) == strtoupper(substr($value, 13, 1))) { 
            $string = str_replace($value, '".ucwords('.strtolower($value).')."', $string); 
        } 
    } 
    return $string; 
} 

function replaceChar($passedContent) { 
    $string = $passedContent; 
    $patterns = '/replace\(.*?\)/'; 
    preg_match_all($patterns, $string, $matches); 
    $replaceChar = '-'; 
    foreach($matches[0] as $key => $value) { 
        $valueReplaced = str_replace(' ', REPLACECHAR, $value); 
        $string = str_replace($value, $valueReplaced, $string); 
    } 
    $replace = array("replace(", ")"); 
    //$string = str_replace($replace, '', $string); 
    return $string; 
} 

function rs($passWord) { 
    return str_replace('-', ' ', $passWord); 
} 

function uc($passWord) { 
    return ucfirst($passWord); 
} 

// get CSV table Information 
$sql = "SELECT * FROM tabledb_details WHERE tdbd_id = '".CSVID."'"; 
$result = mysql_query($sql); 
$row = mysql_fetch_assoc($result); 

// replace '-' in keyword with space and also use keyword with '-' in it incase it is part of the word 
$keywordsArray = explode(",", $csvkeyword); 
$i = 0; 
foreach($keywordsArray as $key => $value) { 
    $keywords[$i] = $value; 
    $i++; 
    $position = strpos($value, '-'); 
    if($position !== false){ 
        $keywords[$i] = str_replace("-", " ", $value); 
        $i++; 
    } 
} 

// CSV fields  to search keyword occurence in 
$keywordFields = explode("|", $row[tdbd_search_fields]); 

$sqlKeyword = ' ('; 
foreach($keywords as $key => $value) { 
    $sqlKeyword .= "("; 
    foreach($keywordFields as $keyField => $valueField) { 
        $sqlKeyword .= "`" . $valueField . "` REGEXP '( |^)".$value."( |s|[\.]|$)' OR ";  
    } 
    $sqlKeyword = substr($sqlKeyword, 0, -4); 
    $sqlKeyword .= ") OR "; 
} 
$sqlKeyword = substr($sqlKeyword, 0, -4).')'; 

// set the default sql 'where' section if the keyword is not defined in url 
if($csvkeyword == '' || !isset($csvkeyword)) { 
    $sqlKeyword = '1'; 
} 




// start template Display Output 
ob_start(); 
include(TEMPLATE_NAME); 
$output = ob_get_contents(); 
ob_end_clean(); 

// get the position of the loop template 
$loopStart = strpos($output,"[start_csv_loop]"); 
$loopEnd = strpos($output,"[end_csv_loop]"); 
// get the loop template layout 
$loopTemplate = substr($output, ($loopStart+16), ($loopEnd-($loopStart+16))); 

// get content before loop template 
$preContent = stripslashes(stripUndefinedTokens(addslashes(replaceTokens(substr($output, 0, $loopStart))))); 

// get content after loop template 
$postContent = stripslashes(stripUndefinedTokens(addslashes(replaceTokens(substr($output, $loopEnd+14))))); 



// output pre content 
eval("\$preContent = \"$preContent\";"); 
print_r( replaceChar($preContent) ); 

$sqlSearch = "SELECT * FROM ".$row[tdbd_name]." WHERE ".$sqlKeyword." LIMIT ".MAX_ROWS; 
$resultSearch = mysql_query($sqlSearch); 

while($displayrows = mysql_fetch_assoc($resultSearch)) { 
    $display = replaceTokens($loopTemplate); 
    $display = str_replace('\\', '[backslash]', $display); 
    $display = str_replace('[%', '$displayrows[', $display); 
    $display = addslashes(str_replace('%]', ']', $display)); 
    $display = replaceTokens($display); 
    $display = changeCase($display); 

    eval("\$display = \"$display\";"); 

    $display = stripslashes($display); 
    $display = str_replace('[backslash]', '\\', $display); 
    $display = replaceChar($display); 

    print_r( $display ); 

} 
// output post content 
eval("\$postContent = \"$postContent\";"); 
print_r( replaceChar($postContent) ); 
?>




And here is part of the template (ppcindexcontent.php) the above code is reading.

                 <div style=" float:right; width: 300px; height: 0px; margin-top:-20px ; margin-bottom:0px"> 
                <p style=" font-size:16px; text-align: center;  line-height:1; color:#0391D1;">     

                 
<?php 
error_reporting(E_ALL); 
ini_set('display_errors','On'); 
$mySQLServer = "xxxxxx"; 
$mySQLUser = "xxxxxxxx"; 
$mySQLPass = "xxxxxxxxx"; 
$mySQLDB = "xxxxxxxxxxx";  
$SQLToday = date("m/d/y") . "<br />"; 
$SQLsevendays = mktime(0,0,0,date("n"),date("j")-7,date("Y")); 
$SQLsevenname = (date("l", $SQLsevendays)); 
$SQLsevennumber = (date("jS", $SQLsevendays)); 
$dbhandle = mssql_connect($mySQLServer, $mySQLUser, $mySQLPass) 
  or die("Couldn't connect to SQL Server on $myServer");  
$selected = mssql_select_db($mySQLDB, $dbhandle) 
  or die("Couldn't open database $myDB");  
$query = "WEB_ApproveHistory @State='CA', @Days=5, @Records=8"; 
$data = mssql_query($query); 
$result = array(); 

while ($row = mssql_fetch_object($data)) : 
 $result[] = $row; 
 $returnedresults = (97*($row->TotalApprovals)) ; 
  

endwhile; 
$englishreturnedresults = number_format($returnedresults); 
echo 'In just the last week since ' . $SQLsevenname . ' the ' . $SQLsevennumber . ' xx '; 
echo $englishreturnedresults;  
echo ' to People Just Like you In California. <br><br>Here are just a few people who' ; 

echo '<ul class="BulletCheck">'; 

mssql_next_result($data); 


while ($row = mssql_fetch_object($data)) : 

       $result[] = $row; 
       echo '<li>' . '  ' . $row->FirstName  . ' From '. $row->City . ', ' . $row->State .' PreApproved On ' .$row->ApprovedDate . '</li>'; 
endwhile; 
mssql_close($dbhandle); 
?>             

</div>

I get an undefined constant error message.  Am I using the variable correctly?  Should I use an echo to output the variable as text?

Added by <?php ${displayName}; ?>

hi, I have just used teh pagination from this site: http://papermashup.com/easy-php-pagination/

all is working ok apart from I get an error:

Notice: Use of undefined constant num - assumed 'num' in D:\retroandvintage.co.uk\wwwroot\default.php on line 207

line 207: Code: [Select]
$total_pages = $total_pages[num];
Please help?

here is my site: http://www.retroandvintage.co.uk/default.php?page=5

Hi all,

In my server at present php4 is running. upto now it is working fine.Suddenly it is showing lot of errors like
Use of undefined constant or Undefined variable:.

While trying in Google and all i came to know that the variable should be initialized and bounded by quotes.I checked in 1 file and it worked fine.

But my coding is 99% completed and to change in every file is not an easy thing.Can anybody help regarding this Please?

Here i'm having 1 more problem also which suffering me for a long time. I'm having one login form in this.That user session is working properly in Chrome but not in Mozilla.Even in Chrome once i try to logoff and relogin again it is behaving like in Mozilla.

anybody please help me regarding these 2 issues.Thanks in advance.

im getting these errors Notice: Use of undefined constant QUERY_STRING - assumed 'QUERY_STRING' in C:\xampps\htdocs\skyline\admin\other.php on line 36  and  
Notice: Undefined variable: update in C:\xampps\htdocs\skyline\admin\other.php on line 67

 

<?php
    $hostname = "localhost";
    $dbname = "pricelist";
    $username = "root";
        $password = "";
    
        $conn = new MySQLi($hostname, $username, $password, $dbname) or die('Can not connect to database')        
?>
<!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" />
<otype></otype>
</head>
<body>
<?php
    if(isset($_POST['Submit'])){
    
    
    $oname = $_POST['updateoname'];
    
    $otype = $_POST['updateotype'];
    
    $ocost = $_POST['updateocost'];
    
    $onotes = $_POST['updateonotes'];
        
    $update = "UPDATE other SET oname='$oname', otype='$otype', ocost='$ocost', onotes='$onotes' WHERE id = ".$id;
    $conn->query($update) or die("Cannot update");
    }
?>
<?php

$sql = "SELECT * FROM other ";
$result = $conn->query($sql) or die(mysql_error());
$query=getenv(QUERY_STRING);
parse_str($query);
?>
<h2>Update Record </h2>
<form action="" method="post">
<?php
    
    
    while ($row = $result->fetch_assoc()) {?>
    
<table border="0" cellspacing="10">
<tr>
<td>otype:</td> <td><input type="text" name="updateotype" value="<?php echo $row['otype']; ?>"></td>
</tr>
<tr>
<td>ocost:</td> <td><input type="text" name="updateocost" value="<?php echo $row['ocost']; ?>"></td>
</tr>
<tr>
<td>name:</td> <td><input type="text" name="updateoname" value="<?php echo $row['oname']; ?>"></td>
</tr>
<tr>
<td>onotes URL:</td> <td><input type="text" name="updateonotes" size="100" value="<?php echo $row['onotes']; ?>"></td>
</tr>
<tr>
<td><INPUT TYPE="Submit" VALUE="Update the Record" NAME="Submit"></td>
</tr>
</table>
<?php    }
    ?>
</form>
<?php
    if($update){
    
    echo "<b>Update successful!</b>";
    
    
        
}  
?>
</body>
</html>

I'm implementing google's reCAPTCHA V2. It works almost perfectly except for the following error located in the recaptchalib.php:   Notice: Use of undefined constant success - assumed 'success' in (script location)   https://github.com/g...ecaptchalib.php   Anyone got an idea how to fix this?
Edited by tork, 28 November 2014 - 04:24 PM.

I've followed every piece of advice (quotes, no quotes, $...) and nothing works. Here is the snippet of code that's generating the error. This woks fine in PHP 5, but I have to upgrade to 7. Warning if for line 71, which corresponds to where query3 starts. 

if($numRows == 0) {
        $query3 = "INSERT INTO comments (article_id, status, date_posted, feedback, visName, visEmail, notify) VALUES ('".$_POST[article_id]."', '0', NOW(), '$visFdbk', '$nameOfVis', '$emailOfVis', 'y');";    
    }else{
        $query4 = "INSERT INTO comments (article_id, status, date_posted, feedback, visName, visEmail, notify) VALUES ('".$_POST[article_id]."', '0', NOW(), '$visFdbk', '$nameOfVis', '$emailOfVis', '');";
    }
    
}
 

Earlier in code, I define this: $numRows = mysql_num_rows($r);

Thanks in advance for any help you can lend.

Edited February 7 by Poet

Hi All,

I am using PHP 5.3 and storing php session data to the database using session.set_save_handler callbacks. I see that the write method, strangely treats the Class constant as undefined. All the other methods seem to work fine with the class constant. Any reason why this would happen? Please see code below. I get an error "Use of undefined constant db_table in Sessions.php in line". This seems to be happening only with the write api. Can someone please help?

Thanks


class Sessions {
 //var $life_time;
 var $id;
 var $data;
 const db_table = 'php_mysql_session';
   function PHPSessions() {
      // Read the maxlifetime setting from PHP
      //$this->life_time = get_cfg_var("session.gc_maxlifetime");

      $this->id = session_id();
      $this->data = '';

      // Register this object as the session handler
      session_set_save_handler(
      array( &$this, "_open" ),
      array( &$this, "_close" ),
      array( &$this, "_read" ),
      array( &$this, "_write" ),
      array( &$this, "_destroy") ,
      array( &$this, "_gc" )
      );

   }
function _open ()
// open the session.
{
   Zend_Log::log("opening connection");
   global $_sess_db;
   Zend_Log::log("session db ".$_sess_db);
   if ($_sess_db = mysql_connect(DB_HOST_READ, DB_USER, DB_PASS)) {
      return mysql_select_db('TEST_SESSION', $_sess_db);
   }
   // If there is a failure return false
   return FALSE;

} // open


function _close ()
// close the db connection here
{
   global $_sess_db;
   return mysql_close($_sess_db);

} // close

function _read ($id)
// read any data for this session.
{

   
    global $_sess_db;
    Zend_Log::log("Session db ".$_sess_db);
   //$id = mysql_real_escape_string(session_id());
    Zend_Log::log("Session Id :" .$id);

   $sql = "SELECT * FROM ". self::db_table ."
   WHERE session_id = '$id'";
   Zend_Log::log("SQL IS : ".$sql);
 
     $data = '';
   $result = mysql_query($sql);
   $a = mysql_num_rows($result);
   Zend_Log::log("Record count ".$a);

   if($a > 0) {
      Zend_Log::log("Record Exists!");
      $row = mysql_fetch_assoc($result);
      $data = $row['session_data'];
      Zend_Log::log("Fetching session Data ".$data);
      return $data;
   }
   else
   {
      Zend_Log::log("No Data ".$data);
      return '';
   }


 
}

function _write ($id, $data)
// write session data to the database.
{
   global $_sess_db;
   
 
   $newid = mysql_real_escape_string($id);

   $newdata = mysql_real_escape_string($data);

   $sql = "REPLACE ". self::db_table ." (session_id,user_id,session_data,date_created) VALUES('$newid', '$userid', '$newdata', 'NOW()')";

   $rs = mysql_query($sql);

   return TRUE;
 

} // write

 
function _destroy ($id)
// destroy the specified session.
{
     Zend_Log::log("Destroy method ");
   return TRUE;

} // destroy

function _gc ($max_lifetime)
// perform garbage collection.
{
     Zend_Log::log("GC Method");
   return TRUE;

} // gc

function _destruct ()
// ensure session data is written out before classes are destroyed
// (see http://bugs.php.net/bug.php?id=33772 for details)
{
   @session_write_close();

} // __destruct

// ****************************************************************************
} // end class

I'm getting the following notice:
Notice: Undefined variable: TotaalBerichten in
C:\Users\Sander\Documents\**********************\index.php on line 60
Is it because it is in the IF?
The code:

        //Aantal berichten totaal  
 if (!$ResultTotaalBerichten = @mysql_query("SELECT COUNT(1) FROM " . $db_prefix . "berichten"))
             {$foutmelding .= $Taal['errorConfiguratieFromDB'];}
         else
             {$TotaalBerichten = mysql_result($ResultTotaalBerichten, 0);
             $TotaalPaginas = ceil($TotaalBerichten / $aantalBerichtenPerPagina);}
         @mysql_free_result($ResultTotaalBerichten);

         //Var eersteBericht is het eerste bericht
         if (isset($_GET['eersteBericht']))
             {if (!is_numeric($_GET['eersteBericht']))
                 {$eersteBericht = '0';}
             else{$eersteBericht = $_GET['eersteBericht'];}}
         else{$eersteBericht = '0';}

        // Als er iets mis is met var eersteBericht, dan hem op 0 zetten
        if (($eersteBericht >= $TotaalBerichten) || ($eersteBericht < 0))   ///////////DIT IS LIJN 60
             {$eersteBericht = 0;}


EDIT: translated to english 

If i modify it to:

$TotaalBerichten=0; /////////////ADDED
        //Aantal berichten totaal  
 if (!$ResultTotaalBerichten = @mysql_query("SELECT COUNT(1) FROM " . $db_prefix . "berichten"))
             {$foutmelding .= $Taal['errorConfiguratieFromDB'];}
         else
             {$TotaalBerichten = mysql_result($ResultTotaalBerichten, 0);
             $TotaalPaginas = ceil($TotaalBerichten / $aantalBerichtenPerPagina);}
         @mysql_free_result($ResultTotaalBerichten);
echo $TotaalBerichten;   //////////////////////////////////////////////////////////////////////////ADDED
         //Var eersteBericht is het eerste bericht
         if (isset($_GET['eersteBericht']))
             {if (!is_numeric($_GET['eersteBericht']))
                 {$eersteBericht = '0';}
             else{$eersteBericht = $_GET['eersteBericht'];}}
         else{$eersteBericht = '0';}

        // Als er iets mis is met var eersteBericht, dan hem op 0 zetten
        if (($eersteBericht >= $TotaalBerichten) || ($eersteBericht < 0))   ///////////DIT IS LIJN 60
             {$eersteBericht = 0;}


The $TotaalBerichten is '0' while there IS a message in the database???

while i am coding to find text between some html tags ,,
am getting an error...
Notice: Undefined offset: 1 in D:\xamp\xampp\htdocs\file\dash.php on line 48


my code is at line 47 and 48 is

Code: [Select]
preg_match('/<td class="trow1" rowspan="3" valign="top">(.*)<\/td> /',$dat,$regs);
echo $etc=$regs[1];
i am thinking copy data from

Code: [Select]
</td>
<td class="trow1" rowspan="3" valign="top">
Posts per day: <strong>6.03</strong><br />
Threads per day: <strong>3.78</strong><br />
Members per day: <strong>4.76</strong><br />
Posts per member: <strong>1.27</strong><br />
Replies per thread: <strong>0.6</strong>
</td>
</tr>


this much

Code: [Select]
Posts per day: <strong>6.03</strong><br />
Threads per day: <strong>3.78</strong><br />
Members per day: <strong>4.76</strong><br />
Posts per member: <strong>1.27</strong><br />
Replies per thread: <strong>0.6</strong>

I got this error when i click update button

Notice: Undefined index: name in C:\wamp\www\mariyano\New Folder - Copy\New\update.php on line 14

Notice: Undefined index: mobile in C:\wamp\www\mariyano\New Folder - Copy\New\update.php on line 14

Notice: Undefined index: email in C:\wamp\www\mariyano\New Folder - Copy\New\update.php on line 14
Unknown column 'diwakar' in 'where clause'

Code: [Select]
<?php

$cn=mysql_connect("localhost","root","");
mysql_select_db("super",$cn);

if(isset($_POST['submit']))
{
//checks cookies to make sure they are logged in 
if(isset($_COOKIE['ID_my_site'])) 
{ 
$username = $_COOKIE['ID_my_site']; 

$qy="UPDATE users SET name='$_POST[name]',  email='$_POST[mobile]',  city='$_POST[email]' WHERE username=$username ";

mysql_query($qy,$cn) or die(mysql_error());
}
}

?>



Code: [Select]
<?php
$cn=mysql_connect("localhost","root","");
mysql_select_db("super",$cn);

//checks cookies to make sure they are logged in 
if(!isset($_COOKIE['ID_my_site'])) 
{
header("Location: login.php");
}

echo "<h3>Profiles</h3><br/><br/>";
echo "Name: <input type=\"text\" name=\"name\" > ";
echo "<br/>";

echo "Email: <input type=\"text\" name=\"email\"> ";
echo "<br/>";
echo "City: <input type=\"text\" name=\"city\"> ";

//echo "<br/><br/><input type=\"submit\" value=\"Update\" >";
//echo "<br/><br/><a href=logout.php>Logout</a>"; 
?>

<html>

<form action='update.php' method='post'>
<br/>
<input type='submit' name='submit' value='Update' >

<br/><br/><a href=logout.php>Logout</a>
</form>

</html>

Hello all - am looking for help with dynamic links in PHP not returning data and coughing out "Notice: Undefined variable: row in /home/jj3wg2td/public_html/Uni More Info.php on line 200"

The initial search is being fed from a mysql into table of results in another page ('ViewMore' being a column in my database and 'UniversityCourses' being the trigger to search that column):

echo "<td class='result'><a href='Uni More Info.php?ID={$row['UniversityCourses']}'>{$row['ViewMore']}</a></td>";

This is working fine as I can see the various links changing when you hover over them in the table.

clicking the links goes to "Uni More Info.php"

where my PHP code is:

<?php
session_start();
	
ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL);	

//Connect to the database
$mysqli = new mysqli("localhost", "jj3wg2td_wix", "MYPASSWORD", "MYDATABASE");

if(isset($_GET['post'])){

	$ID=mysqli_real_escape_string($mysqli, $_GET['ID']);
	
	$sql="SELECT * FROM uni2020 WHERE UniversityCourses='$ID'";
	$result=mysqli_query($mysqli,$sql) or die ("Bad Query: $sql");
	$row=mysqli_fetch_array($result);
	
	if(isset($_GET['post'])){
		$Website=mysqli_real_escape_string($mysqli,$_GET['Website']);
		$UcasPointsRequired=mysqli_real_escape_string($mysqli,$_GET['UcasPointsRequired']);
		$OverallScore=mysqli_real_escape_string($mysqli,$_GET['OverallScore']);
		
	$sql= "INSERT INTO UniversityCourses (Website, UcasPointsRequired) VALUES ('$Website', $UcasPointsRequired');";
	$result=mysqli_query($mysqli,$sql) or die ("Bad Query: $sql");
	}
}	
	
?>
<content>
	<?php echo $row['Website']?>
	<?php echo $row['UcasPointsRequired']?>
	<?php echo $row['OverallScore']?>
</content>

The error codes are showing:

Notice: Undefined variable: row in /home/jj3wg2td/public_html/Uni More Info.php on line 200

Notice: Undefined variable: row in /home/jj3wg2td/public_html/Uni More Info.php on line 201

Notice: Undefined variable: row in /home/jj3wg2td/public_html/Uni More Info.php on line 202

Which is the section in-between the <content></content> tags.

Reading up into "Undefined Variable", it suggest that I havent  "Declared the variables", but isn't that this section?:

if(isset($_GET['post'])){
		$Website=mysqli_real_escape_string($mysqli,$_GET['Website']);
		$UcasPointsRequired=mysqli_real_escape_string($mysqli,$_GET['UcasPointsRequired']);
		$OverallScore=mysqli_real_escape_string($mysqli,$_GET['OverallScore']);

I am new to PHP and am learning as I go along....but yet again...I'm stumped!

Any help is very much appreciated (again)!!!!

 

Steven