Solved

Increment data to database (php - mysql)

Posted on 2009-06-28
4
229 Views
Last Modified: 2012-05-07
Hi experts, in my database I have a field that have this kind of format, word word word word, in practice can be "great bottle water fresh" or more words.
That field in database can be editable, every time I put a new word I put them in the beggining of string, in practice if I want put a new word (ex. super) the result would be "super great bottle water fresh".

For i do the upgrade I use this steps:
Call database and get the string "great bottle water fresh"
join variables $newone + $database_result and becomes "super great bottle water fresh".
upgrade database

My question is, this is the best way for do that? have other way to increment database without call the $database_result?

Regards, JC
0
Comment
Question by:Pedro Chagas
  • 3
4 Comments
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 400 total points
ID: 24732002
in 1 statement:
$sql = "UPDATE yourtable SET yourfield = CONCAT('" . mysql_real_escape_string($new_word) . "', ' ', yourfield ) WHERE id = 1234 ";

Open in new window

0
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 400 total points
ID: 24732004
note: this sounds however like bad design, aka each word should go to a dedicated row, instead of concatenating all the words into 1 string.
0
 
LVL 3

Author Comment

by:Pedro Chagas
ID: 24732054
Hi @angelIII, thanks for your feedback.
I thing you give me a great solution, the problem is I don't understand in that way, and I need a practical example.
Usually I use this code for update the database:
mysql_query("update words set palavras='$newwordstring' where id='$other_variable'", $db);
===================================

How I put your solution in my line of code?

Regards, JC
 
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 400 total points
ID: 24732091
yes:
$sql = "UPDATE words SET palavras= CONCAT('" . mysql_real_escape_string($newwordstring) . "', ' ', palavras) WHERE id = '$other_variable' ";
mysql_query($sql);

Open in new window

0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read about achieving the basic levels of HRIS security in the workplace.
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question