বাংলা ডাটাবেইজ থেকে সার্চিং সমস্যা....

remiz · **Joined:** Tue Jul 17, 2007 4:04 am **Posts:** 2

আমি বাংলায় একটি সাইট ডেভেলপ করছি, ডাটাবেইজ (MySQL)দিয়ে। এতে ডাটা সুন্দর ইনপুট করতে পারছি, কিন্তু যখনই php দিয়ে কল করে

search করাতে বলছি তখন যে অংশটুকু আমি longblob হিসাবে ডাটাবেইজে ইনপুট করি তা, ঠিকতমতো দেখায়, কিন্তু নরমাল টেক্সট ফিল্ডের

বাংলা

?? এমন দেখায়। সমাধানটা কি হবে বলতে পারেন? phpMyAdmin এ ঢুকে তাতে ডাটাবেইজটি একটিভ করে সার্চ দিলে অবশ্য সুন্দরভাবেই ফলাফল দেখায়।
I am in great need of that.

alamgir99 · **Posted:** Tue Jul 17, 2007 5:57 am

This is related to collation of your table and connection. Search google. I knew a blog which had this issue addressed, but that is down now.

alagmgir

remiz · **Joined:** Tue Jul 17, 2007 4:04 am **Posts:** 2

ধন্যবাদ আপনার মন্তব্যের জন্য।

আমি collation তা রেখেই করেছিলাম, কিন্তু ইনপুট এবং আউটপুট (php দিয়ে) করলে ঠিকই বাংলায় ইনপুট এবং আউটপুট হয়। সমস্যা হল, যখন সার্চিং রিকোয়েস্ট দেয়া হয় (অভ্র দিয়ে), নরমালি যেভাবে আমরা সার্চিং ফর্ম তৈরী করি সেভাবে (html/php), তখন দেখা যায়, সার্চিং ফর্মে (php)ঐ স্ট্রিংগুলোর ভেরিয়েবল যাচ্ছে, কিন্তু ডাটাবেইজ থেকে কোন আউটপুট নিতে পারছে না। এটাই হল মূল সমস্যা। নীচে আমার সাচিং ফর্মের নমুনা দেয়া হল:

সার্চ ইনপুট ফর্ম:

New Document

*******************************
search.php:

New Document

include ('db_connect.php');

//include ('common_lib.php');

$cat=$_POST['cat'];

$subcat=$_POST['subcat'];

$query= "SELECT * FROM agri WHERE cat LIKE '%$cat%' AND subcat LIKE '%$subcat%' ";

$result = mysql_query ($query);

$num= mysql_num_rows($result);

echo "finding:".$cat." and ".$subcat."
";

echo "Record found:".$num."
";

while($row = mysql_fetch_array($result))
{
PRINT "Category: ";
print $row["cat"];
print (" ");
print ("
");
PRINT "Subcat: ";
print $row["subcat"];
print ("

");
PRINT "Content: ";
print $row["content"];
print ("

");
}

?>

সমাধান needed, urgently.

ধন্যবাদ।

alamgir99 · **Posted:** Wed Jul 18, 2007 6:30 am

From http://hasin.wordpress.com/2006/07/18/s ... -database/

Well, If you just set the collation as “utf8-general-ci” that wont do all the things for storing and retrieving bangla unicode texts properly. There are something more to do. Last night while working for a project I just found the solution.

You must add these two lines just after selecting the database, i.e mysql_select_db() function.

mysql_query(’SET CHARACTER SET utf8′);
mysql_query(”SET SESSION collation_connection =’utf8_general_ci’”);

After executing these two statements MySQL will handle the rest.

good luck

ssdt · **Joined:** Sun Oct 07, 2007 1:53 pm **Posts:** 52

How did you make a bangla search engine in your site. Please tell me everything in details.

abhicho · **Joined:** Fri Nov 14, 2008 1:48 am **Posts:** 2

I agree with alamgir99 google provides solution to 99% of my problems. Pls. let me know if you still need help.

Travian · **Posted:** Fri Nov 14, 2008 7:43 am

I'm having the same problem, php error with:

Code:

$query= "SELECT * FROM agri WHERE cat LIKE '%$cat%' AND subcat LIKE '%$subcat%\" ";

can't debug it :eek:

Signature Rules: viewtopic.php?t=65

HostingProvider · **Joined:** Fri Nov 14, 2008 9:22 pm **Posts:** 3

This thread is quite old. I think the thread owner has already solved this problem.
If he has not, I recommend him to look for MySQL Tutorials. Anyway, some hosting companies will handle these kind of problems, as they are usually easy to be solved.

To Travian:
Try this code instead:

Code:

$query= "SELECT * FROM agri WHERE cat LIKE '%$cat%' AND subcat LIKE '%$subcat%' ";

Does that solve your problem? You mistyped an ' into a \".

Best regards!

neruna · **Joined:** Mon Dec 29, 2008 12:55 pm **Posts:** 10

Quote:

$query= "SELECT * FROM agri WHERE cat LIKE '%$cat%' AND subcat LIKE '%$subcat%' ";

Does that solve your problem? You mistyped an ' into a \".

that solved my problem. thank you very much!

bumbuketel · **Joined:** Wed Dec 31, 2008 3:15 pm **Posts:** 2

Quote:

This thread is quite old. I think the thread owner has already solved this problem.
If he has not, I recommend him to look for MySQL Tutorials. Anyway, some hosting companies will handle these kind of problems, as they are usually easy to be solved.

where i can find Mysql tutorial please still newbie in here i hope someone can give from the basic

sn2368 · **Joined:** Tue Dec 02, 2008 5:12 pm **Posts:** 6

Creating a MySQL Database Detailed Tutorial http://www.siteground.com/tutorials/php-mysql/mysql_database_user.htm
This can help you

basmatimember · **Joined:** Mon Mar 30, 2009 11:47 pm **Posts:** 4

Add those;
mysql_query(’SET CHARACTER SET utf8′);
mysql_query(”SET SESSION collation_connection =’utf8_general_ci’”);

matinice · **Posted:** Fri Apr 17, 2009 11:22 pm

MySQL command consule বাংলা কমান্ড আেছ িক?
আিম জানেত চাই এভােব বাংলায় ডাটােবইজ বা েটিবল ৈতরী করা যায় িক ভােব।

djsonny · **Joined:** Tue May 12, 2009 12:23 am **Posts:** 23

thank you i have this question too.

Kualaho · **Posted:** Wed Jun 03, 2009 1:33 am

Yoreeka! Thank you.

anton007 · **Posted:** Thu Jun 25, 2009 11:38 am

thanks for sharing that's important to me

lga1983 · **Joined:** Thu Jul 16, 2009 1:42 pm **Posts:** 32

These two lines have solved my problem! Thanks Alamgir99...

mysql_query(’SET CHARACTER SET utf8′);
mysql_query(”SET SESSION collation_connection =’utf8_general_ci’”);

stucacau · **Joined:** Sat Oct 17, 2009 12:51 pm **Posts:** 1

I don't understand this language,what it's saying?

Joomla! Discussion Forums

Forum rules: Please click here to view the forum rules

বাংলা ডাটাবেইজ থেকে সার্চিং সমস্যা....

Quick reply

Who is online