39,320 Topics
| |
[CODE] SELECT count(*) FROM information_schema.`COLUMNS` C WHERE table_name = 'your_table_name' AND TABLE_SCHEMA = "your_db_name" [/CODE] TABLE_SCHEMA is required only if table name exists in more than one db | |
Hello Community, I was wondering if it is possible to use an ID ($_GET) after a file in the address bar so it would look like this http://example.com/file.php/ID_HERE Instead of http://example.com/file.php?id=ID_HERE I know there is a way of doing something like that but I'm only getting it to work on … | |
I have more than 40 or so fields on a php page, the fields dont conatain lots of data but they are allot for users to complete. Is there a way (I did this in VB.Net) to save once the user has edited a field or in VB case "Leave" … | |
Hello! I hve a question, how I can display last 3 years? i.e I would like to display them in the second format - 2013, 2012, 2011, All(...) P.S in All I want to display all other years... Here is code how I get year list now(it displays all years): … | |
Hello, I am working on a project in php.Now i want to send a mail to any e-mail id. How can i send it? Is there any mail API for PHP there or not? because right now i am running project on localhost(for testing).After completion of it i will upload … | |
Please help me. How start PHP. I have complete some HTML language and CSS. | |
Hi all I am trying to call a simple function and I keep getting an error "Parse error: syntax error, unexpected ';', expecting '{' in C:\wamp\www\david\remoteaccess\index.php on line 15" This relates to the call and I don't understand why it does not work. I am using WAMP if that makes … | |
Dear I have following codes <?php // Connection variables $host="localhost"; $username="root"; $password=""; $db_name="asia"; // Connect to database $con=mysqli_connect("$host", "$username", "$password"); // Connect result if(!$con){ die('Error Connecting to Database: ' . mysqli_error()); //die '<script type="text/javascript">alert("Error Connecting to Database"). mysqli_error($con);</script>'; } else { echo '<script type="text/javascript">alert("Connected"). mysqli_error($con);</script>'; } // Database Selection $sel … | |
<?php //connecting to the database and running query $dbc=mysqli_connect('localhost','root','','sam_telephone'); $get_list_sql="SELECT id, CONCAT_WS(',', l_name, f_name) AS display_name FROM master_name;"; $get_list_res= mysqli_query($dbc, $get_list_sql); ?> <!--Building of drop down menu start from here--> <form action="post.php" method="post"> <select name="sel_id"> <option value="">--Select One--</option> <!--Starting while loop for fetching the array--> <?php while($x=mysqli_fetch_array($get_list_res,MYSQLI_BOTH)){ ?> <option value="<?php … | |
Dear Sir, HTML file has following codes <!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=iso-8859-1" /> <title>Connection Checking</title> </head> <body> <center> <h1>Connection Checker</h1> <fieldset style=width:300px;background-color:#E0FFFF> <legend sytle=font-size:12;>Click Connect</legend> <form name="form1" action="connect.php" method="post"> <table> <tr><td></td><td align="center"><input type="submit" name="button1" value="Connect"> </td></tr> </table> </form> </fieldset> </center> … | |
Hello, I am trying make this contact form works. I wonder why <carticle2> & <carticle3> does not works. Right after I insert the php code: <?php require_once('recaptchalib.php'); .... ?> I wonder why? And how to make the code belows works? Please help. contactus.php <html> <head> <link href= "css/contact.css" rel="stylesheet" type="text/css" … | |
Hi! I have a Facebook app which uses PHP and JS SDK. JS for the like button and PHP for passing infromation. It's not displying well in different browsers. Say in safari it's displaying but not in Chrome and Firefox. I have cleared my cache and cookies but still getting … | |
Hi! I was able to connect to another server using ftp_connect and was able to login too. But I tried to list the files in the directory but it is not working. No errors are appearing too. Any thoughts? Thanks! Here's my code: // set up basic connection $conn_id = … | |
im trying to get the values of the text field displayed even after inserting the data into the database but im not doing it right because this error "<br /><b>Notice</b>: Undefined index: basic in <b>C:\xampp\htdocs\CashFlow\income.php</b> on line <b>77</b><br />" is shown inside the text field instead. There was one thread … | |
hi guys, i just want to create a javascript confirm script if the file will overwrite the current file with the same filename or with a file already existing. if yes: ask to overwrite if no: back to edit file page function overwrite() { var r=confirm("The same file name existing. … | |
Hello, I have a little problem. This is what I want to achive: I have 2 mysql tables (categories, channels), the channel table has a cat_id in it. I want to update/edit a product and place it in another category but the code that I've made shows just one catedory … | |
<?php $dbc=mysqli_connect('localhost','root','','sam_telephone'); $query="SELECT * FROM master_name"; $result= mysqli_query($dbc,$query); $display=mysqli_fetch_array($result); echo $display['f_name']; /// its show me the result which is fine // but when i apply while loop it does not show any thing. while($y = mysqli_fetch_array($result)){ echo $y['f_name']; } // $y['f_name'] should give me a result becuase it showing me … | |
Hi Via the cpanel that my host provider has I can use PHPMyAdmin. This has the usual admin functions such as the ability to export the data from a specified table into Excel. My client needs to be be able to do this - but from the website. I have … | |
I'm trying to display in a web page all the images stored in a database. THis is my code, but it only displays the first picture: [code=php]<?php include "cysylltiad.php"; $result = mysql_query("SELECT * FROM files ORDER BY fid"); while($row = mysql_fetch_array($result)){ header("Content-Type: {$row['type']}"); echo $row["content"]; } ?>[/code] where content is … | |
Would you help me to learn PHP. Give the some tutorials for PHP. | |
I am attemping to paginate for a public salaries database I am building for my newspaper. I have the code figuring out that it should only display X rows, however, each page displays the same rows. I also have noticed that clicking the links I've created for Previous/Next Page only … | |
Hello, I need some help on my table report using php.. So this is my coding <?php while($row=mysql_fetch_array($result)) { echo "</td><td>"; echo $row['full_name']; echo "</td><td>"; echo $row['section']; echo "</td><td>"; echo $row['time']; echo "</td><td>"; echo $row['reason']; echo "</td></tr>"; } echo "</table>"; ?> so, this is what i need to do .... … | |
Hi, I am able to post from my CMS and share the post directly on the fan page wall. **BUT** only when I have signed in to facebook, and have copied the access token from my admin profile, and directy inserted it into the php script that sends the post … | |
i got following error in my php program error: Parse error: syntax error, unexpected $end in D:\xampp\htdocs\php\project\sample\upload.php on line 85 <?php /** * Upload an image to mysql database. * * * * @author Mr. Vivek Chaurasia * @copyright www.techshri.com * @license LGPL */ // Check for post data. if … | |
Hi Everyone, I'm not sure if I may be in the wrong venue to post as this would have to do with PHP, CURL and SSL, so I've decided to place the question here. Please feel free to let me know if the question should be dropped in some other … | |
<?xml version="1.0" encoding="utf-8"?> <extension version="2.5" type="plugin" group="system"> <name>plg_system_log_teacher</name> <author>arti shrivas</author> <creationDate>nov 8 2013</creationDate> <license>GNU General Public License</license> <authorEmail>bradm@inmotionhosting.com</authorEmail> <authorUrl>http://www.inmotionhosting.com</authorUrl> <version>1.0</version> <description>simple system plugin.</description> <files> <filename plugin="log_teacher">log_teacher.php</filename> <filename>index.html</filename> </files> </extension> this is my plugin xml file <?php // no direct access defined('_JEXEC') or die; class plgSystemLog_Teacher extends JPlugin { public function … | |
So, i am going to be using a php framework to create a blog and i am curious to know what you guys think is the best framework. I, so far, am most satisfied with codeigniter (mostly) and zend. What do you guys think is the best and tell me … | |
Hi I have a website which is ready to launch apart from one of the key request forms which is not working properly and I just can't understand why. I click 'submit' and the form stays on the screen. I get the following message: ***Warning: Invalid argument supplied for foreach() … | |
This is my html. When I put name and press ENTER , browser opening download box for report.php . I don't know how to fix that. I have Apache MySQL started. Windows 8. <form action="report.php" method="post"> <label for="Your Name">Your Name</label> <input type="text" id="firstname" name="firstname"><br> </form> this is report.php <?php $first_name … | |
this is an url example : http://search.yahoo.com/bin/search?p=computers (it is only an example for specification and clarification) in this url , the **method** used to submit data is **get** . After the question mark , there is one parameter . In this parameter , there is a variable called "p" and … |
The End.