ThinkPHP - CURD增删改查 - 实例

时间:2023-03-09 19:21:13
ThinkPHP - CURD增删改查 - 实例

目录结构:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAO4AAAIfCAIAAAD43XfgAAAgAElEQVR4nO2d3W8b573nH9u6S24CFCnychEHMdCkjWRbjJCrXOTOBbbqyfZ4Nxb/hN3EMNtufJDYomDowthNsek5qhbGSbQ2c1DvSSGj6XZ1HDSn4ssMaVImRXJAiTIpUhKn8EUAA7kIkAthLx5y+Mwrh6/zzDPfD4x2OHxm+PbRk2dmft95iAqAEBCv3wAAowEqA0GAykAQoDIQBKgMBAEqA0FwUFn6fInhc0lVVVVV/vyPnTX/+GeFbdluYGxl0ZJdbWjZ2Qnbjt0xAHY4qJy9u7S09EX5e8q337QF+93m377//vvv/7b5O83R7N2lpaW72e6mu1/9bmlptdNwdUnfsrPP7548ZlvShp9L7ddpt/rb5l+ylm8PAB29VGYEVf78T0tLq5tHTx6rqqo+frL9xdLS0r9IFi2poL/7apc2PNpcddPy8da/0ieVf1vptnr85Mk3I/qsQGh6qcwMBtK/X1pa+tetx53nH/1ldWlp5d+UHiqr6uP6v+tasiMHpqX0+6WlpS/y37TbY3AB+sLtAOO7J4+NwnYt7KGysWVnn99+036qzd0yXac+fvJde7gBnYFb+hhgdHthSreX7qGysrGytLT673Xblqubf/u+/IVe28dPvusMn38vqQD0og+V26Pj9gFce+Tc/MaipU5leo7ii+0njx1bfvOtJrPy58/bpzzSv19aWlr9y6PRfV4gLH2orKrffNvuPJeW6KmM7+ghoPUIuMsXZTpwMLRc+lxipddk3vhqhd22/SIAOOKg8jfftsezppXdc2mmlXSLx0+++96wyqLl999+Q1t29kSf/fYJu7XxDQBgDa72AUGAykAQoDIQBKgMBAEqA0GAykAQoDIQhFGqXC6XZ2ZmpqamCCFTU1Nnz54tl8sj3D8ADoxS5cXFxfn5+Wazqapqo9GYn5+PRqOut46FSSiaMi+zDcIxV5u7fBUgFKNUORKJRCIR7eHKysrJkydJh179dE+VnYHKQae3ysv2GFoaVDbg3E+HO8aHoqm2cNEws0ZlLOz5LO29dc06/bn9tsaWwGf0VnljY8PS442NDUNLZ5V7NTD0yh2nNDP1sto8m4qGeu7E5UrgM3qr3Gw2V1dXDR6vrq7SMTGLZmoul7tw4cJTTz1FbHj55ZczmYx+a7sBhr4zTjk9GwqxGjrvpOdK4DNcjZVlWTaoLMuyuRlVWVGU06dP37hx49Ej6zrjVqv15ptvrqys6FcPrzIJhUKMhlA5WLg97FtbW9M8Xltbs2wTiUQuX7781ltvvffeew67+uCDD2ZmZur1un71CHrlaIp9LhbujIZT0VBnrf2fgbEl8BluVS4Wi5rKxWLRsk0kEnnmmWfefvvto6Mju/3EYrHnnnsul8tZPBXWH/YNpDK1kYRjdE04HNId4Nlva2oJfEYfJ+PW19eXl5fX19ftGiwuLj799NOKotg1uHv37rPPPvvll1/29x4HxP1QAYMKEehD5UePHt28edNuBKyqarlcnp6etjvUO3HixPT09L1790bxtt0AlYMFajCAIEBlIAhQGQgCVAaCAJWBIEBlIAhQGQgCVAaC4IHKyE2BceCBysPlppxLftxct3MOVgG/MhqVaSW+uYLZEufcVM+uOhUNhcNhG2FxCTq4jExlWo9vWcdsoGfYxLGrTkVD4Zga07sc64SZwuZit1A01X663Rc7B6uAXxmlylo1s10VKKWnyk5tqMn6UUK3K+4WHneWtJLPVDTkKlgF/MroVaasr6/b1dANo3LXYN2Sm+Jml3XPwK+MS+Xl5eWbN29aNh5C5ViYHVMbe1kVKgcZX/XK+nMPnUf6uBNUDip+Gisbz6Jpj1PRkNVhH1QOFB6cwaDnlR3yf0dHR32fbAaBx4Pzys65KcrMzAwuAYK+QA0GEASoDAQBKgNBgMpAEKAyEASoDAQBKgNBgMpAECatMtJQYExMWuXRzSJlfggCzaRVHt0sUuaHINCMsV6ZYmg5zCxSjiprpcy6YjebTBTTHtkRURiNyhOcRcqAaV4GczrKIhPF1jqjXxeE0ajsxSxSaq/KY+cFYxYF+J2RjZUnPouUOpzK6IxFY5SHfZOdRUq1HVYYl6yn3oHLgjFKlcc/i1Tfh322nbGWocL4QhRGfDLOb7NIAXEYscp+m0UKiANqMIAgQGUgCFAZCAJUBoIAlYEgQGUgCFAZCAJUBoLAqcrITYF+4VTlYWeRYqo4UTYUECancl93+xxqFilMLBJIJqqy+3swDzGLlF0wpK/ElLswlaEKD5NNecqkVR73nfHtTO4zMdUjTGW5K0w25S3eqEwZy3wl1ioPP/WOy8SKaiqqBhPCS5WXxzWLlNkkqCw+wvXKNmmnPhNTTgY7L0FlrxBurKyqKht36h6E9ZWY6tkZ2+1KhcpewekZDMwiBfqF0/PKmEUK9AunV/sA6BeoDAQBKgNBgMpAEKAyEASoDAQBKgNBgMpAEDhVGYEo0C+cquxhIIpuiioK38HphWvvAlEoBvIrnJYTTSwQpU8xdTtz5EB8h3BFnn0GokwpJvTKfkW40vtBAlF2K4GfQCDKYSXwE8L1yoMEolSoLADCjZVVVe07EKVCZQHg9AwGAlGgXzg9r4xAFOgXTq/2AdAvUBkIAlQGggCVgSBAZSAIUBkIAlQGggCVgSBwqjICUaBfOFV5iEAUiigCCqcXrocIREHlgMJpOdEQgSiDyt0iOaZEznI2p3bpXCgaxR+DHxGvyNOuV46FmfCTeTYnbbNUNITAtR8Rr/TepHI3e4p5cURG9ECU0yQ6PVcCPyF6r6wbVjhYy6Soui2BnxByrMzezKLzMBzu0QFrx4fdlsBPcHoGw8NAlGXKFfAPp+eVJx+IYpKtENmXcHq1D4B+gcpAEKAyEASoDAQBKgNBgMpAEKAyEASoDASBR5WRhgIDwKPKw00PZahrY+uJcBlPZHhU2TkN1aufdii9h8oi43G9MsXQ0rksrlc/be6VmYK4Tg4KE0CJx+RU3tjYsPR4Y2PD0LJnhadjAweVLXJQQBgmp3Kz2VxdXTV4vLq6aq6V00zN5XIXLlx46qmn7IrjXn755Uwmo9/asVdGTkRcJjpWlmXZoLJl7TJVWVGU06dP37hxwy5p0mq13nzzzZWVFf1qqBxQJn3Yt7a2xmZJLNtEIpHLly+/9dZb7733nsOuPvjgg5mZmXq9rl/tNMAwhZ+AOExa5WKxqKlsl4mKRCLPPPPM22+/7ZAiicVizz33XC6XMz9jCkR1e+VwOITielHx4GTc+vo6zajaNVhcXHz66acVRbFrcPfu3WefffbLL78czxsEvsQDlR89enTz5k27EbDaKw114sSJ6enpe/fuTfI9A/7h8RIJAAMAlYEgQGUgCFAZCAJUBoIAlYEgQGUgCFAZCIJfVUZoChjwq8rDhaZUVe1ZVWSopEN9M+/4VeXhQlOqqqqpaCgcDtu7jEJQn8GXypMKTanU5Jga07vM3lecvUOtoYc23LvWbsopMFH4UnlSoamOyfqhgz4nZV2qb7OEqJX38KXypEJTjMG6JcuafbVXFAX5FC7gS2V1cqEpFssbZUBln8GdyuoEQlP6ExKdR4YzGn0NMKCy9/Co8rhDU8ZTa7oxRrebpg/cHvZBZa/hUWUVoSnQP5yqjNAU6BdOVQagX6AyEASoDAQBKgNBgMpAEKAyEASoDAQBKgNBCITKr732GnsBZWpqam5uTpIkr98XGCWBUJkQYni4tLT0wgsvWNbcUdqVFq7qKfqsu/AmiDWm4hCOak4CqrKqqjdu3HjxxRfNpcwd3P9I/f2cHgWx/LXbQQiuyqqqfvTRR3NzczYbWU8tpa8C1dJTprq5Tm1d9z777e51kkEs9s3o3othk86q7ltkH+q+EOMUW5bvwZvJuIRSuWUDIYR9+Morr7CFRzYb3Vkgs4tJukDIwp32uvZS9+nWnQXCLC7cabVaycVZbduFO9pq+szCHaalYa+6HRtexGrJ4o2xH8Bmt9oabWN2W8ND3f5ML+d+pTUj/PVFUJn9ao6sIIRYrnd86vYCmb2eYBfcrOyycPvo6OgocX2WEF1Tul6/pD3f78uZV1ruR/+w+zbpmsT12c7bPTI/HPkb6zJap32vMmvw4eHhAUOzAyGkaYP9U2uXyPlrm+xCXyuZ3RByaY150IWuNmw12MuZX9pmt93Vugab185336bp4QjfGPsDHR4esk4PaYK/VdY8Pjw8bDabjUZjf3+/boIQwi5oDw3Lej59l5z/8Gt2gV3++sPznbWfvkvMK7s7effT9v/Wtf9nnzNtZflyPZb075a+hs1utee7b5vy9YfnLR9abKD/8JbvwfYb0djf3280Gs1mkwo9vM0+Vpl+eNoTNxqNer1eq9X29vaq1equHkKI9r/sGsNKllsXCSGEnLt6f/fWRXLu6n1tdWf5/tVztG+9eNFiJbl4i2l9/+o5cvHWrYvk4i39a7Qft1+NPqQPzl29v2t8aaK9J+Ob6S6zL8Lulm1geNu6V7d6SJduXSTnLl485+49mFvqqFare3t7tVqtXq83Gg3aQw9ps19V1vrjg4OD/f39Wq1WrVYrlYqiKOVyuaSHEMIuaA8Ny8CRlV+QmV//aTQty+WyoiiVSqVardZqtf39/YODgyH7Zh+rTMcVjUajVqsdE4J//vqXz+eLxaKiKLu7u7VardFoaCONwZTwpcra0KLZbNbr9Wq1ekxIoVDIZrOZTEaWZUmSZFmWZTmdTmcymZdeeonY8NJLL2XAREin0/RHkSTpmJBMJpPNZguFgqIo1Wq1Xq/TcfPAHbO/VaZdcqVSOSYkm83KspxMJuPxeDweTyQSqVQqlUppWgMPkSSJ/hyJRCIejx8TkkwmZVnOZrPFYrFSqWgdc+BU1kbJe3t7iqLQv3Lq8ebmpqayLMvpdJr2zcAr6E8gyzKrcjweTyaTmUwmn88rirK3t8eOmAewwvcqV6vVcrl8TIgsy6zHkiRlMplsNpvL5XK53BbwDvoT0OGfJEmJROKYEPpLybK8tbVVLper1WpwVaYD5d3d3VKpdEyIJEna0EKSpGw2+/Dhw0KhUCwWR3IAD4ahWCwWCoWHDx9ms1k6VqY/liRJuVyuVCrt7u7S4TJUJrIsJxIJ6vGDBw/y+XypVKJnfHZ2dixPHoPJsLOzQ8+TlkqlfD7/4MGDY0LojyXLMlS2UDmZTKZSqUwms7W1VSqVtNOW9FQ88Ar6E9AT/6VSaWtr65iQVCpFj/ygslHldDpNT1Zop3jo9aRGo0EvkAKvoD8BvRarKEqhUKBdjyRJ6XQaKhtVpocU9KvZ3t6m53fokcSrr77Knks+derUG2+8kUwmreu1wKihxQX0omylUtne3ta6Hu0/oVBZp7Isy5lMJpfLFYvFnZ0d7VQl0dcrE0Ki0ejzzz8vSZJ9Ja2hwNdc7+ua5OKs07aGAmWn6t5+GOINj3q3R8x12Z2dnWKxyP5eUNlWZfNXQ0YQiBo8+YMEVL+/F1TuT2XVbSDK+NCUF4rpoz+xMAmFwyGmedATUFDZliFVPnPmjDZuPnnypM2L2Klsd8/8VDSkNWC2nOBUVPa71b9T40ewy3Vbvpz7lV2gsi1Dqsxi/5SdyqloyGBMF304tf30pKaist9tTN/1Gz+C4eHI3xhUtsdTlVVV9+M7KzXJqahsdms9/Y8bnaHy+BlYZbrA6utgOfufStNtWLThhPkGLfrucOxTUWmvYbNbdlihe6faRzA8tNiA2bXdezC37AKVbRlMZUuDHVRmD5jsD/LYVsZO125Ybb5dRh+HfbYqG3ar86xziGlYY/Fm9CqHwuGQu/dgbjn47wWVR9wrBx735916tITKtjh/NT0vkbA4PBV43F8N6dESl0hsafV54Zq9HZGBV155ZVyXa0EHXLi2xVJllBNxC8qJbLFUGUWe3IIiT1vsVEbpPZ+g9N4WS5URiOIZBKKsaVnFVPHPX/8QU1VVq5sH5PP5DG4ewCvmmwfQ3wg3D7C4pUuxWMQtXXjGcEsX6rGMW7rQT7u9vT09PX3q1ClCyKlTp3784x9/9dVXGasbbQEeYG+0JctyBjfaorRarevXr//sZz+jJ49LpdKFCxd+9atf5fN57R4i9jdz+eQd5irJO5/Y3Yrkk3fIdORevzcw+eQdh10GGMOPIvjtD5eXlzc2NprNZs+WrVbrypUrV65c0S4jffzxxydOnGCv5J06deonP/lJPB43HU8zd039069nyC9WrA+73d+GFfSH+DelXV5eXl5eXl1dle1n1NOgKjvcKrxUKv30pz+9evWq6USn/o7f3ft3m++Sfe7q1fY6893Az12937kLOLvX3vf3vnjxHDlnflcBQvxbhS8zrK2tFYtFh8aRSOTKlStatUrTagKH999///333zddfvr03W7f3Z1SgZlRoTsRATN7ATP5AtP86w/Pa9MzdKZIcJ51wW5Kg2Ah+AQOyybW19cfPXpk2TgSiUQiEa326shqWp3Lly9fvnzZVBTAzPWyee18d3qbLpfWmrbTw3Qbnr+22WxuXjt//tpm5/8GmXonSARlWh2zysvLyzdv3rRsTFVWHSc7o4MQU6kWOwNX4vosndrLeb6wznJ3nbaUuD47e/329Vnj+p4TgQUd9ocbXh7eVe7ZK7NrzJWyVGXTaqa+Nrk4276LivnOK1azQbITN7IzTy4sdJr2nDdyHHda8SsjlIdfld2MlQ0qu27DpkeZ+IN9tMkxX2SIzbkPNYFRwqPKLs9gLC4uzs/PHx0d2TU4Ojqan5+PRqMjfY+AU7hT2eV5ZVVVy+Xy9PS0XTyEMjMzUy6Xx/22AQ/wpTIAAwOVgSBAZSAIUBkIAlQGggCVgSBAZSAIUBkIgo9VLpfLMzMzU1NThJCpqamzZ8/iakiQ8bHK9MI1vTTYaDT6uUbNTDjQIRUNWc/vYb25XUuUWHgGXyp/9tlnyWTy4ODATWNDqdDKysrJkyfZq9b2XTWt8mFdppVEUNnHcKfyZ5999oc//CGfz/ds3LMyzr6rbt/amp0yJBSNOla0qdY1cRb32YbK3sCjypQ//vGPlUrFofFwRZ6haKo7AVksHIqmekyZoJ+oyXBfe3b2A6jsDfyqTPnLX/6yv79v2XholTsitucjG2DmmB7TQ4FJwrvKn3322e3bty0bD68ylZiZWW8AlZ2naQKTg3eVx9or04FBKOxmTib9JEm28yFBZc/gV+Xxj5Xbi+bBsPVhnxaXYg/7nDJUYKLwqLLLMxgIRAEW7lR2f14ZgSjAwpfKAAwMVAaCAJWBIEBlIAhQGQgCVAaCAJWBIEBlIAg+VhmBKMDiY5UHDkR1ioy1R0zVhL7807RdX/UVqMeYKHyp3NedPAcPRLGixsKhUDdOopXQWwGVuYY7ld3fX3nwQBQjbCxMwlHtoWUYxCkHZR2jahfyW2SqwPjgUeXx3/VeU5aW3XeK77uK29Qum1ayOW2Eo7yFX5UHmIvEfZu2bkyAhPakptplhKN8A+8qu5khygHbNqloKBSNtU1uu8wMoRGO8h+8qzymXrkdhQrpj/7Yg0Fz5MkyB4VwFDfwq/I4x8qqalIvFmbv8RKziDxZ5qCcwlHtMQd0ngw8quyjGaLMXTHwCu5U9sUMUd3+FyJzA18qAzAwUBkIAlQGggCVgSBAZSAIUBkIAlQGggCVgSBwqjLCTqBfOFV52NmfdMWWfWGoeut/B8AjJqfyhMJOhulD+nYR5Wx+ZaIqTyLsZN2t2lcYR8NMLYUhxaRrGQ63p0NrN9KV0Q34nwAwQiat8vgLOO3mXLDJfWiq95CetFMnpDMTD2Gr9tUeCVcwfrxReZxl9cxY2bL+eKiEiOXCMENzMDK8VHk8YSddAMQUcFLHoDI6Yy4QsldmYx1UZv2AYJQqo/ieF0QeK6usaNpAoBthsrSWTTG564xNOSjgCZyeweAh7AT8BafnlTH7E+gXTq/2AdAvUBkIAlQGggCVgSBAZSAIUBkIAlQGggCVgSDwqDLSUGAAeFR5iDSUGtZdELSr80E5m4DwqLJzGspFP93TVKgsIB7XK1MMLZ3L4lz006aSt6ghsgSVBWRyKm9sbFh6vLGxYWjZs8KzVwPTVGVOqScgCJNTudlsrq6uGjxeXV0118pppuZyuQsXLjz11FN2xXEvv/xyJpMxvZR1ITKiH2Iz0bGyLMsGlS1rl6nKiqKcPn36xo0bdkmTVqv15ptvrqysmJ6BykFk0od9a2trbJbEsk0kErl8+fJbb7313nvvOezqgw8+mJmZqdfrpmeMAwyreZ2gsmhMWuVisaipbJeJikQizzzzzNtvv+2QIonFYs8991wul7N80tAT01tYEOuuGgiCByfj1tfXaUbVrsHi4uLTTz+tKIpdg7t37z777LNffvmli1eDtUHBA5UfPXp08+ZNuxGw2isNdeLEienp6Xv37rl7NagcFHi8RALAAEBlIAhQGQgCVAaCAJWBIEBlIAhQGQgCVAaC4GOVkZsCLD5WeeDcVPv+tK4uAuJioW/gS+W+7vY5mlmkegCVfQN3Kru/B/MoZpEyTxKlNTDcV5xdGWN3wc4TATyER5UneGd8y7iU4Rb43UX9TFB0Baap5AV+VaaMeb6SvqYj6dKd4MTlkBuMH95VXh7vLFKDzRzF7AYTkHAD7yp70Svrk1O2M0FhgMEX/Ko8vrEyczLOJtCqTfrEHvbpZ4LCYR9v8KgyZpECA8CdyphFCgwGXyoDMDBQGQgCVAaCAJWBIEBlIAhQGQgCVAaCAJWBIPhVZaShgAG/qjzMLFKmMjdERUTAryoPN4sUVBYQvlS2rFemGFoON4uUrcqd6jet1C2mn1uqc+PxEEqUuIMvlUcyi1Sr1Wq1WleuXLly5UrLmjsLZHYxaX54Z4Es3NG3W7jTarWSi7NaA92WAjD+X3VC8KXyOGaROn36tCzLRzpuL5DZ6wnzw8T1WUIWbjPruyzcNm/oe0Rymi+V1UFnkdrb22u1WvTnOTw8POjQbDbn5uZ++9vfNnWsXSLnr21aP9y8dp6QS2sWzSzX+I8DhsPDQ9bpyf/cI4Q7ldX+Z5GiPwOVuNlsNhqN/f39er1er9d/+ctfvv7665VKpa7n03cJefdTuvz1h+fJ+Q+/7j759Yfn6WPTM/VP3zWs8DP7+/uNRqPZbFKh/W4zjyr3NYvU4eFhq9WiPXGj0ajX67VabW9vr1qt3rp164c//OFf//rXXQvuXz2njR0u3mqvvHXRsKLbiq66dZGcu3rfan9+o1qt7u3t1Wq1er3eaDRoD+1rm3lUWXU9i1S5XKb98cHBwf7+fq1Wq1arlUpFUZRbt2794Ac/iMViJWBFuVxWFKVSqVSr1Vqttr+/f3Bw4Ou+mVOVB5tF6hj/+vmXz+eLxaKiKLu7u7VardFoaCONSf7Wo4JTld1A+w86Pq7X69Vq9ZiQQqGQzWYzmYwsy5IkybIsy3I6nc6ATCadTtMvRJKkY0IymUw2my0UCoqiVKvVer1Ox80+7ZhFULnRaNRqtUqlckxINpuVZTmZTMbj8Xg8nkgkUqlUKpXStA4skiTRryKRSMTj8WNCksmkLMvZbLZYLFYqFa1jhsqThh0l7+3tKYpCexrq8ebmpqayLMvpdDrIfTP9+LIssyrH4/FkMpnJZPL5vKIoe3t77IjZ65+3bwRRuVqtlsvlY0JkWWY9liQpk8lks9lcLpfL5baCCv34dOglSVIikTgmhH5LsixvbW2Vy+VqtQqVvYGqTAfKu7u7pVLpmBBJkrShhSRJ2Wz24cOHhUKhWCx6fc7AY4rFYqFQePjwYTabpWNl+kVJkpTL5Uql0u7uLh0uQ+VJY6myLMuJRIJ6/ODBg3w+XyqV6FmnnZ0db0/lesjOzg49R1kqlfL5/IMHD44JoV+ULMtQ2WPsVE4mk6lUKpPJbG1tlUol7dQpvRwQTOjHpyfdS6XS1tbWMSGpVIoe+UFlj7FUOZ1O05MV2mkmek2r0WjQi7TBhH58eh1UUZRCoUD/7CVJSqfTUNljLFWmhzX059ne3qbnmH70ox+xV1JOnTr1xhtvJJPJyVSf8QC9sE8viFYqle3tbe3PXvvPF1T2DDuVZVnOZDK5XK5YLO7s7NRqNUIIWzFDCIlGo88//7wkSYNW+Roqnu1Wumzm/iUGhNpMO+adnZ1isch+V1DZY1qOKrM/DyGE/XkIIaqq3rhx48UXX8xkMgO9uGWGyrzSZTP3LzEg7r8rqOwB/apMRxdqR2VVVT/66KO5uTmb3XfvDO565qiwtcq6Gai6c5p0HobC4facJu3nTJP7TPK7gsoeMHCvfObMGW3cfPLkyV6v052iwW7mKPNKZlvzDFSGW+2TUDRF/3DCMfYm+lC5PwKkstYrs5jXdDF0oH3MwcPuot9pexwn8hkUqMw1A/fKLLYq6zpbqOwDAqSyoVc2jJuNaMMKy0mieqxkN4bKEyJAKh8xE/BoBtsPMKwO5pxnjuqudFa5vWvtsA8qj4QAqWw+g6E6j5UFAipzzXjHymIBlbnG/c/zyiuvEBvOnDnj9eeYBFCZa4Lw84yKIHxXUDkQBOG7gsqBIAjfFVQOBEH4rqByIAjCdwWVA0EQviuoHAiC8F0FQuVXX32VPZc8NTU1NzcnSZLXn2ByQGWuGSZFsrS09MILL8hWNyHv0C1T7sUAxRKTTpdAZa7xNBDFApW5IEAq9xmI0leo6UJNWgOHcFSM3UU3GsLufIJBKajMNWMORLEqm0NNtuGocExV1VQ0xFZ7mscqkw5KQWWuGXMgaoDwSLdn1USlxcwm9SZdkg+VuWbMRZ6DqWwlLTEfP0Ll0RMglQ29srkMX4+zYb3CUd2dsAMMz4JSUJlrxh+IcgyiOoejSDhmcdjnWVAKKnMNAlHugcpcg0CUe6Ay1yAQ5R6ozDVB+HlGRRC+K6gcCILwXUHlQBCE77JlDWcAAArKSURBVAoqB4IgfFdQORAE4buCyoEgCN8VVA4EQfiuAqEyAlFQmWvGHIgaBrZeolvfbFXtablVz5Uut+0ClbmGm0CUGefb37vfyuWGvZtBZa6ZQCDKJpKkMlX2rEDmiBQ1rFuSH44x2SijfmNMSUFlrhl/IMoukqSvy+woZBWRsqjM1HajpabYVxxTSgoqc83EA1HD5Er0hc5tHx0GISOux4fKXDPxQNSIVKYSx0wmQ+XhCJDKQweirIYV+oGDmwEGbRoOh5mBydhTUlCZayYeiDIOW42HfdZTRVmp1nVdnUxKCipzjX8DUeY467iBylzjz0CUzY0xxgxU5hoEotwDlbkmCD/PqAjCdyWsyrlcrlgs7uzs1Gq1RqNxeHhIf6FgcnR0dHh42Gg0arXazs5OsViEyhzRslFZkqR0Op3L5ba3tyuVSq1W29/fPzg4oDYHk8PDw4ODg/39/VqtVqlUtre3jwlJp9OSJEFl77FUmf48sixns9lCoaAoyt7eHu2YG41GM6jQj1+r1fb29hRFKRQKx4TIsqz92UNlL7FUWZblZDKZSqW0zqZSqVSr1VqtVqvV6kGFfvxqtVqpVEql0tbW1jEhqVQqmUzKsgyVPcZO5UQikUgkJEl68OBBPp8vlUqKolQqlZ2dnd2gsrOzU6lUFEUplUr5fP7BgwfHhNAvCip7j6XKkiTF4/F4PE5tzmazDx8+LBQKxWKxFGyKxWKhUHj48GE2m5Uk6ZgQ+kVJkgSVB6RcLs/MzExNTdFs0tmzZ8vl8gD7oSrTo5lqtVoul48JwT/3/zY3N+PxuCzLW1tb5XK5Wq3S42Oo7JbFxcX5+flms6mqaqPRmJ+fj0aj7jaNMbeVDy0muyrTo5l8Pp/JZJLJ//4fyI//y+ebtG9OpVKyLKfTH/+cvH75i0wm85ufk5//JhMs0ul0Op2WZTmVSiUSiXg8Tj1OJpOZTCafz9PjY6isLi8vb2xsUDt7EolEIpGI9nBlZeXkyZPsFTj7rlpf6E4W7rRa2unSSqVSLBaz2awsf/wz8pP/+i9xTeVUKiVJ/2OevP7+/5EDiyRJ9KugKlOPZVnOZrPFYpGetaQn4Omp6JGIMUlGpvLy8vLq6qrsIvhpUNmMfVetqx1bIAt3Wncukdlrm816vV6t3vp7cvaXfyxks//z5+T199+fp38Y8x/L6XQ6k/kN0yvTBbpMCCEB6aZpx0y1lmU5k8lopyyr1SodKEPlLmtra8Vi0aFxT5Xt2xirg5OtOwtk9nqcdsz/fJGc+2//TykW/+k/EkLe+SSXy+U++TtC/u6TXG5r65N3yHTk3hazsPXJO4S888lWYMgxbG1t5fP5YrGoKMru7q7hmugwMnjF6FWmrK+vP3r0yLLxcCprhGOq2qIqJ+iI+bP/TM79w/1qpfK//p6c/fX/LZdKpVJp5Rdk5td/cl4IIuVymZ6jpCfd2VEyVDZy8+ZNy8Yj6ZW1NQtkdjHZOjw8PDj43++S8x9+Xa/V/vk/kXP/cL+6u7u7u3vrIjl39b7zQhCpVqv0Omi9Xm80GvTCvn89Vn3YKxtUTkVDZOFOq9VqHd1eIGT22maz0Vh7l5DzH35dr9e//vB8e6n+6bvtJW2BeTKQ7O/v04v5bK3V4BJ4jV/Hyrp1lIUFOtg4PLx9icxeujRLCKFyN5vNZnPtEjl/bZNdoMuEEEIurU2wIMJjDhi0Eiu/e6x6cgaDnlc+YpJ2Bo6Ojvo52dzGUNMI3MB+aX192xziwXnlcrk8PT1tF+ugzMzMDHYJUNU7DXoy2JfMIT6uwQCABSoDQYDKQBCgMhAEqAwEASoDQYDKQBCgMhAEHweiAGDxUyAqrLsgSKfjsJyHpjtliAnLCW/YfZrbsDd+NbQEHOGvQJRqdxNi1zjO3dSeAcRBZV3Lvl4YjBt/BaJUC5V1UyqpRvOcnqW9t2GH7lRWY2GozBn+KvJULW49bzulksOz7JQ25ikYYvqRjMXAg7Z09dWASeGv0nvVfoDRx+Q3oRA7mjaGrNyNlR2G48Ab/BWIUkehMgmF2MmZHEfP1nsGPBLEXpmOIUyjZ8uXsNsh4A6/j5UHVFntzkgKlQVBnEAUCDgCBqJAMEENBhAEqAwEASoDQYDKQBCgMhAEqAwEASoDQYDKQBAQiAKC4KdAlH11hJvGfYFyC//hr0AUVAa2+CsQ5Viz1sk+dariTXkTXbw0FQ2ZE6edZuGwLjCCWns/4K8iT8d8h20yynKJ3UlbU12z7p4hsT/wV+m9ywCpm8JlNt/k0Ewrawa8469A1OhUtuiobW9LAJ19gb96ZWb40A1Iq+yAQL/SfkkbONhtqvubYRPagFP8NVZW2cM1pqeMhUkoHA7pj+KcD/ssjvC6++6ujBmOJQG3iBGIwrkzIEggCioD1GAAUYDKQBCgMhAEqAwEASoDQYDKQBCgMhAEqAwEwTOVX3vtNUO5/dzcnCRJXr0f4Hc8U5kQYni4tLT0wgsvuLn0bXN5D9f8Ag1HKquqeuPGjRdffDGTyfTaGioDI3yprKrqRx99NDc312trXQKqU4DMFr85551iLh4ao1BIRnEOLyqfOXNGGzefPHmy19Y9ElD6loyqhul09A/DMZUpTTZEoZCM4h1eVHb5VAfn2EhntW3eyfJhl47TrOuIkvCOoCr3yDv1fNgGOvsIf6nMxph6qeyQd1J7PlSZ9UhG+QORVG6PEnRHgWzeyfk4r3ug2P0jcDgoBLzhL5UBsAUqA0HwTBr27JuBM2fOePWugH9B/wcEASoDQYDKQBCgMhAEqAwEASoDQYDKQBAQiAKCwMvVPtJfIMoSNymSYcqOkVLhGo5UVvsIRFkybtWgMtfwpbLaIxDlclqn7p3DQ9FU+2nj1DnmSBWL/ZRTxk0sWwIP4EXl/gNRztM6kVA01S2VT0VDxupQy0gVu3/LwJXLlcADeFHZ5VPupnXqa0G1Gjn0DFy53A+YHL5S2e20TlA5iHivMl1g9XVS2dW0TgOr3PMFLDexTlyBCeOxypYGOwaiTDEn62mdhle555RTxkNMi6NHMEF81StPDvdDBQwqeMF7lft6alJAZf+BQBQQBM/7PwBGA1QGggCVgSBAZSAIUBkIAlQGggCVgSAgEAUEgZerfe4CUe7jTKO6CIeLeb6BI5XVYQNRLFA5cPClstojENUzztT7DuHaLrrJEnbnCEH5Fl5UdheI6hFnsgpHaYMSw9RP5rEKQlD+hheV3T01QKCjm6Ai+qkarKOpSI74liCobCWtRV8Klf2N9yr3U3rvLJNlOMocUzIMMBCCEgTfBaIc+0WLcJRx6ifTYR9CUILgr155rCA54m+8V7mvp8YJVPY3CEQBQUA5ERAEqAwEASoDQYDKQBCgMhAEqAwEASoDQUAgCggCL1f7XAei3F9mw9W7YMGRymrvQBRUBrbwpbLqGIgyTENiSDqp3Ro4WsNpaKx2NkHqSUx4UbnPQFT7gVXSyboxsxKpJzHhRWV3Txmqhw1JJ21uM3Njuz0gKiIOvlbZQi9GZ6gcLLxXeaBAlGqfRWLHG6yLSD0Jjr8CUe1RRdsrfdLJfBTINEbqSXz81SsPD87QCYv3Kvf11NBAZWFBIAoIAsqJgCBAZSAIUBkIAlQGggCVgSBAZSAIUBkIAlQGggCVgSBAZSAIUBkIAlQGggCVgSBAZSAI/x/SjOtJDhzN6QAAAABJRU5ErkJggg==" alt="" />

UserAction.class.php:

<?php
//编写控制器类
class UserAction extends Action {
/**
* 显示主页面,入口文件
* @return 无返回值
*/
public function index(){
//创建实体模型
$user = M('User');
//查询所有数据
$dataArr = $user->select();
//向前台模板注入数据
$this->assign('data', $dataArr);
//显示模板文件
$this->display();
} /**
* 显示修改数据页面
* @return 无返回值
*/
public function modify(){
//创建实体模型
$user = M('User');
//接受传递的id参数
$id = $_GET['id'];
//获取数据
$dataArr = $user->find($id);
//注入到前台页面
$this->assign('data', $dataArr);
//显示模板文件
$this->display();
} /**
* 显示添加用户页面
* @return 无返回值
*/
public function add(){
//显示添加页面
$this->display();
} /**
* 删除数据
* @return 无返回值
*/
public function del(){
//创建实体模型
$user = M('User');
//接受传递的get参数
$id = $_GET['id'];
//根据id删除数据
$result = $user->delete($id);
//判断结果
if ( $result > 0 ) {
$this->success('删除成功!');
} else {
$this->error('删除失败!');
}
} /**
* 修改数据
* @return 无返回值
*/
public function update(){
//创建实体模型
$user = M('User');
//接受传递来的参数
$id = $_POST['id'];
$dataArr['username'] = $_POST['username'];
$dataArr['sex'] = $_POST['sex'];
//修改
$result = $user->where('id=' . $id)->save($dataArr);
//判断
if ( $result > 0 ) {
$this->success('修改成功!', 'index');
} else {
$this->error('修改失败!');
}
} /**
* 添加数据
* @return 无返回值
*/
public function create(){
//创建实体模型
$user = M('User');
//接收要添加的数据
$dataArr['username'] = $_POST['username'];
$dataArr['sex'] = $_POST['sex'];
//添加
$result = $user->add($dataArr);
//判断
if ( $result > 0 ) {
$this->success('添加成功!', 'index');
} else {
$this->error('添加失败!');
}
}
}

删除效果:

  • 直接点击页面即可删除。删除的链接为 del方法,传递id参数。

ThinkPHP - CURD增删改查 - 实例

add.html:

ThinkPHP - CURD增删改查 - 实例

<!DOCTYPE html>
<html>
<head>
<title>添加页面</title>
</head>
<body>
<form action="__URL__/create" method="POST">
姓名:<input type="text" name="username" /><br/>
性别:
男<input type="radio" name="sex" value="1" />
女<input type="radio" name="sex" value="0" /><br/>
<input type="submit" name="submit" value="添加新用户" />
</form>
</body>
</html>

modify.html:

ThinkPHP - CURD增删改查 - 实例

<!DOCTYPE html>
<html>
<head>
<title>修改页面</title>
</head>
<body>
<form action="__URL__/update" method="POST">
<input type="hidden" name="id" value="<{$data.id}>" />
姓名:<input type="text" name="username" value="<{$data.username}>" /><br/>
性别:
男<input type="radio" name="sex" value="1" />
女<input type="radio" name="sex" value="0" /><br/>
<input type="submit" name="submit" value="提交修改" />
</form>
</body> <script type="text/javascript">
//判断性别
if (<{$data.sex}> == 0) {
//男
document.getElementsByName("sex")[1].checked="checked";
} else {
//女
document.getElementsByName("sex")[0].checked="checked";
}
</script>
</html>

index.html:

ThinkPHP - CURD增删改查 - 实例

<!DOCTYPE html>
<html>
<head>
<title>用户列表页面</title>
<script type="text/javascript">
function jumpPage(){
window.location = '__URL__/add';
}
</script>
</head>
<body>
<table border='1' width="500">
<tr>
<th>编号</th>
<th>姓名</th>
<th>性别</th>
<th>操作</th>
</tr>
<volist name='data' id='vo'>
<tr>
<td>
<{$vo.id}>
</td>
<td>
<{$vo.username}>
</td>
<td>
<{$vo.sex}>
</td>
<td>
<a href="__URL__/del/id/<{$vo.id}>">删除</a>
|
<a href="__URL__/modify/id/<{$vo.id}>">修改</a>
</td>
</tr>
</volist>
</table>
<button onclick="jumpPage()">添加用户</button>
</body>
</html>