PHP - Is It Possible To Create A Table In Mysql Through Php Dynamicly?

Hi ppl,
I am not an php expert, but I want to allow my website users to edit a record in mySQL table.
I need to allow them changing Name and description of a product, thats all. easy edit.

Is there a ready component that will do the hard work for me?
Thank you!

Hello guys,

i want to create array from mysql what is  the script for this...?

value like
$data = array("1" => .0032, "2" => .0028, "3" => .0021, "4" => .0033,
"5" => .0034, "6" => .0031, "7" => .0036, "8" => .0027, "9" => .0024,
"10" => .0021, "11" => .0026, "12" => .0024, "13" => .0036,
"14" => .0028, "15" => .0025);

I have a table in my database for users. On the registration page I want to create another table with the id of the user as the table name.

$sql = "CREATE TABLE IF NOT EXISTS `id_prod` (
)

how do i modify this line so that it takes the id from the user table and creates a new table with id as name followed by prod.

For the life of me I can not figure out why this is not creating the table in the database.  Second set of eyes would be great.

 

function install_kudos() {
 	
 	    global $wpdb;
        $table_name = $wpdb->prefix . 'acikudosnew';
 
        if ($wpdb->get_var('SHOW TABLES LIKE ' .$table_name) != $table_name) 
        {
	    $sql = "CREATE TABLE $table_name (
		kudoid int(9) NOT NULL AUTO_INCREMENT,
        kudomsg text NOT NULL,
        kudoagent text NON NULL,
        kudocust text NOT NULL,
        kudoacct int(16) NOT NULL,
        kudoclient varchar(100) NOT NULL,
        kudoloc text NOT NULL,
        kudoentry TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        kudoadmin text NOT NULL,
		kudopic varchar(55) DEFAULT '' NOT NULL,
		PRIMARY KEY  (kudoid) )";
	       
	require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
	dbDelta( $sql );
	}
 	
 }
  
register_activation_hook(__FILE__, 'install_kudos');

 

 

Hey guys,

Currently Im using the code:

while($row=mysql_fetch_array($nt)){

echo"
$row[user_login],$row[user_email],$row[CallHistoryTimes],$row[CallHistoryInfo],$row[CallHistoryLastOp]$row[CallHistoryLastDate],<br>";
}

To list a mysql array; what I am trying to do is to use the mysql row ID and turn the entire string above into a list.

So for example, the database would get the ID information & create a link of edit.php/?id=3

If someone could help me on this it would be mega appreciated.

Thanks

I want to create a text file based blog ( not using MySQL or other databases).
I have tried to google for tutorials but I couldn't find anything.
is there anyone who can help me and give me some tips?
is there any tutorials about this because I found nothing?
Any good books?

This is an assignment that I have to do and I am using this book:
Spring into PHP 5 by Addison Wesley.

I am a newbie in php and really want to do this because this is my last task and I really want to learn. So I'm grateful if anyone can help me.

i have two tables, employee details table(empno, emp_name , branch) and attendance table(date, Ot, attendence). I want to create a relation between two tables

Hi, I need a quick tip. I want this script to produce an output of "Table created" if it succesfully creates a table.

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

// Create table
mysql_select_db("my_db", $con);
$sql = "CREATE TABLE People
(
FirstName varchar(15),
LastName varchar(15),
Age int
)";

// Execute query
mysql_query($sql,$con);

mysql_close($con);
?> 

I tried to do it on my own, but I guess I'm still completely new to php 
I tried:
<?php
$con = mysql_connect("localhost","****","****");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// Create table
if (mysql_select_db("my_db", $con))
  {
  echo "Table created";
  }
else
  {
  echo "Error creating Table: " . mysql_error();
  }
$sql = "CREATE TABLE People
(
FirstName varchar(15),
LastName varchar(15),
Age int
)"


// Execute query
mysql_query($sql,$con);

mysql_close($con);
?> 

It gave me an error with the last two lines
mysql_query($sql,$con);

mysql_close($con);

 I removed them and it really did give the output "Table created" yet it didn't create the table in the database. I'm having a feeling that I need to add an "if" statement, something of the sort.

if (sql(CREATE TABLE Persons))

But I'm also getting the feeling something there is wrong, I still haven't tried it. 

Help?

Code: [Select]
<?
$link = mysql_connect($dbhost,$dbuser,$dbpass) or die ('Could not connect: ' . mysql_error());
mysql_select_db($dbname) or die ('Error connecting to database');
$sql = "SELECT * FROM papers WHERE ctitle='May 2012'";
$result = mysql_query($sql);
$num = mysql_num_rows($result); //number of entry
$data = mysql_query("select * from papers where ctitle='May 2012' ORDER BY id ASC");

$Wrd = new COM("Word.Application");
$Wrd->Application->Visible = False;
$DocName = "MyDoc/MyWord.doc";

$WrdDoc = $Wrd->Documents->Add();
$WTable = $WrdDoc->Tables->Add($Wrd->Selection->Range, 2, $num); // Colums, Rows

while($info=mysql_fetch_array($data))
{ $i=1;
$WTable->Cell($i,1)->Range->Text = $info['title'];
$WTable->Cell($i,2)->Range->Text = $info['name'] $info['surname'] $info['institution'] $info['country'];
$i++;
        }
$Wrd->ActiveDocument->SaveAs(realpath($DocName));
$Wrd->Application->Quit;
$Wrd = null;
?>
Word Created <a href="<?=$DocName?>">Click here</a> to Download.

php script is not working. Can someone please help me to detect the errors?

i want create a table in ms word file for all entry in my database... "2 columns, number of rows"

Cell(1,1)  Cell(1,2)
Cell(2,1)  Cell(2,2)
etc...
Cell(3,1)  Cell(3,2)

Hello,
 
please let me know how to write xml file, i read somewhere we can use psql.....anyone knows please help!
 
Thanks

I want to show a table with a max of three columns.
I am using an if statement to count the rows and then start a new row (after 3 cols),
I cant see my error. The output just gice one col with all the data in it.
Any help appreciated.
Code: [Select]


<form action="<?php $_SERVER['PHP_SELF'] ?>" method="POST" id="cover" enctype="multipart/form-data">
            <table width="700"><?php
            /* display picture and radio button */
            //add counter for more than 3 images
            $i=0;
            $size=3;
            while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
              {
                
               $coverID=$row['coverID'];

                echo"<tr>";
                
                echo "<td>";
                echo"<img src=\"/wordpress_3/wp-content/plugins/Authors2/jackets/{$row['pix']}\" />";
                
                echo "<input type = 'radio' name ='cover' value= '$coverID'/>";
                ?>
                <br />
                <input type="submit" value="submit">
                <?php
                echo"</td>";
                $i++;
                        if($i==$size)
                    {
                        echo "</tr><tr>";

                        $i=0;
                    }
                
               }
                ?></table>

                </form><?php

Im messing around with functions and arrays but cant seem to get this to work. It basically creates a simple table with the parameters you specify. The array however doesnt go into the table properly.


function asf_create_table($rows, $cols, $border=1, $padding=5, $td_border=1, $contents)
{
$table = "<table style=\"border: {$border}px solid; padding:{$padding}px;\">";

for ($t_rows=0; $t_rows<$rows; $t_rows++)
{
$table .= "<tr>";
}

for ($t_cols=0; $t_cols<$cols; $t_cols++)
{
for ($i=0; $i<$cols; $i++)
{
$table .= "<td style=\"border: {$td_border}px solid;\">";
$table .= $contents[$i];
$table .= "</td>";
}
}

for ($t_rows=0; $t_rows<$rows; $t_rows++)
{
$table .= "</tr>";
}


$table .= "</table>";

echo $table;
}



$t_contents = array("Cell 1", "Cell 2", "Cell 3", "Cell 4");

asf_create_table("4", "4", "1", "5", "1", $t_contents);


instead of 4 cells each with Cell # in them i get 16 cells with the cell #. the 4 displayed 4 times.

i'm trying to achive this results layout: 

example:
                     catagory
                           comment
                           comment
                           comment
                     catagory
                     catagory
                     catagory
                           comment

what is being pulled now is if their is 2 comments two 1 catagory then 2 catagorys are being returned with the same id. what i want is to return one cataogry with many comments.

thanks in advance for your help.

Code: [Select]
<?php require_once('Connections/Del_Comments.php'); ?>
    <?php 
    $all_ids = array();
    $str_ids = "";
     
    // first parent query
    $maxRows_sourceType = 10;
    $pageNum_sourceType = 0;
    if (isset($_GET['pageNum_sourceType'])) {
      $pageNum_sourceType = $_GET['pageNum_sourceType'];
    }
    $startRow_sourceType = $pageNum_sourceType * $maxRows_sourceType;
     
    mysql_select_db($database_Del_Comments, $Del_Comments);
    $query_sourceType = "SELECT a.Id, a.Type, 
a.Dates, 
a.UIdFk, 
b.Id as Did, 
b.comment, 
b.dates as Day, 
b.sfk as Sfk ,
c.sfk as sfk1, 
d.Memo as memo
FROM 
asstatusupdate as a   
left join asstatusdata as b 
on a.id = b.sfk 
left join asmanystatusupdate as c
on b.sfk = c.sfk
left join ascomments as d
on d.id = c.cfk
where a.uidfk='1'
 order by Dates asc";
    $query_limit_sourceType = sprintf("%s LIMIT %d, %d", $query_sourceType, $startRow_sourceType, $maxRows_sourceType);
    $sourceType = mysql_query($query_limit_sourceType, $Del_Comments) or die(mysql_error());
    $row_sourceType = mysql_fetch_assoc($sourceType);
     
    if (isset($_GET['totalRows_sourceType'])) {
      $totalRows_sourceType = $_GET['totalRows_sourceType'];
    } else {
      $all_sourceType = mysql_query($query_sourceType);
      $totalRows_sourceType = mysql_num_rows($all_sourceType);
    }
    $totalPages_sourceType = ceil($totalRows_sourceType/$maxRows_sourceType)-1;
     
    // add the array
    while ($row_source = mysql_fetch_assoc($sourceType)) {
     
        $all_ids[] = $row_source['Sfk'];
     
        $str_ids .= $row_source['Sfk'].',';
     
     }
     
            // remove the array
         $str_ids = (substr($str_ids,-1) == ',') ? substr($str_ids, 0, -1) : $str_ids;
    
echo $str_ids;
    //echo $all_ids;

//second child query
        $maxRows_sourceComments = 10;
    $pageNum_sourceComments = 0;
    if (isset($_GET['pageNum_sourceComments'])) {
      $pageNum_sourceComments = $_GET['pageNum_sourceComments'];
    }
    $startRow_sourceComments = $pageNum_sourceComments * $maxRows_sourceComments;
     
    mysql_select_db($database_Del_Comments, $Del_Comments);
    $query_sourceComments = "SELECT 
c.sfk as sfk1,
d.Memo as memo
FROM 
asmanystatusupdate as c
left join ascomments as d
on d.id = c.cfk
where c.uidfk0='1' and c.sfk in ($str_ids)";
    $query_limit_sourceComments = sprintf("%s LIMIT %d, %d", $query_sourceComments, $startRow_sourceComments, $maxRows_sourceComments);
    $sourceComments = mysql_query($query_limit_sourceComments, $Del_Comments) or die(mysql_error());
    $row_sourceComments = mysql_fetch_assoc($sourceComments);
     
    if (isset($_GET['totalRows_sourceComments'])) {
      $totalRows_sourceComments = $_GET['totalRows_sourceComments'];
    } else {
      $all_sourceComments = mysql_query($query_sourceComments);
      $totalRows_sourceComments = mysql_num_rows($all_sourceComments);
    }
    $totalPages_sourceComments = ceil($totalRows_sourceComments/$maxRows_sourceComments)-1;
     
     
     
    $resultComments = @mysql_query($query_sourceComments, $Del_Comments);
    $numComments = @mysql_num_rows($resultComments);
     
     
    $result = @mysql_query($query_sourceType, $Del_Comments);
     
    $num = @mysql_num_rows($result);
     
    // column count for parent
        $thumbcols = 1;
     
            // column count for parent query
        $thumbrows = 1+ round($num / $thumbcols);
     
                // column count for child query    $thumbrowsComments = 1+ round($numComments/$thumbcols);
     
                // header
                print '<br />';
                print '<table align="center" width="500" border="3" cellpadding="0" cellspacing="0">';
     
                if (!empty($num)) {
                    print '<tr><td colspan="3" align="center"><strong>Returned Num of Record Sets: ' .$num. ' and comments count' .$numComments. '</strong></td></tr>';    
     
                }
     
        // table layout for parent query        

function display_table() {
     
    // global variables
    global $num, $result, $thumbrows, $thumbcols, $resultComments, $numComments, $thumbrowsComments ;
     
    // row count for parent
     for ($r=1; $r<=$thumbrows; $r++) {
     
         // print table row
             print '<tr>';
     
    //format the columns
    for ($c=1; $c<=$thumbcols; $c++) {
     
    print '<td align="center" valign="top">';
     
        $row = @mysql_fetch_array($result);
$row1 = @mysql_fetch_array($resultComments);
     
        $Id = $row['Id'];
        $Type = $row['Type'];
        $Dates = $row['Dates'];
$Comment = $row['Comment'];
$Sfk1 = $row['sfk1'];
$Memo = $row['memo'];


    // test if not empty show record sets            
        if (!empty($Id)) {
     
                                // print output from parent query
     
                       
                                        // grab type dates comment and format for there column
     
                                        echo '<td valign="top" align="center">'; 
                                        echo "$Type"; echo '&nbsp;&nbsp;'; echo "$Dates"; echo '<br />';echo '<br />';echo '<br />';
                                        echo "$Comment"; echo '</td>';
                                        echo '<td>'; echo "$Id"; echo '</td>';
                                        echo '<td>'; echo "$str_ids"; echo '</td>';

                             echo '<tr>';
echo '<td>'; echo "$Sfk1"; echo '</td>';
echo '<td>'; echo "$Memo"; echo '</td>';
echo '</tr>';

} // closing the $id loop
     


                                                    else {
                                                            print '&nbsp;&nbsp;';
                                                        }
                                print '</td>'; //closing the table data
                            } //closing the rows
                                print '</tr>';
                 } // closing the outter loop
                //} //closing fk id loop
                                print '</td>'; //closing the table data
                    } //closing the rows
                                print '</tr>';    
              
        //} // closing the main loop
     
                    // call the main table
                display_table() ;
                    print '</table>';
     
     
    ?>
     
     
     <?php
var_dump(substr('a', 1)); // bool(false)
?>