39,320 Topics
| |
Please help! i am troubling about on how can i execute my sql script properly. Thanks!Here's my code $sql="INSERT INTO inventory(account_number,serial_number,locator,remarks,`date_assigned`) VALUES('$accountno','$serial','$locator','$remarks',NOW())"; $sql.="INSERT INTO action_log(action,username,`date`) VALUES ('assigns the box($serial) to $accountno','$user',NOW())"; $sql.="INSERT INTO account_logs(action_log,account_number,username,`date`) VALUES('Assign','$accountno','$user',NOW())"; if(mysql_query($sql)){echo "Successfully Assigned!";} else{echo "Insertion Failed!";} | |
Hello, I am using mysql as database, innodb as tables engine. Some of my tables have foreign keys referencing to other tables primary keys. Since the definition of foreign key is to restrict the value of itself, I would like to know if I should check the existence of the … | |
Hello everyone, im trying to make a registration system with PHP and MySQL but im not going well i just created table and i have writed the code well but there is something wrong the inputs don't send that data into database i have tryed much different ways of doing … | |
Hi, Need Suggestion for hiding a div from 9Pm to 9Am. | |
I have this code for my site, the zip is generating (but corrupted because of the 0 byte files...) but the actual curled files (in the tmp/ directory) are there, just with nothing in them. if ($_GET['download']== 'true'){ $downloadarray = array(); while($row = mysql_fetch_array($res)){ $url= $row['loc']; $path = 'tmp/'; $path … | |
Hi Everybody I have to import excel data in MySQL table, I know how to do this for simple excel data to 1 MySQL table. Here also I need to import data from excel to 1 table but data is provided in 1 form which needs to be converted first … | |
how to file upload and save in data base, and also how to retrive from there in any page | |
Hello All, I am displying the paragraph by fetching it from DB using function `mysql_result($result1,$i,"Summary")` and here in DB database Summary field contains link (for ex: htttp://google.co.in) but on UI side, it simply shows htttp://google.co.in not a clickable link. How to do this ??? in short as my mysql_result() is … | |
I'm having trouble understanding the keyword 'this' in php. When and where does it need to be used? Why can you not simply use the variable name as you would normally do when not placing a variable inside a class? In the small test case program below I can't even … | |
Dear Experts, I have following codes $sql = "SELECT * from contacts order by name" ; $select = mysqli_query($con,$sql); $row=mysqli_num_rows($select); //echo ($row); while($row = mysqli_fetch_array($select)) { echo "<tr>"; echo "<td> <a href='edit.php?id=".$row['id']."'> <img border=noborder src=images/pencil.png title=Display></a></td>"; echo "<td align='left'> " . $row["name"]. "</td>"; echo "<td> " . $row["moba"]. "</td>"; echo … | |
Hello, I am trying to make the frontend banner works. index.php <html> <link href= "css/style.css" rel="stylesheet" type="text/css" media="screen"> <script src="js/jquery.min.js" type="text/javascript"></script> <script src="js/chili-1.7.pack.js"></script> <script src="js/jquery.cycle.all.js" type="text/javascript"></script> <script src="js/jquery.easing.1.3.js" type="text/javascript" ></script> <script type="text/javascript"> $('#slideshow').cycle({ fx: 'fade', speed: 900, timeout: 10000, pager: '#nav', pagerAnchorBuilder: function(idx, slide) { // return selector string for … | |
Hye guys, can help me I have a problem with my login. At my login page user have to insert username and password. If the username and password has been set to staff it will direct to mainpage.php but if the username and password was on admin it will direct … | |
Hey everyone, So I have an issue that I'm not sure how to solve. As for most of my posts, I'm sure it's an easy fix that I'm just not fully grasping. Anyway, I want to have a data form upload and show an image of the type of data … | |
Assuming someone is developing a site similiar to facebook in content where users are allowed to upload of heavy files, images, videos, pdf etc. what could be the php best option of coding and fast in workability 1: Is it the best to upload and retrieve the files to and … | |
Sir, I am using these codes. <script type="text/javascript"> $("#moba").change(function() { var formVal = $("#moba").val(); $.get( "ajax_find.php", { id: formVal } ) .done(function( data ) { $('#my_name').val(data); $('#mobb').val(data); $('#email').val(data); }); }); </script> And ajax_find.php has these codes <?php require_once("connect.php"); if (isset($_GET['id'])) { $sno =trim($_GET['id']); $record_check ="SELECT * FROM contacts WHERE moba … | |
Hello dear friends on daniweb. i have a problem i have hotst package on 1and1.com now is 9 months.... i it is 6 months i try to install latest phpmyadmin but still i can't i don't know how i had download phpMyAdmin-4.0.4-all-languages zip i unziped and i upluad on www.myadomainname.com/phpMyAdmin-4.0.4-all-languages … | |
Dear Friends, Help me to write a script for create dynamic list menus in php. Simply, my need is retrieve value from URL & create list menus according to the value that we retrieved from URL. Ex : site.com/text.php?no=4 Should be displayed 4 text boxes Thank you friends. | |
Is there a way to query all public posts on facebook using facebook graph api? I know that public facebook pages are available for this, but what about regular user’s public posts? For now, I can only access my friend’s posts. Is there some kind of universal access token that … | |
Hello guys. i am trying to create a php + ajax form that enables the user to make a transfer from their account to another. is this correct what i am doing so far? `for the ajax file function sendpayment(){ var payment = _("SendPayment").value; var touser =_("ToUser".value; if (payment == … | |
Hello bretheren and programming Gurus? Am new and blank about php and just trying to experiment to get things as i want. Am using the code below but it does not validate data input and also does not redirect to the index page specified in it.I want if the fileds … | |
Hello, people! I need some help with Wordpress.. I'm using Starkers, to create my theme. And I have a design, which I follow. I have Posts, and my question is, How can I add extra fields in the admin interface for the posts? I need to add some extra fields … | |
Hi All Daniweb PHP Group, I have a big favor to ask (well for me this is big lol). I have 3 databases first (LOCAL),(AIMIS),(ERM). Here's the table (namely account_manager) of LOCAL. ![7938f748bd02de5247f37aaa10a5f0c2](/attachments/large/4/7938f748bd02de5247f37aaa10a5f0c2.jpg "7938f748bd02de5247f37aaa10a5f0c2") and Here's the table (namely customer_call) of AIMIS. ![247807516642224dfd5f6e93eadef14b](/attachments/large/4/247807516642224dfd5f6e93eadef14b.jpg "247807516642224dfd5f6e93eadef14b") and Here's the table (namely quotations_header) … | |
Hello Everybody I am trying to display the value of an array in which is passed from one php page to another php page, but I am getting only last element value. Where as when I checked the array content using print_r() it is showing all the values. This is … | |
Hi Anyone can explain whats means with this vulnerability(Blind SQL Injection) and explain Attack details 1 and 2? 1. This vulnerability affects /xxxx/. Discovered by: Scripting (Blind_Sql_Injection.script). Attack details Path Fragment (suffix .html) input - was set to -1' or 61 = '59 2. This vulnerability affects /xxxx/. Discovered by: … | |
Dears, I have script like this... <?php include_once "library/inc.sesadmin.php"; include_once "library/inc.library.php"; # Filter Terpilih $dataTahun = isset($_POST['cmbTahun']) ? $_POST['cmbTahun'] : date('Y'); $dataBulan = isset($_POST['cmbBulan']) ? $_POST['cmbBulan'] : date('m'); # TMBOL CETAK DIKLIK if (isset($_POST['btnCetak'])) { // Buka file echo "<script>"; echo "window.open('cetak/periksa.php?bulan=$dataBulan&tahun=$dataTahun')"; echo "</script>"; } # UNTUK PAGING (PEMBAGIAN HALAMAN) … | |
<?php /*~ class.phpmailer.php .---------------------------------------------------------------------------. | Software: PHPMailer - PHP email class | | Version: 5.1 | | Contact: via sourceforge.net support pages (also www.worxware.com) | | Info: http://phpmailer.sourceforge.net | | Support: http://sourceforge.net/projects/phpmailer/ | | ------------------------------------------------------------------------- | | Admin: Andy Prevost (project admininistrator) | | Authors: Andy Prevost (codeworxtech) codeworxtech@users.sourceforge.net | … | |
Hi, I am trying to get last updated time of database in mysql. need suggestion??? | |
Hi there, I am building a Wordpress site, but I'm struggling to find a good plugin to achieve a few things... Basically I want to make the website a central hub of a lot of my social networks, without me having to continaully update things in several places. So I'm … | |
hlo all, i need to write a code in php oop for registration without using form and data directly goes in the database. i try to write the code for this. i show u that code and help me to correct that or by giving me another code. the database … | |
Hi all,please help me. I want to create bar graph in my system. But I have problems. user can pick date from datetime picker and the graph should appear. But the graph not appear. This is my code. <?php include("dbase.php"); ?> <?php $dateCollect = $_GET['dateCollect']; $show = "SELECT count(mailCategory) As … |
The End.