Yioop - PHP Search Engine

-- Oct 5 In-Class Exercise Thread

CREATE DATABASE Blogs; CREATE TABLE Entry (

    entry_id int(5) NOT NULL,
    author_name VARCHAR(30),
    blog_title VARCHAR(30),
    blog_post VARCHAR(250),
    post_date date,
    PRIMARY KEY(entry_id)

); INSERT INTO Entry VALUES ('1', 'Aaron Li', 'Mozzarella for pizza', 'Pizza must use mozzarella cheese', '2022-'); INSERT INTO Entry VALUES ('2', 'Chris Pollet', 'I like cheese', 'Cheese is very good so I like it'); INSERT INTO Entry VALUES ('3', 'Bob Smith', 'Cheese pun', 'Relax. Just take it cheesy.');

UPDATE Entry SET blog_title='Jaime fromage' WHERE blog_title='I like cheese';

select * from Entry WHERE post_date between "2022-9-29" and "2022-10-5";

CREATE DATABASE Blogs; CREATE TABLE Entry ( entry_id int(5) NOT NULL, author_name VARCHAR(30), blog_title VARCHAR(30), blog_post VARCHAR(250), post_date date, PRIMARY KEY(entry_id) ); INSERT INTO Entry VALUES ('1', 'Aaron Li', 'Mozzarella for pizza', 'Pizza must use mozzarella cheese', '2022-'); INSERT INTO Entry VALUES ('2', 'Chris Pollet', 'I like cheese', 'Cheese is very good so I like it'); INSERT INTO Entry VALUES ('3', 'Bob Smith', 'Cheese pun', 'Relax. Just take it cheesy.'); UPDATE Entry SET blog_title='Jaime fromage' WHERE blog_title='I like cheese'; select * from Entry WHERE post_date between "2022-9-29" and "2022-10-5";

-- Oct 5 In-Class Exercise Thread

CREATE DATABASE BLOG;

USE BLOG;

CREATE TABLE ENTRY (

	title VARCHAR(30),
	publish_date DATE,
	description VARCHAR(300)

);

INSERT INTO ENTRY VALUES("i like cheese", "2022-10-03", "my first favorite cheese"); INSERT INTO ENTRY VALUES("i like cheese two", "2022-10-04", "my second favorite cheese"); INSERT INTO ENTRY VALUES("i like cheese three", "2022-10-05", "my thrid favorite cheese");

UPDATE ENTRY SET title = "Jaime fromage" WHERE title = "i like cheese";

SELECT * FROM ENTRY WHERE publish_date >= "2022-09-28";

CREATE DATABASE BLOG; USE BLOG; CREATE TABLE ENTRY ( title VARCHAR(30), publish_date DATE, description VARCHAR(300) ); INSERT INTO ENTRY VALUES("i like cheese", "2022-10-03", "my first favorite cheese"); INSERT INTO ENTRY VALUES("i like cheese two", "2022-10-04", "my second favorite cheese"); INSERT INTO ENTRY VALUES("i like cheese three", "2022-10-05", "my thrid favorite cheese"); UPDATE ENTRY SET title = "Jaime fromage" WHERE title = "i like cheese"; SELECT * FROM ENTRY WHERE publish_date >= "2022-09-28";

-- Oct 5 In-Class Exercise Thread

CREATE DATABASE Blog; CREATE TABLE Entry(

	title VARCHAR(15),
	text VARCHAR(50),
	author VARCHAR(10),
	postDate DATE

); INSERT INTO Blog VALUES("Cheese1", "I like Cheese", "Author1", '2022-08-05'); INSERT INTO Blog VALUES("Cheese2", "I like Cheese too", "Author1", '2022-08-05'); INSERT INTO Blog VALUES("Cheese3", "I like cheese three!", "Author3", '2022-07-30');

UPDATE Blog SET title="Jaime Fromage" where title ="I like cheese"; SELECT * from Blog where postDate < 2022-08-01;

CREATE DATABASE Blog; CREATE TABLE Entry( title VARCHAR(15), text VARCHAR(50), author VARCHAR(10), postDate DATE ); INSERT INTO Blog VALUES("Cheese1", "I like Cheese", "Author1", '2022-08-05'); INSERT INTO Blog VALUES("Cheese2", "I like Cheese too", "Author1", '2022-08-05'); INSERT INTO Blog VALUES("Cheese3", "I like cheese three!", "Author3", '2022-07-30'); UPDATE Blog SET title="Jaime Fromage" where title ="I like cheese"; SELECT * from Blog where postDate < 2022-08-01;

-- Oct 5 In-Class Exercise Thread

CREATE DATABASE BLOG;

CREATE TABLE ENTRY (

    title varchar(50) not null,
    entry varchar(300),
    timeOfPost date,
 );

INSERT INTO ENTRY VALUES ("Mozzerela", "This is my favorite", "2022-10-02"), ("Parmesan", "Second favorite", "2022-10-03"), ("Swiss", "Third favorite", "2022-10-04");

UPDATE ENTRY SET title = "Jaime fromage" WHERE title = "I like cheese";

SELECT * FROM ENTRY WHERE timeOfPost BETWEEN "2022-09-28" AND "2022-10-05";

CREATE DATABASE BLOG; CREATE TABLE ENTRY ( title varchar(50) not null, entry varchar(300), timeOfPost date, ); INSERT INTO ENTRY VALUES ("Mozzerela", "This is my favorite", "2022-10-02"), ("Parmesan", "Second favorite", "2022-10-03"), ("Swiss", "Third favorite", "2022-10-04"); UPDATE ENTRY SET title = "Jaime fromage" WHERE title = "I like cheese"; SELECT * FROM ENTRY WHERE timeOfPost BETWEEN "2022-09-28" AND "2022-10-05";

-- Oct 5 In-Class Exercise Thread

CREATE database blogdatabase; USE blogdatabase; CREATE table blogEntries (

	blogID int primary key,
	title varchar(60),
	content varchar(300),
        submission_date date

);

INSERT INTO blogEntries(blogID, title, content, submission_date) values (1, "chesse? is it real?", "content", "2020-12-05");

INSERT INTO blogEntries(blogID, title, content, submission_date) values (2, "I like cheese", "cheese is awesome!", "2022-10-05");

INSERT INTO blogEntries(blogID, title, content, submission_date) values (3, "Queso?", "The history of cheese...", "2022-10-05");

UPDATE blogEntries SET title = "Jaime fromage" WHERE title = "I like cheese";

SELECT * FROM blogEntries where submission_date >= "2022-09-26";

(Edited: 2022-10-05)

CREATE database blogdatabase; USE blogdatabase; CREATE table blogEntries ( blogID int primary key, title varchar(60), content varchar(300), submission_date date ); INSERT INTO blogEntries(blogID, title, content, submission_date) values (1, "chesse? is it real?", "content", "2020-12-05"); INSERT INTO blogEntries(blogID, title, content, submission_date) values (2, "I like cheese", "cheese is awesome!", "2022-10-05"); INSERT INTO blogEntries(blogID, title, content, submission_date) values (3, "Queso?", "The history of cheese...", "2022-10-05"); UPDATE blogEntries SET title = "Jaime fromage" WHERE title = "I like cheese"; SELECT * FROM blogEntries where submission_date >= "2022-09-26";

-- Oct 5 In-Class Exercise Thread

CREATE DATABASE blog
CREATE TABLE Entry(title varchar(128) PRIMARY KEY NOT NULL UNIQUE, text TEXT, data DATE)
INSERT INTO Entry VALUES(“Parmesan”, “Good on Pizza”, 8/4/22)
INSERT INTO Entry VALUES(“American”, “Good in a sandwich”, 9/4/22)
INSERT INTO Entry VALUES(“Swiss”, “Good with salad”, 10/4/22)
UPDATE Entry SET title=“Jaime Fromage” WHERE title=“I like Cheese”
SELECT * FROM Cheese WHERE date > '2022-09-28'

(Edited: 2022-10-05)

CREATE DATABASE blog CREATE TABLE Entry(title varchar(128) PRIMARY KEY NOT NULL UNIQUE, text TEXT, data DATE) INSERT INTO Entry VALUES(“Parmesan”, “Good on Pizza”, 8/4/22) INSERT INTO Entry VALUES(“American”, “Good in a sandwich”, 9/4/22) INSERT INTO Entry VALUES(“Swiss”, “Good with salad”, 10/4/22) UPDATE Entry SET title=“Jaime Fromage” WHERE title=“I like Cheese” SELECT * FROM Cheese WHERE date > '2022-09-28'

-- Oct 5 In-Class Exercise Thread

CREATE DATABASE blog CREATE TABLE Entry ( title VARCHAR(60), author VARCHAR(30), body VARCHAR(255), posted_at DATETIME DEFAULT CURRENT_TIMESTAMP); INSERT INTO Entry VALUES ("My Favorite Cheese", "Richard Milhous Nixon", "For me, it's a nice swiss."); INSERT INTO Entry VALUES ("Going to the big Cheese convention in Zhengzhou this weekend", "Richard Milhous Nixon", "Please email me if you want to hang."); INSERT INTO Entry VALUES ("I like cheese", "obamna", "i am going to bomb syria"); UPDATE Entries SET title = "Jaime fromage" WHERE title = "I like cheese"; SELECT * FROM Entries WHERE posted_at > "2022-09-29"

(Edited: 2022-10-07)

<nowiki> CREATE DATABASE blog CREATE TABLE Entry ( title VARCHAR(60), author VARCHAR(30), body VARCHAR(255), posted_at DATETIME DEFAULT CURRENT_TIMESTAMP); INSERT INTO Entry VALUES ("My Favorite Cheese", "Richard Milhous Nixon", "For me, it's a nice swiss."); INSERT INTO Entry VALUES ("Going to the big Cheese convention in Zhengzhou this weekend", "Richard Milhous Nixon", "Please email me if you want to hang."); INSERT INTO Entry VALUES ("I like cheese", "obamna", "i am going to bomb syria"); UPDATE Entries SET title = "Jaime fromage" WHERE title = "I like cheese"; SELECT * FROM Entries WHERE posted_at > "2022-09-29" </nowiki>

-- Oct 5 In-Class Exercise Thread

Create database Blog; use Blog; Create Table Entry(

  blog_id int(5) NOT NULL,
  title varchar(100),
  blog_body varchar(2000),
  author varchar(30),
  blog_post_date date,
  PRIMARY KEY(blog_id)

); Insert into

  Entry(
    blog_id,
    title,
    blog_body,
    author,
    blog_post_date
  )

Values

  (
    1,
    "Types of Cheese",
    "Cheddar, Mozarella, Swiss",
    "John",
    2022 -10 -08
  ),
  (
    2,
    "I like cheese",
    "Cheese fan",
    "Mary",
    2022 -10 -08
  ),
  (
    3,
    "Cheese recipes",
    "Cheese sandwich",
    "Doe",
    2022 -10 -08
  );

Update

  Entry

set

  title = "Jaime fromage"

where

  title = "I like cheese";

select

from

  Entry

where

  blog_post_date > '2022-10-01';

Create database Blog; use Blog; Create Table Entry( blog_id int(5) NOT NULL, title varchar(100), blog_body varchar(2000), author varchar(30), blog_post_date date, PRIMARY KEY(blog_id) ); Insert into Entry( blog_id, title, blog_body, author, blog_post_date ) Values ( 1, "Types of Cheese", "Cheddar, Mozarella, Swiss", "John", 2022 -10 -08 ), ( 2, "I like cheese", "Cheese fan", "Mary", 2022 -10 -08 ), ( 3, "Cheese recipes", "Cheese sandwich", "Doe", 2022 -10 -08 ); Update Entry set title = "Jaime fromage" where title = "I like cheese"; select * from Entry where blog_post_date > '2022-10-01';

-- Oct 5 In-Class Exercise Thread

CREATE DATABASE Blog;

USE Blog;

CREATE TABLE Entry (

	title VARCHAR(50) NOT NULL,
	author VARCHAR(25),
	date DATE

);

INSERT INTO Entry VALUES

	("I like cheese", "me", "2022/9/19"), 
	("Cheese is pretty good", "myself", "2022/10/3"), 
	("I am sick of cheese", "I", "2022/10/6");

UPDATE Entry

	SET title = "Jaime fromage"
	WHERE title = "I like cheese";

SELECT * FROM Entry

	WHERE date > ‘2022/10/2’;

(Edited: 2022-10-09)

CREATE DATABASE Blog; USE Blog; CREATE TABLE Entry ( title VARCHAR(50) NOT NULL, author VARCHAR(25), date DATE ); INSERT INTO Entry VALUES ("I like cheese", "me", "2022/9/19"), ("Cheese is pretty good", "myself", "2022/10/3"), ("I am sick of cheese", "I", "2022/10/6"); UPDATE Entry SET title = "Jaime fromage" WHERE title = "I like cheese"; SELECT * FROM Entry WHERE date > ‘2022/10/2’;

-- Oct 5 In-Class Exercise Thread

CREATE DATABASE blog; USE blog;

CREATE TABLE Entry (title VARCHAR(15), content VARCHAR(100), postDate DATE); INSERT INTO Entry VALUES("I like cheese", "CHeeeeeeese", '2022-10-6'); INSERT INTO Entry VALUES("Cheeeese", "i love eating cheese",'2022-10-7'); INSERT INTO Entry VALUES("Cheeesee?", "i still love hcheese",'2022-10-8');

UPDATE Entry SET title = 'Jaime fromage' WHERE title = 'I like cheese';

SELECT * FROM Entry WHERE postDate > '2022-10-2';

CREATE DATABASE blog; USE blog; CREATE TABLE Entry (title VARCHAR(15), content VARCHAR(100), postDate DATE); INSERT INTO Entry VALUES("I like cheese", "CHeeeeeeese", '2022-10-6'); INSERT INTO Entry VALUES("Cheeeese", "i love eating cheese",'2022-10-7'); INSERT INTO Entry VALUES("Cheeesee?", "i still love hcheese",'2022-10-8'); UPDATE Entry SET title = 'Jaime fromage' WHERE title = 'I like cheese'; SELECT * FROM Entry WHERE postDate > '2022-10-2';