webdeveloper93

Here is an anonymous ranting website that i've built currently it has a pretty steady user base just looking for some feedback on how It can maybe be improved or added upon https://irantme.com

Who ever built the site needs to be fired sorry

So it's been awhile this i posted something I've built on here but thought someone may find this database class useful or build onto it. Here is the project on github https://github.com/webdeveloper73/MysqliDB/blob/master/MysqliDB.php here is a basic example... Example <?php //Connect to database $db = new MysqliDB("mysql_host","mysql_username","mysql_password","mysql_database"); //SELECT * FROM `posts` WHERE id > 10 AND id < 55 ORDER BY `id` DESC $db->select() ->from("posts") ->whereByArray(array("id >" => 10,"id <" => 55)) ->order_by("id","DESC") ->run(); if($db->num_rows() > 0) { foreach($db->result() as $row): echo $row->postContent."<br />"; endforeach; }else{ echo "No posts to show"; } Example 2 <?php //SELECT * FROM `posts` WHERE id > 5 //Pass false to the last parameter to prevent escaping fields with back ticks //The run method executes the built query $db->select()->from("posts")->where("id",5,">",null,false)->run(); Example 3 multiple where conditions //SELECT * FROM `posts` WHERE `id` = 7 OR `id` = 9 LIMIT 1 $db->select()->from("posts")->where("id",7)->where("id",9,null,"OR")->limit(1)->run(); Example 4 whereIN method //SELECT * FROM `users` WHERE `id` IN('5','8','1','2') $db->select()->from("users")->whereIN("id",["5","8","1","2"])->order_by("id","DESC")->run(); This class includes quite a few more methods here is the list... rawQuery() insert() insertID() update() delete() escape() num_rows() select() selectCustom() from() where() whereCustom() whereByArray() whereIN() whereNotIN limit() order_by() result() row() run() getLastQuery() more functionality will be added at a later date

Here is a site i've been working on the past few weeks. It lets you vent/rant 100% anonymously. Any feedback is appreciated http://itirks.com/

Honestly the CMS I build will just have the basics and if people decide to add onto it they can... It'll prob use codeigniter with the basic below features such as... Being able to create blog posts(This ones a give me) Being able to create/manage pages Being able to create/manage links and sort them The adding of categories And themes A simple wysiwyg editor like QuillJs If you think a cms to get started needs more than that please list other features here

Ya honestly it's just for fun. If someone decides to use it then great, if not then atleast it can be part of my development portfolio thanks for the feedback tho

I personally think wordpress has one big flaw and that's it's codebase. Would it be worth creating a blogging platform that uses a MVC(Model-View-Controller) framework like laravel or codeigniter ? honestly this would just be a project for fun posted to github so i'm not looking to make money off of it or anything.

Honestly these services already exists so unless its going to be something unique i'm not sure the service would take off.

<input type="hidden" value="<?=Mage::getSingleton('core/session')->getFormKey()?>" name="form_key" />

Well one benefit of a query builder such as codeigniters is that it will escape the data for you using mysqli_escape_string and helps tremendously when building more complex queries . Not to mention the many other classes a good framework consists of such as ... Form validation Pagination Upload Security Etc... Also helpers such as HTML helper Form helper Date helper Array helper etc... And like i said if for any reason you need a different library or helper you can build your own. I guess i just don't see the purpose in building these classes from scratch. Maybe just try one framework out if you ever get the time.

After 16 years you are still building everything from scratch? Once i moved to Codeigniter I never looked back. It provides you with essential libraries such as the database Query builder. Instead of doing this... <?php $query = mysqli_query($conn,"SELECT * FROM `posts` ORDER BY `id` LIMIT 20"); if($query->num_rows() > 0){ while($row = mysqli_fetch_object($query)): echo $row->title."<br />"; endwhile; } you can do this using the frameworks query builder inside a model... <?php class My_model extends CI_Model { //Get posts public function get_posts() { $query = $this->db->order_by('id','DESC') ->limit(20) ->get('posts'); return $query->result(); } } And then pass the data to the view within the controller. Unless someone is just learning PHP or the project is simply way to small to warrant a framework then idk what reason anyone would choose to write stuff from scratch. You can always add functionality to the framework by building your own libraries,helpers etc... without ever having to touch the core code.

Here is a micro MVC framework i've been working on you can give it a try if you choose or add onto the framework. Here is the github project... https://github.com/webdeveloper73/AlohaPHPFramework

You're referring to something called pagination. There are plenty of php classes that have the functionality to do exactly what you want. A class off the top of my head would be Zebra Pagination https://github.com/stefangabos/Zebra_Pagination

Really hope your friend doesn't do this as a profession