PHP - Show Db Structure In A Table

Can someone please tell me how to use the "SHOW FIELDS FROM $mytable" in php? I understand how the MySql works but need to get these fields back into an array in php. That is the part I am strruggling with.. I normally return rows of data from my table and use a while loop.

Hi, okee so I'm new to everything that has to do with scripting, especially when it comes to PHP and stuff,
but what is the best way to display information from a table on a page?
I'm creating this site where users can post their events, but I want the Location to be based on the Location they inserted during the registration process, so that the location will be displayed directly.
How am I able to do that? I've already got an login script, it looks like this:
Code: [Select]
<?php
ob_start();
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="whats_happening_db"; // Database name
$tbl_name="members"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// Define $myusername and $mypassword
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];

// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
header("location:membersarea.php?user=$myusername");
}
else {
echo "Wrong Username or Password";
}

ob_end_flush();
?>
Sorry if my English is terrible haha.

Dante.

hi,

Instead giving its default on "Choose Process", I would like to display its process based on the value in database. How can I do it?

Code: [Select]
<?php 
require_once '../../connectDB.php';
require_once '../include/functions.php';

$sql = " SELECT *
 FROM tb_item
 ORDER BY itm_id asc";
$result = mysql_query($sql) or die(mysql_error());
?>
<form>
<h1>Items</h1>
<table width="75%" border="1" align="left" cellpadding="5" cellspacing="1">
<tr>
    <th width="100" align="left">Item ID</th>
    <th width="100" align="left">Parts</th>
    <th width="100" align="left">Sub-Process</th>
    <th width="100" align="left">Confirmation</th>
    </tr>
    <tr>
    <?php 
    while ($row = mysql_fetch_array($result)) 
{
    extract($row);
?>
<td><?php echo $itm_id; ?></td>
    <td><?php echo $itm_parts; ?></td>
    <td>
<select name='cboSub' id='cbosub'>
<option value='' selected>---- Choose Process ----</option>
    <?php createComboBox(); ?>  
</select>
</td>
<td>
<a href='processItem.php?itm_id=<?php echo $itm_id; ?>'>
<img src='../images/modify.png' width='20' height='20' alt='confirm'/>
</a>
</td>
</tr>
<?php 
}; 
?>

</table>
</form>
<?php 
/**
 * Create combo box for sub-process
 */
function createComboBox() 
{
$sql = " SELECT *
   FROM tb_sub_process
      ORDER BY sub_id asc";

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

while ($row = mysql_fetch_array($result)) 
{
extract($row);

echo "<option value='$sub_id' $select>$sub_name</option>";
}
}
?>

I've attached an example of what basically the output will looks like.

Any help are appreciated.

Thanks in advance.


Regards,
Juz

[attachment deleted by admin]

Hello Guys.   I am having a trouble viewing a specific column content both in phpMyAdmin and console.It only shows a partial info about the contents inside that column.   I have attached a screenshot of this to give you a demonstration inside that link:   http://i59.tinypic.com/2n6ymqf.jpg   as you can see , the user picked hamburger ,steak and ground beef (and some more), but it seems that it stops showing it right in the middle of the word. Is there any limit for characters in this case?   What would be possible to figure that out please?   Thanks in advance..
Edited by osherdo, 17 December 2014 - 09:11 PM.

Hi all,

I am trying to make a members details section that can be updated.

I want to be able to "SELECT * FROM users WHERE email='$email'" and then show the values that can be changed in a html drop down box with the selection that was made when the user registered already selected="selected";

You will be able to see what I am attempting to do below.


<?php

$sql = "SELECT manufacturer FROM table1 WHERE email=$'email'";
$result = mysqli_query($cxn,$sql);
$row = mysqli_fetch_assoc($result);

foreach manufacturer in table1 { 
      if table1.manufacturer = table2.manufacturer {
               echo '<option name="manufacturer" selected="selected" value"$row['manufacturer']"</option>';
     }
     else {
              echo '<option name="manufacturer" value"$row['manufacturer']"</option>';
     }
}
?>

Here is my code.

$display_block .= "
    <P>Showing posts for the <strong>$topic_title</strong> topic:</p>
 
   <table width=100% cellpadding=3 cellspacing=1 border=1>
    <tr>
    <th>AUTHOR</th>
   <th>POST</th>
    </tr>";
 
         while ($posts_info = mysql_fetch_array($get_posts_res)) {
         $post_id = $posts_info['post_id'];
         $post_text = nl2br(stripslashes($posts_info['post_text']));
         $post_create_time = $posts_info['fmt_post_create_time'];
         $post_owner = stripslashes($posts_info['post_owner']);
         
//add to display
   $display_block .= "
     <tr>
         <td width=35% valign=top>$post_owner<br>[$post_create_time]</td>
         <td width=65% valign=top>$post_text<br><br>
         <a href=\"replytopost.php?post_id=$post_id\"><strong>REPLY TO
         POST</strong></a></td>
         </tr>";
}
 
//close up the table
   $display_block .= "</table>";
}
?>
<html>      
<head>
   <title>Posts in Topic</title>
</head>
<body>
      <h1>Posts in Topic</h1>
      <?php print $dislplay_block; ?>
</body>
</html>

I´ve reached to

    <?php require_once('Connections/conexxion.php'); ?>
    <?php
    mysql_select_db($database_conexxion, $conexxion);
    $query_consulta = "SELECT venta,compra,taller,regula_mas,regula_menos,movimiento.id_item,sum(compra+regula_mas-venta-taller-regula_menos)  as stock, cilindro, esfera FROM movimiento  join item on item.id_item=movimiento.id_item join rx on rx.id_rx=item.id_rx join cilindro  on cilindro.id_cil=rx.id_cil  join esfera  on esfera.id_esf=rx.id_esf GROUP BY movimiento.id_item ORDER BY esfera desc, cilindro desc";
    $consulta = mysql_query($query_consulta, $conexxion) or die(mysql_error());
    $row_consulta = mysql_fetch_assoc($consulta);
    $totalRows_consulta = mysql_num_rows($consulta);
    ?>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>test</title>
    </head>
     
    <body>
     
       <?php
    echo "<table align=center>";
     
    $columnes = 10; # Número de columnas (variable)
     
    if (($rows=mysql_num_rows($consulta))==0) {
      echo "<tr><td colspan=$columnes>No hay resultados en la BD.</td></tr> ";
    } else {
      echo "<tr><td colspan=$columnes>$rows Resultados </td></tr>";
    }
     
    for ($i=1; $row = mysql_fetch_row ($consulta); $i++) {
    $resto = ($i % $columnes); # Número de celda del <tr> en que nos encontramos
    if ($resto == 1) {echo "<tr>";} # Si es la primera celda, abrimos <tr>
       echo "<td>$row[1]</td>";
    if ($resto == 0) {echo "</tr>";} # Si es la última celda, cerramos </tr>
    }
    if ($resto <> 0) { # Si el resultado no es múltiple de $columnes acabamos de rellenar los huecos
    $ajust = $columnes - $resto; # Número de huecos necesarios
    for ($j = 0; $j < $ajust; $j++) {echo "<td>&nbsp;</td>";}
    echo "</tr>"; # Cerramos la última línea </tr>
    }
    mysql_close($connexion);
    echo "</table>";
    ?>
     
     
     
    </body>
    </html>
    <?php
    mysql_free_result($consulta);
    ?>

it "works", but results doesn´t start at number 1 but number 2   anyways, The intent of this table is to show the stock of a product, a lens, that has a range of Rx, we use to see this range this way, and show the stock this way would be very productive, but I can´t figure out how to achive it, any sugestion??  
Edited by gralfitox, 16 December 2014 - 06:45 AM.

Hello, i am coding a backend portal, this portal will have staff members lets call them 'M1' and each staff member will have a client 'C1'

What is the best way to put this into a database?

do i have a table for Staff? then a seperate table for Members? or one table consisting of staff, with the members details written into the staff's row?

I need to copy a table from one code to another. But I couldn't figure out how to do it properly. Just tried to copy code from one file to another but it doesn't work the same. I need to find where to change the code to show right columns.

https://easyupload.io/maoa9h - zipped cart.php (original code with right table) and review.php (the one that doesn't show right table)
 

We need to copy the table from cart.php:
https://ibb.co/MZ7K7S5 - table look

But it doesn't work. The quantity column doesn't show in review.php - as you can see here https://ibb.co/brP0yy1

I'm have trouble getting my script to show images in a table across the screen. I want to show the picture and have the description shown below it. Right now it shows it in a column with the name next to it. Any help would be greatly appreciated.
Thanks in advance. Below is the script.

<?php
include 'config1.php';

// Connect to server and select database.
mysql_connect($dbhost, $dbuser, $dbpass)or die("cannot connect");
mysql_select_db("vetman")or die("cannot select DB");


$result = mysql_query("SELECT * FROM $dbname WHERE year = '1954'") or die(mysql_error());
// store the record of the "" table into $row
//$current = '';

// keeps getting the next row until there are no more to get
if($result && mysql_num_rows($result) > 0)

{
    $i = 0;
    $max_columns = 3;
    echo "<table>";
echo "<br>";
    while($row = mysql_fetch_array($result))
   {
       // make the variables easy to deal with
       extract($row);

       // open row if counter is zero
       if($i == 0)

          echo "<tr>";

          echo "<td align=center>";
          ?>
          <div>
               <a><img src="<?php echo $tn; ?>"</a><a><?php echo $title; ?></a></div>



          <?php
          echo "</td>";

       // increment counter - if counter = max columns, reset counter and close row
       if(++$i == $max_columns)
       {
           echo "</tr>";
           $i=0;
       }  // end if
   } // end while
} // end if results

// clean up table - makes your code valid!
if($i > 0)
{
    for($j=$i; $j<$max_columns;$j++)
        echo "<td>&nbsp;</td>";
   echo '</tr>';
}
mysql_close();
 ?>
</table>

Hi,

How can I get others informations on another page by clicking on one row's value

I have this code, but it doesn't work:


while($row = mysql_fetch_array($result))
  {
 echo "<tr><p>";
 
  echo "<th><p>" . $row['fname'] . "&nbsp;&nbsp;&nbsp;" . $row['lname'] . "</p></th>";
  echo"<th><p><a href='student.php?id='".$row['topic']."'\'>".$row['topic']."</p></a></th>";

  echo "</tr>";
  }
echo "</table>";


Student.php


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

mysql_select_db("college", $con);

$result = mysql_query("SELECT * FROM students");
$topic = $_Get['topic'];
while($row = mysql_fetch_array($result))
  {
  
 echo "<tr><p>";
  echo "<th><p>" . $row['month']."&nbsp;" .$row['datetime']."</p></th>";
  echo"<th><p>". $row['topic'] ."</p></th>"; 
  echo "<th><p>" . $row['gender'] . "</p></th>";
  echo "<th><p>" . $row['fname'] . "&nbsp;&nbsp;&nbsp;" . $row['lname'] . "</p></th>";
  echo "<th ><p>" . $row['id'] . "</p></th>";
  echo "</tr>";
  
echo "</table>";

mysql_close($con);
  }
?> 

create table mimi (mimiId int(11) not null, mimiBody varchar(255) );
<?php
//connecting to database
include_once ('conn.php');
$sql ="SELECT mimiId, mimiBody FROM mimi";

$result = mysqli_query($conn, $sql );

$mimi = mysqli_fetch_assoc($result);

$mimiId ='<span>No: '.$mimi['mimiId'].'</span>';

$mimiBody ='<p class="leading text-justify">'.$mimi['mimiBody'].'</p>';
?>
//what is next?

i want to download pdf or text document after clicking button or link how to do that

I have multiple forms within one php file.

What is the best structure to use?

Code: [Select]
if (isset($_POST["one"])) {
    include...
}
if (isset($_POST["two"])) {
    include...
}
if (isset($_POST["three"])) {
    include...
}
OR

Code: [Select]
if (isset($_POST["one"])) {
    include...
}
else if (isset($_POST["two"])) {
    include...
}
else if (isset($_POST["three"])) {
    include...
}

thanks

Hello dear friends,

Let say we have

Code: [Select]
$to = "gigi";
then we have link like this

Code: [Select]
mysite.com/file.php?id=$1
We can change it to new form by add rule at .htaccess codes

Code: [Select]
RewriteRule -(.*)\.htm file.php?id=$1
So that the link be like this

Code: [Select]
mysite.com/$to-$id.htm

it will works , Now what if i want to make the link like this

Code: [Select]
mysite.com/$id/$to.htm
what will be the .htaccess code in this way ???

thanks

Hy

I have a question.
Do you think that the code structure from php affect the SEO?
I mean if the application is made in basic php or OOP.

thk