Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- source mySource{
- type = mysql
- sql_host = localhost
- sql_user = root
- sql_pass = mypass
- sql_db = test
- sql_query = SELECT id, uname FROM users
- sql_attr_uint = id
- sql_attr_string = uname
- sql_port = 3306
- }
- index test{
- source = mySource
- path = /var/lib/sphinxsearch/data
- docinfo = extern
- }
- searchd{
- listen = 9306:mysql41
- log = /var/log/sphinxsearch/searchd.log
- query_log = /var/log/sphinxsearch/query.log
- read_timeout = 5
- pid_file = /var/run/sphinxsearch/searchd.pid
- seamless_rotate = 1
- preopen_indexes = 1
- unlink_old = 1
- binlog_path = /var/lib/sphinxsearch/data
- }
- <?php
- $conn = new mysqli('localhost','root','mypass','test',9306);
- if($conn->connect_error){
- die("Could not connect");
- }else{
- echo "You are connected!";
- }
- $query = $conn->query("SELECT * FROM test WHERE MATCH('hsmith')");
- echo $query->error;
- ?>
Add Comment
Please, Sign In to add comment