Choose a record in MySQL using its unique identifier with PHP

Question

Choose a record in MySQL using its unique identifier with PHP

I want to retrieve rows by their id and display the information. My table is called text and here's its structure:

BookID Type init 
Title
Author 
PublisherName
CopyrightYear

This is how I plan to access them:

text id 10

With this command, I can fetch all the details of row number 10 including:

BookID, Title, Author, PublisherName, CopyrightYear

If I run a query like this:

text id 14

I will receive all the details from row number 14 as well.

<?php
function text($id){

$query = "SELECT * FROM text WHERE BookID =" .$id ;  

$result = mysql_query($query) or die(mysql_error()); 


$row = mysql_fetch_assoc($result); 
}

?>

<?php

echo text (14) ;
?>

php mysql

Answer 1

Answer №1

It seems like there are a few issues that need to be addressed.

The use of the outdated mysql_* functions is a concern. It is highly recommended to switch to mysqli
Your code may be susceptible to SQL injection attacks. It would be beneficial to transition to mysqli and learn how to properly implement prepared statements.
There appears to be inconsistency in function names, as you have named your function text but are calling displaytext
Lastly, ensure that your function is returning a result by adding return $row; at the end of the function to retrieve the desired output

Answer 2

It seems like there are a few issues that need to be addressed.

The use of the outdated mysql_* functions is a concern. It is highly recommended to switch to mysqli
Your code may be susceptible to SQL injection attacks. It would be beneficial to transition to mysqli and learn how to properly implement prepared statements.
There appears to be inconsistency in function names, as you have named your function text but are calling displaytext
Lastly, ensure that your function is returning a result by adding return $row; at the end of the function to retrieve the desired output

Answer 3

Answer №2

When you try to execute the function displytext(), you are actually calling a different function named text().

It is important to note that the function text() does not return any value, which means the echo statement will not output anything.

Answer 4

When you try to execute the function displytext(), you are actually calling a different function named text().

It is important to note that the function text() does not return any value, which means the echo statement will not output anything.

Answer 5

Answer №3

Apologies for the delayed response, after taking another look here is a functional code snippet. Issues found:

No return value in your functions
Failure to escape the $id variable, making it vulnerable to SQL injection attacks
The function name mentioned previously

Hopefully this resolves the issue for you. Please find the updated code below

<?php

function fetchText($id){
$id = mysql_real_escape_string($id);
$query = "SELECT * FROM text WHERE BookID = $id";  
$row = mysql_fetch_assoc(mysql_query($query));
return $row;
}
print_r(fetchText('1'));
?>

Answer 6

Apologies for the delayed response, after taking another look here is a functional code snippet. Issues found:

No return value in your functions
Failure to escape the $id variable, making it vulnerable to SQL injection attacks
The function name mentioned previously

Hopefully this resolves the issue for you. Please find the updated code below

<?php

function fetchText($id){
$id = mysql_real_escape_string($id);
$query = "SELECT * FROM text WHERE BookID = $id";  
$row = mysql_fetch_assoc(mysql_query($query));
return $row;
}
print_r(fetchText('1'));
?>

Choose a record in MySQL using its unique identifier with PHP

Answer №1

Answer №2

Answer №3

Similar questions

When utilizing an iframe, the file surpasses the specified ini size

What is the best way to incorporate multiple variables in a MySQL query when using Node.js?

Is there a way to eliminate empty arrays from my data?

Comparing Doctrine's Data Insertion Methods: Repository vs Entity

What is the best way to handle binary files (such as images or audio) when serving them from a RESTful API that was built using

What is the best way to showcase and tally the outcome of a filtering process?

Laravel typically adds the "php" string as a prefix to the result

The Express JS server has encountered a user access issue and is denying permission for localhost to disconnect

Empty space under the banner in Wordpress theme Avada

A step-by-step guide to receiving Json input in a CakePhp Restful API through the PUT method

Issues with transferring arguments between PHP and PL/SQL

Radio button triggers an ajax call once, but then fails to function

Modify the name of the file for downloading and initiate the download either upon clicking or after a specified

"Hello there, let's chat about the need for require

Update the form action URL when a specific option is selected from the dropdown menu upon clicking the submit

PHP, unable to successfully deliver email messages

Can you provide a succinct explanation of what constitutes a well-defined "landing page"?

Having trouble with the dynamic form not submitting correctly using AJAX in PHP?

Calculating total group orders in Woocommerce based on specific date custom fields

Using PHP to ascertain the requested dataType or responseType from the client