|
PHP - Database Normalization Question
Hi
Just want some advice on how to do the below: I already have one table called 'venopt' which has two fields one is 'id' and 'venues' I also already have a table for members details called 'ptdata' and has 'id' 'firstname' and 'surname' etc Both ids in each table are primary keys and autoincremented. The user will be selecting options from the 'venues' table and submitting them via POST. How should i then handle the data, is it best to setup another table which will store the selections and if so how would i go about that? Or is it best to store the details in an array say in the 'ptdata' table. Either way I would also want to retrieve the contents of the array and display it in another drop down list? Any ideas Similar TutorialsThis topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=330221.0 I have a standard form that displays users current data from a mysql database once logged in(code obtained from the internet). Users can then edit their data then submit it to page called editform.php that does the update. All works well except that the page does not display the updated info. Users have to first logout and login again to see the updated info. even refreshing the page does not show the new info. Please tell me where the problem is as i am new to php.
my form page test.php
<?PHP
require_once("./include/membersite_config.php");
if(!$fgmembersite->CheckLogin())
{
$fgmembersite->RedirectToURL("login.php");
exit;
}
?>
<form action="editform.php?id_user=<?= $fgmembersite->UserId() ?>" method="POST">
<input type="hidden" name="id_user" value="<?= $fgmembersite->UserId() ?>"><br>
Name:<br> <input type="text" name="name" size="40" value="<?= $fgmembersite->UserFullName() ?>"><br><br>
Email:<br> <input type="text" name="email" size="40" value="<?= $fgmembersite->UserEmail() ?> "><br><br>
Address:<br> <input type="text" name="address" size="40" value="<?= $fgmembersite->UserAddress() ?> "><br><br>
<button>Submit</button>
my editform.php
<?php
$con = mysqli_connect("localhost","root","user","pass");
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
mysqli_query($con,"UPDATE fgusers3 SET name = '".$_POST['name']."', email= '".$_POST['email']."', address= '".$_POST['address']."' WHERE id_user='".$_POST['id_user']."'");
header("Location: test.php");
?>
Hey guys.. I've been setting up a database for a contact page and I have everything working for it except the following error on my update contact page.. can anyone help me figure it out?? The error lines are the ones where I have my mysql_result's. Errors: No Records Found Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/jonnyp22/public_html/a5/update_contact.php on line 103 Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/jonnyp22/public_html/a5/update_contact.php on line 104 Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/jonnyp22/public_html/a5/update_contact.php on line 105 Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/jonnyp22/public_html/a5/update_contact.php on line 106 Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/jonnyp22/public_html/a5/update_contact.php on line 107 Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/jonnyp22/public_html/a5/update_contact.php on line 108 Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/jonnyp22/public_html/a5/update_contact.php on line 109 Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/jonnyp22/public_html/a5/update_contact.php on line 110 Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/jonnyp22/public_html/a5/update_contact.php on line 111 Code: [Select] <!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 content="text/html; charset=utf-8" http-equiv="Content-Type" /> <title>Update Contact</title> <script type="text/javascript"> function Validateform(){ var email=document.form1.email; var firstname=document.form1.firstname; var lastname=document.form1.lastname; var state=document.form1.state; var reEmail = /^(?:\w+\.?)*\w+@(?:\w+\.)*\w+$/; if ((email.value==null)||(email.value=="")){ alert("Please enter email address"); email.focus(); return false; } if (reEmail.test(email.value)==false){ alert ("Please enter valid email address"); email.focus(); return false; } if ((firstname.value=="")||(firstname.value==null)) { alert("Please enter first name"); firstname.focus(); return false; } if ((lastname.value=="")||(lastname.value==null)) { alert("Please enter last name"); lastname.focus(); return false; } if (state.selectedIndex==0) { alert("Select state"); state.focus(); return false; } return true; } </script> <style type="text/css"> .style1 { text-align: center; color: #F8B57E; font-size: x-large; } .style2 { text-align: center; } .style3 { text-align: right; color: #F8B57E; } .style4 { text-align: left; } .style6 { text-align: center; color: #F8B57E; font-size: medium; } .style7 { color: #FFFFFF; } </style> </head> <body style="color: #FFFFFF; background-color: #102541"> <div class="style2"> <p class="style1"><strong>Update Contact</strong></p> <p class="style6">* Indicates a Required Field</p> <?php include("dl.php"); // If the form has not been submitted then show it if(!$_POST['Submit']) { $email=$_GET['email']; $query="SELECT * FROM person WHERE Email = '$email'"; $result=mysql_query($query) or die('Error: ' . mysql_error()); $num=mysql_numrows($result); mysql_close(); if ($num == 0) { echo "<b><center>No Records Found</center></b>"; } $lastname=mysql_result($result,0,"Last_Name"); $email=mysql_result($result,0,"Email"); $firstname=mysql_result($result,0,"First_Name"); $address1=mysql_result($result,0,"address1"); $address2=mysql_result($result,0,"address2"); $city=mysql_result($result,0,"city"); $state=mysql_result($result,0,"state"); $zip=mysql_result($result,0,"zip"); $phone=mysql_result($result,0,"phone"); ?> <form action="<?=$_SERVER['PHP_SELF']?>" method="post"> <table style="width: 100%"> <tr> <td style="width: 219px; height: 26px" valign="top" class="style3">E-mail Address:</td> <td style="height: 26px" class="style4"> <input name="email" style="width: 363px" type="text" value="<? echo $email; ?>" readonly="readonly" /> </td> </tr> <tr><td class="style3">First Name:</td><td class="style4"><input type="text" name="firstname" id="firstname" size="30" width="250px" value="<? echo $firstname; ?>"/></td></tr> <tr> <td class="style3" >Last Name:</td><td class="style4" ><input name="lastname" id="lastname" type="text" size="30" width="250px" value="<? echo $lastname; ?>"/></td> </tr> <tr><td class="style3">Phone:</td><td class="style4"><input type="text" name="phone" id="phone" size="15" width="250px" value="<? echo $phone; ?>"/></td></tr> <tr> <td class="style3">Address Line 1:</td><td class="style4"><input type="text" name="address1" id="address1" size="50" width="250px" value="<? echo $address1; ?>" /></td></tr> <tr> <td class="style3">Address Line 2:</td><td class="style4"><input type="text" name="address2" id="address2" size="50" width="250px" value="<? echo $address2; ?>"/></td></tr> <tr><td class="style3">City:</td><td class="style4"><input type="text" name="city" id="city" size="50" width="250px" value="<? echo $city; ?>"/></td></tr> <tr><td class="style3">State:</td><td class="style4"><select name="state" id="state"> <option <? if ($state=="NJ") echo selected ;?> >NJ</option> <option <? if ($state=="NY") echo selected ;?> >NY</option> </select></td></tr> <tr><td class="style3">Zip:</td><td class="style4"><input type="text" name="zip" id="zip" size="5" value="<? echo $zip; ?>"/></td></tr> </table> <p class="style2"><input name="Submit" type="submit" value="Update" /> <a href="show_contacts.php"><span class="style7">Show Contacts</span></a> <br /> </p> </form> <?php } else { // The form has been submitted so process it $email=$_POST['email']; $lastname=$_POST['lastname']; $firstname=$_POST['firstname']; $phone=$_POST['phone']; $address1=$_POST['address1']; $address2=$_POST['address2']; $city=$_POST['city']; $state=$_POST['state']; $zip=$_POST['zip']; $query="UPDATE person SET Last_Name='$lastname',FIRST_Name='$firstname',Phone='$phone', Address1='$address1', Address2='$address2', city='$city', state='$state',zip='$zip' WHERE Email='$email'"; if (!mysql_query($query,$con)) { die('Error: ' . mysql_error()); } else { echo "<center><b> Contact info $lastname updated successfully </b><a href='show_contacts.php'>show contacts</a></center>"; } mysql_close(); } ?> </div> </body> </html> quick question... I have a column in my table called views. I want to reset the column to 0 for each row in the table. What's the easiest way to do this? Is there any other way of getting PHP form data into C# any other way besides calling www.downloadHandler.text I am having issues bringing all the entries into C# and breaking them all up. I can do one row fine but multiple rows isn't working. I keep getting an out range error. This is my PHP echo echo $row['userName']. '|' .$row['level']. '|' .$row['points']. '|' .$row['killRate']. '/'; And this is my C# code
string nothing = "Not Placed";
string Data_string = www.downloadHandler.text;
string[] DataArray;
DataArray = Data_string.Split('/');
int numberOfEntries = DataArray.Length;
Debug.Log(numberOfEntries);
if (DataArray[0] == null || numberOfEntries == 1)
{
DataArray[0] = nothing;
Debug.Log("Data Array [0] isn't there");
High_Points_1.text = DataArray[0];
}
else
{
High_Points_1.text = DataArray[0];
//Debug.Log(DataArray.Length);
}
if (DataArray[1] == null || numberOfEntries == 2)
{
DataArray[1] = nothing;
Debug.Log("Data Array [1] isn't there");
High_Points_2.text = DataArray[1];
}
else
{
High_Points_2.text = DataArray[1];
//Debug.Log(DataArray.Length);
}
if (DataArray[2] == null || numberOfEntries == 3)
{
DataArray[2] = nothing;
Debug.Log("Data Array [2] isn't there");
High_Points_3.text = DataArray[2];
}
else
{
High_Points_3.text = DataArray[2];
}
if (DataArray[3] == null || numberOfEntries == 4)
{
DataArray[3] = nothing;
Debug.Log("Data Array [3] isn't there");
High_Points_4.text = DataArray[3];
}
else
{
High_Points_4.text = DataArray[3];
}
if (DataArray[4] == null || numberOfEntries == 5)
{
DataArray[4] = nothing;
Debug.Log("Data Array [4] isn't there");
High_Points_5.text = DataArray[4];
}
else
{
High_Points_5.text = DataArray[4];
}
I have two entries in the database. But when I debugged the number int he array I get 3 strings. I want to show the top five entries in the database. I currently am working on a fantasy golf site. I have a table where I store each users picks by tournament. I want to be able to write a small snippet of code that can compare the current date and time to the Start Time in the database and display that weeks picks. I can do this the long way by extracting the date in each row and comparing it. Is there a way that I can do it without having to write out the code for each row in the database? this is the current code I have to do it the long way: Code: [Select] <?php $result2 = mysql_query("SELECT * FROM `2010_Picks` WHERE Id = 2"); echo "<table border='1'> <tr> <th>Tournament</th> <th>Player</th> <th>Golfer</th> </tr>"; while($row2 = mysql_fetch_array($result2)) { $result = mysql_query("SELECT * FROM `2012_tournaments` WHERE id = 2"); while($row = mysql_fetch_array($result)) { $time1 = strtotime($row['start_date_time']); if ($time2 < $time1) { echo "<tr>"; echo "<td>" . $row2['tournament'] . "</td>"; echo "<td>" . $row2['player'] . "</td>"; echo "<td>" . $row2['golfer'] . "</td>"; echo "</tr>"; } else echo "This did not work"; }}echo "</table>"; ?> So here is a small sample of the data I have stored in my database: Date Start Time Tournament Jan. 2-9 2012-01-06 16:10:00 Hyundai Tournament of Champions(Monday finish) Jan. 9-15 2012-01-12 16:00:00 Sony Open in Hawaii Jan. 16-22 2012-01-19 10:00:00 Humana Challenge in partnership with the Clinton Foundation Jan. 23-29 2012-01-26 10:00:00 Farmers Insurance Open Jan. 30-Feb. 5 2012-02-02 09:00:00 Waste Management Phoenix Open Feb. 6-12 2012-02-09 10:00:00 AT&T Pebble Beach National Pro-Am Feb. 13-19 2012-02-16 11:00:00 Northern Trust Open Feb. 20-26 2012-02-23 09:25:00 World Golf Championships-Accenture Match Play Championship Feb. 27-March 4 2012-03-01 07:00:00 The Honda Classic March 5-11 2012-03-08 07:00:00 World Golf Championships-Cadillac Championship March 12-18 2012-03-15 07:00:00 Transitions Championship March 19-25 2012-03-22 07:00:00 Arnold Palmer Invitational presented by MasterCard March 26-April 1 2012-03-29 08:00:00 Shell Houston Open April 2-8 2012-04-05 07:00:00 Masters Tournament # April 9-15 2012-04-12 07:00:00 RBC Heritage April 16-22 2012-04-19 09:00:00 Valero Texas Open April 23-29 2012-04-26 07:00:00 Zurich Classic of New Orleans April 30-May 6 2012-05-03 07:00:00 Wells Fargo Championship May 7-13 2012-05-10 07:00:00 THE PLAYERS Championship May 14-20 2012-05-17 09:00:00 HP Byron Nelson Championship May 21-27 2012-05-24 09:00:00 Crowne Plaza Invitational at Colonial May 28-June 3 2012-05-31 07:00:00 the Memorial Tournament presented by Nationwide Insurance June 4-10 2012-06-07 08:00:00 FedEx St. Jude Classic June 11-17 2012-06-14 11:00:00 U.S. Open # June 18-24 2012-06-21 07:00:00 Travelers Championship June 25-July 1 2012-06-28 07:00:00 AT&T National July 2-8 2012-07-05 07:00:00 THe Greenbrier Classic July 9-15 2012-07-12 08:00:00 John Deere Classic July 16-22 2012-07-19 01:00:00 The Open Championship # July 23-29 2012-07-26 07:00:00 RBC Canadian Open July 30-Aug. 5 2012-08-02 07:00:00 World Golf Championships-Bridgestone Invitational Aug. 6-12 2012-08-09 07:00:00 PGA Championship # Aug. 13-19 0000-00-00 00:00:00 Off week Aug. 20-26 2012-08-23 07:00:00 The Barclays Aug. 27-Sept. 3 2012-08-30 07:00:00 Deutsche Bank Championship (Monday Finish) Sept. 3-9 2012-09-06 07:00:00 BMW Championship Sept. 10-16 0000-00-00 00:00:00 Off week Sept. 17-23 2012-09-20 10:00:00 TOUR Championship by Coca-Cola hello. i have a question for you. say i have a group of tick boxes and i select a couple. would i put them in to the database as varchar ? like this: id varchar 1 1, 2, 3 or id varchar 1 '1', '2', '3' then my next question is how would i use them. i guess i would explode them or something. the thing is, i have some code that currently pull 1 item from the database (using varchar) and echos it fine but when i add more i get nothing back. thanks rick I created a database class to connect to a database. The code is below. I'm not sure how to call this connection in other classes. Do I use: $db->pdo = $conn->prepare($sql); or what? Note that the db object is instantiated at the end of the class file. Here is the class:
class DB {
public $pdo = '';
//public $message = 'A message from db'; // Debug
function __construct() {
// Database info located elsewhere
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "dbname";
try {
$this->pdo = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
// set the PDO error mode to exception
$this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} // End Try
catch(PDOException $e) {
echo "Error: " . $e->getMessage();
}
//echo '<h3>Everything wnet OK.</h3>'; // Debug
} // End __construct
} // End class definition DB.php
$db = new DB;
Thanks,
--Kenoli I have code for displaying result from database:
foreach ($_SESSION["products"] as $cart_itm)
{
$product_code = $cart_itm["code"];
$results = $mysqli->query("SELECT * FROM products WHERE product_code='$product_code' LIMIT 1");
$obj = $results->fetch_object();
Now, I display data with: $obj->product_name
When I get the list, how to put inline numbers (1 2 3 4 ...)?
1 products1
2 products1
3 products1
4 products1..
This is a more general schema design question as opposed to specific queries.
I'm designing a database which tracks the production status of 2 (and in the future maybe 2 or so more) completely different products. So let's call these products productA and productB. I have a page where the user can see the progress of either of the products.
This concerns these 3 tables:
productA(id, order_id, status)
productB(id, order_id, status)
production_status(id, status, ordering, type)
The status is number based PER product so that it can move up a chain of statusses in its production process. So if a product is in status with ordering 10 it's done (assuming there are 10 production steps). So at ordering 1 its production just started. The status field contains at which production step it is which will be visible on the page. Now this is where i get stuck. I somehow have to differentiate between statusses so I know which statusses belong to which product. I put type in so it could filter for either productA or productB, but also for future products. But working with strings is not such a smart idea I think. I could make 2 more seperate tables, but I'm not sure how well that would scale.
So my question is what a good approach would be.
Some background info: I'm building a Joomla component for a small company. Like I said they want to track the status of these products. Every time a production person unpublishes said item on its production view inside the component, the product moves to the next status
Edited by Ortix, 13 May 2014 - 04:14 AM. well I know the standard way of retrieving mysql data was through the following codes: Code: [Select] $query = "SELECT * FROM {$tablename} WHERE columnmame = '{$var}'"; $result = mysql_query($query); $row = mysql_fetch_array($result); This will return all properties inside a table row by an associative array indexed by column names. I am, however, wondering if there is an easier way to retrieve database info from more than one table. For now, what I am doing is: Code: [Select] $result = mysql_query( "SELECT * FROM {$tablename} WHERE columnmame = '{$var}'"); $row = mysql_fetch_array($result); $result2 = mysql_query( "SELECT * FROM {$tablename2} WHERE columnmame2 = '{$var2}'"); $row2 = mysql_fetch_array($result2); which is a bit tedious and can cause problems when two or more coders work on the same project(it will be difficult to tell what is $row1, $row2 and $row3...). Is there away to write a simpler code than the one above? I mean, if it is possible to run mysql_fetch_array only once and retrieve database info from multiple tables? I am very new to php and am trying to create a simple application that uploads a PDF file to a database. I have one field for the Volume Number and on file field for the PDF to be uploaded. My issue is i can't get the PDF to upload or insert the name of the pdf (eg volume1.pdf) into the data base. I would also like to point out that I know i have a low post count, but i only seek help when i truly need it and have exhausted all other resources... Here is what i have, please go easy on me this is my first round at php: Code: [Select] <?php if(isset($_POST['submit'])){ $vol_num = $_POST['vol_num']; $pdf = $_FILES['pdf']['name']; $path = '../pdf/'.$_FILES['pdf']['name']; move_uploaded_file($_FILES["pdf"]["tmp_name"], $path); mysql_query("INSERT INTO volumes set vol_num='$vol_num', vol_link='$pdf'") or die (mysql_error()); echo "<script>location.href='add_volume.php'</script>"; } ?> what am i doing wrong here? Thanks in advance At the moment I am creating a search function for my website. The approach I have in mind is a pseudo-PHP database. To give an example: A HTML form will submit the results to a PHP file. HTML FORM - Colour: Black PHP RESULT PAGE - if ($_POST['color'] == 'Black') {readfile("./products/black/*.html");} HTML FORM - Price: <$50 PHP RESULT PAGE - if ($_POST['Price'] == '<$50') {readfile("./products/less50/*.html");} The problem here is if there is an item that is black and costs less than $50, then its going to be listed twice. There is probably some code I can write to ommit the listing of duplicate entries, but it is probably going to be messy, so I am wondering if its better to use a centralized MySQL database, rather than a pseudo-PHP database? I've never used MySQL and don't know much about it and this is my first real attempt at using PHP. after cloasing connection of database i still got the values form database. Code: [Select] <?php session_start(); /* * To change this template, choose Tools | Templates * and open the template in the editor. */ require_once '../database/db_connecting.php'; $dbname="sahansevena";//set database name $con= setConnections();//make connections use implemented methode in db_connectiong.php mysql_select_db($dbname, $con); //update the time and date of the admin table $update_time="update admin set last_logged_date =CURDATE(), last_log_time=CURTIME() where username='$uname'limit 3,4"; //my admin table contain 5 colums they are id, username,password, last_logged_date, last_log_time $link= mysql_query($update_time); // mysql_select_db($dbname, $link); //$con=mysql_connect('localhost', 'root','ijts'); $result="select * from admin where username='a'"; $result=mysql_query($result); mysql_close($con); //here i just check after closing data baseconnection whether i do get reselts but i do, why? echo "after the cnnection was closed"; if(!$result){ echo "cont fetch data"; }else{ $row= mysql_fetch_array($result); echo "id".$row[0]."usrname".$row[1]."passwped".$row[2]."date".$row[3]."time".$row[4]; } // echo "<html>"; //echo "<table border='1' cellspacing='1' cellpadding='2' align='center'>"; // echo "<thead>"; // echo"<tr>"; // echo "<th>"; // echo ID; // echo"</th>"; // echo" <th>";echo Username; echo"</th>"; // echo"<th>";echo Password; echo"</th>"; // echo"<th>";echo Last_logged_date; echo "</th>"; // echo "<th>";echo Last_logged_time; echo "</th>"; // echo" </tr>"; // echo" </thead>"; // echo" <tbody>"; //while($row= mysql_fetch_array($result,MYSQL_BOTH)){ // echo "<tr>"; // echo "<td>"; // echo $row[0]; // echo "</td>"; // echo "<td>"; // echo $row[1]; // echo "</td>"; // echo "<td>"; // echo $row[2]; // echo "</td>"; // echo "<td>"; // echo $row[3]; // echo "</td>"; // echo "<td>"; // echo $row[4]; // echo "</td>"; // echo "</tr>"; // } // echo" </tbody>"; // echo "</table>"; // echo "</html>"; session_destroy(); session_commit(); echo "session and database are closed but i still get values from doatabase session is destroyed".$_SESSION['admin']; ?> session is destroyed but database connection is not closed. thanks I have a very tricky php problem here. At least for me. On a page that is editing a job entry. I have a database generated group of checkboxes some of which have been checked when the job was entered. So the script has to do two things generate the complete list of checkboxes and check the ones that have already been selected in the job request. The below script is what I've done trying to figure it out. Description of what I'm trying to do: I'm generating the the boxes with a call to my database for the list of checkboxes. Then I'm building an array with all the possible items that could be checked to compare against. Ok here is where I think my first problem is. I need to make a second query to another table "worklog" in the same database. This is where the list of checked items are stored. What is the best way to do this? A second query seems wrong "or at least not efficient" Code: [Select] <div class="text">Job Type (<a class="editlist" href="javascript:editlist('listedit.php?edit=typelist',700,400);">edit list</a>):</div> <div class="field"> <?PHP $connection=mysql_connect ("localhost", "user", "password") or die ("I cannot connect to the database."); $db=mysql_select_db ("database", $connection) or die (mysql_error()); $query = "SELECT type FROM typelist ORDER BY type ASC"; $sql_result = mysql_query($query, $connection) or die (mysql_error()); $i=1; echo '<table valign="top"><tr><td>'; while ($row = mysql_fetch_array($sql_result)) { $type = $row["type"]; if ($i > 1 && $i % 26 == 0) echo '</td><td>'; else if ($i) echo ''; ++$i; $aTypes = array ("Spec Ad Campaign", "100 x 100 Logo", "100 x 35 (Featured Developer/Broker)", "100 x 40 (Featured Lender)", "120 x 180 (Home Page Auto)", "120 x 45 (Half Tile - Jobs)", "120x60 (Section Sponsor)", "125 x 40 (Profile Page logo)", "135 x 31 (Autos)", "135 x 60 (Autos)", "135 x 60 (Logotile - Jobs)", "150 x 40 (Auto Logo)", "160 x 240 (monster tile)", "160 x 400 (Skyscraper)", "160 x 600 (Tower)", "170x30 (Section Sponsor)", "240 x 180 JPG/GIF Auto Video", "240 x 180 size FLV video ", "300 x 250 (Story Ad)", "300 x 600 (Halfpage)", "468 x 60 (Banner Jpg/Gif)", "728 x 90 (Leaderboard)", "95 x 75 (Sweeps Logo) ", "Agent Profile Page", "Contest", "Creative Change", "Employer Profile", "Holiday Shop", "Home of the Week", "HP Half Banner (234 x 60 Static)", "Mobile Ads (320x53 *300x50*216x36*168x28)", "Newsletter", "Peelback", "Pencil Ad", "Print", "Real Deals", "Resize ad campaign", "Roll-Over Skyscraper", "Site Sponsor logo (170x30)", "Splash Page Production", "Travel Deals Update", "Video Ad", "Web Development", "Web Maintenance", "Web Quote (or Design)"); $dbTypes = explode(',',$row['type']); foreach ($aTypes as $type){ if(in_array($aType,$dbTypes)){ echo "<input style='font-size:10px;' name='type[]' type='checkbox' value='$type' CHECKED><span style='color:#000;'>$type</span></input><br/>"; }else { echo "<input style='font-size:10px;' name='type[]' type='checkbox' value='$type'><span style='color:#000;'>$type</span></input><br/>"; } } } echo '</td></tr></table>'; ?> </div> hello everyone, I am about to start coding my pages to display results from a database but before i do i want to know information about the following : Is it best to upload images to a database?and display them accordingly? or is it best to use images from a directory? What is most commonly used and or more reliable? Another topic i have trouble finding information on is actually positioning the output from you mysql database, is this practice done with tables?fields and rows? What is this method called? And is there more then one way to go about controlling result layout on your page? Sorry about the 1001 questions , but i am unable to find a clear answer on the topic ..especially question two . Thanks in advance. Hi guys, I was just wondering if anyone could help me. I've got a My_SQL database containing articles, a summary for the article and a date. I have a basic CMS system set-up, but I want to create a script that when users sign up to a mail list it forwards the summary and dates of the articles database. If that makes sense? But I only want it to forward the most recent 5 rows. I'm pretty new to PHP and I've been mostly following tutorials thus far, but this is quite specific. Thanks in advance! hello I want query from one table and insert in another table on another domain . each database on one domain name. for example http://www.site.com $con1 and http://www.site1.com $con. can anyone help me? my code is : <?php $dbuser1 = "insert in this database"; $dbpass1 = "insert in this database"; $dbhost1 = "localhost"; $dbname1 = "insert in this database"; // Connecting, selecting database $con1 = mysql_connect($dbhost1, $dbuser1, $dbpass1) or die('Could not connect: ' . mysql_error()); mysql_select_db($dbname1) or die('Could not select database'); $dbuser = "query from this database"; $dbpass = "query from this database"; $dbhost = "localhost"; $dbname = "query from this database"; // Connecting, selecting database $con = mysql_connect($dbhost, $dbuser, $dbpass) or die('Could not connect: ' . mysql_error()); mysql_select_db($dbname) or die('Could not select database'); //query from database $query = mysql_query("SELECT * FROM `second_content` WHERE CHANGED =0 limit 0,1"); while($row=mysql_fetch_array($query)){ $result=$row[0]; $text=$row[1]."</br>Size:(".$row[4].")"; $alias=$row[2]; $link = '<a target="_blank" href='.$row[3].'>Download</a>'; echo $result; } //insert into database mysql_query("SET NAMES 'utf8'", $con1); $query3= " INSERT INTO `jos_content` (`id`, `title`, `alias`, `) VALUES (NULL, '".$result."', '".$alias."', '')"; if (!mysql_query($query3,$con1)) { die('Error: text add' . mysql_error()); } mysql_close($con); mysql_close($con1); ?> the second database found on the cloud
i try to get JSON data but how to insert and update them to another online database with the same table my php script to return json data <?php include_once('db.php'); $users = array(); $users_data = $db -> prepare('SELECT id, username FROM users'); $users_data -> execute(); while($fetched = $users_data->fetch()) { $users[$fetchedt['id']] = array ( 'id' => $fetched['id'], 'username' => $fetched['name'] ); } echo json_encode($leaders);
i get
{"1":{"id":1,"username":"jeremia"},"2":{"id":2,"username":"Ernest"}} Edited March 24 by mahenda when in a form, I wish to build a conditional that if the response to a radio button is a value of 2 (female), it will display an input requesting for users maiden name. If not 2 goes to the next input statement. Here is code I was experimenting with: <html> <body> <form action="" name="test" method='POST'> <input type="radio" id="sex" value=1 checked><label>Male</label> <input type="radio" id="sex" value=2><label>Femaleale</label> <?php $result = "value"; if ($result == 2) echo "<input type='int' id='gradYear' size='3' required>"; else echo "Not a female!" ?> <input type="submit" value="GO"> </form> </body> </html> The code passes debug, however, Not a Female is displayed. My question is - Can I do this and if so, what value do I test against id='sex' or value. I tried each one but gave the same results. I realize that $_POST[sex] would be used after the submit button is clicked. But this has me stumped. Thanks for the assis in advance. |
|||||||