The Joomla! Forum ™

Download

Demo


Board index » Joomla! International Language Support » International Zone » Bengali Forum

Forum rules


Please click here to view the forum rules



Post new topic Reply to topic  Page 1 of 1
  [ 20 posts ] 
  Print view Previous topic | Next topic 
Author Message
remiz
PostPosted: Tue Jul 17, 2007 4:12 am 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Tue Jul 17, 2007 4:04 am
Posts: 2
আমি বাংলায় একটি সাইট ডেভেলপ করছি, ডাটাবেইজ (MySQL)দিয়ে। এতে ডাটা সুন্দর ইনপুট করতে পারছি, কিন্তু যখনই php দিয়ে কল করে

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

বাংলা ????? এমন দেখায়। সমাধানটা কি হবে বলতে পারেন? phpMyAdmin এ ঢুকে তাতে ডাটাবেইজটি একটিভ করে সার্চ দিলে অবশ্য সুন্দরভাবেই ফলাফল দেখায়।
I am in great need of that.
Top
 Profile  
 
alamgir99
PostPosted: Tue Jul 17, 2007 5:57 am 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Sat Aug 20, 2005 1:44 pm
Posts: 324
Location: Melbourne, Australia
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

_________________
www.apona-bd.com Bangla OCR and other software.
www.joomla.org.bd Bangla Joomla Site
Top
 Profile  
 
remiz
PostPosted: Wed Jul 18, 2007 4:35 am 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Tue Jul 17, 2007 4:04 am
Posts: 2
ধন্যবাদ আপনার মন্তব্যের জন্য।

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

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



New Document











Search For:


ক্যাটেগরী:


সাব-ক্যাটেগরী:








*******************************
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.

ধন্যবাদ।
Top
 Profile  
 
alamgir99
PostPosted: Wed Jul 18, 2007 6:30 am 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Sat Aug 20, 2005 1:44 pm
Posts: 324
Location: Melbourne, Australia
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

_________________
www.apona-bd.com Bangla OCR and other software.
www.joomla.org.bd Bangla Joomla Site
Top
 Profile  
 
ssdt
PostPosted: Sun Oct 07, 2007 3:02 pm 
Joomla! Intern
Joomla! Intern
Offline

Joined: Sun Oct 07, 2007 1:53 pm
Posts: 53
How did you make a bangla search engine in your site. Please tell me everything in details.
Top
 Profile  
 
abhicho
PostPosted: Fri Nov 14, 2008 1:58 am 
Joomla! Fledgling
Joomla! Fledgling
Offline

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.

_________________
http://www.countrywiderate.info/
[url]http://www.suzuki-hayabusa.org/
[/url]
http://allloaninfo.info/
Top
 Profile  
 
Travian
PostPosted: Fri Nov 14, 2008 7:43 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Fri Nov 14, 2008 7:39 am
Posts: 23
Location: Bengal
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

_________________
Joomla Fan http://freetubetv.net
Top
 Profile  
 
HostingProvider
PostPosted: Fri Nov 14, 2008 9:30 pm 
Joomla! Fledgling
Joomla! Fledgling
Offline

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!

_________________
Signature Rules: viewtopic.php?t=65
Top
 Profile  
 
neruna
PostPosted: Mon Dec 29, 2008 1:01 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Mon Dec 29, 2008 12:55 pm
Posts: 9
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!

_________________
Joomla Rocks!
http://www.ebarcade.com
Top
 Profile  
 
bumbuketel
PostPosted: Wed Dec 31, 2008 3:24 pm 
I've been banned!
Offline

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

_________________
joomla newbie
Top
 Profile  
 
sn2368
PostPosted: Sun Jan 11, 2009 8:07 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

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 :D

_________________
Please read forum rules regarding signatures: viewtopic.php?f=8&t=65
Top
 Profile  
 
basmatimember
PostPosted: Mon Mar 30, 2009 11:56 pm 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Mon Mar 30, 2009 11:47 pm
Posts: 3
Add those;
mysql_query(’SET CHARACTER SET utf8′);
mysql_query(”SET SESSION collation_connection =’utf8_general_ci’”);

_________________
Please read forum rules regarding signatures: viewtopic.php?t=65
Top
 Profile  
 
matinice
PostPosted: Fri Apr 17, 2009 11:22 pm 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast
Offline

Joined: Wed Apr 01, 2009 8:42 pm
Posts: 124
Location: kushtia,Bangladesh
MySQL command consule বাংলা কমান্ড আেছ িক?
আিম জানেত চাই এভােব বাংলায় ডাটােবইজ বা েটিবল ৈতরী করা যায় িক ভােব।

_________________
Web Developer
www.globalweboutsourcing.com
Top
 Profile  
 
djsonny
PostPosted: Tue May 12, 2009 3:38 am 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Tue May 12, 2009 12:23 am
Posts: 23
thank you i have this question too.

_________________
ฟังเพลงยอดนิยม : http://www.djsonny.com/
เพลงเพราะ ๆ เพลงใหม่ ๆ ทุกวัน http://www.djsonny.com/
Top
 Profile  
 
Kualaho
PostPosted: Wed Jun 03, 2009 1:33 am 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast
Offline

Joined: Sat Apr 18, 2009 9:38 pm
Posts: 140
Location: UK
Yoreeka! Thank you.

_________________
http://www.hoodiadietworks.com | http://www.findiet.com
Top
 Profile  
 
anton007
PostPosted: Thu Jun 25, 2009 11:38 am 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Fri Jan 16, 2009 11:26 am
Posts: 20
Location: indramayu
thanks for sharing that's important to me

_________________
http://antonfkip.com
http://miss925.com
Top
 Profile  
 
lga1983
PostPosted: Fri Jul 24, 2009 7:45 am 
Joomla! Apprentice
Joomla! Apprentice
Offline

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’”);

_________________
http://www.nedivektraskt.com/
Top
 Profile  
 
jan99
PostPosted: Sun Jan 24, 2010 6:01 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Wed May 20, 2009 9:32 pm
Posts: 6
Tanks for the good info - Have all a good day...

_________________
Signature rules: Literal URLs only - viewtopic.php?f=8&t=65
Top
 Profile  
 
modhumiah
PostPosted: Sat Feb 27, 2010 2:48 pm 
Joomla! Intern
Joomla! Intern
Offline

Joined: Wed Feb 24, 2010 2:14 am
Posts: 56
Alamgir Vai. Many many thanks for sharing the info.

_________________
http://www.webdirectorybd.com - Bangladesh Web Directory
Top
 Profile  
 
sharonferrell
PostPosted: Mon Sep 27, 2010 5:50 am 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Mon Sep 27, 2010 5:42 am
Posts: 2
am also want to know how Bengali search engine can b use in our site...please give me some information related it..
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 20 posts ] 


Board index » Joomla! International Language Support » International Zone » Bengali Forum

Who is online

Users browsing this forum: No registered users and 2 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group