I hve encountered this error that I was using php pdo and wamp server 3.0. I couldnt insert data in ms sql server 2012 because it says that it couldnt find the table Error sql state[ 42S02] Base table or view not found: 208 invalid object name isys.ref_product sql insert into isys.dbo.ref_product(somecolumn)values(somevalues)

Member Avatar
+0 forum 0

I have a form as below on a page pricelist.php. On submit, it uses the code in submit.php to print a price next to the form on pricelist.php depending on the choices submitted in the form. On submit, I need the values of the first two fields to be retained. Is there a way to do this? pricelist.php form code snippet... <form id="myForm2" method="post" enctype="multipart/form-data" > <p class="white">HOW MANY YEARBOOKS DO YOU NEED?</p> <input class="color4 center" style="font-size: 16px; " name="copies" id="copies" size="6" value="<?php echo htmlspecialchars($copies); ?>" /><br /><br /> <p class="white">HOW MANY PAGES IN EACH YEARBOOK?</p> <input class="color4 center" style="font-size: …

Member Avatar
Member Avatar
+0 forum 3

hi am doing this assignment in web develpment. have been trying to run it but for some reason it is not working. maybe a third eye will hope here is the code <?php error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE); if(isset($_POST['register_user'])) { //capture the variable from the form and store in php variables $title=$_POST['title']; $fullname=$_POST['fullname']; $lastname=$_POST['lastname']; $screenname=$_POST['screenname']; $email=$_POST['email']; $gender=$_POST['gender']; $address=$_POST['address']; $mypwd=$_POST['mypwd']; //connecting to the server include'db_server.php'; $conn = mysqli_connect($db_host,$db_username,$db_password) or die (mysqli_connect_error()); //select the database you want to query mysqli_select_db($conn, 'national_wonders') or die (mysqli_error($conn)); $sql = "SELECT * FROM members WHERE screenname='$screenname'"; $result = mysqli_query($conn, $sql) or die ("ERROR:" .mysqli_error()); …

Member Avatar
Member Avatar
+0 forum 3

I am working on a new project where I want to add candidates scores, there are different columns with HTML inputs that holds their performance scores at every stage, then I want to sum it up under the column TOTAL, get also the AVERAGE, and GRADE also on different columns I intend working with HTML, jQuery and Php in getting this done, any help please?

Member Avatar
Member Avatar
+0 forum 1

As web developers we do take seriously the security of our end users by applying a hash method on their passwords before storing it to the database so should our database be hacked we know that our end user passwords are secure. But what about the browser remembered passwords on the front end? We all know that a password can be viewed on the front end by using a tool called element inspector and change the password type from password to text and we can see the actual password and we can login on our own device with that at …

Member Avatar
+0 forum 0

This is my array: [0] => Array ( [0] => SupSKU [1] => MfrSKU [2] => Cost ) [1] => Array ( [0] => A [1] => 11742-4 [2] => 47.25 ) [2] => Array ( [0] => B [1] => 11742-4 [2] => 283.5 ) [3] => Array ( [0] => C [1] => 0904101 [2] => 995 ) I want to find duplicates values in Mfrsku value, in this example that is 11742-4, then compare their prices, and save bigger price SupSku value. So my output will be $final_output => Array ( [0] => B ) I tried …

Member Avatar
Member Avatar
+0 forum 2

So here's a little background to help with what I'm trying to accomplish (be mindful I'm also fairly new to MySQL): I'm creating a dynamically built navigation for a website using PHP and MySQLi. I've created a class called *Database* where I've got helper functions, such as connect() for connecting to the database, and the like. Then I have another class called *Navigation* which extends *Database*, and there I'm creating helper functions to do specific things for the database that holds my navigation links, such as selecting and inserting and so on. Now, the following code works flawlessly when working …

Member Avatar
Member Avatar
+0 forum 9

Hi, I want to replace ticks in text with other text. This method usually works, but when adding three dots, I get php warning ltrim(): Invalid '..'-range, no character to the right of '..' or invalid range needs to be incrementing. I don't know where to look for error, except deleting dots. Here is the code: $code = "some text before block ´´´´code block1´´´´ text after block ´´´´code block2...´´´´"; // I want ticks to be replaced to this: <pre><code> code block1 </code></pre> $pattern = "´´´´"; // we are using ticks $countCodeBlock = substr_count($code, $pattern); // count how many times pattern …

Member Avatar
Member Avatar
+0 forum 4

Hi, I am developing a system that need to monitor machines' licence, so i have a field 'movedate' and 'outdate' every machines can only been kept for 2 years for most. and if the machine didn't go out for almost 2 years, an alert will come out to remind the tenant. I want the alert will come out about 2 weeks before the expire date. But Im not sure how to do it..can someone guide me?

Member Avatar
Member Avatar
+0 forum 10

Hello, I am trying to redirect my website from desktop version to mobile version. Here is the desktop version example: http://www.example.com Here is what I have accomplished: http://m.example.com The problem is that some files are stored under the www version and I want them to be shown on the m version like javascript and images. Any help would be much appreciated. Here is my code: RewriteEngine on RewriteBase / RewriteCond %{HTTPS} on RewriteRule ^(.*)$ http://%{HTTP_HOST}%{REQUEST_URI} [L,R=301] RewriteCond %{HTTP_HOST} ^example.xyz [NC] RewriteRule ^(.*)$ http://www.example.xyz/$1 [L,R=301,NC] RewriteCond %{HTTP_USER_AGENT} android|avantgo|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge\ |maemo|midp|mmp|opera\ m(ob|in)i|palm(\ os)?|phone|p(ixi|re)\/|plucker|pocket|psp|symbian|treo|up\.(browser|link)|vodafone|wap|windows\ (ce|phone)|xda|xiino [NC,OR] RewriteCond %{HTTP_USER_AGENT} ^(1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a\ wa|abac|ac(er|oo|s\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\-m|r\ |s\ )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\-(n|u)|c55\/|capi|ccwa|cdm\-|cell|chtm|cldc|cmd\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\-s|devi|dica|dmob|do(c|p)o|ds(12|\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\-|_)|g1\ u|g560|gene|gf\-5|g\-mo|go(\.w|od)|gr(ad|un)|haie|hcit|hd\-(m|p|t)|hei\-|hi(pt|ta)|hp(\ i|ip)|hs\-c|ht(c(\-|\ …

Member Avatar
Member Avatar
+1 forum 3

Hello i have a problem with a Sql script `SELECT col1_id, col1_name, col2 FROM table GROUP BY ?????` col1_id col1_name col2 A john bear A john dog A john cat A john bear A john dog A john cat A john dog A john cat A john bear A john dog A john cat A john bear A john dog A john cat A john dog A john cat I want to return all results. It has to return like this: ` echo col1_id . col1_name` (A john) and then `col2` (bear,dog, cat)

Member Avatar
Member Avatar
+0 forum 3

Hello i want to UNION three tables from the same database. SELECT DISTINCT * FROM (SELECT uid as id, name as name, username as username,bio as aboutme, '' as text, 'user' as type, profile_pic as profile_pic, '' as media_pic, '' as group_pic, 'U' as mediatype, '' as image_path FROM users ORDER BY rand() LIMIT 5) AS T UNION ALL (SELECT group_id as id, group_name as name,'' as username, group_desc as aboutme, '' as text, 'group' as type, '' as profile_pic, '' as media_pic, group_pic as group_pic, 'G' as mediatype, '' as image_path FROM groups ORDER BY rand() LIMIT 5) UNION …

Member Avatar
Member Avatar
+0 forum 3

php-pdf attachment is in wrong format on webmails

Member Avatar
+1 forum 0

php-pdf attachment is in wrong format on webmails

Member Avatar
+0 forum 0

I'm recently trying to upload images without page refreshing. To do that I had identify ajax. My server side programing language is php. So I tried and success with it, but it's refreshing page. So I change that code after do research. But it shows error. Please help me with this. **This is my html form and it's file name is *index.php*** <form method="post" enctype="multipart/form-data" id="formUploadFile"> <label>Select single file to upload:</label> <input type="file" name="files[]" multiple="multiple" /> <input type="submit" value="Upload File" name="btnSubmit"/> </form> **In the same *index.php* page I opened `<script></script>` tag and put following code.** <script> $(document).ready(function (e) { $('#formUploadFile').on('submit', …

Member Avatar
+0 forum 0

Hello, Recently I am using phpexcel and afer many tries I wasn't able to find out how to make a document with a image in its header. Here is a simplified code that I am using. Can someone helps me with this issue?! <?php require_once 'PHPExcel.php'; $objPHPExcel = new PHPExcel(); $objDrawing = new PHPExcel_Worksheet_HeaderFooterDrawing(); $objDrawing->setPath('header.jpg'); $objPHPExcel->getActiveSheet()->getHeaderFooter()->addImage($objDrawing, PHPExcel_Worksheet_HeaderFooter::IMAGE_HEADER_RIGHT); $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader("&C&G"); $objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('A1', 'CODICE PRATICA'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); $objWriter->save('test.xlsx'); ?>

Member Avatar
Member Avatar
+0 forum 4

Got Client with need of **"online print shop"** Client is providing paper printing (like business cards, flyers), printing on cloths, office stationary, logo embroidery on any type of clothing. Client provided some examples. **Links** * [rockdesign](https://www.rockdesign.com/) * [moo](https://www.moo.com/ca/) * [readyprint](https://www.readyprint.ca/) * [vistaprint](https://www.vistaprint.ca/) * [printshop](https://printshop.ca/) * [printvenue](https://www.printvenue.com/) **Where do I start?** Which platform should I choose? 1. CorePHP 2. Wordpress 3. WooCommerce 4. Magento 5. Prestashop 6. WordPress Is there any plugin or script that should I go for???

Member Avatar
Member Avatar
+1 forum 13

My code is given me error Parse error: parse error, expecting `T_FUNCTION' in C:\wamp\www\schoolapp\application\controllers\Login.php on line 277 here is my code <?php if (!defined('BASEPATH')) exit('No direct script access allowed'); class Login extends CI_Controller { function __construct() { parent::__construct(); $this->load->model('crud_model'); $this->load->database(); $this->load->library('session'); /* cache control */ $this->output->set_header('Last-Modified: ' . gmdate("D, d M Y H:i:s") . ' GMT'); $this->output->set_header('Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0'); $this->output->set_header('Pragma: no-cache'); $this->output->set_header("Expires: Mon, 26 Jul 2010 05:00:00 GMT"); } //Default function, redirects to logged in user area public function index() { $results = $this->up(); if ($this->session->userdata('admin_login') == 1) redirect(base_url() . 'index.php?admin/dashboard', 'refresh'); if ($this->session->userdata('teacher_login') == 1) redirect(base_url() …

Member Avatar
Member Avatar
+0 forum 1

Hi All, I am building an eCommerce website and I really new to PHP and MYSQL but loving the challenge. On my website I have 9 different categories of products with each page having about 8 items to sell. Rather than duplicating the code from each .php/.html file into a new file and change the SQL query, is it possible to write a script that says when the user clicks on category1 in the navigation bar, show all the products in category1? Hope this makes sense. Thanks in advanced.

Member Avatar
Member Avatar
+2 forum 7

I have a webpage which helps download files from database. I want to count the how many times the download button has been clicked and display it on my webpage with unique id. This is my download webpage <div class="container"> <div class="row"> <div class="col-12"> <div class="media"> <img src="./images/<?= $mainImage; ?>" alt="PowerBeatz" width="300" height="300" /> <div class="media-body"> <h5 class="mt-0"><span class="title"><?php echo $row['song']; ?></span></h5> <?php echo $row['artist']; ?> <div class="play"> <a href="file.php?id=<?php echo $row['song_id']; ?>" class="btn btn-primary"><i class="fa fa-download"></i> </a> </div> <div> <p>Total Downloads: </p> </div> </div> </div> </div> </div> </div>

Member Avatar
Member Avatar
+0 forum 2

I am trying to display some text "THIS IS A TEST" on the html page. I am getting this error: "Notice: Undefined variable: text1 in /home/public_html/themes/videos/content.html on line 23" Here is the php file ( I added line 35 and 39): <?php declare( strict_types=1); // these should be set in PHP.ini error_reporting(-1); // set maximum errors ini_set('display_errors' , 'true'); if (empty($_GET['page'])) { header("Location: " . PT_Link('404')); exit(); } $page = PT_Secure($_GET['page']); $limit = 20; $pt->rss_feed = false; $pt->exp_feed = true; $pages = array( 'trending', 'category', 'latest', 'top' ); if (!in_array($page, $pages)) { header("Location: " . PT_Link('404')); exit(); } if (!empty($_GET['feed']) …

Member Avatar
Member Avatar
+0 forum 2

Hello please i have a download webpage which allow users to download mp3 files. I want to display the number of times a user has click the download button and display it on the webpage. The records are in a database and this is my code. This is my download button which will be click to update my record count... <a href="file.php?id=<?php echo $row['song_id']; ?>" class="btn btn-primary"><i class="fa fa-download"></i></a> My database looks like this... song_id song artist filename download xxx xxx xxxx xxxx xxxx I want the count to update the download column anyt time a button is clicked. Any …

Member Avatar
Member Avatar
+0 forum 1

guys pls help me ,, how can i make a matrix round rounbin display ,, if you have an idea thats a big help for me

Member Avatar
Member Avatar
-2 forum 1

--Hi DaniWeb. I have been doying bulk data Uploads from Excel Sheet to MySql data base and hence thought that I may need the reverse of this process and so Export MySql Tables into Excel Format for Backup purposes (I also will be happy for a better suggestion for a better data backup solution if is any from this like saving them in .sql readable format and ready for upload Programatically as the way is there if I go to Php Myadmin). For now I just wanted to have something of the sort as I alredy have a mechanism for …

Member Avatar
Member Avatar
+1 forum 4

So im trying to make a background switch by adjusting the z-index with a hover. I got it to work on one of my pages but the second page has more stuff on it and is too complex. Maybe im just over looking what im suppose to fix. First, the working code: <style> body { font-family: Century Gothic,CenturyGothic,AppleGothic,sans-serif; font-size: 16px; } .container { position: fixed; left: 0; right: 0; top: 0; bottom: 0; z-index: 2; } .content { width: 1080px; position: absolute; padding: 15px; top: 65px; right: 0; bottom: 0; left: 0; margin: auto; } body { position: fixed; top: …

Member Avatar
Member Avatar
+0 forum 2

I am getting a screen resolution through XMLHttpRequest. I am opening a show_content.php file with *xmlhttp.open* that contains screen resolution variables which I pull with the GET Method. xmlhttp.open("GET","show_content.php"+queryString,true); This works! and showing this file with the variables in a following div <div id="txtResolution"></div> This part works as well! PROBLEM: This div ( show_content.php ) contains screen resolution variables that I would like to use throught the rest of the code outside of it but I can not pass them somehow. How can I get those variables to be passed to the original code. I used the GET method but …

Member Avatar
Member Avatar
+0 forum 3

Hello webmasters, I have a website about memes and I want to update the database each time the user scrolls down. I have no problem when I make a few requests to the database, but what if I want to do a lot of requests in a large database? I recently had to refactor my code to exclude some code that is important just for the sake of performance. Is there any way around it? How does Facebook do it?

Member Avatar
Member Avatar
+0 forum 3

I am hacking my way through a Laravel project. I am returning a search-filtered databse query with Laravel and applying a pagination, the pagination works, the query works, but the pagination links go to a blank page, only the first page of results is visible. Any hints would be much appreciated: Controller: <? namespace App\Http\Controllers; use Illuminate\Support\Facades\DB; use App\Http\Controllers\Controller; use App\Job; use Carbon\Carbon; class FilterJobsController extends Controller { /** * Show a list of all of the application's users. * * @return Response */ public function index() { $bidded = request('bidded'); $state = request('state'); $city = request('city'); $contractor = request('contractor'); …

Member Avatar
Member Avatar
+0 forum 1

hey its me again.. now another matter about fetch data from db for provide information to modal form ( edit data ) not shown, [Click Here](https://i.ibb.co/L8jP6tb/update.png) here's just part code fr each related page : **modal edit** ill try with first input type with **id="name" name="name"** <!-- edit modal --> <div class="modal fade" tabindex="-1" role="dialog" id="editEmployModal"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button> <h4 class="modal-title"><span class="glyphicon glyphicon-edit"></span> Update Pegawai</h4> </div> <form class="form-horizontal" action="pegawai/update.php" method="POST" id="updateMemberForm"> <div class="modal-body"> <div class="edit-messages"></div> <div class="form-group"> <!--/here teh addclass has-error will appear --> <label for="nama" class="col-sm-2 control-label">Nama</label> <div class="col-sm-10"> …

Member Avatar
Member Avatar
+0 forum 1

Write a PHP code to: 1- Create a 2-dimensional array, with a random number of rows and columns. 2- Fill the array with random numbers. 3- Send the array to a function that returns the number of the highest frequency in the array. Who can help me to solve it?

Member Avatar
Member Avatar
+0 forum 4

The End.