PHP - Multiple Checkbox Submit - Pulling Data From Sql To Display Results

Hello everyone,

Very new to coding - enjoying it but struggling! I think I'm trying to do something pretty common but I seem to have come up against a complete wall now and after hours/days searching the internet and reading books I'm completely stuck! I'm  trying to write some code to search a MySQL database of products, then display the results. For some search results there will be lots of products so I want to display 10 products on the first page then allow visitors to go to the next page to see another 10, and so on - a type of pagination, as they should then be able to click back to see the last page etc.
I've got to the point of being able to display the first 10 search results, but I can't figure out at all how to create some kind of page scrolling/pagination system.
Please, does anybody have any ideas??
I've attached my code, I hope this is the correct way of doing things here.
Many thanks for your time!

The PHP search code...
Code: [Select]

<?php
//opens connection to mysql server
$dbc = mysql_connect('localhost');
if (!$dbc) {
die('Not connected :' . mysql_error());
}
echo "Connected to mysql database<br />";
//select database
$db_selected = mysql_select_db("NAME_OF_DATABASE", $dbc);
if (!$db_selected)
{
die ("Cannot connect :" . mysql_error());
}
echo "Connected to database<br /><hr />";
echo "Here are your results";

$term = $_POST['term'];
$category = $_POST['category'];
$brand = $_POST['brand_name'];
 
  
$sql = mysql_query("SELECT * FROM products where product_name like '%$term%' AND category_name like '%$category%' AND brand_name like '%$brand%' LIMIT 0, 10");
 
{ 
while ($row = mysql_fetch_array($sql)){
echo "<table border='1' width='100%'> ";
echo "<tr>"; 
echo "<td style='vertical-align:top' width='25%'>" . '<img src="', $row['image_url'], '" alt="', $row['product_name'], '"  width="100" height="100" />' . "</td>";
echo "<td style='vertical-align:top' width='50%'>" . $row['product_name'];
echo "<br />";
echo  "<span style='font-size: 10px'>" . $row['description'] . "</span>" . "</td>"; 
echo "<td style='vertical-align:top' width='25%'>" . $row['price'];
echo "<br />";
echo "<br />";
echo "<hr />";
echo "$row['merchant_name'] </td>";
echo "</tr>";
    }
echo "</table>"; 
}
?>

i have a mysql table which contains name like

mid           mname

101           AAA
102          BBB
103          CCC

now i have to print this name in a html table like AAA, BBB, CCC

i am getting this by while loop in a variable but when loop changes then value also change so please tell me how i get this only in one variable & print

This is actually a page to edit the drama details.
Database-  3 tables

1. drama                           dramaID    drama_title
                                              1              friends

2. drama_genre             drama_genreID     dramaID    genreID
                                               1                        1               2
                                               2                        1               1
                                               3                        1               3
3. genre                              genreID       genre
                                                1            comedy
                                                2            romance
                                                3            family
                                                4            suspense
                                                5            war
                                                6            horror

<?php       

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'drama';
$link = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or trigger_error('Error connecting to mysql');

$id = $_GET['dramaID'];

$link2 = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or trigger_error('Error connecting to mysql');
$sql2 = "SELECT * from drama , drama_genre , genre
WHERE drama.dramaID='".$id."' AND drama_genre.dramaID='".$id."' AND drama.dramaID = drama_genre.dramaID AND drama_genre.genreID = genre.genreID";
$status2 = mysqli_query($link2,$sql2) or die (mysqli_error($link2));

$link3 = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or trigger_error('Error connecting to mysql');
$sql3 = "SELECT * from genre ";
$status3 = mysqli_query($link3,$sql3) or die (mysqli_error($link3));

<form method='Post' action='doUpdate.php' enctype="multipart/form-data">

<?php while ($row2 = mysqli_fetch_assoc($status2)) { ?>
                  <td height="1"></td>
               
                             <td><select name="gdrop">      
                     
      <option value="<?php echo $row2['genreID'];?>"><?php echo $row2['genre'];?></option>
                     
      <?php while ($row3 = mysqli_fetch_assoc($status3)) { ?>
                        
      <option value="<?php echo $row3['genreID'];?>"><?php echo $row3['genre'];?></option>
                     
                     
      <?php }   mysqli_close($link3);  ?>
                     
 <input type='hidden' id='drama_genreID' name='drama_genreID' value = "<?php echo          $row2['drama_genreID']; ?>"/>
                 </select>

<input type="hidden" id="dramaID" name="dramaID" value = "<?php echo $row['dramaID'];?>"/>
<input type="submit" Value="Update"/>
 
The result was there were 3 dropdown menus but only the first dropdown menu has all 6 genres from my database and also the genre that belongs to the drama.

I'm also wondering how I can bring all the drama_genreIDs to my save(doupdate.php) page and update all 3 of them because it seems like only the last dropdown menu's data is saved.

And also how can I display only 6 genres instead of 7 with the genre that belongs to the drama , being set as the default selection.


                                       

I've used a little PHP but I am not great. Is there any way to take information from a html page written in basic text and have it dynamically displayed.

The content I want is found he
http://www.kitco.com/texten/texten.html

I want to take the information from the following chart - only Metal and Ask and create a ticker.
New York Spot Price
MARKET IS OPEN
Will close in 2 hour 24 minutes
----------------------------------------------------------------------
Metals Bid Ask Change Low High
----------------------------------------------------------------------
Gold 1822.80 1823.80 -12.30 -0.67% 1810.70 1840.90
Silver 41.45 41.55 +0.10 +0.24% 41.08 42.15
Platinum 1844.00 1852.00 -7.00 -0.38% 1826.00 1861.00
Palladium 783.00 788.00 +10.00 +1.29% 775.00 794.00
----------------------------------------------------------------------

So basically I would just take the word: Gold - $1823.80 Silver - $41.55 Platinum $1852.00 Palladium - $788.00

Can someone help me through this or point me in a direction where I can read more about accomplishing this? I've been searching google for articles but still haven't found what I'm looking for.

nofx1728

I am pulling records from a mysql db.   

Example Output:

Team A=  Our Team
Team b = An opponent team
Team A score = 7
Team B score = 8

Team A = Our Team
Team b = Another Opponent
Team A score = 3
Team B score = 1


What I need now is to add ONE more output, which is whether this is a "WIN" or a "LOSS".

Should I add a field into the table that calc's this?    If so, how?   Please be specific.

Or, should I use php to compare Team A score vs Team B score PER every record and then insert this new variable into the output.    If so, how do I create a new variable value for every single output in the table?


I know ultimately that this is a IF THEN type of calc, but can't quite figure out how specifically.   

Please be specific.

Thanks

FOr some reason i cant pull data from an XML file to insert into the database, it works without error just adds a blank value in the database?

i have this code at the moment, i guess arrayValue[71] is the value i need to pull and add to the "TABLE2" table, but when i run the script it just adds a blank value in the database?


<?php
include "connect.php";

//Price check Isle 9001! Query EVE-Central API. Example XML file is: http://api.eve-central.com/api/marketstat?typeid=35&regionlimit=10000002
$queryItemList = mysql_query("SELECT * FROM TABLE2;") or die(mysql_error());
$rowCount = mysql_num_rows($queryItemList);
$s=0;
$typeArray = array();
$region = "regionlimit=10000002";
while($s<$rowCount){

$typeID = mysql_result($queryItemList,$s,"typeID");

echo $typeID."<br />";

//echo "start<br />";

$reader = new XMLReader();

//echo "initialized XMLReader<br />";

$url = "http://api.eve-central.com/api/marketstat?typeid=".$typeID;

echo $url.$region."<br />";

$reader->open($url.'&'.$region);

$t=0;

$arrayName = array();

$arrayValue

 = array();

while ($reader->read()) {

//echo $reader->name;

$name = $reader->name;

$arrayName[$t] = $name;

if ($reader->hasValue) {

//echo ": " . $reader->value."<br />";

$value = $reader->value;

$arrayValue[$t] = $value;

}

$t++;

}

echo $arrayValue[71];

$import="UPDATE TABLE2 SET marketPrice='$arrayValue[71]' WHERE typeID='$typeID';";

mysql_query($import) or die(mysql_error());

$s++;;
}
print_r($typeArray);

/*print_r($arrayName);
echo "<br />";
echo "<br />";
echo "<br />";
print_r($arrayValue);*/

?>


an example XML file would be:
Code: [Select]
<!--
 Automatically generated data from EVE-Central.com
-->
<!-- This is the new API :-) -->
−
<evec_api version="2.0" method="marketstat_xml">
−
<marketstat>
−
<type id="24692">
−
<all>
<volume>4.00</volume>
<avg>152500000.00</avg>
<max>152500000.00</max>
<min>152500000.00</min>
<stddev>0.00</stddev>
<median>152500000.00</median>
<percentile>0.00</percentile>
</all>
−
<buy>
<volume>0.00</volume>
<avg>0.00</avg>
<max>0.00</max>
<min>0.00</min>
<stddev>0.00</stddev>
<median>0.00</median>
<percentile>0.00</percentile>
</buy>
−
<sell>
<volume>4.00</volume>
<avg>152500000.00</avg>
<max>152500000.00</max>
<min>152500000.00</min>
<stddev>0.00</stddev>
<median>152500000.00</median>
<percentile>152500000.00</percentile>
</sell>
</type>
</marketstat>
</evec_api>

im looking at pulling the following value from the <sell> section:
Code: [Select]
<median>152500000.00</median>
i am guessing the above should be arrayValue[71] but for some reason its not picking it up.

any help on this would be greatly appreciated as im lost in this script.

Good evening,

This has been bugging me for 24 hours now. I have created 2 web applications. The first one is the dummy, and the second one is the final. Basically, this two web applications does the same, just a few modifications made on the final one. I have a process of pulling out of information from the database should the user would want to modify a field. I have a problem though, the dummy one works perfectly, but the new one don't. In fact, if I use the dummy php file together with the new files, the dummy won't be working. But if I use it together with the old files, it works perfectly fine.

This is the error I am getting:


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\invent-asia\edit_client.php on line 46

<?php
include("dbconnection.php");

if(isset($_POST["btnSubmit"]))
{
$id = $_POST["id"];
$territory = $_POST["territory"];
$job_title = $_POST["job_title"];
$area_of_work = $_POST["area_of_work"];
$employer = $_POST["employer"];
$location = $_POST["location"];
$job_title = $_POST["job_title"];
$date_posted = $_POST["date_posted"];
$closing_date = $_POST["closing_date"];
$department = $_POST["department"];
$gender = $_POST["gender"];
$first_name = $_POST["first_name"];
$last_name = $_POST["last_name"];
$title = $_POST["title"];
$telephone = $_POST["telephone"];
$address_1 = $_POST["address_1"];
$address_2 = $_POST["address_2"];
$address_3 = $_POST["address_3"];
$country = $_POST["country"];
$city = $_POST["city"];
$postal_code = $_POST["postal_code"];
$website = $_POST["website"];
$email_address = $_POST["email_address"];
$comment_by_cg = $_POST["comment_by_cg"];
$date_emailed = $_POST["date_emailed"];
$mailing_comments = $_POST["mailing_comments"];
$telesales_comments = $_POST["telesales_comments"];

$query = "UPDATE contacts SET territory= '".$territory."', job_title = '".$job_title."', area_of_work = '".$area_of_work."', employer = '".$employer."', location = '".$location."', job_title = '".$job_title."', employer = '".$employer."', date_posted = '".$date_posted."', department = '".$department."', closing_date = '".$closing_date."', gender = '".$gender."', first_name = '".$first_name."', last_name = '".$last_name."', title = '".$title."', telephone = '".$telephone."', address_1 = '".$address_1."', address_2 = '".$address_2."', address_3 = '".$address_3."', country = '".$country."', city = '".$city."', postal_code = '".$postal_code."', website = '".$website."', email_address = '".$email_address."', comment_by_cg = '".$comment_by_cg."', date_emailed = '".$date_emailed."', mailing_comments = '".$mailing_comments."', telesales_comments = '".$telesales_comments."' WHERE id = '".$id."'";
mysql_query($query) or die(mysql_error());

echo "<script>
alert('You have successfully updated a record');
window.location = 'view.php';
</script>";
}

$query = "SELECT * FROM contacts WHERE id = '".$_GET["id"]."'";
$result = mysql_query($query, $connection);

if(mysql_num_rows($result) > 0) - THIS IS THE 46th LINE IN THE CODE
{
$territory = mysql_result($result,0, "territory");
$job_title = mysql_result($result, 0, "job_title");
$area_of_work = mysql_result($result, 0, "area_of_work");
$employer = mysql_result($result, 0, "employer");
$status = mysql_result($result, 0, "status");
$location = mysql_result($result,0, "location");
$department = mysql_result($result,0, "department");
$date_posted = mysql_result($result,0, "date_posted");
$closing_date = mysql_result($result,0, "closing_date");
$gender = mysql_result($result,0, "gender");
$first_name = mysql_result($result,0, "first_name");
$last_name = mysql_result($result,0, "last_name");
$title = mysql_result($result,0, "title");
$telephone = mysql_result($result,0, "telephone");
$address_1 = mysql_result($result,0, "address_1");
$address_2 = mysql_result($result,0, "address_2");
$address_3 = mysql_result($result,0, "address_3");
$city = mysql_result($result,0, "city");
$country = mysql_result($result,0, "country");
$postal_code = mysql_result($result,0, "postal_code");
$website = mysql_result($result,0, "website");
$email_address = mysql_result($result,0, "email_address");
$comment_by_cg = mysql_result($result,0, "comment_by_cg");
$date_emailed = mysql_result($result,0, "date_emailed");
$mailing_comments = mysql_result($result,0, "mailing_comments");
$telesales_comments = mysql_result($result,0, "telesales_comments");
}
?>

Can anyone help me solve this issue? This is the only feature in my project that is left bugged

Your quick response is well appreciated. Thank you very much

Code: [Select]
id: 20 Reason: this is a test
id: 21 Reason: Tests
id: 22 Reason: Lolcatz
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: 36 Reason: Test
As you can see on the 2nd code box there are id's 20,21,22 and 36 in the database the rest are not active in the database.

i am using using Code: [Select]
for to pull out the id that starts with the lowest value in the database, and only have it run until it gets to the maximum value.
Code: [Select]
for ($id=$set_min; $set_max<=7; $id++)
{
                // $id=$set_min is pulling the smallest value and $set_max is pulling the maximum value so it stops  after it gets to 36
$query=mysql_query("SELECT * FROM posted WHERE id = $id");
$query_row=mysql_fetch_array($query);

$reason = $query_row[reason];
$pulled_id = $query_row[id];
$pulled_pic22 = $query_row[picture];
$href_pull = "<a href=" . "search.php?id=" . "$id" .">";

echo "<td>" . $href_pull . "<img src=$pulled_pic22 height=200 width=150 />" . "</td>";
}

how would i make it so i do not pull the values 23-35 which are not in the active database.

Example: http://dev.hackmuch.com/of-the-day/search.php?id=36

Hey, I was wondering if there is a way to pull multiple rows at once using a list of unique identifiers. For example, I want to pull the rows with the IDs of 4,13,91 and 252

I know the WHERE part of this query is incorrect, but I'm putting it to hopefully help you guys understand what I'm looking for.

$result = mysql_query("SELECT * FROM $table WHERE id='4' OR '13' OR '91' OR '252'");
while($row = mysql_fetch_array($result))
{
echo($row['name']);
}


Or is the best way simply to do it one query at a time without a while statement? There could be as many as a few dozen records being pulled per page.

OK, I've scoured the forms on here, searched and tutorial read and even pulled out an old PHP book. Alas, I'm stumped.

First off, my two tables that I'm trying to pull data from:

rubric
-------------------------------------
---- code ---- | ---- title --------
-------------------------------------
ABCD            | Category Name


schedule
----------------------------------------------------
------ name ------ | ------ short_title ------
----------------------------------------------------
ABCD-123-4569   | Title Is Here


Now, none of these share the same value, per say. rubric.code shares the first THREE letters from schedule.name, but that is all.
What I'm trying to do is something similar to the old:

A
apple
automobile

B
banana
basket
bench

C
car
child
crumb

... etc, etc, where the letter heading is actually the rubric.title value and then underneath it it lists all the matching short_title from
schedule where the first four letters of schedule.name match the value of rubric.code - if that even makes sense.

Unfortunately these are the tables I have to work with. If anyone out there has any ideas, I would be thrilled to hear them. Another
thing that is driving me crazy is that this server I'm working on doesn't have error reporting turned on so I've been stuck with just a
white screen to let me know something is amiss.

I'm running PHP Version 5.3.3-7+squeeze8 if that helps.

Thank you!

I've got a table (tbl_items) that holds a number of items and the individual information for each. Within 'tbl_items' I also have a row labeled 'category_id' in which each item is given a number (ex: 2).

I've got a separate table (tbl_items_categories) that only has 2 rows: 'category_id' and 'category_name'.

I wasn't sure if a JOIN method would be best for this but what would be the best approach to list all items and within each item, also echo out the name of the category they belong to and not the category_id number?

Hello,   I'm not sure if I'm allowed to post the code, as I didn't write it. But, if you could offer some ideas on where I'm going wrong, I'd be very appreciative!   I basically have a feature on my homepage that displays "Hello _username_!" upon login, but the username is missing. So, I'm presuming that the functionality for pulling the username from the table is somehow failing.   Any ideas?   Thanks   Daisy

index.php?page=1 that link style but there is not hard files it is all to be stored in the DB

here is what i have got so far

Code: [Select]
<?

$result = mysql_query("SELECT * FROM page") or die(mysql_error());
$row = mysql_fetch_array( $result );

if(isset($_GET['page'])) {
echo $row['text'];
} else {
$result = mysql_query("SELECT * FROM page
 WHERE id='1'") or die(mysql_error());
$row = mysql_fetch_array( $result );
echo $row['text'];
}
?>
but always shows page ID 1 (home page) so i no i am missing something just not sure what hehe

DB structu
Code: [Select]
menu
----id (auto increase)
----name (home, about etc)
----id2 (page weight)
pages
----id (auto increase)
----name (page name home, about etc)
----text (page text)


link structure from the menu

Code: [Select]
<?

$result = mysql_query("SELECT * FROM menu ORDER BY id2") or die(mysql_error()); 


?>
<table>
<?
while($row = mysql_fetch_array( $result )) { ?>

<tr><td>
<a href="index.php?page=<? echo $row['id'];?>"><? echo $row['name']; ?></a>
</td></tr> <?
}
?>
</table>


dont think i have missed any info that i have on file but not sure why it will not link so thought of you guys hehe

Thanx in advance

Say I have an "Entries" table. I want to submit same multiple entries using a form submission. And If I have other queries submitted in the same form, I want those quarries to be submitted only once.  Is that possible to do? 

Here's my code.

if(isset($_POST['submit'])) {

  $entries = 10;

  $id   = 55;
  $name = 'Smith';

  $insert = $db->prepare("INSERT INTO entries(id, name) VALUES(:id, :name)");
  $insert->bindParam(':id', $id);
  $insert->bindParam(':name', $name);
  $result_insert = $insert->execute();
  if($result_insert == false) {
    echo 'Fail';
  } else {
    echo 'Success';
  }

}
?>
<form action="" method="post">
  <input type="submit" name="submit" value="SUBMIT" />
</form>

 

Edited January 13, 2019 by imgrooot

Hey Guys,

I'm struggling with some logic of how to do something wondering if anyone can point me in the right direction.

Details:
I am making a PHP/MySQL game to learn more PHP, I've got my login/logout system created. However I am planning on the game been map based on a 100x100 grid. I have two tables:

USERS
Username, Password, x, y
Test, Test, 1, 1


MAP
X, Y, type
0,1,1
0,2,1
0,3,2
0,4,3
0,5,2
etc

I am stuck on how to get the user's logged in X and Y coordinates and then compare them with the map table X and Y, to see what type of field to show, 1,2 or 3.

Is there a name for this type of function so I can do some research on it? Or could someone give me an example? Would be fantastic if anyone has any advice.

Thanks in advance
NewcastleFan