39,320 Topics
| |
I am currently working on an online website which houses a database inside that has 50-75 fields. I have what I believe may be a somewhat rudimentary question. Assuming we want to query the Database how would one go about making it so it builds a query statement using the … | |
Hi there, I have a website that i need to have a user submit some information and upload 2 files. And add the information to the database. what is the best way to do this. Any and all help would be apprechiated. This is a not for profit site. I … | |
Hello, I have been breaking my head here and I can't figure out what I am doing wrong, I am trying the get the result of the first query into variables to then run the second query. It works inside mysql but not insite my php query. $data = mysql_query("select … | |
Hi guys, so i have a table populated by event details from database and i use a checkbox to select which event to be deleted: echo "<tr> <td><input type='checkbox' name='check[]' class='check' value='$id'>$name</a></td><td>$formatDate</td> </tr>"; my delete function: <?php if(isset($_SESSION['sess_user_id'])) { if(isset($_POST['del_event']) && isset($_POST['check'])) { require "connection.php"; $userid = $_SESSION['sess_user_id']; foreach($_POST['check'] as … | |
I want to count records using datediff() and where condition; I am getting the result with no. of days; but cant count records with condition; below is the my query SELECT DATEDIFF(CURDATE(), jobs.jobs_listed_date) FROM tbl_first_category AS FIRST , tbl_second_category AS SECOND , tbl_jobs AS jobs WHERE first.fc_id = second.sc_fc_id AND … | |
I'm trying to code a registration form. But I'm stuck at adding a borrowed code of image upload, resize, save and store its path in MySQL database. The error message is "Undefined index: fileimage" on the line where I have this code: if($_FILES['fileimage']['name']). Here is the register.php: <?php // include … | |
| Hello All. Been playing around with some linked dropdowns. It seems to be a recurring theme here on DW, so I thought I'd offer this up as a possible solution or for discussion, to see how it could be improved. The premise for this set of linked dropdowns is that … |
I have array of keys. $all_skills2= CHtml::listData(Skill::model()->findAll(array('order' => 'skill')),'skill_id','skill'); $database = array_fill_keys($all_skills2,''); this array looks like: Array ( [Android] => [ax] => [bbb] => [Big Data] => ); now i want to fill values to this array. where values are in another array **$skill_type_count** which i got from below code: … | |
Hey everyone! I've created my db.php and all my other scripts are fine.. just when I created a new page and included db.php I created a function. In the function I used my $dbh variable and it is throwing an error... > Notice: Undefined variable: dbh in C:\xampp\htdocs\Crafting Bench Server … | |
| Bit of an open question I must admit but I began working on my own CMS in codeigniter. Trouble is - it is getting massive and taking very long. Now I like that wordpress has most of the things already integrated so I was just wondering who here has integrated … |
Hello, I am creating an upload material program for elearning. Now, I have an exe file, if I run it from my computer it's directly open a new browser and run it's content. Now, if I click the material list in my web browser, it's asking me to save the … | |
How do I upload photos to a mysql database using php and I again reproduce an image from the database and displayed in the browser | |
hpw to store a permanent value in php variable? for eg input.php <form action = "output.php" method = "post"> <input type = "text" name = "q"> <input = "submit"> </form> ============================================ now output.php <?php $a = $_POST['q']; echo $a;?> now when we upload output.php in new tab it has no … | |
Why is this code note updating the database???? <?php include '../connection.php'; $today = new DateTime('2014-7-14 20:10:10'); $appt = new DateTime('2014-8-15 20:10:10'); $days_until_appt = $appt->diff($today)->days; if ($days_until_appt>=30) { $sql = "SELECT username FROM users WHERE position = 'Tenant'"; $result = mysql_query($sql) or die(mysql_error()); echo '<table align="center" border="1" cellpadding="0">'; echo '<tr align="center"><th> … | |
Pease I need your help! I am very new in Php programming,I just downloaded wampserver on my system and also komodo for text editor.I launched komodo to place my text and saved the file with the file extension .php then try to run the script for web browser to display … | |
I need help to be able to credit tenants that are in my system after every 30 days of stay. Code in either PHP, AJAX, jQuery | |
Hi to All, Can anyone show me a sample alarm script using php or javascript? The alarm was base on the record at the database. I mean, for example I have records that have overdue, the user is the one who state the overdue. For example, the user input his … | |
Please can some one help me descrypt the below php code i using it for my project, i encrpyt it through a code given to me by friend. | |
Hi there me again, sry for the many questions but only way to learn for me is to try (even if I cant succeed) Please feel free to ask any questions of me if I'm not being clear :) What i'm trying to do is basically a auto-select or I … | |
i have a dopdown menu which shows the list of tables in the database..now i want to dispaly the result of the selected table from the database in the dropdown menu on submit but i am unable to get how to do it,kindly help.. <? $link= mysql_connect("localhost","root","") or die ("could … | |
I am setting up a wordpress page on an ubuntu server with Apache/2.4.6 (Ubuntu). Here is what I did: 1. I enabled rewrite mod with : a2enmod rewrite 2. Changed "AllowOverride None" to "AllowOverride All" in apache2.conf :vi /etc/apache2/apache2.conf <Directory /> Options FollowSymLinks AllowOverride **All** Require all denied </Directory> <Directory … | |
Hello Everyone I am using this service 000webhosting.com to host my website. When I tried to connect to the database. I got this error Could not connect to the database a7848759_lumos :SQLSTATE[28000] [1045] Access denied for user 'a7848759_fareedh'@'10.1.1.13' (using password: NO) This is my code below `<?php ` $host = … | |
our problem is " Cannot modify header information - headers already sent "? Is anyone know about this problem that why this happen? | |
in my SE site when i use <h2> it becomes <h1> autometically and <h3> tag becomes <h2> can any one tell me what is the reason? | |
Hallo, I download opensource file uploader from the internet and there is one problem with it. I cannot exceed the limit of php.ini maximum file size: file-upload.php // we should not exceed php.ini max file size $ini_maxsize = ini_get('upload_max_filesize'); if (!is_numeric($ini_maxsize)) { if (strpos($ini_maxsize, 'M') !== false) $ini_maxsize = intval($ini_maxsize)*1024*1024; … | |
<html> <body> <div id="content"> <style> .current { padding: 2px 5px 2px 5px; margin: 2px; border: 1px solid #000099; font-weight: bold; background-color: #000099; color: #FFF; } li { display:inline-block } </style> <?php include"connection.php"; $start=0; $limit=5; $page=''; if(isset($_POST['fullname'])){ $term=$_POST['fullname'];} if(isset($_GET['page'])){ $page=$_GET['page']; $start=($page-1)*$limit; } { if(isset($_POST['Submit'])){ $query=mysql_query ("select * from users where FirstName … | |
Hi, so im trying to insert data but i get: > Notice: Undefined index: events html part: <form method="post" action="seating.php> <div class="drop"> <label>Event : <label/> <select name="events" id="dd-events" onchange="getguests(this.value)"> <option value="" disabled selected >Event</option> <?php foreach($retrieve as $r): ?> <option value="<?=$r['event_id']?>"><?=$r['event_name']?></option> <?php endforeach ?> </select> </div> <input type="hidden" name="table_name[]" value='+tablename+'><span … | |
Hi all, i am storing the value in session but while retrieving its showing the some other value.....totally i want this stored value in the next page .........can u help me........... This is the code i am storing the value in session [code=php] <? session_start(); include('database.php'); $mailid1 = $_GET['mail_id']; session_register('mailid1'); … | |
So I know I can restrict the viewing of a page by session/access using this <?PHP require_once('../../lib/connections/db.php'); include('../../lib/functions/functions.php'); checkLogin('2'); $getuser = getUserRecords($_SESSION['user_id']); ?> is there a way to add to that if the id of the page doesnt match the username in the same database it wont allow you to … |
The End.