[SOLVED] need help in php code

[saad|_d3vil]

hi i am new here first of all hi and i need help in php code i have just make table in database sql now what i put code for insert table in to website and other is that how i make hyper link for sql database table in php code

[DeanWhitehouse]

Hey , and welcome to the site. Do you know any PHP

[DarkWater]

...What? o-O

[DeanWhitehouse]

I think he wants to create a table, then insert data into it, and then display it.

[Lamez]

hi i am new here first of all hi and i need help in php code i have just make table in database sql now what i put code for insert table in to website and other is that how i make hyper link for sql database table in php code

 

Translation:

Hi I am new here. First of all, hi and I need help with my php code. I just made a table in the database, how do I use the insert query on my website? Other question is, how do I make a hyper link to the database table in my php code?

 

I think that is what he is say...

[saad|_d3vil]

see my page i make database table now i want to know that how i make hyperlink see this page http://www.apnimuskaan.com/sadasdas.php here is my sql database table now how i make hyperlink

[wildteen88]

see my page i make database table now i want to know that how i make hyperlink see this page http://www.apnimuskaan.com/sadasdas.php here is my sql database table now how i make hyperlink

You'll have to echo (or print) the necessary HTML in your code, eg

echo '<a href="/path/to/page.ext">This is a link</a>';

[saad|_d3vil]

where i put this code and i want to make link with id how i make? for example http://www.apnimuskaan.com/sadasdas.php?=id2 i want to make like this how i make

[wildteen88]

where i put this code and i want to make link with id how i make? for example http://www.apnimuskaan.com/sadasdas.php?=id2 i want to make like this how i make

How would I know! You'll need to post your code and than we can suggest what you should do

[MasterACE14]

<?php
echo "<a href=\"page.php?id=" . $_GET['id'] . "\">Link</a>";

[saad|_d3vil]

THANKS YOU ALL BUT NOW THERE IS ONE MORE PROBLEM IS THAT I DO NOT WANT TO CHANGE THE PAGE I WANT THAT IF SOME ONE CLICK ON THE PAGE SO THE PAGE KEEP SAME AND THE SQL DATABASE TABLE GET CHANGE HOW I DO THAT

[DeanWhitehouse]

What your saying isnt making sense, and loose the caps lock. Please post the code you have , and the question and we will try and help.

[saad|_d3vil]

thi is my coding

<?php

$con = mysql_connect("localhost","apnimusk","password");

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

 

mysql_select_db("my_db", $con);

 

$result = mysql_query("SELECT * FROM album");

 

while($row = mysql_fetch_array($result))

{

echo $row['name'] . " " . $row['age'];

echo "<br />";

}

 

mysql_close($con);

?>

i have put this code now i want to know how i make hyperlink so people who click on the hyperlink it goes to other table of my database but on same page but the id of the change

my website link is this http://www.apnimuskaan.com/sadasdas.php

[DeanWhitehouse]

<?php
$con = mysql_connect("localhost","apnimusk","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM album");

while($row = mysql_fetch_array($result))
  {
  echo $row['name'] . " " . $row['age'];
echo "<a href='?id='".$row['id']."'>".$row['name']."</a>'";
  }

mysql_close($con);
?>

[saad|_d3vil]

no it is working but the url is this http://www.apnimuskaan.com/sadasdas.php?id= there is no id now what i do see this page http://www.apnimuskaan.com/sadasdas.php

[DeanWhitehouse]

are you using the updated one

 

<?php
$con = mysql_connect("localhost","apnimusk","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM album");

while($row = mysql_fetch_array($result))
  {
  echo $row['name'] . " " . $row['age'];
echo "<a href='?id='".$row['id']."'>".$row['name']."</a>'";
  }

mysql_close($con);
?>

[saad|_d3vil]

no it is working but the url is this http://www.apnimuskaan.com/sadasdas.php?id= there is no id now what i do see this page http://www.apnimuskaan.com/sadasdas.php

[DeanWhitehouse]

thats because you need to put whatever you want it to be there. I added $row['id']; as an example.

[sasa]

change

echo "<a href='?id='".$row['id']."'>".$row['name']."</a>'";

to

echo "<a href='?id=".$row['id']."'>".$row['name']."</a>'";

[DeanWhitehouse]

thnks for pointing that out , sasa.

[saad|_d3vil]

can some explain me in detail plz what i change in this code for makeing hyper link

echo "<a href='?id='".$row['id']."'>".$row['name']."</a>'";

[wildteen88]

That code does create a hyperlink! I understand you want to create a link which links to http://www.apnimuskaan.com/sadasdas.php?id= however what I dont understand is what you want ?id= set to? You need to change $row['id'] to whatever you want the ?id= set to.

[saad|_d3vil]

i write this code

<?php

$con = mysql_connect("localhost","apnimusk","password");

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

 

mysql_select_db("apnimusk_naat", $con);

 

$result = mysql_query("SELECT * FROM album");

 

while($row = mysql_fetch_array($result))

{

echo $row['name'] . " " . $row['age'];

echo "<a href='?id='".$row['1']."'>".$row['age']."</a>'";

}

 

mysql_close($con);

?>

but it is not working see this page http://www.apnimuskaan.com/sadasdas.php

[saad|_d3vil]

i also want to know where we can see that what is the id?

[wildteen88]

The variable $row['id'] corresponds to the id field in your album table, What field do you to be part of your link?