WorldWideScripts.net Delivering the best Add-Ons in more than 37 languages.

中文(简体), English, हिन्दी/हिंदी, Español/Castellano, العربية, Русский язык, Français, 中文 (台灣), বাংলা, Bahasa Indonesia, اردو, Português, Deutsch, Bahasa Melayu (بهاس ملايو‎), 日本語 (にほんご), فارسی, Italiano, తెలుగు, Türkçe, ગુજરાતી, Język polski/polszczyzna, Tiếng Việt, ಕನ್ನಡ, Українська мова, ไทย
PHP Scripts / Database Abstractions

Mega Class Database (MYSQL) v 1.0

— Add-On kwa WorldWideScripts.net

Kujiunga na kulisha wetu kukaa hadi tarehe!

Mpya! Kufuata yetu kama unataka!


Mega Class Database (MYSQL) v 1.0 - CodeCanyon Item for Sale

Ads

Ad: Bluehost hosting

Mega Hatari Database (MySQL) v 1.0


Matumizi ya kila kipengele cha MySQL katika PHP.

Sifa kuu:

1. MySQL Sambamba na: MySQL 3.23+, MySQL 4.0 +, MySQL 4.1 +, MySQL 5.0 +.
2. rahisi kutumia, safi, rahisi kuelewa kanuni.
3. Kupata MySQL Database bila elimu yoyote ya MySQL au SQL.
4. Matumizi Associative safu ya data kuingiza na safu update katika meza database.
5. Hiari kamba kutoroka kipengele ili kuepuka SQL sindano.
6. Moja kwa moja inajenga Tayari Taarifa.
7. Teule Safu, nguzo, Vigezo na moja ya plastiki.
8. Easy Teule, Insert, Mwisho, Futa, kuchujwa
9. vizuri kumbukumbu na mifano na maoni.
10. Small Size.
11. Ambatisha Kikamilifu Kumbukumbu.


Kazi

 // Kuungana kwa kompyuta sql_connect ($ sqlserver, $ sqluser, $ sqlpassword, $ Mbegu, $ bandari = uongo, $ ulabibu = uongo, $ new_link = uongo); // ------------------------------------------------ ----------------- + sql_query ($ swala = ''); // Kujenga Kauli sql kutoka safu kwa ajili ya kuchagua na kuchagua kauli tofauti // ------------------------------------------------ ----------------- + // Kujenga LIMIT swala sql_query_limit ($ swala, $ jumla, $ kukabiliana = 0); // ------------------------------------------------ ----------------- + // Kuchota mstari wa sasa sql_fetchrow ($ query_id); // ------------------------------------------------ ----------------- + // Inawezekana swala maadili: SELECT, SELECT_DISTINCT kazi sql_build_query ($ swala, $ safu); // ------------------------------------------------ ----------------- + // Kukimbia kauli zaidi ya moja kuingiza. sql_multi_insert ($ meza, & $ sql_ary); // ------------------------------------------------ ----------------- + // Kuepuka kamba kutumika katika sql swala sql_escape (); // ------------------------------------------------ ----------------- + // Anapata baadhi ya taarifa kuhusu meza maalum. get_table_status ($ table_name); // ------------------------------------------------ ----------------- + // Anapata idadi halisi ya safu katika meza maalum. get_row_count ($ table_name); // ------------------------------------------------ ----------------- + // Anapata inakadiriwa idadi ya mistari katika meza maalum. get_estimated_row_count ($ table_name); // ------------------------------------------------ ----------------- + // Kuonyesha sql makosa ukurasa sql_error (); // ------------------------------------------------ ----------------- + // Kujenga KATIKA au si katika kamba sql kulinganisha, matumizi <> au juu ya kipengele moja = sql_in_set ($ shamba, $ safu, $ yanatofautiana = uongo, $ allow_empty_set = uongo); // ------------------------------------------------ ----------------- + // Usahihi kurekebisha KAMA kujieleza kwa herufi maalum sql_like_expression ($ kujieleza); // ------------------------------------------------ ----------------- + // Version taarifa kuhusu kutumiwa orodha sql_server_info (); // ------------------------------------------------ ----------------- + // Rudisha idadi ya mistari walioathirika sql_affectedrows (); // ------------------------------------------------ ----------------- + // Tafuteni kwa kutokana na mfululizo idadi sql_rowseek ($ rownum, & $ query_id); // ------------------------------------------------ ----------------- + // Kupata mwisho kuingizwa id baada kuingiza taarifa sql_nextid (); // ------------------------------------------------ ----------------- + // Bure sql matokeo sql_freeresult ($ query_id = uongo); // ------------------------------------------------ ----------------- + // Karibu sql uhusiano sql_close (); // ------------------------------------------------ ----------------- + 

Matumizi

 // Kufafanua darasa file katika hati yako. define ('IN_MEGA_DB', kweli); // Ni pamoja na daraja la faili katika script yako. pamoja na ('mega.class.database.php'); $ dbhost = 'localhost'; $ dbport = ''; $ dbname = 'database'; $ dbuser = 'db_username'; $ dbpasswd = 'db_password'; $ tableprefix = ''; // wa zamani meza kutumika define ('USERS_TABLE', $ tableprefix 'watumiaji.); // New Hatari $ db = mapya dbal_mysql (); // Kuungana Database $ con = sql_connect ($ dbhost, $ dbuser, $ dbpasswd, $ dbname, $ dbport); // ------------------------------------------------ ----------------- + // SELECT, Insert, UPDATE, kufuta na kauli tayari: // ------------------------------------------------ ----------------- + // CHAGUA $ sql = $ db-> sql_query ("CHAGUA * KUTOKA".USERS_TABLE "".); $ mstari = $ db-> sql_fetchrow ($ sql); // AU wakati wakati ($ safu = $ db-> sql_fetchrow ($ sql)) { // Wakati kificho } // ------------------------------------------------ ----------------- + // Kuingiza $ sql_ins = safu ( 'id' => (int) '', 'jina la mtumiaji' => 'jina la mtumiaji', 'password' => '123456', 'email' => [email protected]', 'hadhi' => (int) '1', ); $ sql = 'kuingiza KATIKA'. USERS_TABLE. ''. $ db-> sql_build_array ('kuingiza', $ sql_ins); $ kusababisha = $ db-> sql_query ($ sql); // ------------------------------------------------ ----------------- + // UPDATE $ db-> sql_query (.. "UPDATE" USERS_TABLE "SET` password` = '123456' WAPI `id` = '1'"); // ------------------------------------------------ ----------------- + // Kufuta $ db-> sql_query ("kufuta" USERS_TABLE "WAPI` id` = '1' "..); // ------------------------------------------------ ----------------- + // LIMIT QUERY kama (! isset ($ _ GET ['ukurasa'])) {$ ukurasa = 1;} mwingine {$ ukurasa = intval ($ _ GET ['ukurasa']);} $ sql_limit = '10'; $ sql_start = ($ sql_limit * $ ukurasa) - $ sql_limit; $ sql = "CHAGUA * KUTOKA".USERS_TABLE "ORDER BY tarehe desc".; $ kusababisha = $ db-> sql_query_limit ($ sql, $ sql_limit, $ sql_start); wakati ($ safu = $ db-> sql_fetchrow ($ matokeo)) { // Wakati kificho } // ------------------------------------------------ ----------------- + // Hesabu Safu echo $ db-> get_row_count (USERS_TABLE); echo $ db-> get_estimated_row_count (USERS_TABLE); 


Toleo la Historia

 v1.0 Awali toleo. 

Download
Vipengele vingine katika jamii hiiKila sehemu ya mwandishi huyu
MaoniMara kwa mara kuulizwa maswali na majibu

Mali

Kuundwa:
Januari 21 13

Badiliko:
N / A

Files Pamoja:
PHP

Programu Version:
PHP 4.x, PHP 5.x, MySQL 4.x, MySQL 5.x, Nyingine

Keywords

eCommerce, eCommerce, Vitu zote, Hatari Database, tabaka la MySQL, Mbegu, mega darasa orodha, mysql