Results 1 to 3 of 3

Thread: Passing CSS formatted data to a PHPMyAdmin database

  1. #1
    Join Date
    Oct 2012
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Passing CSS formatted data to a PHPMyAdmin database

    I have applied text-transform to a data entry form to ensure consistency. I want certain characters to be uppercase regardless of whether the user enters them that way. However when I submit the data to my database it appears as it was entered i.e. if the user didn't capitalise the characters in question they appear in the lowercase, even though on the data entry form they are in uppercase. Has anybody any suggestions as to how I can rectify this issue?

  2. #2
    Join Date
    May 2012
    Location
    Hitchhiking the Galaxy
    Posts
    1,013
    Thanks
    46
    Thanked 139 Times in 139 Posts
    Blog Entries
    1

    Default

    You could use the mysql function UPPER()?
    http://www.sqlinfo.net/mysql/mysql_f...pper_lower.php
    Edit:
    Or alternatively you could use the php function strtoupper() before submitting it.
    Last edited by bernie1227; 10-11-2012 at 11:56 PM.
    "Most good programmers do programming not because they expect to get paid or get adulation by the public, but because it is fun to program." - Linus Torvalds
    Anime Views Forums
    Bernie

  3. #3
    Join Date
    Apr 2008
    Location
    So.Cal
    Posts
    3,643
    Thanks
    63
    Thanked 516 Times in 502 Posts
    Blog Entries
    5

    Default

    Do you mean CSS text-transform? That doesn't affect the actual text at all (only how the browser displays it). You'd need to apply those changes to the text itself before saving it to your database.

Similar Threads

  1. ACCESS DB I may extract data to csv or sql file, for importing to MySQL/PHPMyAdmin ?
    By leonidassavvides in forum MySQL and other databases
    Replies: 1
    Last Post: 03-07-2009, 06:49 PM
  2. colunm shows same price(column) in phpmyadmin rather than the data table (csv)importe
    By leonidassavvides in forum MySQL and other databases
    Replies: 0
    Last Post: 04-11-2008, 10:52 AM
  3. Importing .cvs to MySql database -- phpMyAdmin
    By Humper in forum MySQL and other databases
    Replies: 1
    Last Post: 10-27-2006, 05:41 AM
  4. Retriving data from a formatted hard disk?
    By sunny in forum The lounge
    Replies: 3
    Last Post: 03-30-2006, 02:33 PM
  5. Replies: 1
    Last Post: 12-13-2005, 12:43 AM

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
  •