php help

BrentonHale

Hi, I'm Brenton and I'm needing some help with php. I'm a noob when it comes to php/MySQL or any programming language for that matter. I'm currently taking an online class in the both (php/MySQL) and I'm only in the second week, so I don't know much and please bare with me. Anyway, here is what I need help with:

<html>
<head>
<title>Hale's Music World:  Inventory Search Results</title>
</head>
<body>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="56%" id="table1" height="129">
<tr>
<td  bgcolor="#008000"> </td>
</tr>
<tr>
<td>
<p align="center"><font size="5" color="#0000FF"><b>Inventory Search Results</b></font></td></tr>
<tr>
<td bgcolor="#008000"> </td>
</tr>
<tr>
<td>
<p align="center"> </td>
</tr>
<tr>
<td width="99%" align="center">
<p align="left"><font color="#0000FF"><b>Your search resulted in the following records:</b></font></td></form></tr>
<tr>
<td width="99%" align="center">
<p align="left">

<?php

$link = mysql_connect('localhost', 'halesuser', 'hales123db'); mysql_select_db('halesmusicworld'); 
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);

if ($search_type==1)
{
$artist_search=($_POST ['Artist_Search'] ) . '!'  ;
$query= "select * from inventory where artist like '%".$artist_search."%'";
$query_results=mysql_query($query);
$match_results=mysql_num_rows($query_results);
echo 'Number of matching records='.$match_results. '<hr>';

}

If ($search_type==2)
{
$title_search=($_POST ['Title_Search'] ) . '!'  ;
$query= "select * from inventory where title like '%".$title_search."%'";
$query_results=mysql_query($query);
$match_results=mysql_num_rows($query_results);
echo 'Number of matching records='.$match_results. '<hr>';
}

If ($search_type==3)
{
$genre_search=($_POST ['Genre'] ) . '!' ;
$query= "select * from inventory where genre like '%".$genre_search."%'";
$query_results=mysql_query($query);
$match_results=mysql_num_rows($query_results);
echo 'Number of matching records='.$match_results. '<hr>';

}
?>

</td>
</tr>
<tr>
<td align="center"> </td>
</tr>
<tr>
<td align"center" bgcolor="#008000"> </td>
</tr>
</table>
<p align="center"><i><a href="halesmusicworld_home.html"><font face="Arial" size="5">Return to</font></a><font face"Arial" size"5"><a href="HalesMusicWorld_Home.html">Hale's Music World Home</a></font></i></p>
</body>
</html>

The html part of the code will load and it say's it's "Connected successfully"

However, I'm getting the following code errors on three lines

Notice: Undefined variable: search_type in C:\wamp\www\inventory_search.php on line 36

Notice: Undefined variable: search_type in C:\wamp\www\inventory_search.php on line 46

Notice: Undefined variable: search_type in C:\wamp\www\inventory_search.php on line 55

Thanking you in advance for all the replies!

NogDog

The issue is just what the notice message says: you are using the variable $search_type in a context which implies it should exist, but it does not. Where do you expect that variable to come from? If it is coming from your form that calls this script, then you should probably be using the corresponding $POST (or $GET if using the get method) array element.

If basing this on other code you've seen, you may have been led astray by obsolete coding techniques that depend on the now-deprecated [man]register_globals[/man] feature of PHP, which is turned off by default in all modern versions and should not be depended upon any more.

BrentonHale

NogDog;10936174 wrote:
The issue is just what the notice message says: you are using the variable $search_type in a context which implies it should exist, but it does not. Where do you expect that variable to come from? If it is coming from your form that calls this script, then you should probably be using the corresponding $POST (or $GET if using the get method) array element.

If basing this on other code you've seen, you may have been led astray by obsolete coding techniques that depend on the now-deprecated [man]register_globals[/man] feature of PHP, which is turned off by default in all modern versions and should not be depended upon any more.

Now I can't even get the page to load at all! 😕

<html>
<head>
<title>Hale's Music World:  Inventory Search Results</title>
</head>
<body>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="56%" id="table1" height="129">
<tr>
<td  bgcolor="#008000"> </td>
</tr>
<tr>
<td>
<p align="center"><font size="5" color="#0000FF"><b>Inventory Search Results</b></font></td></tr>
<tr>
<td bgcolor="#008000"> </td>
</tr>
<tr>
<td>
<p align="center"> </td>
</tr>
<tr>
<td width="99%" align="center">
<p align="left"><font color="#0000FF"><b>Your search resulted in the following records:</b></font></td></form></tr>
<tr>
<td width="99%" align="center">
<p align="left">

<?php

$link = mysql_connect('localhost','halesuser','hales123db');
mysql_select_db("halesmusicworld", $link);

if ($_GET['Artist_Search'] == 1) 
echo '1';
{
$artist_search=($_GET["Artist_Search"]).'1' ;
$query= "select * from inventory where artist like '%".$artist_search."%'";
$result = mysql_query("SELECT * FROM inventory", $link);
$num_rows = mysql_num_rows($result);
echo 'Number of matching records='.$result. '<hr>';

} 

if ($_GET['Title_Search'] == 2)
echo '2';
{
$title_search=($_GET['Title_Search']).'2';
$query= "select * from inventory where title like '%".$title_search."%'";
$query_results=mysql_query($query);
$match_results=mysql_num_rows($query_results);
echo 'Number of matching records'.$match_results. '<hr>';

if ($_GET['Genre_Search'] == 3)
echo '3';
{
$genre_search=($_GET['Genre']).'3';
$query= "select * from inventory where genre like '%".$genre_search."%'";
$query_results=mysql_query($query);
$match_reults=mysql_num_rows($query_results); 
echo 'Number of matching records='.$match_results. '<hr>';

} 

?>

</td>
</tr>
<tr>
<td align="center"> </td>
</tr>
<tr>
<td align"center" bgcolor="#008000"> </td>
</tr>
</table>
<p align="center"><i><a href="halesmusicworld_home.html"><font face="Arial" size="5">Return to</font></a><font face="Arial" size"5"><a href="HalesMusicWorld_Home.html">Hale's Music World Home</a></font></i></p>
</body>
</html>

I've tried reading over the php and mysql manuals, but i'm still lost and not really sure what to even look for in those manuals.

djjjozsi

one example:

<?php
if ( isset( $_GET['Artist_Search'] ) AND $_GET['Artist_Search'] == 1 ) {
    echo '1';
    $artist_search = mysql_real_escape_string( $_GET["Artist_Search"] ) . '1' ;
    $query = "select * from inventory where artist like '%" . $artist_search . "%'";
    $result = mysql_query( "SELECT * FROM inventory", $link );
    $num_rows = mysql_num_rows( $result );
    echo 'Number of matching records=' . $num_rows . '<hr>';
} 
?>

Lets see these functions:
isset()
mysql_num_rows()
mysql_query()
mysql_real_escape_string()

BrentonHale

djjjozsi;10936201 wrote:

one example:

<?php
if ( isset( $_GET['Artist_Search'] ) AND $_GET['Artist_Search'] == 1 ) {
    echo '1';
    $artist_search = mysql_real_escape_string( $_GET["Artist_Search"] ) . '1' ;
    $query = "select * from inventory where artist like '%" . $artist_search . "%'";
    $result = mysql_query( "SELECT * FROM inventory", $link );
    $num_rows = mysql_num_rows( $result );
    echo 'Number of matching records=' . $num_rows . '<hr>';
} 
?>

Lets see these functions:
isset()
mysql_num_rows()
mysql_query()
mysql_real_escape_string()

Thanks alot! This really helped out!

BrentonHale

BrentonHale;10936206 wrote:
Thanks alot! This really helped out!

Now after adding additional code -- I'm stuck again. What I was trying to do is have it display matching names of artists and titles.

I get the following error message and I don't understand what it means:

Notice: Undefined variable: match_results in C:\wamp\www\inventory_search.php on line 59

Fatal error: Function name must be a string in C:\wamp\www\inventory_search.php on line 59

<html>
<head>
<title>Hale's Music World: Inventory Search Results</title>
</head>
<body>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="56%" id="table1" height="129">
<tr>
<td bgcolor="#008000"> </td>
</tr>
<tr>
<td>
Inventory Search Results</td></tr>
<tr>
<td bgcolor="#008000"> </td>
</tr>
<tr>
<td>
 </td>
</tr>
<tr>
<td width="99%" align="center">
Your search resulted in the following records:</td></form></tr>
<tr>
<td width="99%" align="center">

<?php

$link = mysql_connect('localhost','halesuser','hales123db');
mysql_select_db("halesmusicworld", $link);

if ( isset( $POST['Artist_Search'] ) AND $POST['Artist_Search'] == 1 ) {
echo '1';
$artist_search = mysql_real_escape_string( $_POST["Artist_Search"] ) . '1' ;
$query = "select from inventory where artist like '%" . $artist_search . "%'";
$result = mysql_query( "SELECT FROM inventory", $link );
$num_rows = mysql_num_rows( $result );
echo 'Number of matching records=' . $num_rows . '<hr>';
}

if ( isset( $POST['Title_Search'] ) AND $POST['Title_Search'] == 2 ) {
echo '2';
$title_search = mysql_real_espace_string( $_POST["Title_Search"] ) . '2' ;
$query = "select from inventory where title like '%" . $title_search . "%'";
$result = mysql_query( "SELECT FROM inventory", $link );
$num_rows = mysql_num_rows( $result );
echo 'Number of matching records='. $num_rows . '<hr>';
}

if ( isset( $POST['Genre_Search'] ) AND $POST['Genre_Search'] == 3 ) {
echo '3';
$genre_search=$_POST ['Genre'] ;
$query= "select * from inventory where genre like '%".$genre_search."%'";
$query_results=mysql_query($query);
$match_results=mysql_num_rows($query_results);
echo 'Number of matching records='.$match_results. '<hr>';
}
echo '</tr>';
for ($i=0; $i < $match_results; $i++)
{
echo '<tr> <td>';
$row=mysql_fetch_array($query_results);
echo ($row ['artist'] );
echo '';
echo '</td> </tr>';
}
?>
<tr>
<td align="center"> </td>
</tr>
<tr>
<td align="center" bgcolor="#008000"> </td>
</tr>
</table>
<a href="HalesMusicWorld_Home.html">

Return to </a> <a href="HalesMusicWorld_Home.html">HalesMusicWorld Home</a>

</body>
</html>

BrentonHale

disregard my previous posting... please check and see what is wrong with this new code I'm posting "now".

<html>
<head>
<title>Hale's Music World: Inventory Search Results</title>
</head>
<body>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="56%" id="table1" height="129">
<tr>
<td bgcolor="#008000" colspan"3"> </td>
</tr>
<tr>
<td colspan="3">
Inventory Search Results</td></tr>
<tr>
<td bgcolor="#008000" colspan="3"> </td>
</tr>
<tr>
<td width="33" align="center">

Artist</td>
<td width="33%" align="center">

Title</td>
<td width="33%" align="center">

Genre</td>
</tr>

<?php

$link = mysql_connect('localhost','halesuser','hales123db');
mysql_select_db("halesmusicworld", $link);

for ($i=0; $i < $match_results; $i++)
{
echo '<tr>';
$row=mysql_fetch_array($query_results);
echo '<td align="center">, ($row ['artist'] ), '</td>';
echo '<td align="center">, ($row ['title'] ), '</td>';
echo '<td align="center">, ($row ['genre'] ), '</td></tr>';
}

? >
<tr>
<td bgcolor="#008000" colspan="3"> </td>
</tr>
</table>

<a href="HalesMusicWorld_Home.html">

Return to </a> <a href="HalesMusicWorld_Home.html">HalesMusicWorld Home

</body>
</html>

BrentonHale

Okay I saw and fixed some mistakes and errors I made. But, it's still not working correctly:

<html>
<head>
<title>Hale's Music World: Inventory Search Results</title>
</head>
<body>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="56%" id="table1" height="129">
<tr>
<td bgcolor="#008000" colspan"3"> </td>
</tr>
<tr>
<td colspan="3">
Inventory Search Results</td></tr>
<tr>
<td bgcolor="#008000" colspan="3"> </td>
</tr>
<tr>
<td width="33" align="center">

Artist</td>
<td width="33%" align="center">

Title</td>
<td width="33%" align="center">

Genre</td>
</tr>

<?php

$link = mysql_connect('localhost','halesuser','hales123db');
mysql_select_db("halesmusicworld", $link);

for ($i=0; $i < $match_results; $i++)
{
echo '<tr>';
$row=mysql_fetch_array($query_results);

echo '<td align="center">', ($row ['artist'] ), '</td>';

echo '<td align="center">', ($row ['title'] ), '</td>';
echo '<td align="center">', ($row ['genre'] ), '</td> </tr>';
}

?>
<tr>
<td bgcolor="#008000" colspan="3"> </td>
</tr>
</table>

<a href="HalesMusicWorld_Home.html">

Return to </a> <a href="HalesMusicWorld_Home.html">HalesMusicWorld Home

</body>
</html>

That code gives the following error

Notice: Undefined variable: match_results in C:\wamp\www\inventory_search.php on line 61

Weedpacket

When posting, please use the formatting tags described in the FAQ to make your posts easier to read; thank you.

djjjozsi

BrentonHale, you should see this video, how to embed php codes in this forum:here