CODEWITHSUNDEEP
mysqlphphtml
Noosrep
Noosrep

Reputation: 416

PHP getting data from HTML fields

I'm having some problems with getting data from HTML fields. This is how it looks in HTML

<form action="getInfo.php">
    <span>Series</span>
    <input class="searchFieldAlign" type="text" name="seriesName" /><Br>

    <span>Volume</span>
    <input class="searchFieldAlign" type="text" name="volumeName" /><Br>

    <span>Nr</span>
    <input class="searchFieldALign" type="text" name="issueNR" /><Br>

    <p input class="searchFieldALign" type=submit></p>
</form>

This is my php script:

<?php
$seriesName = mysqli_real_escape_string($conn, $_POST['seriesName']);
$volumeName = mysqli_real_escape_string($conn, $_POST['volumeName']);
$issueNR = mysqli_real_escape_string($conn, $_POST['issueNR']);
$con=mysqli_connect("localhost","user","psswd","db");

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
$qryIssueInfo = mysqli_query($con,"select issueNR, issueVolume, issueName, issueImageURL from issue, series where (seriesName='$seriesName') and (issueVolume='$volumeName') and (issueNR=$issueNR)");
$rowIssueInfo = mysqli_fetch_array($qryIssueInfo);

The problem is I don't get output from my query. There are no problems if i change it to this:

$qryIssueInfo = mysqli_query($con,"select issueNR, issueVolume, issueName, issueImageURL from issue, series where seriesName='Buffy, the Vampire Slayer' and issueVolume= 'Season 8' and issueNR=1");

Upvotes: 0

Views: 100

Answers (2)

Muhammet Arslan
Muhammet Arslan

Reputation: 985

If you not set form method = "post" it will be "get" and you should $_GET.

To correct:

<form method="post" action"getInfo.php">

Take it easy

Upvotes: 1

mcserep
mcserep

Reputation: 3299

The first version does not contain the apostrophes around the variables.

You should also consider security issues, like SQL injection.

Upvotes: 0

Related Questions