Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 21
  1. #11
    GKIye's Avatar
    Title
    Moderator
    Join Date
    Nov 2008
    Location
    @ home
    Posts
    3,005
    Rep Power
    69
    Hi James,

    Should a similar button exist also for Whatsapp ?
    To Me Whatsapp is more interesting than Skype ...
    Into my data plan at my provider (smartphone) I have a special option to select a "free" app with unlimited up/download. I selected Whatsapp, so I'm available at any moment of the day (well ... unless I'm sleeping )
    Quote Originally Posted by James View Post
    Sounds like you only need a Skype contact button.
    https://www.skype.com/en/developer/c...actme-buttons/
    Last edited by GKIye; 05-29-2017 at 01:17 PM. Reason: typo
    Visit and listen @ BW !



  2. #12
    xhilaration's Avatar
    Title
    Junior Broadcaster
    Join Date
    May 2017
    Location
    Mississippi
    Posts
    28
    Rep Power
    3
    Quote Originally Posted by James View Post
    You'll need to structure a database for requests. Whatever fields you want to name.
    e.g. id, name, phone number, song title, artist etc..
    Yeah but I get lost what I need to put for em, I guess you would say permissions

    name - Null - char - text

    you wouldn't havr a picture of how this would be setup look like?

    So I get the idea

    Like I said, when I go into the phpmyadmin, I get lost & confused ☹️😟
    🌺 Xhilaration 🌺

  3. #13
    James's Avatar
    Title
    Administrator
    Join Date
    Jan 2008
    Location
    Melbourne, Australia
    Posts
    12,182
    Rep Power
    10
    Quote Originally Posted by GKIye View Post
    Hi James,

    Should a similar button exist also for Whatsapp ?
    To Me Whatsapp is more interesting than Skype ...
    Into my data plan at my provider (smartphone) I have a special option to select a "free" app with unlimited up/download. I selected Whatsapp, so I'm available at any moment of the day (well ... unless I'm sleeping )
    You can use the WhatsApp API Link to launch the WhatsApp application on a mobile device:

    Code:
    https://api.whatsapp.com/send?phone=PHONENUMBER&text=YOURTEXTGOESHERE
    Just replace PHONENUMBER with your WhatsApp phone number, and YOURTEXTGOESHERE with whatever text you wish the person to send you.
    I could whip something up in PHP so that a user fills in a form and then it navigates to that URL with prepopulating text.

    Quote Originally Posted by xhilaration View Post
    Yeah but I get lost what I need to put for em, I guess you would say permissions

    name - Null - char - text

    you wouldn't havr a picture of how this would be setup look like?

    So I get the idea

    Like I said, when I go into the phpmyadmin, I get lost & confused ☹️
    A structure I would envision would be:

    Code:
    id int(100) AUTO_INCREMENT
    name varchar(255)
    email varchar(255)
    songtitle varchar(255)
    songartist varchar(255)
    message TEXT
    daterequested DATETIME default:CURRENT_TIMESTAMP
    That would store the persons name, song title, song artist and an optional message. The database would store an ID (you always need a primary key) and record the date requested.

  4. #14
    xhilaration's Avatar
    Title
    Junior Broadcaster
    Join Date
    May 2017
    Location
    Mississippi
    Posts
    28
    Rep Power
    3
    Quote Originally Posted by James View Post
    You can use the WhatsApp API Link to launch the WhatsApp application on a mobile device:

    Code:
    https://api.whatsapp.com/send?phone=PHONENUMBER&text=YOURTEXTGOESHERE
    Just replace PHONENUMBER with your WhatsApp phone number, and YOURTEXTGOESHERE with whatever text you wish the person to send you.
    I could whip something up in PHP so that a user fills in a form and then it navigates to that URL with prepopulating text.



    A structure I would envision would be:

    Code:
    id int(100) AUTO_INCREMENT
    name varchar(255)
    email varchar(255)
    songtitle varchar(255)
    songartist varchar(255)
    message TEXT
    daterequested DATETIME default:CURRENT_TIMESTAMP
    That would store the persons name, song title, song artist and an optional message. The database would store an ID (you always need a primary key) and record the date requested.
    Ty James ��
    I get how to create a db but after not so much

    ty again !!
    🌺 Xhilaration 🌺

  5. #15
    xhilaration's Avatar
    Title
    Junior Broadcaster
    Join Date
    May 2017
    Location
    Mississippi
    Posts
    28
    Rep Power
    3
    James
    I found a part of an example code

    CREATE TABLE 'request_song'
    Code:
    (`id` bigint NOT NULL auto_increment,
    `song` longtext NOT NULL default '',
    `artist` longtext NOT NULL default '',
    `name` longtext NOT NULL default '',
    `ip` varchar(100) NOT NULL default '',
    PRIMARY KEY (`id`)
    )
    TYPE=MyISAM;
    


    For the 'id' part, does it need to have a name for it?

    Example:
    'id' = request

    or am I off??

    :O
    Last edited by xhilaration; 05-30-2017 at 02:09 PM. Reason: Adjusting code
    🌺 Xhilaration 🌺

  6. #16
    James's Avatar
    Title
    Administrator
    Join Date
    Jan 2008
    Location
    Melbourne, Australia
    Posts
    12,182
    Rep Power
    10
    Quote Originally Posted by xhilaration View Post
    James
    I found a part of an example code

    CREATE TABLE 'request_song'
    Code:
    (`id` bigint NOT NULL auto_increment,
    `song` longtext NOT NULL default '',
    `artist` longtext NOT NULL default '',
    `name` longtext NOT NULL default '',
    `ip` varchar(100) NOT NULL default '',
    PRIMARY KEY (`id`)
    )
    TYPE=MyISAM;
    


    For the 'id' part, does it need to have a name for it?

    Example:
    'id' = request

    or am I off??

    :O
    'id' should be named 'id' as it's the unique identifier for the table. You can name it what you like but it wont make a difference.

  7. #17
    saint's Avatar
    Title
    Content Manager
    Join Date
    Mar 2009
    Posts
    1,190
    Rep Power
    28
    One thing you need to remember in code development is KISS - keep it simple stupid. Creating a database for song requests ASSUMES that listeners know exactly what songs you have - OR - what artists you have. With the way data base hacks are being created - I would be leary of relying on that to "communicate" information to the on air DJ.

    A simple message application could be incorporated into the station website to e mail or message the online DJ - no need to worry about API information related to Skype / whats app. When you start adding mega features to a basic concept - the obfuscation to the end results can be very harrowing.

    I personally love to keep things simple - as it requires less maintenance and constant prodding. Just my two cents

  8. #18
    James's Avatar
    Title
    Administrator
    Join Date
    Jan 2008
    Location
    Melbourne, Australia
    Posts
    12,182
    Rep Power
    10
    Quote Originally Posted by saint View Post
    One thing you need to remember in code development is KISS - keep it simple stupid. Creating a database for song requests ASSUMES that listeners know exactly what songs you have - OR - what artists you have. With the way data base hacks are being created - I would be leary of relying on that to "communicate" information to the on air DJ.

    A simple message application could be incorporated into the station website to e mail or message the online DJ - no need to worry about API information related to Skype / whats app. When you start adding mega features to a basic concept - the obfuscation to the end results can be very harrowing.

    I personally love to keep things simple - as it requires less maintenance and constant prodding. Just my two cents
    Agreed, I recently deployed a message feature for a station near me so that listeners could message the studio from their computer. Just set up a Slack API call, no need for a database or anything really.

  9. #19
    xhilaration's Avatar
    Title
    Junior Broadcaster
    Join Date
    May 2017
    Location
    Mississippi
    Posts
    28
    Rep Power
    3
    Guess that I prefer try my hand in a db & try to get myself to understand how mysql works. You can say that I like challenges hehe. Dab into db so my site would look good & I can say that I finally made a proper site with not only PHP but mysql as well

    I tried using a plain jane email form in the past but now not so much thats my opinion :p. Yeah, keep it simple BUT I want it to look nice, crisp & clean as well !! .

    Im just a tad new to the mysql side vs the just php side of coding

    🌺 Xhilaration 🌺

  10. #20
    James's Avatar
    Title
    Administrator
    Join Date
    Jan 2008
    Location
    Melbourne, Australia
    Posts
    12,182
    Rep Power
    10
    Quote Originally Posted by xhilaration View Post
    Guess that I prefer try my hand in a db & try to get myself to understand how mysql works. You can say that I like challenges hehe. Dab into db so my site would look good & I can say that I finally made a proper site with not only PHP but mysql as well

    I tried using a plain jane email form in the past but now not so much thats my opinion :p. Yeah, keep it simple BUT I want it to look nice, crisp & clean as well !! .

    Im just a tad new to the mysql side vs the just php side of coding

    Great way to learn too. Do what's best for you and your station.
    Be sure to read up on SQL injection and keeping your SQL connection secure between MySQL and PHP. I recommend looking into PDO rather than traditional mysql_connect or mysqli_connect, far more secure.

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •