PHP Help

Red Soda

Well-known member
  • Mar 15, 2012
    3,013
    460
    113
    Kalutara
    මචන් මන් PHP වලින් පොඩි survey සිස්ටම් එකක් හදනවා.ඒත් ඒකේ Database structure එක ගෑන මට කිසිම අදහසක් නෑහෑ.මේකේ අපිට පුලුවන් dynamic form එකක් හදාගන්න.කෑමති form field එකක් දාල.ඒකට හරියන විදිහට කොහොමද database structure හදන්නේ කියල මට කියන්න පුලුවන්ද? ලොකු උදව්වක් මච්න් :(:(
     

    Barry Allen

    Member
    Oct 15, 2016
    2,855
    139
    0
    Central City
    note easy work :rolleyes:

    Osclass දාන් බලපන්..එකේ ඇති dynamic form එකක් හදාගන්න විදිය..

    textbox,textarea,radio,dropdown,checkbox වලට වෙනම කරන්න වෙනවනේ :sorry:
     
    • Like
    Reactions: Red Soda

    Red Soda

    Well-known member
  • Mar 15, 2012
    3,013
    460
    113
    Kalutara
    note easy work :rolleyes:

    Osclass දාන් බලපන්..එකේ ඇති dynamic form එකක් හදාගන්න විදිය..

    textbox,textarea,radio,dropdown,checkbox වලට වෙනම කරන්න වෙනවනේ :sorry:


    ow machan
    mokakda Osclass kiyanne ?
     

    TheNewThinker

    Well-known member
  • Dec 5, 2016
    1,458
    201
    63
    kanthare
    machan issela system eka mona wage ewada enne kiyala kiyanda.
    system eke apita handle karanda one data walata anuwa db eka plan karnda.
    eta passe eka eka form walin ea data manipulate karanda widiyata hadaganda.
    saralwa kiyanda amarui

    nathan one basic crud (create retrive update delte) karaganna widiyatad php mysql walin ?
     
    • Like
    Reactions: Red Soda

    Red Soda

    Well-known member
  • Mar 15, 2012
    3,013
    460
    113
    Kalutara
    machan issela system eka mona wage ewada enne kiyala kiyanda.
    system eke apita handle karanda one data walata anuwa db eka plan karnda.
    eta passe eka eka form walin ea data manipulate karanda widiyata hadaganda.
    saralwa kiyanda amarui

    nathan one basic crud (create retrive update delte) karaganna widiyatad php mysql walin ?

    survey monkey ekata samana system ekak machn
    Eke survey ekak create karana widhihata samanwa thmai hadanna ona
     

    TheNewThinker

    Well-known member
  • Dec 5, 2016
    1,458
    201
    63
    kanthare
    survey monkey ekata samana system ekak machn
    Eke survey ekak create karana widhihata samanwa thmai hadanna ona

    ok. dan ethakota ekata galapenda db tables ghala relations dagandada udu one.

    ehenam umba ganda hope karana fields monwada kiyala list ekak hadala therena widiyata table wage hadala meke dapanko.

    mata dan wadath ekka surway monkey balanda ba. eth fieldsui system eke functionalites ui wisthara karoth er adala help ekak dennam.
     

    shenic_v2.0.0

    Member
    Sep 17, 2016
    2,287
    351
    0
    mamath me ekak hadana gaman :(

    From No 1.
    meken karanne "input form" ekata oona inputs create karana eka.
    mekedi,

    1. input type eka
    2. max length
    3. min length
    ....
    ..
    etc.

    wage attributes ekka input add kara ganna eka. inputs wala info ekka. db tables 1k ho keepayak use karala meka karanna puluwan. eeka depend wenne oyage system structure eka anuwa.

    Form No 2.
    me thiyenne user ta load wena form eka.
    oya use karana logic ekak anuwa mekata input dinamic widihata add wenawa kalin save wechchi db info anuwa.

    ethakota form_2 eke data validate karanneth form_1 eken add karana input wala info anuwama thmai.

    meeka maha epawena wadak :(
     
    Last edited:

    Barry Allen

    Member
    Oct 15, 2016
    2,855
    139
    0
    Central City
    eka hariyanne na wage machn
    Awulak na
    thanks machn udaw kalata
    mta awula thiyenne DB structure eka hadaganna widhiha:sorry:
    Anikwa echchara awulak na

    එක රැගෙන බලපන් කිව්වේ,එක Use කරන්න නෙවි...එකේ ඇති ඔය db table structure එක :P
     

    Barry Allen

    Member
    Oct 15, 2016
    2,855
    139
    0
    Central City
    mamath me ekak hadana gaman :(

    From No 1.
    meken karanne "input form" ekata oona inputs create karana eka.
    mekedi,

    1. input type eka
    2. max length
    3. min length
    ....
    ..
    etc.

    wage attributes ekka input add kara ganna eka. inputs wala info ekka. db tables 1k ho keepayak use karala meka karanna puluwan. eeka depend wenne oyage system structure eka anuwa.

    Form No 2.
    me thiyenne user ta load wena form eka.
    oya use karana logic ekak anuwa mekata input dinamic widihata add wenawa kalin save wechchi db info anuwa.

    ethakota form_2 eke data validate karanneth form_1 eken add karana input wala info anuwama thmai.

    meeka maha epawena wadak :(

    input_slug =>name attribute
    input_required =>required දෙන්න
     

    TheNewThinker

    Well-known member
  • Dec 5, 2016
    1,458
    201
    63
    kanthare
    thanks machn
    mn balannm
    mn list ekak hadala dannm balanna

    Hithapan api inventory system ekak hadanawa kiyala,

    ethakota oke wikunana items tieynwa, ea items tiyaganda table ekak one

    customersla innwa unge details tiyaganda wenama ekak one
    thawa bill issue karanwa. ethkota bill details tiyaganda table 2k wage one

    bill eke date, number, customer wage common details tikai, items tika tiyaganda wenama ekakui. ethakota ea items tiyaganna eke bill eke number eka tiyenwa. eken thami releate wenne.

    thawa accounts handle wenwa nam thwa tiyenwa tables. mehema sarlwa kiyanda amarui. eth idea ekak ganda pulwan wei kiyala hithuwa okata adalwa.
     

    Barry Allen

    Member
    Oct 15, 2016
    2,855
    139
    0
    Central City
    PHP:
    --
    -- Table structure for table `meta_fields`
    --
    
    CREATE TABLE IF NOT EXISTS `meta_fields` (
      `m_field_id` int(5) NOT NULL AUTO_INCREMENT,
      `m_slug` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
      `m_type` int(2) DEFAULT NULL,
      `m_required` tinyint(1) DEFAULT '0',
      PRIMARY KEY (`m_field_id`)
    ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
    
    
    --
    -- Table structure for table `survey_meta`
    --
    
    CREATE TABLE IF NOT EXISTS `survey_meta` (
      `i_meta_id` int(11) NOT NULL AUTO_INCREMENT,
      `survey_id` int(11) DEFAULT NULL,
      `m_field_id` int(5) DEFAULT NULL,
      `i_m_value` text CHARACTER SET utf8,
      PRIMARY KEY (`i_meta_id`),
      KEY `survey_id` (`survey_id`)
    ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

    මේ table structure එකෙන් ඕක කරන්න පුළුවන් ;)
     

    TheNewThinker

    Well-known member
  • Dec 5, 2016
    1,458
    201
    63
    kanthare
    umba ahala athine isselama requirements aran eta passe db eka thami hadaganne
    hama paththam cover wena widiyata fields dala db eka hadla.

    awashya de karaganda forms & interfaces hadnwa.

    ohoma mokak hari project ekak patan gaththa eka hodai ethkota thamai purudu wenne.

    apith ohoma 6k 4k theren nathuwa hitapu kalayak thibba ban ea kale elakiri thibbe wath nathuwa athi :)
     

    Red Soda

    Well-known member
  • Mar 15, 2012
    3,013
    460
    113
    Kalutara
    ok. dan ethakota ekata galapenda db tables ghala relations dagandada udu one.

    ehenam umba ganda hope karana fields monwada kiyala list ekak hadala therena widiyata table wage hadala meke dapanko.

    mata dan wadath ekka surway monkey balanda ba. eth fieldsui system eke functionalites ui wisthara karoth er adala help ekak dennam.

    me system eke admin and users la innawa
    admin surveys create karala danawa backend eken
    admin create karana surveys frontend eke show wenawa
    usersla site ekata awith ewa fill karanwa
    eka thamai meken mulikawama wenne

    admin survey ekak create karanakota form fields dynamically add karaganna puluwan
    (Ex : textbox, checkbox, radio buttons, text areas)

    users la surveys fill kalama e results admin ta backend eken balagann puluwan

    oya tika thmai mulikawama wenna one machn
     

    shenic_v2.0.0

    Member
    Sep 17, 2016
    2,287
    351
    0
    input_slug =>name attribute
    input_required =>required දෙන්න

    PHP:
    --
    -- Table structure for table `meta_fields`
    --
    
    CREATE TABLE IF NOT EXISTS `meta_fields` (
      `m_field_id` int(5) NOT NULL AUTO_INCREMENT,
      `m_slug` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
      `m_type` int(2) DEFAULT NULL,
      `m_required` tinyint(1) DEFAULT '0',
      PRIMARY KEY (`m_field_id`)
    ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
    
    
    --
    -- Table structure for table `survey_meta`
    --
    
    CREATE TABLE IF NOT EXISTS `survey_meta` (
      `i_meta_id` int(11) NOT NULL AUTO_INCREMENT,
      `survey_id` int(11) DEFAULT NULL,
      `m_field_id` int(5) DEFAULT NULL,
      `i_m_value` text CHARACTER SET utf8,
      PRIMARY KEY (`i_meta_id`),
      KEY `survey_id` (`survey_id`)
    ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

    මේ table structure එකෙන් ඕක කරන්න පුළුවන් ;)

    wenas wenas input wala wenas attributes thiyene.

    text, radio, checkbox, select, textarea .. etc.

    oya oonama input ekak (data input karanna use karana inputs) handle karanna oya structure eken puluwan da? :oo:

    mata penne baha :no:
     
    • Like
    Reactions: Red Soda