Click here to Skip to main content
15,867,780 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
QuestionHow to handle response after PayPal subscription approval Pin
Petar Vasilev1-May-20 10:27
Petar Vasilev1-May-20 10:27 
Questionhow to add additional in php query or jquery Pin
captan389926-Apr-20 21:57
captan389926-Apr-20 21:57 
AnswerRe: how to add additional in php query or jquery Pin
Richard MacCutchan26-Apr-20 22:35
mveRichard MacCutchan26-Apr-20 22:35 
AnswerRe: how to add additional in php query or jquery Pin
Richard Deeming27-Apr-20 0:33
mveRichard Deeming27-Apr-20 0:33 
Questionsocket_send not working without break or exit Pin
Member 147929365-Apr-20 2:04
Member 147929365-Apr-20 2:04 
QuestionHow to share session cookies from a PHP application with my WordPress website, hosted on the same server and the same domain? Pin
mplusplus29-Dec-19 17:50
mplusplus29-Dec-19 17:50 
AnswerRe: How to share session cookies from a PHP application with my WordPress website, hosted on the same server and the same domain? Pin
who8mypnuts31-Dec-19 16:28
who8mypnuts31-Dec-19 16:28 
QuestionSubmit to view hyperlink using PHP? Pin
Member 829590119-Jul-19 10:11
Member 829590119-Jul-19 10:11 
After many years of hosting a website on Windows Server with several Access DB's delivering cooking information via dropdown lists, I'm moving all to a Linux-Centos 6.6 VPS. They were created using Front Page but I didn't use FP Extensions just .asp. As an example see one that I need advice on---  http://www.cooksaurus.com/foodnews.asp

I know how to and have converted most the databases to MySql. I'm on a localhost test machine at the moment until all is working to my satisfaction. So with the referenced page, I'm basically trying to recreate it using PHP and HTML and have already created a page that creates a dropdown list using php and calling data from the MySql db and it works fine. Here is my humble coding, BTW I'm a chef with some novice coding knowledge.

<?php
	$hostname ="127.0.0.1";
	$username="root";
	$dbname="newspaper";
	$password="xxxxx";
	$usertable="Food_Sections";
	$columnname="Newspapers";

	mysql_connect($hostname,$username,$password) Or die ("Unable to connect the dbase");
	mysql_select_db($dbname);
	$query="select * from $usertable";
	$result=mysql_query($query);

?>

<html>
<head>
<center>
<h1> Dropdown List of Newspapers</h1>
<h2> DataServer</h2>
<hr/>
</head>
<body>
<select>
<option> Select Newspaper!</option>

<?php
	if($result)
	{
	    while($row=mysql_fetch_array($result))
	    {
		$Newspapers=$row["$columnname"];
		echo"<option>$Newspapers<br></option>";
	    }
	}
?>
</select>
</center>
</body>
</html>



But now I can't figure out how to "Click" on a city's newspaper and display its hyperlink to the Food Sections website using php? (I'm trying to duplicate what already exists on the Windows .asp page with a submit button or by simply clicking on an entry and when selected a clickable hyperlink to its corresponding web page.

Any suggestions, examples of what to do or references to how to make this work would be gratefully accepted.

JJV

Questionphp + validation ajax + ISSET() Pin
nelsonpaixaopinto16-May-19 12:51
nelsonpaixaopinto16-May-19 12:51 
QuestionFailover Architecture (Apache/TOMCAT) Pin
Member 143600218-May-19 3:21
Member 143600218-May-19 3:21 
Questionwhat is the error:mysqli_query() expects parameter 1 to be mysqli, null given in Pin
Amir karim30-Apr-19 7:29
Amir karim30-Apr-19 7:29 
AnswerRe: what is the error:mysqli_query() expects parameter 1 to be mysqli, null given in Pin
Richard MacCutchan30-Apr-19 21:39
mveRichard MacCutchan30-Apr-19 21:39 
AnswerRe: what is the error:mysqli_query() expects parameter 1 to be mysqli, null given in Pin
Member 1456979427-Aug-19 7:03
Member 1456979427-Aug-19 7:03 
Questionany latest api for currency converter free Pin
Member 1434851229-Apr-19 21:32
Member 1434851229-Apr-19 21:32 
AnswerRe: any latest api for currency converter free Pin
OriginalGriff29-Apr-19 21:34
mveOriginalGriff29-Apr-19 21:34 
AnswerRe: any latest api for currency converter free Pin
Richard MacCutchan29-Apr-19 21:35
mveRichard MacCutchan29-Apr-19 21:35 
QuestionUtilize webhook using PHP Webhook Listener Pin
Jassim Rahma18-Apr-19 5:04
Jassim Rahma18-Apr-19 5:04 
QuestionHaving Trouble moving my Wordpress site offline using MAMP Pin
Davstr15-Apr-19 8:02
Davstr15-Apr-19 8:02 
QuestionConvert the sql query into linq Pin
Member 1246113211-Apr-19 22:52
Member 1246113211-Apr-19 22:52 
AnswerRe: Convert the sql query into linq Pin
Richard MacCutchan11-Apr-19 23:05
mveRichard MacCutchan11-Apr-19 23:05 
Questionwhat is the error : SQL syntax; check the manual that corresponds to your MariaDB server version? Pin
Amir karim3-Apr-19 20:47
Amir karim3-Apr-19 20:47 
AnswerRe: what is the error : SQL syntax; check the manual that corresponds to your MariaDB server version? Pin
Peter_in_27803-Apr-19 21:02
professionalPeter_in_27803-Apr-19 21:02 
GeneralRe: what is the error : SQL syntax; check the manual that corresponds to your MariaDB server version? Pin
Amir karim3-Apr-19 21:24
Amir karim3-Apr-19 21:24 
GeneralRe: what is the error : SQL syntax; check the manual that corresponds to your MariaDB server version? Pin
Richard Deeming3-Apr-19 22:28
mveRichard Deeming3-Apr-19 22:28 
QuestionStored procedure is needed Pin
Member 1246113225-Mar-19 4:02
Member 1246113225-Mar-19 4:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.