Hello friends,
I have face a problem, the problem is that when i fetch data from mysql database i get '&' in the place of '&'. I am using php 5.1.2 and mysql version 5.0.11-beta.
What is the problem? any body solve my problem?
Please answer me.
Thanks in advance!
3 3540 code green 1,726
Recognized Expert Top Contributor
Are you sure?
If viewing results in a browser you won't see the 'amp;'
Thanks for your reply.
Yes i can't see the 'amp;'.
I entered a text like 'testing articles & others' in a text box. This text saved in a mysql database like 'testing articles & others'. But when i fetch this text through mysql_fetch_ass oc the text display in the browser like 'testing articles & others' and if i submit this text again in the database i find only 'testing articles & others' . So each time when i edit this i have to put '&' in the place of '&'.
Thanks in advance!
code green 1,726
Recognized Expert Top Contributor
If you view the browser source code you will see '&' It is still there just not visible in the browser as should be.
But if I understand your problem, you wish to reinsert the edited data back into the DB with 'amp;' still intact.
First just double check what I have said above is correct.
Then are you using PHP by any chance?
If so try calling function htmlspecialchar s() just before inserting the text back into the DB.
Failing that, the only thing I can think of is runnng the text through your own function using string functions to add the additional 'amp;' before re-insertion
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: James |
last post by:
HI,
I'm looking for a script that will allow users/admins to have a one
click backup solution for a MYSQL Database..
'BACK DATABASE' button, click and its done...
The a restore option, that shows all current backups, and restores the
selected one with one click...
|
by: Ken |
last post by:
First time I have installed mysql.
I have not been able to connect to the server/database with a new php
installation.
I have installed IIS. Do I need this for mysql?
The php works fine. I can run scripts,etc.
When I try mysql_connect ("localhost","mysql_user", mysql_password") or
|
by: Andy |
last post by:
I'm using Mysql Max-4.1.4-gamma for Linux.
I have a question related to a problem with my database server.
If on my db server I have 2 different database, say DB1 & DB2, I
create two INNODB tables with the same name (foo), one for each
database, how they are stored in the innodb data dictionary ?
DB1.foo & DB2.foo or simply foo ?
Thank you in advance
Andrea
|
by: MLH |
last post by:
A programmer developed an AMP (Apache/MySQL/PHP) application
for me. When he was done, he sent me the PHP files and the MySQL
dump file. Now, when I connect to the application on my LAN using
http://192.168.1.106/~mlh/credifree/index.php the AMP app still
thinks the data resides somewhere else. It runs fine - as long as I
leave my LAN's external internet connection up. But if I unplug my
LAN from the world, my app locks up.
Before I...
|
by: Steven Sinfield |
last post by:
Hi All,
I am trying to use PHP & MySQL over SSL, my issue is that the data that I am
querying also needs to be available by non-secure as well.
Can someone please help me in doing this.
Cheers
Steve
| |
by: Smriti Dev |
last post by:
Hi,
I have a question regarding autonumbering . I'm using linked tables between
msql and MS Access. Quite a few linked tables exist with relationships. The
auto increment fields once linked loose thier autonumber property and come
up as numbers.
I have developed a form interface and when I press the next record the next
number does not come as the autonumber property has been lost. Thier are
quite a few relationships with linked...
|
by: pmz |
last post by:
Dear Group,
I'm connecting in C# with remote (BSD) MySQL server with ODBC Driver,
and I'm trying to find the best sollution in such problem:
As I've read on MySQL manual, they have suggested table design
including the BLOB-Fieldtype size in UInt64, where they've stored,
while inserting, the size of inserted BLOB data. But in the matter of
fact, I'm interested if it's necessary to include in table this integer
field? Is there any way...
|
by: ronverdonk |
last post by:
Sorry acousticmarc, I accidentally removed your thread!! - Ronald
Hello, first time post here and novice php user.
Man, this is frustrating the hell out of me. I've got a timecard database that goes way back, to the early 90's. I've created a form that will select the employee_id as well as any particular contract_id associated with that employee, hours and billing date. What I really want to do is be able to select a date range...
|
by: AndrewJ |
last post by:
I am having problem decoding data which is imported into a MySQL 4.0.* DB (thus no UTF-8 character set encoding possible)
Basically my application utilises PEAR for DB abstraction.
I import data from an EXCEL file directly into the DB. The data is imported correctly, i.e. I do not want it encoded in the DB. I want it imported directly with the special characters intact. So ë remains ë!
When I retrieve the Data it is not displaying...
|
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...
|
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,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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...
| |