Hi,,
My problem is that i have two table city and location.In city table i have 3 field city_id(Primary key),city_name,city_status where city_status is true or false.In location table i have 3 field also loc_id(Primary key),city_id,loc_city.i done a code in which city_name comes into drop down list from city table.my problem starts here when i select one of this value and want to insert into location table...then this show error..is there any code available related to my problem plz send my id......
muneer_alam 0 Newbie Poster
richieking 44 Master Poster
post your code .i need to look through
:)
muneer_alam 0 Newbie Poster
Here is my code which i am using here...........
droplistcity.php
<html>
<head>
<script language="JavaScript">
function onChange() {
var Current=document.form1.select1.selectedIndex;
document.form1.currentText3.value=document.form1.select1.options[Current].text;
}
</script>
</head>
<body>
<form name="form1" method="POST">
<?php include("connect.php")?>
<table border="1" align="center">
<tr><td>List of City</td>
<td><select name="select1" onChange="onChange()">
<option value="">Select City</option>
<?php
$reza=mysql_query("select city_id,city_name from city order by city_id");
while ($row=mysql_fetch_array($reza)){
$id1=$row["city_id"];
$id2=$row["city_name"];
echo "<option value=\"$id2\">$id2</option>";
}
mysql_close($con);
?>
</select></td>
</tr>
<tr><td>Selected City</td>
<td><input
name="currentText3"
type="text"
value=""
></td>
</tr></form>
</body>
</html>cityname.php
<?php include("connect.php");?>
<?php
$city_name = $_POST['currentText3'];
$result=mysql_query("select * from city where city_name='$city_name'");
while($row = mysql_fetch_array($result))
{
echo $row['city_name'] ;
echo "<br />";
}
mysql_close($con);
?>addloc.php
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<form name="form1"action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table border="1" align="center">
<input type="hidden" name="l_id" />
<tr>
<?php include("droplistcity.php");?>
</tr>
<tr>
<td>Location Name</td>
<td><input type="text" name="location" /></td></tr>
<tr>
<td></td><td><input type="submit" value="added!">
</td>
</tr>
</table>
</form>
</body>
</html>
<?php include("connect.php");?>
<?php include("cityname.php");?>
<?php
$l_id = $_POST['l_id'];
$city_id = $_POST['city_name'];
$location = $_POST['location'];
$query = "INSERT INTO location (loc_id, city_id,loc_city) VALUES('$l_id',(SELECT city_id FROM city WHERE city_id = '$city_id'),'$location')";
$result = mysql_query($query) or die("Query failed: ".mysql_error());
mysql_close($con);
?>
here is my all code........plz reply as soon as possible....... muneer_alam 0 Newbie Poster
Here is my code which i am using here...........
droplistcity.php
<html>
<head>
<script language="JavaScript">
function onChange() {
var Current=document.form1.select1.selectedIndex;
document.form1.currentText3.value=document.form1.select1.options[Current].text;
}
</script>
</head>
<body>
<form name="form1" method="POST">
<?php include("connect.php")?>
<table border="1" align="center">
<tr><td>List of City</td>
<td><select name="select1" onChange="onChange()">
<option value="">Select City</option>
<?php
$reza=mysql_query("select city_id,city_name from city order by city_id");
while ($row=mysql_fetch_array($reza)){
$id1=$row["city_id"];
$id2=$row["city_name"];
echo "<option value=\"$id2\">$id2</option>";
}
mysql_close($con);
?>
</select></td>
</tr>
<tr><td>Selected City</td>
<td><input
name="currentText3"
type="text"
value=""
></td>
</tr></form>
</body>
</html>cityname.php
<?php include("connect.php");?>
<?php
$city_name = $_POST['currentText3'];
$result=mysql_query("select * from city where city_name='$city_name'");
while($row = mysql_fetch_array($result))
{
echo $row['city_name'] ;
echo "<br />";
}
mysql_close($con);
?>addloc.php
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<form name="form1"action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table border="1" align="center">
<input type="hidden" name="l_id" />
<tr>
<?php include("droplistcity.php");?>
</tr>
<tr>
<td>Location Name</td>
<td><input type="text" name="location" /></td></tr>
<tr>
<td></td><td><input type="submit" value="added!">
</td>
</tr>
</table>
</form>
</body>
</html>
<?php include("connect.php");?>
<?php include("cityname.php");?>
<?php
$l_id = $_POST['l_id'];
$city_id = $_POST['city_name'];
$location = $_POST['location'];
$query = "INSERT INTO location (loc_id, city_id,loc_city) VALUES('$l_id',(SELECT city_id FROM city WHERE city_id = '$city_id'),'$location')";
$result = mysql_query($query) or die("Query failed: ".mysql_error());
mysql_close($con);
?>
here is my all code........plz reply as soon as possible....... richieking 44 Master Poster
$query = "INSERT INTO location (loc_id, city_id,loc_city) VALUES('$l_id',(SELECT city_id FROM city WHERE city_id = '$city_id'),'$location')";
Why dont you try simple select query to get the city_id and then insert into location table,
That should work ok? ;)
I also want to see your error mysql prints;
muneer_alam 0 Newbie Poster
Query failed: Access denied for user 'ODBC'@'localhost' (using password: NO)
when i am accessing file addloc1.php
plz find as soon as possible....
richieking 44 Master Poster
you must set password for your mysql connection.
example:
$host="localhost";
$user="root";
$pass="SeKr1t";
mysql_connect($host,$user,$pass); // You need a password set ok?thats all ;)
muneer_alam 0 Newbie Poster
Thanks for your reply but i have tried this one also there was no result.is there any problem on my code or query......
plz reply me....
richieking 44 Master Poster
please get this for me.
1. what is your database engine or type. eg ms sql, mysql, oracle, etc.
2. did you received any errors of any kind.??
a.if yes, post the error
b. if no, make sure you have data in the database for your query.
please advice. ;)
muneer_alam 0 Newbie Poster
i am using mysql and iis for running application.....all are current version...
(if no, make sure you have data in the database for your query.) what is the meaning of this...........
richieking 44 Master Poster
populate at least some few data in your tables that you query.
if they are empty, you will get no data out.
Do what i told you and post all errors if any.
muneer_alam 0 Newbie Poster
in my city table there are two entry
city_id 1,2
city_name noida ,lucknow
city_status true,true
in my location table this is empty.....because i am inserting this...
richieking 44 Master Poster
You error must be very simple only i cant understand what you really want.
// select from city
$query= "select city_id from city where( you know what you want)";
//exe query
$result=mysql_query($query) or die();
$row=mysql_fetch_array($rsult));
$city_id=$row['city_id'];
// then insert into location
if($city_id){
$q= "insert into location values('','$location_nane','$city_id')";
$re=mysql_query($q) or die (mysql_error());
if($re){
echo "roger that";
}
}this should be out last contact skyhawk 67.
roger that ;)
muneer_alam 0 Newbie Poster
My problem is not resolved yet when i am running this code a problem is displaying
HTTP Error 500.0 - Internal Server ErrorThe page cannot be displayed because an internal server error has occurred.
what is this error????/
richieking 44 Master Poster
your server is not setup well. This got nothing to do with your mysql stuff.
Did you play around with the apache2 conf or the php ini? ????
need more info :)
muneer_alam 0 Newbie Poster
Error SummaryHTTP Error 500.0 - Internal Server ErrorThe page cannot be displayed because an internal server error has occurred.Detailed Error InformationModule FastCgiModule
Notification ExecuteRequestHandler
Handler PHP_via_FastCGI
Error Code 0x00000000
Requested URL http://localhost:80/muneer/newzstreet/addloc1.php
Physical Path C:\inetpub\wwwroot\muneer\newzstreet\addloc1.php
Logon Method Anonymous
Logon User Anonymous
HOw can i remove this error?......I am using IIS server not apache.....
richieking 44 Master Poster
o hell no,
I dont remember the last time i used microsoft stuff.
why dont you simply use wamp or xamp.??
well thats your taste. if you care to, just google wamp or xamp and start developing. They are better for php my friend ;)
muneer_alam 0 Newbie Poster
<?php include("connect.php");?>
<?php include("cityname.php");?>
<?php // select from city
$query= "select city_id from city where(city_name='$city_name')";
//exe query
$result=mysql_query($query) or die();
$row=mysql_fetch_array($rsult);
$city_id=$row['city_id'];
// then insert into location
if($city_id){
$l_id=$_POST['l_id'];
$location=$_POST['location'];
$q = "INSERT INTO location (loc_id,city_id,loc_city)VALUES('','$city_id','$location')";
$re=mysql_query($q) or die (mysql_error());
if($re){
echo "roger that";
}
}
?>when i am using this code following i find this code
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\newzstreet\addloc1.php on line 29
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampp\htdocs\newzstreet\addloc1.php on line 29
currently i am using Apache server
richieking 44 Master Poster
Check if your DB was connected.
The Link to the DB server was not established.
1. You must connect to your mysql server with your hostname, uername, password.
Do that first . ::)
xerilagang 0 Newbie Poster
Thanks for your reply, but I also tried result.is had a problem in my code or the implementation of ...... plz answer me ....
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.