Jump to content

nomadsoul

Members
 View Profile  See their activity

  • Posts

    70

  • Joined

  • Last visited

Profile Information

  • Gender
    Male
  • Location
    Ningbo, ZheJiang China

nomadsoul's Achievements

Member

Member (2/5)

0

Reputation

  1. nomadsoul
    I just got a warning saying "I have been given a warning, no porn links" However, I have never put up a porn link. What's up? I haven't even been logged in for over a year. I'm upset
  2. nomadsoul
    Sassa's fix worked thanks! Echoing the query was the first thing I did. But thanks for the great advice. Jaques1: You also can't just drop GET parameters into your query string. Never heard of escaping? -Thank You. You are correct, I'm getting back to coding after a long layoff.
  3. nomadsoul
    I tried the suggestions and still get the same error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR keywords LIKE 'web' keywords LIKE 'yahoo'' at line 1" yahoo is one of multiple keywords in the keywords column When I run the query SELECT * FROM searchengine WHERE keywords LIKE 'yahoo' directly through phpmyadmin it returns an empty set: MySQL returned an empty result set (i.e. zero rows). (Query took 0.0000 seconds.) It will only return a results set (in phpmyadmin) only when yahoo is the only keyword in the keywords column. But the keywords column is supposed to be able to process multiple keywords within a cell as long as they are space delimited. I was hoping someone might paste this code into htdocs and dump the sql into phpmyadmin or the mysql shell to see if the same errors arise.
  4. nomadsoul
    Barand: Thanks The error out put is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR keywords LIKE 'search' OR keywords LIKE 'term'' at line 1 And the output should return all the rows based on keywords from the keywords column that match the '$k' input. and the other columns are the id, title, description, and link fields. (I think that is what you are asking)? sass: Thanks will try that maxxd;Thanks Ok will try that. I think you mean something like: $query .= "OR keywords LIKE %$each% ";?
  5. nomadsoul
    Hi and thank you for reading my topic. I'm building a search engine from a tutorial and I'm getting the famous "Warning: mysql_num_rows() expects parameter 1" boolean etc.. I know mysql_num_rows() is depricated and I promise not to use it in the future but for now I'm using it in other projects on the same server and all's ok. I'm quite sure it's a problem with the SQL syntax because when I paste SELECT * FROM searchengine WHERE keywords LIKE 'any_keyword_from_the_column' -into Phpmyadmin it won't return results, however a simple SELECT * FROM searchengine returns results. So, without using mysql_error() I get: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\research2\search.php on line 42 But after I applyin mysql_error() to everything I narrowed it down to this: $query = mysql_query($query) or die (mysql_error());: I get the error msg: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR keywords LIKE 'search' OR keywords LIKE 'term'' at line 1 I've checked multiple times to see if I've left out any columns in the db or mismatched them in while loop. Below I have included the code which you can paste into a file called search.php along with the mysql dump file to pase into phpmyadmin query box. I'm using xampp. In the code the WHERE clause is extended into the if statement and concatenated into the $query variable. This is done to break the words in the text box so they can be searched as an array. As I said, I really think it is the SQL syntax and not the mysql_* functions but I could be wrong. I'd really like to get this code working and mess with it. It looks like it could be very useful as a private website search engine. Thanks for your time and mental energy. <html> <head> <title></title> <meta http-equiv="content-type" content="text/html;charset=utf-8" /> </head> <body> <h2>Search Engine</h2> <form action = './search.php ' method = 'get'> <input type = 'text' name = 'k' size = '50' value = '<?php echo $_GET['k']; ?>' /> <input type = 'submit' value = 'Search'> </form> <hr /> results <br> <?php $k = $_GET['k']; $terms = explode(" ", $k); $query = "SELECT * FROM searchengine WHERE "; foreach ($terms as $each) { $i = 0; if ($i == 1) $query .= "keywords LIKE '$each' "; else $query .= "OR keywords LIKE '$each' "; } mysql_connect("localhost", "root", "") or die (mysql_error()); mysql_select_db("search2") or die (mysql_error()); $query = mysql_query($query) or die (mysql_error()); $numrows = mysql_num_rows($query) ; if ($numrows > 0) { while ($row = mysql_fetch_assoc($query)) { $id = $row['id']; $title = $row['title']; $description = $row['description']; $keywords = $row['keywords']; $link = $row['link']; echo "<h2><a href='$link'>$title</a></h2> $description<br /><br />"; } } else echo $k ; ?> </body> </html> and here is the SQL dump (I called my db search2 and my table searchengine -- phpMyAdmin SQL Dump -- version 4.2.7.1 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Nov 27, 2014 at 11:54 AM -- Server version: 5.6.20 -- PHP Version: 5.5.15 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `search2` -- CREATE DATABASE IF NOT EXISTS `search2` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `search2`; -- -------------------------------------------------------- -- -- Table structure for table `searchengine` -- CREATE TABLE IF NOT EXISTS `searchengine` ( `id` int(11) NOT NULL, `title` varchar(250) NOT NULL, `description` varchar(250) NOT NULL, `keywords` text NOT NULL, `link` varchar(250) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `searchengine` -- INSERT INTO `searchengine` (`id`, `title`, `description`, `keywords`, `link`) VALUES (1, 'Nick Frosty''s Official Web Site', 'Welcome to Nick''s', 'Nickfrosty Website tutorials videos web design', 'http://www.nickfrosty.com'), (2, 'Google search engine', 'The best search engine', 'google web site search ', 'http://www.google.oom'), (3, 'The Yahoo Search Engine', 'Not as good as Google', 'Yahoo search engine website', 'http://www.google.com'), (4, 'This is a test', 'This is a test website', 'Google', 'http://www.google.com'); -- -- Indexes for dumped tables -- -- -- Indexes for table `searchengine` -- ALTER TABLE `searchengine` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `searchengine` -- ALTER TABLE `searchengine` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; If you have any questions about any details of this code please ask me. Thanks for your time
  6. nomadsoul
    Thanks fenway, I suspected it would be this complex
  7. nomadsoul
    I'm tasked with a hypothetical challenge and I'd like to know if it can be done. And if it can, I'd love some ideas (pseudo code is ok) of different ways I could do this maybe the solution could benefit others as well: Imagine that there are 3 companies selling produce: Company 1 Company 2 Company 3 Each of these companies are tracking the price and types of products they are selling. Prices change each day so our website is asking each company to upload the type and price of product each day -so buyers can compare prices. So, imagine the seller will be greatly inconvenienced to try to log into the website and update the prices manually (they may have thousands of products). If they are using their own automated spread sheet, then they could simply upload the excel sheet, and the website will parse through the existing list, compare with the old list (already in the website) and sync the prices and products that the seller has in their own BI software. In this method, the website uses 1 name to describe each product.. and forces whatever name each of the various sellers use as a description, be mapped to the website common name (in the Mysql table or a master list?). The buyer will be trying to compare a produce item, and if all the names are different, then it wouldn't work. Company 1 sells Granny Smith medium apples for .99 cents a pound Company 2 Medium Green Granny apples for 1.05 a pound Company 3 sells Green Granny apples for .85 cents a pound Now.. the website lists that product as Granny Smith Medium Apples ...but they are the same apples. Buyers will look at the site and find Granny Smith Medium Apples and want to see the pricing, but since each seller uses a different name.. we need each of those names to be mapped to our common name (Granny Smith Medium Apples). Logging in and updating with a php form is not an option because the update has already been done for the company on the spreadsheet, we don't want to ask the customer to update everything again on the website because the customer may have thousands of products. I think I might be overanalyzing the situation and there is probably a simple solution. I also thought of providing a spreadsheet template for each company with names matching the Mysql table but as I mentioned these companies may have thousands of products. Names can be added and dropped or changed. Maybe I could join 3 tables: MasterList, ImportedList, and UpdatedList, using diff, REPALCE or some regular expressions? Like I say if you have some ideas, pseudocode is ok but if you know of any scripts related to this task let me know.
  8. nomadsoul
    Sorry I am a complete dumbass, I forgot the tablename. SELECT DATEDIFF(ShippedDate,RequiredDate) AS DiffDate FROM Orders
  9. nomadsoul
    #1054 - Unknown column 'ShippedDate' in 'field list' But there is a ShippedDate column
  10. nomadsoul
    Hi all, I've found many explanations on how to calculate the difference between two individual dates i.e: DATEDIFF (day, ‘7/8/2009’, ‘8/14/2009’) AS Result ] But nothing on how to calculate the difference between two date fields i.e: SELECT DATEDIFF(ShippedDate,RequiredDate) AS NewCalculatedField I tried but won't work, can it be done? -tried with and without parenthesis
  11. nomadsoul
    I'm doing a project from an ecommerce book and it says "the non_coffee_products table has a many to one relationship with the non_coffee_categories table" I have listed them both below but I see no fk-references syntax. I see absolutely no connection between these two tables. Does the Key Index link these tables? I guess I need a tutorial on Indexes CREATE TABLE `non_coffee_products` ( `id` mediumint( unsigned NOT NULL AUTO_INCREMENT, `non_coffee_category_id` tinyint(3) unsigned NOT NULL, `name` varchar(60) NOT NULL, `description` tinytext, `image` varchar(45) NOT NULL, `price` decimal(5,2) unsigned NOT NULL, `stock` mediumint( unsigned NOT NULL DEFAULT '0', `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `non_coffee_category_id` (`non_coffee_category_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `non_coffee_categories` ( `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `category` varchar(40) NOT NULL, `description` tinytext NOT NULL, `image` varchar(45) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `category` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  12. nomadsoul
    Hi all, I am using kplaylist (a huge php file) paired with xspf_player (a flash player) to serve mp3 files on a site I'm building. My problem is : I can't figure out how customize the appearance of the flash player. Specifically I'd like to remove the album cover jpg area. Here is the xspf_player website :http://www.xspf-player.com/customize.html#skin I am not sure what to do with the code provided on the website. Do I insert the code into the php file or do I make an html file to link to the player? I'm clueless. If anyone is familiar with this I hope you can assist me.
  13. nomadsoul
    Yes, I was using a session that was already set and users name is echoed no problem. It's not imperative but I thought i'd be nice to let the user see hisher name uc. I tried your code and it didn't work. I've wrapped the variable in {}brackets because it is inside html, that's how I learned it but if there is another way I will try. I will keep trying variations on your code. Thanks
  14. nomadsoul
    Hi, gday, how can I use the ucfirst variable on the posted variable after to form has been submitted to welcome my member? "<p>Welcome: ucfirst{$_SESSION['first_name']};" This is not working. Should I use it in the form instead?
  15. nomadsoul
    A blank screen should mean your db connection is working. Do you have a deadline on your website or is it your own project? Sorry that you've had so much trouble. Your book certainly arrived fast. Which book and which forum did you join?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.