public static List <Post> PostSearch(string searchWord) { List <Post> allPosts = new List <Post> { }; MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT id, blog_id, title, content, date, file FROM posts WHERE content LIKE '%" + searchWord + "%' OR title LIKE '%" + searchWord + "%';"; MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int postId = rdr.GetInt32(0); int postBlogId = rdr.GetInt32(1); string postTitle = rdr.GetString(2); string postContent = rdr.GetString(3); DateTime postDate = rdr.GetDateTime(4); string postFile = rdr.IsDBNull(5) ? null : rdr.GetString(5); Post searchPost = new Post(postTitle, postContent, postFile, postBlogId, postId); searchPost.SetDate(postDate); allPosts.Add(searchPost); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allPosts); }
public List <Post> GetPosts() { List <Post> allPosts = new List <Post> { }; MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM posts WHERE blog_id = @thisId;"; MySqlParameter thisId = new MySqlParameter("@thisId", _id); cmd.Parameters.Add(thisId); MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int postId = rdr.GetInt32(0); int blogId = rdr.GetInt32(1); string postTitle = rdr.GetString(2); string postContent = rdr.GetString(3); DateTime postDate = rdr.GetDateTime(4); string postFile = rdr.IsDBNull(5) ? null : rdr.GetString(5); Post thisPost = new Post(postTitle, postContent, postFile, blogId, postId); thisPost.SetDate(postDate); allPosts.Add(thisPost); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allPosts); }
public static Post Find(int id) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM posts WHERE id = (@searchId);"; MySqlParameter searchId = new MySqlParameter(); searchId.ParameterName = "@searchId"; searchId.Value = id; cmd.Parameters.Add(searchId); var rdr = cmd.ExecuteReader() as MySqlDataReader; int postId = 0; int postBlogId = 0; string postTitle = ""; string postContent = ""; DateTime postDate = new DateTime(); string postFile = null; while (rdr.Read()) { postId = rdr.GetInt32(0); postBlogId = rdr.GetInt32(1); postTitle = rdr.GetString(2); postContent = rdr.GetString(3); postDate = rdr.GetDateTime(4); postFile = rdr.IsDBNull(5) ? null : rdr.GetString(5); } Post foundPost = new Post(postTitle, postContent, postFile, postBlogId, postId); foundPost.SetDate(postDate); conn.Close(); if (conn != null) { conn.Dispose(); } return(foundPost); }