Redbean：入门(一)，redbean入门

<?<span>php
    </span><span>require_once</span> 'rb.php'<span>;
    </span><span>$tableName</span> = "link"<span>;
    </span><span>//</span><span>链接数据库</span>
    R::setup("mysql:host=localhost;dbname=hwibs_model","root",""<span>);
    </span><span>//</span><span>创建一个表（也可以指为实例化一个表）</span>
    <span>$handler</span> = R::dispense(<span>$tableName</span><span>);
    
    
    </span><span>#</span><span>####################################   add #####################################</span>
    
    <span>/*</span><span>同上[同时实例化多个表]
        list($handler_1,$handler_2) = R::dispenseALL("test_1,test_2");
    </span><span>*/</span>
    <span>//</span><span>对象方式给字段赋值
    //::注意，如果字段不存在，store方法过后，会自动添加对应的字段，并且自动根据字段值设置字段的对应字段类型</span>
    <span>$handler</span>->name = "haha"<span>;
    </span><span>$handler</span>->url = "isxiugai"<span>;
    </span><span>$handler</span>->plushtime = <span>time</span>() - 5000<span>;
    </span><span>//</span><span>如果有下划线的字段名，则可以使用驼峰法命名，将自动转换为下划线</span>
    <span>$handler</span>->isMyName = <span>false</span>;<span>//</span><span> = is_my_name
    //执行,此静态方法会返回添加成功后的自增id值(单个)</span>
    <span>$inser_id</span> = R::store(<span>$handler</span><span>);
    
    </span><span>#</span><span>####################################   query ####################################
    //获取记录句柄(参数1为表名，参数2为id值),返回值为对象集合
    //如果id不存在，则返回0
    //注意，这个获取到的句柄，可以用于删除操作</span>
    <span>$bean</span>  = R::load(<span>$tableName</span>,4);<span>//</span><span>获取单个</span>
    <span>$beans</span> = R::loadAll(<span>$tableName</span>,<span>array</span>(1,2,3,4));<span>//</span><span>获取多个</span>

    <span>#</span><span>####################################   update #####################################
    
    //1.注意，修改跟add的唯一区别就是id，如果id不为空，则为修改，否则则为添加!
    //2.如果id不存在的情况下，既不会添加，也不会修改！所以一般在修改前，需要事先用load进行判断是否存在</span>
    
    <span>foreach</span> (<span>$beans</span> <span>as</span> <span>$k</span>=><span>$v</span><span>){
        </span><span>$beans</span>[<span>$k</span>]->url = <span>rand</span>(100,5555);<span>//</span><span>测试[循环将每个记录对象中的url赋值一个随机数]</span>
<span>    }
    R</span>::storeAll(<span>$beans</span>);<span>//</span><span>执行修改</span>
    
    
    <span>#</span><span>####################################   delete #####################################
    //删除单个::成功或失败都是返回null</span>
    <span>var_dump</span>(R::trash(R::load(<span>$tableName</span>,1<span>)));
    </span><span>//</span><span>删除多个::如果有不存在的，则会只删除存在的,成功或失败都是返回null</span>
    <span>var_dump</span>(R::trashAll(R::loadALL(<span>$tableName</span>,<span>array</span>(117,118<span>))));
    
    
    </span><span>#</span><span>####################################   other #####################################
    //清除表中所有数据::相当于truncate，因为会将自增指针重置
    //R::wipe($tableName);
    //删除数据库中所有的表,[无语的功能，要这个搞毛]
    //var_dump(R::nuke());
    //关闭链接</span>
    R::<span>close();
</span>?>