WampServer
Apache, PHP, MySQL
on Windows
Problem with MySQL files.
Posted by:
Dimitris
(150.140.130.---)
Date: February 24, 2006 01:42AM
I have set up Wamp5 successfully.
I have created a database named "sxoleio". (host=localhost, user=root, NO pass).
It lies into the path c:/wamp/mysql/data/sxoleio.
I made a project with forms in PHP for searching into the database.
It lies into the path c:/wamp/www/ΕΡΓΑΣΤΗΡΙΟ ΒΔ 2005 - 2006/
There lies the file :
ANAZITISI_MATHITIS.php
<html>
<head>
<title>ΑΝΑΖΗΤΗΣΗ ΣΤΟΝ ΠΙΝΑΚΑ mathitis</title>
</head>
<body>
<h1>ΑΝΑΖΗΤΗΣΗ ΣΤΟΝ ΠΙΝΑΚΑ mathitis</h1>
<?php
// create short variable names
$searchtype=$HTTP_POST_VARS['searchtype'];
$searchterm=$HTTP_POST_VARS['searchterm'];
$searchterm= trim($searchterm);
if (!$searchtype || !$searchterm)
{
echo 'Δεν έχετε εισάγει δεδομένα.Παρακαλώ προσπαθείστε ξανά.';
exit;
}
$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);
$db = mysql_connect('localhost', 'root');
mysql_select_db('sxoleio',$db);
$query = "select * from mathitis where ".$searchtype." like '%".$searchterm."%'";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);
echo '<br />ΟΝΟΜΑ: ';
echo stripslashes($row['name']);
echo '<br />ΕΠΩΝΥΜΟ: ';
echo stripslashes($row['lastname']);
echo '<br />ΑΜ: ';
echo stripslashes($row['am']);
echo '<br />ΚΑΤΑΓΩΓΗ: ';
echo stripslashes($row['katagogi']);
echo '<br />ΠΑΤΡΩΝΥΜΟ: ';
echo stripslashes($row['patronymo']);
echo '<br />ΗΜΕΡΟΜΗΝΙΑ ΓΕΝΝΗΣΗΣ: ';
echo stripslashes($row['hmgen']);
echo '<br />ΤΑΞΗ: ';
echo stripslashes($row['taxi']);
echo '<br />ΑΡΙΘΜΟΣ ΑΙΘΟΥΣΑΣ: ';
echo stripslashes($row['ar_aithousas']);
echo '</p>';
}
?>
</body>
</html>
MY PROBLEM IS THAT :
Warning: Unknown: failed to open stream: No such file or directory in Unknown on line 0
Warning: Unknown: Failed opening 'C:\wamp\www\ΞΞ΅ΞΞΣΤΞΞ΅ΞΞ ΞΞ 2005 - 2006\ΞΞΞΞ ΞΞ¦ΞΞ£_ΞΞΞΞΞΞ¤ΞΞ£Ξ\ANAZITISI_MATHITIS.php' for inclusion (include_path='.;C:\php5\pear') in Unknown on line 0
In what folder must I put the files of my database "sxoleio" in order to connect to it?
I have created a database named "sxoleio". (host=localhost, user=root, NO pass).
It lies into the path c:/wamp/mysql/data/sxoleio.
I made a project with forms in PHP for searching into the database.
It lies into the path c:/wamp/www/ΕΡΓΑΣΤΗΡΙΟ ΒΔ 2005 - 2006/
There lies the file :
ANAZITISI_MATHITIS.php
<html>
<head>
<title>ΑΝΑΖΗΤΗΣΗ ΣΤΟΝ ΠΙΝΑΚΑ mathitis</title>
</head>
<body>
<h1>ΑΝΑΖΗΤΗΣΗ ΣΤΟΝ ΠΙΝΑΚΑ mathitis</h1>
<?php
// create short variable names
$searchtype=$HTTP_POST_VARS['searchtype'];
$searchterm=$HTTP_POST_VARS['searchterm'];
$searchterm= trim($searchterm);
if (!$searchtype || !$searchterm)
{
echo 'Δεν έχετε εισάγει δεδομένα.Παρακαλώ προσπαθείστε ξανά.';
exit;
}
$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);
$db = mysql_connect('localhost', 'root');
mysql_select_db('sxoleio',$db);
$query = "select * from mathitis where ".$searchtype." like '%".$searchterm."%'";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);
echo '<br />ΟΝΟΜΑ: ';
echo stripslashes($row['name']);
echo '<br />ΕΠΩΝΥΜΟ: ';
echo stripslashes($row['lastname']);
echo '<br />ΑΜ: ';
echo stripslashes($row['am']);
echo '<br />ΚΑΤΑΓΩΓΗ: ';
echo stripslashes($row['katagogi']);
echo '<br />ΠΑΤΡΩΝΥΜΟ: ';
echo stripslashes($row['patronymo']);
echo '<br />ΗΜΕΡΟΜΗΝΙΑ ΓΕΝΝΗΣΗΣ: ';
echo stripslashes($row['hmgen']);
echo '<br />ΤΑΞΗ: ';
echo stripslashes($row['taxi']);
echo '<br />ΑΡΙΘΜΟΣ ΑΙΘΟΥΣΑΣ: ';
echo stripslashes($row['ar_aithousas']);
echo '</p>';
}
?>
</body>
</html>
MY PROBLEM IS THAT :
Warning: Unknown: failed to open stream: No such file or directory in Unknown on line 0
Warning: Unknown: Failed opening 'C:\wamp\www\ΞΞ΅ΞΞΣΤΞΞ΅ΞΞ ΞΞ 2005 - 2006\ΞΞΞΞ ΞΞ¦ΞΞ£_ΞΞΞΞΞΞ¤ΞΞ£Ξ\ANAZITISI_MATHITIS.php' for inclusion (include_path='.;C:\php5\pear') in Unknown on line 0
In what folder must I put the files of my database "sxoleio" in order to connect to it?
Re: Problem with MySQL files.
Posted by:
CyberSpatium
(---.hsd1.or.comcast.net)
Date: February 24, 2006 11:24PM
1.) First, you said you created the DB sxoleio, is this a SQLite DB, or a MySQL DB? You dont need to know about the path of the DB (c:/wamp/mysql/data/sxoleio) for MySQL DB's.
2.) The super glogal $HTTP_POST_VARS is old school. Because of regiser global issues in older versions of php, $HTTP_POST_VARS was depreciated. Use the newer and safer super global:
change:
$searchtype=$HTTP_POST_VARS['searchtype'];
$searchterm=$HTTP_POST_VARS['searchterm'];
To this:
$searchtype=$_POST['searchtype'];
$searchterm=$_POST['searchterm'];
3.) According to the errors you are getting, you are not using the right path to inclue your files. For example I put all my php functions in a file called functions.inc.php, and I put them in this folder:
c:wamp\www\includes\functions\functions.inc.php
So, to included them in my php scripts I use:
include_once ('includes/functions/functions.inc.php');
2.) The super glogal $HTTP_POST_VARS is old school. Because of regiser global issues in older versions of php, $HTTP_POST_VARS was depreciated. Use the newer and safer super global:
change:
$searchtype=$HTTP_POST_VARS['searchtype'];
$searchterm=$HTTP_POST_VARS['searchterm'];
To this:
$searchtype=$_POST['searchtype'];
$searchterm=$_POST['searchterm'];
3.) According to the errors you are getting, you are not using the right path to inclue your files. For example I put all my php functions in a file called functions.inc.php, and I put them in this folder:
c:wamp\www\includes\functions\functions.inc.php
So, to included them in my php scripts I use:
include_once ('includes/functions/functions.inc.php');
Sorry, only registered users may post in this forum.
