I used this coding. but it didnt display the value. now i paste my code and output here. Otherwise if you can give full coding for retrieving image from database.
seimg.php
<body>
<form action="seimg.php">
Enter image id:<input type="text" name="foo" />
<input type="submit" name="submit" value="show" />
<?php
$username = "root";
$password = "";
$host = "localhost";
$database = "simg";
@mysql_connect($host, $username, $password) or die("Can not connect to database: ".mysql_error());
@mysql_select_db($database) or die("Can not select the database: ".mysql_error());
//check that $_POST['foo'] exists
if (isset($_POST['foo'])) {
//$_POST['foo'] exists
$foo = $_POST['foo']; //we might perform input validation here
} else {
//$_POST['foo'] does not exist
$foo = ''; //assign a default value
}
//use $foo
echo $foo;
$query = mysql_query("SELECT * FROM img WHERE id='".$foo."'");
$row = mysql_fetch_array($query);
$content = $row['image'];
header('Content-type: image/jpg');
echo $content;
?>
</form>
</body>
</html>
I use that link and do the same way. but i dont know how link one file to another in this program . successfully image downloaded, but not stored into database. can you help me?
I want to store images in database and retrieve. I can successfully stored. But i dont know how retrieve it. If any one know pls help me. I paste my code here.
I dont know how checked in phpmyadmin. Bcoz i write query like "$idvalue=$_REQUEST". So according user selection it will retrieve the values. I don't know how check it in phpmyadmin.
1) I need "where" condition for the first query only for retrieving values from table. I passed id from php . This id passed to next detail.php file like $idvalue=$_REQUEST; Then retrieve value from old table using where id='$idvalue.This underline id is one field of old table.
Ya echo "$idvalue" display the value. just I want retrieve some values from existing table and posted into new table. I used where condition here for retrieve values. But no condition for storing values.already i done this in following way. select from one table and printed in one place and then moved to another table. I thing this long process. so only i need this way. sorry frnd my query also too long.
Just I insert your coding in phpmy admin it produce the following error.
Error
SQL query:
$query = "insert into orde values('$projectid','$projectname','$projectcat','$scope','$location','$rate')";
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$query="insert into orde values('$projectid','$projectname','$projectcat','$scop' at line 1
And I add some codings with this then i show some error
"select * from smenu where id='$idvalue'";
while($row=mysql_fetch_array($result))
{
$projectid=$row['id'];
$projectname=$row['main'];
$projectcat= $row['itemm'];
$scope=$row['descrip'];
$location=$row['Category'];
$rate=$row['Rate'];
}
$query="insert into orde values('$projectid','$projectname','$projectcat','$scope','$location','$rate')";
$dbase=mysql_query($query);
echo $dbase;
error_reporting(E_ALL);
ini_set("display_errors", 1);
error
Error
Error
SQL query: Documentation
"select * from smenu where id='$idvalue'";
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"select * from smenu where id='$idvalue'"' at line 1
now i try this frnd. but one more doubt. Now i clearly say.
insert into table2 , select * from table1 ( It table1 have some empty field). I try to do this Retrieve value from one table and stored into another table. I dont know how do it nu......
I need to perform calculation in same field . $sql="SELECT itemcode,itemname,quantity,price,total,remarks,SUM(total) FROM bill WHERE invoiceno = '".$q."'";
Is this query possible?anybody know say to me pls.
I attached screen shot with this thread. is this possible for calculating these two values and display the same page. This values retrieve from database.
Notice: Undefined index: plo in C:\wamp\www\data\accep.php on line 19 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order values('1','starters','Edamame','Steamed','','4.95')' at line 1
Notice: Undefined index: plo in C:\wamp\www\data\accep.php on line 19 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order values('1','starters','Edamame','Steamed','','4.95')' at line 1
Really thanks for quick reply. I attach one more screen shot. I used list and select the value it retrieve data from database. some fields only empty. You see attachment you get clear idea of my question.
I want display data from database. I done it. but some fields have null values. it display empty field . I attached screen shot with this. If you know the solution pls say to me.
I used following code for automatically incrementing value and stored in database. This working but it have small problem. when I submit value then only incrementing. ex, i entered details for invoice number 2, but it showing invoice number 1.
<?php
mysql_connect("localhost","root","") or die(mysql_error());
mysql_select_db("menus") or die(mysql_error());
$query2=mysql_query("select invoiceno from bill");
while($row=mysql_fetch_array($query2))
{
$var=$row['invoiceno'];
}
$count=$var+1;
echo $count;
?>
ya i try this. its working. i have one more doubt. values from list to text box successfully working. using this value can we retrieve data from database and displayed in another text box. u cant understand na i will send screen shot.
i want calculating values in two text box , result display in another text box and this result will be stored in database. if anybody know this say to me..
