Problem with DB connection
Posted on
16th Feb 2014 07:03 pm by
admin
Hello there! I'm new to this forum and I'm new to PHP coding also. I wrote something that doesn't make exactly what I thought it will. Can you give me a hand please. There we go:
Code: [Select] <?php
error_reporting(E_ALL);
$Host = "***";
$User = "***";
$PassWord = "****";
$DataBaseName = "***";
$TableName = "products";
mysql_connect($Host, $User, $PassWord);
mysql_select_db($DataBaseName);
if (isset($_GET['id'])) {
$id = (int)$_GET['id'];
// $select = "SELECT id FROM" . $TableName;
if ($id > 0) {
$select = "select description from" . $TableName . "WHERE id = " . $id;
$result = mysql_query($select);
echo $result;
echo $id;
}
else {
echo "id not > 0";
}
}
else {
echo "ID not set;
}
?>
<p><a href="proba.php?id=1" name="id=1"> Find out more about it. </a></p>
<a href="proba.php?id=2" name="id=2"> Find out more about it. </a></p>
<a href="proba.php?id=3" name="id=3"> Find out more about it. </a></p>
That's a testing page only. What happens here is that only the ID is displayed.
The funny thing is when i add this code to the original page, my apache gives errors on the localhost and i get Quote Premature end of script headers. Obviously I'm doing something wrong, but I don't know what it is. oh, when i run this code on the original page but remove the password, apache is not shoting..
No comments posted yet
Your Answer:
Login to answer
237
36
Other forums
Help building / using array
First - this is a cross-posting, if this is wrong I apologise! What started out as a MySQL query que
Select question
Hi,
First I would like to say that php is pretty new for me..
so please don't shoot me if
Schedule editor
Hi,
I have a question related to Schedule editor.
If we schedule a BLS for every 30
Get content from table into a list, without repeating.
Alright this is kinda an odd thing, so I need some help.
I have a table "quote" wit
PHP form authentication
Hi guys,
what am trying to achieve is this: Whenever a user tries to login to my website, an
Set Categories
I am creating a submission form for somebody to come in and submit products. These products are sep
cURL proxy
Okay here is the thing... i know how to add proxys
Code: curl_setopt($ch, CURLOPT_PROXYTYPE,
close site for maintenance
i get a tutorial, saying the following code can put our site offline, and only the developer can vie
string to currency format
Hi guys...
Actually I chunk out some data from txtfile and one of the data contains amount va
Line break?
Hi, I'm new to the forum and new to php. I'm not sure if I'm using the correct terminology so here i