473,614 Members | 2,101 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to copy a row from a table'tipuranib asti'(one field is blob type)to'puranib asti'

1 New Member
in my code all field are copied from tipuranibasti to puaranibasti except image(blob one).in table puranibasti it($image field) shows entry as [BLOB - 0B]

Expand|Select|Wrap|Line Numbers
  1. <?php
  2. include ("connect.php");
  3. $id=@addslashes($_GET['id']);
  4. $image=@mysql_query("select * from tipuranibasti where  id = $id");
  5. $image_row=@mysql_fetch_assoc($image);
  6.  
  7.    $name=@$image_row['name'];
  8.    $date=@$image_row['date']; 
  9.    $msg=@$image_row['msg'];
  10.    $image=addslashes(@file_get_contents($image_row['image']));
  11.  
  12.  
  13. if(@mysql_query("insert into puranibasti values('','$name','$date','$msg','$image')"))
  14. {
  15.     echo "image has been inserted successfully";
  16. } else
  17.  {
  18.  echo "problem inserting the image";
  19.  }
  20. ?>
  21.  
Dec 25 '11 #1
0 1368

Sign in to post your reply or Sign up for a free account.

Similar topics

1
8510
by: Svelte Poshy | last post by:
Copy the content of a field into another field In my table Customers i want to copy the content of the field "Employee" which is a text field, into the field MOL, also a text field I need to copy the field through code, with DoCmd.statement Can somebody help me ?
1
1756
by: Geir Baardsen | last post by:
Hi! As you can see I have worked with my code and done some changes. Now the code will execute, because of this, and because I took away some code in the OnCurrent event that was probably causing a clash. It does in fact copy the new Invoice number and the data from tblOrderDetails, but still missing is the CustID-field, that it refuses to copy. The CustID-field is a Combobox on frmOrders, and is by no way locked or... I again have...
4
4550
by: feng | last post by:
For a HTTP textbox with a Type of "password", the default behaiver is that the field will be cleared out when the page is posted back. This make sense in most of the cases. But in some situation, it become problematic. In our asp.net applicaiton, I would like to keep the password in the field, if the page is posted back. Is this possible? how? Thanks
4
1366
by: micatcat | last post by:
Hello, I have a text field that gets populated when the user clicks on the submit button. How do I transfer this field onto a Word document? Please help me.
17
3620
by: amanda27 | last post by:
Can anyone help me. I have a database that has a form. On the form I have a subform that brings in some data that is relevant to the data on the main form but from a week before (status of projects it was the data is about). If things haven't changed I want someone to click on a button so that the data from the week before goes into the spot for this weeks data. I can't get it to work. I have tried using the expression builder on the on click...
3
2040
by: elainenguyen | last post by:
I want to add a new record and then copy the field DCDate over to the new record, but when I click on the command button it only adds a new record, but didn't copy the DCDate over. Can any body help? here is my code. Private Sub cmdAddNew_Click() DoCmd.GoToRecord , , acNewRec !! = Me.txtDCDate !!.SetFocus End sub
3
9233
by: Richnep | last post by:
Hi all, I have tabbed subforms where I need to copy one field value from one subform over to another subform. Although I can run an update query to accomplish this I would like to do it through VBA. sub tables relationships are 1:N with the main table. So the recods display like this in the subform:
19
6049
by: VUNETdotUS | last post by:
Firefox showed me a security error when I was copying a value of file field object into new DOM created input file field. Can I do something about it? Thanks.
9
1586
by: SuzK | last post by:
In Access 2002, I have created a Make Table query to add a new field “Base$” through a custom function, moving average, that averages each 8 weeks of data. However, I also need to calculate a different result if there is an entry “X” in the Flag field--where there is a Flag "X", I want to duplicate the 8-week average number of the previous record. What is the VBA code to provide that alternate result? Here is a sample of the data, followed by...
2
1364
rightclick
by: rightclick | last post by:
I am setting up a database to be used to keep a point ranking system for my table tennis school. I have a table tblMain with records for each player. It includes a field called StartOfSeasonRank. I have set this to a text datatype. No calculations are performed on this field. It only stores the ranking position of the player at the start of the season and is used in the reporting. At the start of a new season I would like to reset the...
0
8176
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8120
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8620
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8571
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8423
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5537
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4115
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2560
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
1420
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.