submit button has turned into a text box

Question

http://lindsaymacvean.com/wuwo/activlist/sql_update.php

Im trying to implement a simple form from this question.

#1273 - Unknown collation: 'utf8mb4_unicode_ci' Cpanel

I am seeing a textbox where the submit button should be and I don't know why?

UPDATE For those of you who are seeing the code with spaces this is not what the original file shows.

<!DOCTYPE html>
<html>
<head>
  <title>DB-Convert</title>
  <style>
    body { font-family:"Courier New", Courier, monospace;" }
  </style>
</head>
<body>

<h1>Convert your Database to utf8_general_ci!</h1>

<form action="sql_update.php" method="POST">
  dbname: <input type="text" name="dbname"><br>
  dbuser: <input type="text" name="dbuser"><br>
  dbpass: <input type="text" name="dbpassword"><br>
  <input type="submit">
</form>
version 1

</body>
</html>
<?php
if ($_POST) {
  $dbname = $_POST['dbname'];
  $dbuser = $_POST['dbuser'];
  $dbpassword = $_POST['dbpassword'];

  $con = mysql_connect('localhost',$dbuser,$dbpassword);
  if(!$con) { echo "Cannot connect to the database ";die();}
  mysql_select_db($dbname);
  $result=mysql_query('show tables');
  while($tables = mysql_fetch_array($result)) {
          foreach ($tables as $key => $value) {
           mysql_query("ALTER TABLE $value CONVERT TO CHARACTER SET utf8   COLLATE utf8_general_ci");
     }}
  echo "<script>alert('The collation of your database has been successfully changed!');</script>";
}

?>

`type="submit"`. I.e. get rid of the spaces. – Jonnix Aug 24 '15 at 15:56 — Jonnix, Aug 24 '15 at 15:56

score 0 · Answer 1 · answered Aug 24 '15 at 15:56

0

Remove the spacing between everything and it should work.

<form action="sql_update.php" method="POST">
  dbname: <input type="text" name="dbname"><br>
  dbuser: <input type="text" name="dbuser"><br>
  dbpass: <input type="text" name="dbpassword"><br>
  <input type="submit">
</form>

Example

http://jsfiddle.net/w2c507ud/

answered Aug 24 '15 at 15:56

Script47

14,230
4
45
66

I dont understand why that is happening on the front end because the original file is fine. – lindsaymacvean Aug 24 '15 at 15:57
@lindsaymacvean does the original file have spacing? If it does, remove the spaces. – Script47 Aug 24 '15 at 15:58
no the original file does not have spaces I will past the code into my question. – lindsaymacvean Aug 24 '15 at 15:58
yeah it works locally. Weird. Anyone with any thoughts on this it would be really appreciated?? – lindsaymacvean Aug 24 '15 at 16:04

score 0 · Answer 2 · answered Aug 24 '15 at 15:59

0

try to change,

<input type=" submit ">

to

<input type="submit" name="submit" value="submit">

answered Aug 24 '15 at 15:59

I have changed that and now it just looks like a text box with the word submit inside it. – lindsaymacvean Aug 24 '15 at 16:02
Im thinking its something maybe todo with the way my server is serving the file or the permissions? – lindsaymacvean Aug 24 '15 at 16:03

score 0 · Answer 3 · answered Aug 24 '15 at 17:32

0

There was an error in the

 body { font-family:"Courier New", Courier, monospace;" }

Should be

body { font-family:"Courier New, Courier, monospace;" }

answered Aug 24 '15 at 17:32

lindsaymacvean

4,419
2
19
21

submit button has turned into a text box

3 Answers3