Member Avatar

I've just started working with PHP and MySQL, and I'm trying to create a table in MySQL. If I've got this right, I'm trying to do so by going to my host's SQL MyAdmin page and typing in mysql_query("CREATE TABLE example( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(30), age INT)") in the query tab. I get an error saying that my syntax is wrong. Any advice?

Member Avatar
+0 forum 4
Member Avatar

How important is Unit Testing taken by employers, is it something that every developer should have as one of their skills, do some jobs require it more than others or is a simple test like handing out a piece of software to be used by friends family etc sufficient enough.

Member Avatar
+0 forum 5
Member Avatar

I come across this problem every so often and end up having to do work arounds when I would prefer to keep it in the database. I have a query where the data in the query updates frequently so the query won't stay in the cache but I don't need the query to be accurate. I was trying to avoid adding an extra step of storing the data in a temp table and having to update it on a timer. Does anyone know of a way to get MariaDB or MySQL to Keep the result set for a period of …

Member Avatar
+1 forum 11
Member Avatar

I have three tables(table, table2,table3). From table1 i want to return three rows: Title, Desc,time,'products' AS type From table2 i want to return three rows: group_title, group_desc, created,'groups' AS type From table3 i want to return three rows: name, occupation,birth,'users' AS type $sql = "SELECT DISTINCT * FROM (SELECT table1.title, table1.desc, table1.time,'products' AS type FROM table1 ORDER BY rand() LIMIT 5) AS T UNION ALL (SELECT table2.group_name,table2.group_desc,table2.created,'groups' AS type FROM tabl2 JOIN table1 ON table2.id = table1.id ORDER BY rand() LIMIT 5) UNION ALL (SELECT table3.name,table3.occupation,table3.birth,'users' AS type FROM table3 JOIN table1 ON table3.id = table1.id ORDER BY rand() LIMIT …

Member Avatar
+1 forum 5
Member Avatar

How can I minify my code in here, I am giving each 23 total imageview a eventhandler. code works, but I like to make the code shorter. I tried to use for loops to shorten the code. here is a example what I tried to do: for (int i = 0 ; i < imgArrayList.size() ; i++) { imgArrayList.get(i).setOnMouseClicked(new EventHandler<MouseEvent>() { @Override public void handle(MouseEvent event) { selectedTile = i; } }); } but it can't because, the "i" inside the handle method is final. I can't pass the "i" inside the handle method. my goal is, that a specific …

Member Avatar
+1 forum 4
Member Avatar

Hi all at Daniweb, I'm quite new to PHP and I'm banging my head over this... query 1 WORKS: **$query = "CALL procedure_is_a_great_way_to_let_db_do_some_work('1','6')";** //both 1 and 6 are IN parameters! query 2 DOESN'T WORK: $id_pictures = 1; $id_names = 6; **$query = "CALL procedure_is_a_great_way_to_let_db_do_some_work('".$id_pictures."','".$id_names."')";** //both 1 and 6 are IN parameters!

Member Avatar
-1 forum 2
Member Avatar

Hi, I have an idea of building an API for **Machine-to-machine payments.** The API will enable to assign wallets to connected devices, record available amounts of something valuable, as well as all incoming and outgoing movements of value. Would love to hear back from developers who are seeking to address the issue of M2M payments. * Which challenges around M2M payments are you trying to solve? * Which technology do you use? Appreciate your feedback a lot!

Member Avatar
+1 forum 1
Member Avatar

Hi DW. I'm developing an App that uses the FCM notification, but the problem is that my code doesn't seem to get the actual data like when I extract the `message` or `body` it shows just the icon only if the notification was received when the App is open, and it shows the `title` and `body` if the notification is received when the App is not running. Basically what I'm trying is to get the `message` and put that on a textView so that it is seen on the actual App when you click the notification. Here is my `FirebaseMessagingService` …

Member Avatar
+0 forum 1
Member Avatar

I'd like for my page (https://fiftyallstars.com/tour.html) to load, and for the TOUR to start automatically. Right now visitors must click a button with id "starttour" Here's what I've added so far, but it doesn't do the trick: <script> $(function () { window.onload = $('#starttour').click(); }); </script> <a class="start-tour" href="#" id="starttour"><span class="two skinny" style="margin:10px 5px; width:290px; font-weight:bold; letter-spacing:4px;"><i class="fa fa-photo animated faa-pulse faa-slow"></i> Take a Detailed Tour</span></a> Thanks for any help whatsoever.

Member Avatar
+0 forum 4
Member Avatar

I am trying to add Jquery validation to the comments page in WordPress. Everything works except it won't post the fields. May someone help? FUNCTIONS PAGE function comment_validation_init() { if(is_single() && comments_open() ) { ?> <script type="text/javascript"> jQuery(document).ready(function() { jQuery('#commentform').bootstrapValidator({ message: 'This value is not valid', feedbackIcons: { valid: 'glyphicon glyphicon-ok', invalid: 'glyphicon glyphicon-remove', validating: 'glyphicon glyphicon-refresh' }, fields: { author: { validators: { notEmpty: { message: 'Please Enter Your Name' } } }, email: { validators: { notEmpty: { message: 'Please Enter Your Email' }, emailAddress: { message: 'This Is Not A Valid Email Address' } } }, comment: …

Member Avatar
+0 forum 2
Member Avatar

Hi Dani, I'm new to Python . I started working on an automation project where i need to connect to a SunOS server through a windows jump server and run commands to get output on my local machine. I checked this existing module on python called jumpssh but not sure if it's the right one for me or if there is a better alternative by using subprocess or any other modules. To accomplish this manually, I'm doing an RDP to the jump server and then connecting to target server through putty. Any help would be appreciated. Thanks in advance.

Member Avatar
+0 forum 1
Member Avatar

Hi, I have been trying to code an timetable which allows timeslots to be booked. What I am finding difficult is the schedule settings. So three things, "schedule settings", "find common slots" and "make booking". The "find common slots" and "make booking" seems to almost work. But "schedule settings" is more difficult. The idea: The timetable is a typical one with days of the week on the top and hours of the day on the left side. Ofcourse bookings should be possible by choosing month and year also. There are three paricipants. Two of these have a schedule. The third …

Member Avatar
-1 forum 10
Member Avatar

So I'm faced with a CSS mystery. Developing a project, came across an unexpected result, and can't explain it, nor have I been able to come up with a workaround. First I define 8 custom properties properties on a custom selector <b->. Then I conditionally (based on classes defined on the <html> element) override 3 of those propertiess with calc() formulas. Then, I use those properties to define some more properties, again using calc(). Finally, I use the result of the most complex calculation as the width of the <b-> element and a nested <iframe> element. But the calculation only …

Member Avatar
+1 forum 8
Member Avatar

Hi, I need advice on how to implement a Review Management System. Something like realized on mypresences.com or brightlocal.com Not all services allow you to interact with their API. Review services are productreviews, trustpilot, tripadvisor, whirlpool, wordifmouth, seek, indeed, glassdoor. Maybe you now a script or have an offer how it can be realize. Help me, please.

Member Avatar
+1 forum 1
Member Avatar

I am using magento for sending mail with condition, My code: <?php class Gta_MerchantNotification_Model_Observer { public function merchantremainder($Observer) { $order = $Observer->getEvent()->getOrder(); $order_details = $order->getAllVisibleItems(); $itemData = array(); foreach ($order_details as $list) { $incrementid = $order->getIncrementId(); $sku = $list->getsku(); $name = $list->getName(); $price = $list->getPrice(); $Qty = $list->getQtyOrdered(); $extra = $order->getIncrementId(); $message = " <tr> <!-- <td>$incrementid</td> --> <td>$sku</td> <td>$name</td> <td>$price</td> <td>$Qty</td> </tr>"; $itemData[$list->getId()] = $message; } $finalMessage = " <p>Order Id : $incrementid</p> <table border='1'> <tr> <!-- <th>Id</th> --> <th>Sku</th> <th>Product name</th> <th>Price</th> <th>Qty Ordered</th> </tr>"; if (!empty($itemData)) { foreach ($itemData as $data) { $finalMessage .= $data; } $finalMessage …

Member Avatar
+0 forum 2
Member Avatar

Hello, I'm quite nub in web development, so be gentle please. If this place is wrong for such problems point me to a more appropriate resource please. To became more familiar with web-programming I found good (as I thought) area for self-improvement. One of my friends owns web project. This project was developed during last 15 years with one programmer who seems to be slightly tired and probably is needed for backup. I've tried (for the very beginning) copy all stuff to the new development environment and found that project consists of several tens of sites: site1.domain.name, site2.domain.name, etc. So …

Member Avatar
+0 forum 2
Member Avatar

Does anyone have any experience using Ezoic to increase site speed? Namely ... * Is their site speed increase predictor accurate? * Does complicated Javascript still work perfectly? What are the trade-offs? * What is their pricing?! It says it's based on traffic, once the free trial ends, but I can't find anywhere that actually says what the actual pricing is

Member Avatar
+0 forum 4
Member Avatar

I tried alot to print this arrow with random generated values which are 0101 , every time it should be differnt, please help me out thanks :) ![Untitled1.png](/attachments/large/4/c843d1e3a2cf1464dc1f1eb7c0d4a68a.png)

Member Avatar
+0 forum 6
Member Avatar

Looking to create an asset for the Unity Asset store in C#. I don't want to give away the source code, yet I want users to be able to purchase + download my work and use it in their projects. I'm not sure what this is called or how to do it. Any ideas? Much appreciated!

Member Avatar
+0 forum 1
Member Avatar

Sorry for the lousy title, "InterProcess Communication" was too long Basically, I'm looking to use the native `_winapi` and `msvcrt` modules to launch an integrated python interpreter and communicate with it over pipes I can't find anything on Google or DDG, and I've been searching for days, but nobody uses these modules for some reason... I already have the foundation with a 1-way Parent->Child pipe that works, but it's giving me a few issues: 1: I can't seem to get a 2nd Child->Parent pipe to run without the program hanging 2: the output of the subprocess only prints after the …

Member Avatar
+0 forum 19
Member Avatar

<?php include 'ProcessDAO.php'; $dest=""; if(isset($_POST['login'])){ session_start(); // i get an error in this line !! $_SESSION['status']='online'; $_SESSION['breadcrumb']='home'; $pro = new ProcessDAO(); $dest = $pro->LogIn($_POST['username'],$_POST['password']); }else{ session_start(); $dest ="Location: ../index.php"; session_destroy(); } header($dest); ?> guyss can you help me out because in my Login.PHP file when i login i always get this error . >** Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\xampp\htdocs\IPMS\process\ProcessDAO.php:1) in C:\xampp\htdocs\IPMS\process\login.php on line 5**

Member Avatar
+0 forum 8
Member Avatar

What is the best game in 2018

Member Avatar
+3 forum 20
Member Avatar

Hey I want to Develop A mobile app in android for my food business. Can anyone suggest me any company and the cost of the App? Thanks

Member Avatar
+2 forum 13
Member Avatar

I am working on a problem for which i have already developed a solution, but i am new to OPP prgramming and started learning recently. Would request OPP Gurus to provide suggestions for the better designs, keeping scalability, extendability of (course readability) in mind. Also,I would like to extend the the current program for mutiple random players and winner is decided based on max number of votes. But there are rules: 1)Currently i have 6 players, out of which any number of players might contest(taken from std::input or cmd args) 2)Contestants are not aware of other contestants. 3)Each contestant has …

Member Avatar
+2 forum 1
Member Avatar

Hi Team, I have an excel which has multiple rows and each row can have multiple images associated with that , which are postioned on a specific cells of that particular row.I know while we are positioning a image on top of a cell, that is not associated with the cell and it is actually floting the sheet of the workbook.My target is to read those images and at the same time mapping that image with particular cell using apche POI. I have two questions actually: 1. Is there any way to associate an image with a excel cell so …

Member Avatar
+2 forum 1
Member Avatar

Hi, I am ope and new to daniweb

Member Avatar
+0 forum 1
Member Avatar

Hello i want to show html5 video with content over it . Like background image. The whole div html5 video must be of 400px height <div style="height: 400px"> <video controls poster="{{item.media_pic}}"> <source src="{{item.image_path}}" type="video/webm" /> <source src="{{item.image_path}}" type="video/mp4"> <source src="{{item.image_path}}" type="video/ogg"> Your browser does not support HTML5 video. </video> <ion-row> <ion-col col-4> some text </ion-col> <ion-col col-8> button </ion-col> </ion-row> </div>

Member Avatar
+0 forum 2
Member Avatar

Hi. I was wondering if anyone could help me with checking for a valid move in Othello. I was thinking about hard=coding everything but that takes too long. this is what i have so far: 1. Check which direction is valid (adjacent piece is different from piece being placed) 2. Go in that direction(s) and if: 1. hit the end, or hit a empty space return false 2. hit another piece, keep going 3. hit my own piece, stop

Member Avatar
+0 forum 9
Member Avatar

Help me , Search data with dataGuidViewer and print that searching result (vb.Net). I am try verious Code thous are found youtube, but it not work...... Please Help me VB.Net (2010, 2012,2013,)

Member Avatar
+0 forum 2
Member Avatar

![net.jpg](/attachments/large/4/7ba3189ab11bd153b391c468177113e9.jpg) Please help how to code this on vb.net with SQL server database

Member Avatar
+0 forum 1

The End.