mysql help

[ra20002]

how 2 save image path (not the image) into mysql database .....

if u can plz give me the code......

 

[ra20002]

kauruth nadooooooo????????

 

[NisalJaya]

add a column for image parth. lets say imgpath varchar(255) NOT NULL default ''
you can put a string value upto 255 characters length on imgpath column.

e.g "path/to/image/myfile.jpg"

btw what is your programming language? php? or perl?

 

[ra20002]

add a column for image parth. lets say imgpath varchar(255) NOT NULL default ''
you can put a string value upto 255 characters length on imgpath column.

e.g "path/to/image/myfile.jpg"

btw what is your programming language? php? or perl?

not working machan ........ can u give me the full code......

 

[gnome89]

 

[ra20002]

 

[NisalJaya]

not working machan ........ can u give me the full code......

What is your programming language?

 

[ra20002]

What is your programming language?

java....but i wnt 2 store this image path in sql syntax

 

[ra20002]

helpppppppppppppppppppppppppppppppppppppppppppppppppppppppppppp

 

[ra20002]

kauruth nadooooooo

 

[ra20002]

 

[ra20002]

 

[asachan]

Mata pena widihata wenna one de hariyata kiyala na ban

By default saving a image path to a R-Table field is not a big task ban
It's very simple

I think you have a special task and you need to explain what is that pls
Then we can help you

 

[ra20002]

Mata pena widihata wenna one de hariyata kiyala na ban

By default saving a image path to a R-Table field is not a big task ban
It's very simple

I think you have a special task and you need to explain what is that pls
Then we can help you

mekai machan seen eka mata one image eka DB ekata save karala eta passe eka jsp eka through call karanna (server eka glassfish)

vena solution ekak thiyanavanam ekath kiyanna......

 

[asachan]

mekai machan seen eka mata one image eka DB ekata save karala eta passe eka jsp eka through call karanna (server eka glassfish)

vena solution ekak thiyanavanam ekath kiyanna......

1. Mulinma Mysql wala table eka set karaganna
Image column ekata tikak wadipura chars thiyaganna

2. Image path eka save karanna

3. JSP code eken db eka access karala dala table eka filter karaganna
E field eke walue eka aragena Image eka Image display karana control ekata pass karanna

Mama Jsp wadiya danne na machan. ASP ASP.net nam okata code eka dennam

 

[miyuru4u]

mysql wala image save karanne blob kiyana data type eken mama hithanne...so use data type as blob...and save the image file

 

[ra20002]

1. Mulinma Mysql wala table eka set karaganna
Image column ekata tikak wadipura chars thiyaganna

2. Image path eka save karanna

3. JSP code eken db eka access karala dala table eka filter karaganna
E field eke walue eka aragena Image eka Image display karana control ekata pass karanna

Mama Jsp wadiya danne na machan. ASP ASP.net nam okata code eka dennam

machan mata one image path eka save karana SQL code eka ....... mama google eken search karala codes gahuva but eva vada nane ubata puluvannam sql code eka diyanko..

 

[ra20002]

mysql wala image save karanne blob kiyana data type eken mama hithanne...so use data type as blob...and save the image file

ya machan image eka sava karana type eka blob but mata one image path eka save karanna ... mokada image eka save karama slow venna balan nisa

 

[miyuru4u]

 

[kosandpol]

escape the image path properly and insert the data string
eg :
if path is /public_html/images/image.jpg
it has to be passed in to the sql statement like :

insert into pictures_table(image_path) Values('\/public_html\/images\/image\.jpg');

the \ is the escape character.