|
PHP - Moved: How Do I Print Out The Sql I Used To Create My Table In Phpmyadmin
This topic has been moved to PHP Applications.
http://www.phpfreaks.com/forums/index.php?topic=355885.0 Similar TutorialsThis topic has been moved to PHP Applications. http://www.phpfreaks.com/forums/index.php?topic=359282.0 This topic has been moved to Other Libraries and Frameworks. http://www.phpfreaks.com/forums/index.php?topic=355753.0 This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=355485.0 This topic has been moved to PHP Applications. http://www.phpfreaks.com/forums/index.php?topic=352409.0 This topic has been moved to PHP Applications. http://www.phpfreaks.com/forums/index.php?topic=314698.0 This topic has been moved to PHP Applications. http://www.phpfreaks.com/forums/index.php?topic=309461.0 This topic has been moved to PHP Applications. http://www.phpfreaks.com/forums/index.php?topic=323073.0 This topic has been moved to HTML Help. http://www.phpfreaks.com/forums/index.php?topic=323045.0 This topic has been moved to Installation in Windows. http://www.phpfreaks.com/forums/index.php?topic=351150.0 This topic has been moved to Miscellaneous. http://www.phpfreaks.com/forums/index.php?topic=346728.0 This topic has been moved to JavaScript Help. http://www.phpfreaks.com/forums/index.php?topic=320005.0 while($row = mysql_fetch_row($query)) { echo "<tr>"; echo '<td>' . $row[0] . '</td>'; echo '<td>' . $row[1] . '</td>'; echo '<td>' . $row[2] . '</td>'; echo '<td>' . $row[3] . '</td>'; echo '<td>' . $row[4] . '</td>'; echo "</tr>\n"; } Currently I have this code. I would like to make it print certain text, let's say... 'car', if the value of table's column 'automobiles' is equal to 0. Otherwise - print the real value. I've tried if statement and $one = $two... But that apparently didn't worked. Thanks. We have booking data in spreadsheet looks like table in below, and each booking is for a full week. | wk1 | wk2 | wk3 | wk4 | wk5 |..........| wk52 | ================================== E1 | resv | |resv | |resv | |resv E2 | | resv |resv |resv | E3 | resv | resv |............................................... E4 | resv | E5 | ... | resv | resv|.................................... ... | E50|resv | resv | | resv It looks great excel but required one person to manage all bookings. So we moved to web interface and allow users to make their own bookings. Now, data moved to sql database with fields (id, wk#, room, other....), and records like below. 01 wk1 E1 02 wk1 E3 03 wk1 E4 ..... etc.... nn wk2 E2 nn wk2 E3 ... and more Now, I need a method in PHP to print above data in HTML table that looks like excel table in above. It doesn't have to print 52 wks in one page, but at least something like 4 wks view and next page to show the next 4 wks. At start it will print the first 4 wks from the current week (wk 11), and next page will print wk12 to wk15, etc. | wk1 | wk2 | wk3 | wk4 =================== E1 | resv | |resv | E2 | | resv |resv |resv E3 | resv | resv |............... E4 | resv | E5 | more rows...... Can someone here give me a direction how to code this in PHP? Thank you very much! bobo What I want to do is what is in the shown in the table. I want to only get the Math subject and order the units from unit 1 (UI) to the last available unit in the database; after this, under each unit, to show the homework related to each unit. I have tried to save it into an array with mysql_fetch_array but it stores the row that involves one unit. I want all the units and only the units with their homework under them.
My database is attached to this post in a txt file.
hope someone can help.
<!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>Documento sin título</title> </head> <body> <form action="" method="post" name="form1" id="form1"> <table width="200" border="1"> <tr> <td>Subject:</td> <td>Math</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td>UI</td> <td>UI</td> <td>UII</td> <td>UIII</td> <td>UII</td> <td>...</td> </tr> <tr> <td>Home work</td> <td>Math work1</td> <td>Math work2</td> <td>Math work3</td> <td>Math work4</td> <td>Math work5</td> <td>...</td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> </table> </form> </body> </html> [ Newbie Alert ] Hi i have an array of 39 arrays. Only 5 are shown below so that you have an idea before i ask my question. <? array(39) { [0]=> array(3) { [0]=> string(18) "unit name 1" [1]=> string(9) "category name 1" [2]=> string(20) "Course 1" } [1]=> array(3) { [0]=> string(54) "unit name 2" [1]=> string(15) "category name 2" [2]=> string(20) "Course 1" } [2]=> array(3) { [0]=> string(29) "unit name 3" [1]=> string(15) "category name 2" [2]=> string(20) "Course 1" } [3]=> array(3) { [0]=> string(64) "unit name 4" [1]=> string(30) "category name 3" [2]=> string(20) "Course 2" } [4]=> array(3) { [0]=> string(57) "unit name 5" [1]=> string(24) "category name 1" [2]=> string(20) "Course 1" } [5]=> array(3) { [0]=> string(50) "unit name 6" [1]=> string(24) "category name 4" [2]=> string(20) "Course 2" } } i want a php solution to print category names in table headers , unit names in table rows and course name(s) in table caption.I have tried foreach loop but how to remove duplicate entries as you can see category name 1 and 2 will become two separate headers instead of one and same is the case with Course 1 and 2. i have googled but could'nt find any solution. i don't want to remove duplicate entries , all i want to display them once in a table as described above. This topic has been moved to mod_rewrite. http://www.phpfreaks.com/forums/index.php?topic=352032.0 This topic has been moved to Miscellaneous. http://www.phpfreaks.com/forums/index.php?topic=313625.0 This topic has been moved to Miscellaneous. http://www.phpfreaks.com/forums/index.php?topic=334031.0 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');
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. |
|||||||